Create a gist now

Instantly share code, notes, and snippets.

What would you like to do?
Logic App with Deep Insert
{
"$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