You’re offline. This is a read only version of the page.
Announcements
11
I am creating a flow to use the API to our HR system, to pull a report of all employees with specific fields. These fields then need to be added to a csv file and uploaded to another system.
So far I've got my flow to successfully query the API. The system website has some query builders which help with that, so I created the first part of my flow. The part underlined in blue, i can change the format of what is returned to be either CSV, PDF, XLS, XML, JSON. For the moment JSON is configured.
The next step then i need to take the data which is returned, which when i run a test can view all the records returned - so this call is working. And with the returned data do something with it.
End goal is to have it in a csv file with headers over the 10 rows which will then have the data beneath.
BUT, this is my problem - the call is successfull and returns the data - but then I cannot get it to pass it anywhere.
I added a Parse JSON action shown below and generated the Schema from the output of the previous step (Schema at the bottom of the post for reference)
Then i add an update row in excel to do what i expect would take the data and update the rows with it, however this is where i then get the error
I'm new to this and so not sure where to go next. I've tried a variety of different things, but nothing seems to work
Thanks
I managed to resolve this issue already using power automate built in actions.
Posting this here to then close the topic incase it ever helps anybody else
I changed the format of what i was receiving from the api to CSV
I then just simply used the create file action. I originally didn't expect this action would have worked without parsing or doing something with the data received from the HTTPS request
Set the File Content to the body of the HTTPS response and hey presto!
Share
Report
All responses (
Answers (
