Answered

How to read JSON file from Azure blob using Power Automate

(0) Share

Report

Posted on by KGG

I have a JSON file which stored in Azure Blob storage and I need to verify the json property(result) using power automate when a new item gets added to the Blob and send an email.

I got Blob SAS url using Power-Automate(FLOW) action(Create SAS URI by path (V2)) but could not find any option to parse JSON with SAS Url.

Sample JSON as below "{"data": {"result": \”ticket\”, \”value\”: 0.767419, "influencers": {"contributor": {"0": \”Server: Process Status: Default\”}, "time": "2021-08-04 12:40:00"}"

All responses (4)

Answers (2)

Verified answer

eric-cheng 5,171 on at

Like (0)

Report

Re: How to read JSON file from Azure blob using Power Automate

Hi @KGG ,

Pass Path.

--------------------------------------------------------------------------
If I have answered your question, please mark my post as a solution
If you have found my response helpful, please give it a thumbs up

Connect on LinkedIn
KGG 11 on at

Like (0)

Report

Re: How to read JSON file from Azure blob using Power Automate

Hi @eric-cheng ,

Thanks a lot for your response.
Your solution works fine when we use action(Get Blob Content V2) where we hardcode the blob eg: /test/test.json as shown in the below screen shot.
Can we ge the latest item. eg: When a new item(new.json) gets added to blob storage, need to get that file(new.json) details.
Please let me know if any clarification required

Thanks again for your help and support.
eric-cheng 5,171 on at

Like (0)

Report

Re: How to read JSON file from Azure blob using Power Automate

Hi @KGG ,

Result from above.

--------------------------------------------------------------------------
If I have answered your question, please mark my post as a solution
If you have found my response helpful, please give it a thumbs up

Connect on LinkedIn
Verified answer

eric-cheng 5,171 on at

Like (1)

Report

Re: How to read JSON file from Azure blob using Power Automate

Hi @KGG ,

Try this

@base64(outputs('Get_blob_content_(V2)')?['body'])

@base64ToString(outputs('Compose'))

--------------------------------------------------------------------------
If I have answered your question, please mark my post as a solution
If you have found my response helpful, please give it a thumbs up

Connect on LinkedIn