Logic Apps (Insert or Merge Entity into Azure Table)
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.'.