Search code examples
azure-logic-apps

InvalidTemplate. Unable to process template language expressions in action 'Parse_JSON' inputs at line '0' and column '0':

InvalidTemplate. Unable to process template language expressions in action 'Parse_JSON' inputs at line '0' and column '0': 'The template language function 'json' parameter is not valid. The provided value

i need to get json file from azure blob storage account and need to use that json file data

issue is

InvalidTemplate. Unable to process template language expressions in action 'Parse_JSON' inputs at line '0' and column '0': 'The template language function 'json' parameter is not valid. The provided value

enter image description here

i used to get the input from azure get content json(body('Get_blob_content_(V2)'))

enter image description here

i tryed to get input from get blob content json(body('Get_blob_content_(V2)'))

i checked with inserd json file in parse json input it working

output from Get_blob_content_(V2)

Solution

  • When you use Get Blob Content(V2) action then the outputs we get in content-type: application/octet-stream.

    If you want to get the actual json file and Parse it, you could do the following-

    enter image description here

    enter image description here

    By doing the above actions, I am able to get the data in expected format.

    enter image description here

    enter image description here

    In this way, you can get the expected result.