Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
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 230

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 230 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 Microsoft Employee 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 230 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 Microsoft Employee 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

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,214 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans