Hello Microsoft Enthusiast,

Azure is LCNC(low-code/no-code)development platform.There are several triggers available.It is always exciting to work and explore them.So I am demonstrating one of them i.e. When a HTTP request is received.

Scenario: This is the integration between Biz talk Server and Dynamics 365. Azure Logic Apps listens Biz talk Server whenever it receives JSON object and perform the further crud operation. My scenario operation is : If Account exists in Dynamics 365 then update the Account’s address details based on the received ‘Account Number’ from the biz talk server’s request in the Logic Apps.

Let’s start as follows:

#1: Create a logic apps with the template: ‘When a HTTP request is received’. When you click on ‘Save’ button endpoint will be generated automatically and click on ‘Use sample payload to generate schema’.After this a window will popup, paste the JSON(It is prerequisites for you and will differ case to case.) in pop-up window. In this way, ‘Request Body JSON Schema’ will get structured automatically.

Some of the sensitive data has been hidden in some of the screen shot.

#2: Initialize the variable for ‘Account Number’ and ‘Account ID’. Query the ‘List records’ to check whether the Account is present or not in Dynamics 365 based on the received Account Number from Biz talk request.

#3: loop the received input in ‘For each’ loop. Put the condition where Account Number is equal to Biz talk Account Number.

#4: If condition is true then set Account’s Guid in Account ID variable and update the address details in Acoount. Refer the below Screen.

#5: Send the ‘200’ Status Code as Response message to Biz talk Server. So that Biz talk get to know that sent request has been processed successfully. 😊

Test: Once Logic Apps received request from Biz talk, It updates Address details of particular Account.

If you want more clarification/information.Don’t forget to comment.I will be happy to assist you. 🙂

Hope it helps to some extent.

May the DynamicsPower be with you!

Hello Reader,

Have a quick look on how to create Azure Logic App Custom Connector to create contact in HubSpot.

Disclaimer: I am assuming that you are familiar with Azure and have Azure Subscription to login on portal.azure.com with your credentials (If Not, you can comment to get more information/clarification.)

The steps are as follows:

Step 1: Create a new Resource Group if you don’t have, else start with the existing one like me. Go to the Resource Group and add Logic Apps Custom Connector and name your Custom Connector as per your wish and click on “Create”. Refer below Screen. Wait till it get deployed to resource group successfully.

Step 2:  Start with Rest API-end point and OPEN API file

Step 3: Scroll down a bit and fill the Host API base url (Currently working in General Tab) and click on the “Security”, you will be moved to Security tab.

Step 4: I chose No Authentication Since it will authenticate from HAPI key in its next Definition tab. Click on “Definition”.

Step 5: Welcome to Definition tab, Add Action by entering Summary, Description, Operation Id as below:

Step 6: Scroll down a bit within the same page and click on “import form sample” which you can find under ‘Request’.

Step 7: Please remain on the same page, you will get a pop-up window immediately on the right-hand side to fill-in the request information as:

Verb-Post,

URL-https://api.hubapi.com/contacts/v1/contact/?hapikey=demo,

Body–

 {   
"properties": 
[     
{       "property": "email"  },     
{       "property": "firstname"},     
{       "property": "lastname"},     
{       "property": "website"},     
{       "property": "company"},     
{       "property": "phone"},     
{       "property": "address"},     
{       "property": "city"},     
{       "property": "state"},     
{       "property": "zip"}   
] 
} 

After clicking on “Import”, the pop-up window will disappear.

Step 8: Click on “Update connector”, and you are good to go with your custom connector. You will get notification” Custom Connector has been successfully updated.”

This Connector will be used in my next blog. Stay tuned to see it in action.

Hope it helps to some extent !

May the DynamicsPower be with you ! 🙂