Logic Apps: Problems with "Parse JSON"

Question

Hey guys,

i need to parse a JSON of an AZ Table Storage:

My Workflow looks like this: 1) Trigger-> 2) [AZ Table Storage] Get Entities-> 3)[Data Operations] Parse JSON-> 4)[AZ Table Storage] Insert Entity (in second table storage).

After Mapping the variables of step 3 in step 4, the result is empty.

Maybe there is a problem with parsing the JSON?
I've chosen "Get entities result" as content. Is that right?

Can anyvone help me with entering the JSON Schema of the AZ Table Storage in Step 3?
My Table Strage looks like this: PartitionKey l RowKey l Column1 I Column 2 (all strings)
How does the JSON schema look like?

Is ther a way of exporting a JSON for a sample payload out of AZ table Storage?

Thanks for your help!

Answer 1

@Raphael Schnizler Thanks for reaching out. The JSON schema will be different based on your query and what output a particular connector will be returning.
In your case, as you are using Get Entities action. I will suggest you to first build your query and once you have finalized the query then execute your workflow once and navigate to the run history of your workflow. Navigate to your Get Entities action and copy the output which will help you to generate the JSON schema for your Parse JSON action.

To get the output from Get Entities action :

Once you have the output you can now Use Sample payload to generate schema option on your Parson action as below. Make sure you have used Content value as Get entities result List of Entities output of your Get Entities action

When you hover over the Entity value for Insert Entity action it will show you the format what is expected. Now you can leverage the output of your Parson Json action as token and leverage to build what value you want to insert on your new table.

The above is only for reference and you need to modify it as per your requirement. Feel free to get back to me if you need any assistance.

Please 'Accept as answer' and ‘Upvote’ if it helped so that it can help others in the community looking for help on similar topics.