Logic Apps (Insert or Merge Entity into Azure Table)

Mike Schuman 1 Reputation point
2021-05-15T04:50:35.537+00:00

I have been using Logic Apps to call a REST API > Convert the .csv output to JSON > Parse the JSON and then try to Insert or Merge.

Note: The Parse function kicked up errors directing me to change all items to type=string which now tests fine. However, the below error on the Insert or Merge has me at a dead end now that I have no integers in my JSON (only strings).

ERROR MESSAGE
InvalidTemplate. Unable to process template language expressions in action 'Insert_or_Merge_Entity_2' inputs at line '1' and column '3296': 'The template language expression 'body('Parse_JSON')?['AccountSid']' cannot be evaluated because property 'AccountSid' cannot be selected. Array elements can only be selected using an integer index. Please see https://aka.ms/logicexpressions for usage details.'.

Azure Table Storage
Azure Table Storage
An Azure service that stores structured NoSQL data in the cloud.
171 questions
Azure Logic Apps
Azure Logic Apps
An Azure service that automates the access and use of data across clouds without writing code.
3,213 questions
{count} votes

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.