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"}"

Categories:

Using flows

I have the same question (0)

All responses (4)

Answers (2)

Verified answer

eric-cheng 5,171 on at

Like (1)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
eric-cheng 5,171 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
KGG 11 on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
Verified answer

eric-cheng 5,171 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No