Logic App with Deep Insert
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
{ | |
"$connections": { | |
"value": { | |
"dynamicscrmonline": { | |
"connectionId": "/subscriptions/6a539c1f-4415-493f-89b6-9458246ac115/resourceGroups/amreek/providers/Microsoft.Web/connections/dynamicscrmonline-5", | |
"connectionName": "dynamicscrmonline-5", | |
"id": "/subscriptions/6a539c1f-4415-493f-89b6-9458246ac115/providers/Microsoft.Web/locations/australiaeast/managedApis/dynamicscrmonline" | |
} | |
} | |
}, | |
"definition": { | |
"$schema": "https://schema.management.azure.com/providers/Microsoft.Logic/schemas/2016-06-01/workflowdefinition.json#", | |
"actions": { | |
"Generate_the_GUID": { | |
"inputs": { | |
"variables": [ | |
{ | |
"name": "NewGuid", | |
"type": "String", | |
"value": "@{guid()}" | |
} | |
] | |
}, | |
"runAfter": { | |
"Initialize_ChangeSetNo": [ | |
"Succeeded" | |
] | |
}, | |
"type": "InitializeVariable" | |
}, | |
"HTTP-Call CRM API": { | |
"inputs": { | |
"body": { | |
"Contact_CustomerAddress": [ | |
{ | |
"addresstypecode": "1", | |
"city": "@{triggerBody()?['Billing Address']['b_city']}", | |
"line1": "@{triggerBody()?['Billing Address']['b_address']}", | |
"name": "Billing Address", | |
"postalcode": "@{triggerBody()?['Billing Address']['b_zip']}", | |
"stateorprovince": "@{triggerBody()?['Billing Address']['b_state']}" | |
}, | |
{ | |
"addresstypecode": "3", | |
"city": "@{triggerBody()?['Shipping Address']['s_city']}", | |
"line1": "@{triggerBody()?['Shipping Address']['s_address']}", | |
"name": "Shipping Address", | |
"postalcode": "@{triggerBody()?['Shipping Address']['s_zip']}", | |
"stateorprovince": "@{triggerBody()?['Shipping Address']['s_state']}" | |
} | |
], | |
"emailaddress1": "@{triggerBody()?['Email']}", | |
"firstname": "@{triggerBody()?['FirstName']}", | |
"lastname": "@{triggerBody()?['LastName']}" | |
}, | |
"headers": { | |
"Accept": "application/json", | |
"Authorization": "Bearer @{body('Parse_JSON')?['access_token']}", | |
"Cache-Control": "no-cache", | |
"Content-Type": "application/json", | |
"OData-MaxVersion": "4.0", | |
"OData-Version": "4.0" | |
}, | |
"method": "POST", | |
"retryPolicy": { | |
"type": "none" | |
}, | |
"uri": "https://hpecrm365.api.crm6.dynamics.com/api/data/v9.0/contacts" | |
}, | |
"runAfter": { | |
"Parse_JSON": [ | |
"Succeeded" | |
] | |
}, | |
"type": "Http" | |
}, | |
"HTTP-GetToken": { | |
"inputs": { | |
"body": "grant_type=client_credentials&client_id=507cfbe8-c898-4f59-9bb2-b09d579de34c&client_secret=SGDvDTvWb3QqpfBc4SShWuVLceVJLhVVGowPh/HDJdA=&resource=https://hpecrm365.api.crm6.dynamics.com", | |
"headers": { | |
"Cache-Control": "no-cache", | |
"content-type": "application/x-www-form-urlencoded" | |
}, | |
"method": "POST", | |
"uri": "https://Login.windows.net/0cb4884d-d869-4d3e-adb4-c62880b6f645/oauth2/token" | |
}, | |
"runAfter": { | |
"Generate_the_GUID": [ | |
"Succeeded" | |
] | |
}, | |
"type": "Http" | |
}, | |
"Initialize_BatchNo": { | |
"inputs": { | |
"variables": [ | |
{ | |
"name": "BatchNo", | |
"type": "String", | |
"value": "Batch__@{guid()}" | |
} | |
] | |
}, | |
"runAfter": {}, | |
"type": "InitializeVariable" | |
}, | |
"Initialize_ChangeSetNo": { | |
"inputs": { | |
"variables": [ | |
{ | |
"name": "ChangesetNo", | |
"type": "String", | |
"value": "changeset_@{rand(100,999)}" | |
} | |
] | |
}, | |
"runAfter": { | |
"Initialize_BatchNo": [ | |
"Succeeded" | |
] | |
}, | |
"type": "InitializeVariable" | |
}, | |
"Log_an_error": { | |
"inputs": { | |
"body": { | |
"new_description": "@{body('HTTP-Call CRM API')}", | |
"new_httpstatus": "@{outputs('HTTP-Call CRM API')['statusCode']}", | |
"new_name": "contactId :@{triggerBody()?['contactid']}" | |
}, | |
"host": { | |
"connection": { | |
"name": "@parameters('$connections')['dynamicscrmonline']['connectionId']" | |
} | |
}, | |
"method": "post", | |
"path": "/datasets/@{encodeURIComponent(encodeURIComponent('org63b0712d.crm6'))}/tables/@{encodeURIComponent(encodeURIComponent('new_integrationlogs'))}/items" | |
}, | |
"runAfter": { | |
"HTTP-Call CRM API": [ | |
"Failed" | |
] | |
}, | |
"type": "ApiConnection" | |
}, | |
"Parse_JSON": { | |
"inputs": { | |
"content": "@body('HTTP-GetToken')", | |
"schema": { | |
"properties": { | |
"access_token": { | |
"type": "string" | |
}, | |
"expires_in": { | |
"type": "string" | |
}, | |
"expires_on": { | |
"type": "string" | |
}, | |
"ext_expires_in": { | |
"type": "string" | |
}, | |
"not_before": { | |
"type": "string" | |
}, | |
"resource": { | |
"type": "string" | |
}, | |
"token_type": { | |
"type": "string" | |
} | |
}, | |
"type": "object" | |
} | |
}, | |
"runAfter": { | |
"HTTP-GetToken": [ | |
"Succeeded" | |
] | |
}, | |
"type": "ParseJson" | |
}, | |
"Terminate": { | |
"inputs": { | |
"runError": { | |
"code": "@{outputs('HTTP-Call CRM API')['statusCode']}", | |
"message": "Failed" | |
}, | |
"runStatus": "Failed" | |
}, | |
"runAfter": { | |
"Log_an_error": [ | |
"Succeeded" | |
] | |
}, | |
"type": "Terminate" | |
} | |
}, | |
"contentVersion": "1.0.0.0", | |
"outputs": {}, | |
"parameters": { | |
"$connections": { | |
"defaultValue": {}, | |
"type": "Object" | |
} | |
}, | |
"triggers": { | |
"manual": { | |
"inputs": { | |
"schema": { | |
"properties": { | |
"Billing Address": { | |
"properties": { | |
"b_address": { | |
"type": "string" | |
}, | |
"b_city": { | |
"type": "string" | |
}, | |
"b_state": { | |
"type": "string" | |
}, | |
"b_zip": { | |
"type": "string" | |
} | |
}, | |
"type": "object" | |
}, | |
"Email": { | |
"type": "string" | |
}, | |
"FirstName": { | |
"type": "string" | |
}, | |
"LastName": { | |
"type": "string" | |
}, | |
"Shipping Address": { | |
"properties": { | |
"s_address": { | |
"type": "string" | |
}, | |
"s_city": { | |
"type": "string" | |
}, | |
"s_state": { | |
"type": "string" | |
}, | |
"s_zip": { | |
"type": "string" | |
} | |
}, | |
"type": "object" | |
} | |
}, | |
"type": "object" | |
} | |
}, | |
"kind": "Http", | |
"type": "Request" | |
} | |
} | |
} | |
} |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment