SBX - Search With Button

SBX - Forum Post Title

Microsoft Flow connector to On-Premise WebAPI

Microsoft Dynamics CRM Forum

JoeO asked a question on 17 Apr 2018 10:44 AM
My Badges

Question Status

Unanswered

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?

Reply
Vladimir Sarov responded on 19 Apr 2018 4:50 AM
My Badges

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

Reply
JoeO responded on 1 May 2018 4:22 PM
My Badges

Hi,

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

Reply
KenRJk responded on 12 Nov 2018 11:26 AM
My Badges

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!

Reply
djmilt responded on 21 Nov 2018 7:48 AM

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

Reply
JoeO responded on 21 Nov 2018 3:34 PM
My Badges

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

Reply

SBX - Two Col Forum

SBX - Migrated JS