Create new records in CRM from JSON data in Blob Storage

If you want to create new records from a json data, you can do it by using Logic App.

First you need to make sure to upload json file in blob container

Steps for Logic App:

• First select a HTTP Trigger block in a new logic app designer

• Next step is to select Get blob content (V2) and choose the storage account name and the blob file where you uploaded the json file.

Note: If you don’t have a connection to Blob Storage account already you need to create one by clicking on change connection and the Add New.

You need to fill the details properly to create a correct connection.

Access Key of the storage account can be found in Storage account in access keys section

• Now select Parse Json block to extract all values. Click on use sample payload and paste your payload there to get a schema.

Note: In Content if you directly put File content then you will get error after you run the logic.

Error:

You get this error so for the you need to convert the octet-stream file to json file by writing the following function

json(body(‘Get_blob_content_(V2)’))

• Now once your json is parsed you need to create record in CRM using this data by selecting Create a new record block in CRM.

You need to first sign in with your CRM account and then choose the organization and entity.

Later you need to map the fields.

Note: If there are mulitple records in json then the logic app will automatically take the create new record block in  for each block as a step.

Now the records will be created in CRM.