Answered

JSON Download Url to CSV

(0) Share

Report

Posted on by Community Power Pla...

Hi guys,

I'm a total noob when it comes to Power Automate. But, I need to create a flow to pull API data daily. I was able to setup 2 HTTP requests (Post & GET) and the Parse that information to get a download_url but this is where I am stuck.

The last Parse JSON 2 contains the following object/string. I need to either download the "download_url" or parse out the data and upload it to OneDrive or google sheets.

Categories:

Building flows

I have the same question (0)

All responses (14)

Answers (1)

schwibach 2 Moderator on at

Like (0)

Report

body('HTTP')?['download_url'] is what you want to put in the expression.

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

@schwibach - What step would I use that after the Parse JSON?

Was this reply helpful? Yes No
schwibach 2 Moderator on at

Like (0)

Report

you can put this in a compose action instead of the Parse_Json action.

Parse Json only helps you reference dynamic content without having to write out the code each time.
This: body('HTTP')?['download_url'] already is the code.

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Ok, I'm not actually following. Sorry, I'm very new to PA.

The first HTTP request is a POST request that returns an ID. That ID gets parsed out to run a second HTTP GET request which then provides a download_url.

I've added a compose set with the body('HTTP')?['download_url'] expression and get the following:

I click to download and nothing happens.

Was this reply helpful? Yes No
schwibach 2 Moderator on at

Like (0)

Report

can you show me the outputs of the HTTP action?

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

HTTP (1):
HTTP (2)

Was this reply helpful? Yes No
schwibach 2 Moderator on at

Like (0)

Report

So, it's the second HTTP action

Try putting this expression in a compose action after the second HTTP action.

body('HTTP_2')?['download_url']

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Looks like it worked but still not sure on final steps?

Was this reply helpful? Yes No
schwibach 2 Moderator on at

Like (0)

Report

Well, what do you want to do with that URL, it's now available to you for everything you want.

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Ultimately I want to connect to the data source through PowerBI. Once I can get a connection, I want to schedule the flow to update once per day. If it's possible to either access it directly via Power Automate or download the csv file to OneDrive, either would work.

Was this reply helpful? Yes No