Skip to main content

Notifications

Announcements

Announcing new navigation menus and the Engage with the Community forum!
News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics CRM (Archived) / Microsoft Flow connect...
Microsoft Dynamics CRM (Archived)

Microsoft Flow connector to On-Premise WebAPI

(0) ShareShare
ReportReport
Posted on by JoeO 234

Hi,

Has anyone successfully created a Flow/LogicApps custom connector to an On-Premise Dynamics CRM using WebAPI? I can successful query using any simple query: https://CRMURL/OrgName/api/data/v8.2/accounts?$select=name&filter=emailaddress eq 'user@domain.com' but im struggling with the Put/Update option. How do i configure the flow connector action for an update? I tried using REST Builder to generate, but the update operation is not a complete URL but part of code.

Also, im curious on what authentication method folks are using. Im using the On-Premise gateway and configured to use windows authentication (i get occasional 401 Unauthorized), i dont have an IFD/ADFS deployment for OAuth, was anyone sucessful using OAuth? If yes, can you share the config with me?

*This post is locked for comments

  • ssolis Profile Picture
    ssolis 5 on at
    RE: Microsoft Flow connector to On-Premise WebAPI

    Hello JoeO, could you explain how to create this connector? I need it and I am not a programmer, so I do not know how to start.

  • JoeO Profile Picture
    JoeO 234 on at
    RE: Microsoft Flow connector to On-Premise WebAPI

    Hi,

    I've posted the info in a feedback for this functionality, see below. 

    https://powerusers.microsoft.com/t5/PowerApps-Ideas/CRM-On-Premise/idi-p/18733

  • djmilt Profile Picture
    djmilt 5 on at
    RE: Microsoft Flow connector to On-Premise WebAPI

    Joe - would you mind posting more info?  I'd be interested in seeing this solution.  Thanks!

  • Community Member Profile Picture
    Community Member on at
    RE: Microsoft Flow connector to On-Premise WebAPI

    Hi JoeO, 

    I am looking at doing something similar to what you are showing above-- both GET and POST/PATCH operations. Can you provide an example of the configuration that you are using to set up your custom connector? I am familiar with making WebApi calls, just not sure how this information should be put into the connector. 

    Thanks!

  • JoeO Profile Picture
    JoeO 234 on at
    RE: Microsoft Flow connector to On-Premise WebAPI

    Hi,

    I actually got it working, its working flawlessly. If anyone needs it, ill post more info.

  • Community Member Profile Picture
    Community Member on at
    RE: Microsoft Flow connector to On-Premise WebAPI

    Hi Joe!
     
    I believe that there is no possibility to insert data into CRM just with URL. This is the POST action, that is why the data should be included into the request body.

    Hope it helps.
     
    Please mark it As Answered or Verified if it did help you.

    Thanks

    Vlad
    dynamicalabs.com

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Announcing new navigation menus and the Engage with the Community forum!

Quick Links

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

🌸 Community Spring Festival 2025 Challenge Winners! 🌸

Congratulations to all our community participants!

Adis Hodzic – Community Spotlight

We are honored to recognize Adis Hodzic as our May 2025 Community…

Leaderboard > Microsoft Dynamics CRM (Archived)

#1
Mohamed Amine Mahmoudi Profile Picture

Mohamed Amine Mahmoudi 83 Super User 2025 Season 1

#2
Community Member Profile Picture

Community Member 54

#3
Victor Onyebuchi Profile Picture

Victor Onyebuchi 6

Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans