Using CRM On-premise with Logic Apps

(1) Share

Report

Posted on by awalters

3,079

I'm playing around with Logic Apps, and since it has connectors for a number of services we use, I'm interested in how we can integrate it with CRM - but as we're on-prem, nothing is ever as straightforward as it seems.

There's a Dynamics 365 Connector, and since our server is IFD enabled, I was hoping I'd be able to give it the URL. However, there's no way to put in a URL - it just goes to Online.

So I tried adding in a Custom Connector, but it wants a Swagger file or Postman collection. Does anyone know if this exists for CRM or if there's any way to generate it somehow?

Is there any other way of getting this working that I've missed, short of directly connecting to the SQL database? *shudder* I was at a Dynamics conference yesterday, and was told by one of the presenters that I should be able to use Flow/Powerapps/etc with on-prem as long as it was IFD enabled, but I'm really missing how to make that work.

*This post is locked for comments

I have the same question (0)

All responses (11)

Answers (1)

Aric Levin - MVP 30,190 Moderator on at

Like (0)

Report

Hi Allison,

As you mention there is a connector for Logic Apps and Dynamics 365 (Online).

I was looking at the following documentation:

docs.microsoft.com/.../logic-apps-gateway-connection

which allows connecting Azure Logic Apps to On Premise data sources, but Dynamics CRM is not there.

I am not aware of anything out of the box for connection to Dynamics On-Prem. Possibly via BizTalk, or as you mention SQL Server (which will be read only).

Hopefully sometime in the near future.

Was this reply helpful? Yes No
awalters 3,079 on at

Like (1)

Report

Theoretically we should be able to do it via the web API, but I need a definition file. I could just give the base API URL and write all my own definitions that just call Web API URLs, it looks like, but that seems really unnecessary. All of the definitions clearly exist somewhere, since they're (at least, most of them if not all?) the same for Online. Just wish I knew how to find them...:-(

Was this reply helpful? Yes No
awalters 3,079 on at

Like (0)

Report

So interestingly, I just found this page of features for online vs on-prem, and it says this:

Dynamics 365 Connector Updates for Power App and Flow

Both

(from: https://technet.microsoft.com/library/mt812192.aspx )

So this certainly implies there should be a connector...still haven't found an option for it, though. I've looked through Dynamics 365 itself, in case the entry point is there rather than through PowerApps, but can't find anything on that end either (we are on 8.2, so if it was introduced in 365 like the page says, we should be good to go).

Was this reply helpful? Yes No
JohnAnonymous 5,241 on at

Like (1)

Report

I'm guessing that you can connect with onpremises if you are able to authenticate with oauth to your CRM api's. Afaik this is support with the latest version of Windows Server and ADFS.

There are options to connection your logic apps with you onprem envrionment using Gateways (and I think VPN's), but the OOTB connecter requires oauth authentication no matter if you are using a gateway or not.

Was this reply helpful? Yes No
awalters 3,079 on at

Like (0)

Report

"I'm guessing that you can connect with onpremises if you are able to authenticate with oauth to your CRM api's"

We can. But I see no option in the connectors to give our internal URL to in order to even attempt this; that's the issue. The gateway option connects directly to SQL, AFAIK, and so would only be supported for read-only (which isn't what we're looking for).

Was this reply helpful? Yes No
Verified answer

awalters 3,079 on at

Like (0)

Report

Just found out that this is on the ideas site as a suggestion, and currently is in the Planned status. So hopefully soon!

Link for anyone who would like to vote/follow:

powerusers.microsoft.com/.../18733

Was this reply helpful? Yes No
Suggested answer

Community Member on at

Like (1)

Report

Hi Allison,

You can set up a Flow with the "HTTP with Azure AD - Invoke an HTTP Request" connector over the Data Gateway. Just check the Gateway box in the connector during setup. Make sure you test any firewall access between your on-prem servers as applicable. Test each component separately. Finally, if your connection is mis-configured, you can edit as necessary in PowerApps "Connections".

Was this reply helpful? Yes No
StefanS365 3,575 Most Valuable Professional on at

Like (0)

Report

Hi JP,

Could you please describe/show an example of how you configured the connection and the action Invoke an HTTP Request ?

Thanks.

Was this reply helpful? Yes No
awalters 3,079 on at

Like (0)

Report

Yeah - I was never able to parse that and figure out anything to try. Got busy with other things. If anyone has an example, that'd be awesome.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

I'm also looking for the similar kind of issue... My Dynamic 365 was hosted in virtual Machine which is in azure(nothing but on premise) .

Now i want access the Dynamics 365 webapi using logic app from azure.. by creating a new Webapi.. Can you any one suggest me how to achieve my requirement..

Was this reply helpful? Yes No