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:

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.