cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
rotator
Level: Powered On

Collect JSON Data from Multiple Web Links and Write to Single Excel Table

Hello,

 

We use software from a third-party vendor and we need to capture their data on a daily basis.

 

Their output sits on the web and we can capture it in Flow via HTTP GET. The path is https://api.SERVER.com/DATA/###/flow?start=0&api_token=PASSWORD. #### has a static range from 100 to 999. The PASSWORD is essentially a static constant. 

 

We are able to build a flow that captures data in JSON format from a specific path, e.g. https://api.SERVER.com/DATA/111/flow?start=0&api_token=PASSWORD.

 

However, we are having issue with converting this into a loop, with issues being:

(1) concatenating/union/appending JSON files,

or (2) if converting each JSON data batch, incrementally appending multiple rows to Excel,

and (3) properly skipping blank data sets (some of the urls have no record and return errors).

 

Could you please help us with building the flow?

4 REPLIES 4
rotator
Level: Powered On

Re: Collect JSON Data from Multiple Web Links and Write to Single Excel Table

 

This is how our flow is currently setup:

 

flow.png

 

 

rotator
Level: Powered On

Re: Collect JSON Data from Multiple Web Links and Write to Single Excel Table

 

This is how our flow is currently setup:

 

flow.png

 

 

Community Support Team
Community Support Team

Re: Collect JSON Data from Multiple Web Links and Write to Single Excel Table

Hi, @ rotator,

 

Could you please share a full screenshot with details of the configuration of your flow?

 

 

For your first question,do you want to concatenate/union/append JSON files?

Please take a try to use "Append to array variable" to realize your needs.

 

For your second question,could you please explain more about the converting each JSON data batch?

if you want to insert date to excel, you could use the "Insert row" action.

 

For your third question,I afraid  skipping blank data sets is not supported in microsoft flow currently,

You could post this idea in the Flow Ideas forum, so it might be considered for future releases.

https://powerusers.microsoft.com/t5/Flow-Ideas/idb-p/FlowIdeas

 

 

 

Regards,
Alice Zhang

rotator
Level: Powered On

Re: Collect JSON Data from Multiple Web Links and Write to Single Excel Table

Alice, thank you for your reply. Here is the full flow.flow_01.PNG

 

flow_02.PNG

 

 

Based on your resposnes above, it sounds like I may need to ajdust the construction of the flow. Could you plesae give me a some guidence on how to change/adjust the blocks?

 

Right now my flows fails with good data. The schema was constructed by copying in the exactly same sample payload that it currently fails on.flow_error_jsonparse.PNG

 

 

 

Helpful resources

Announcements
firstImage

Microsoft Business Applications Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

firstImage

Watch Sessions On Demand!

Continue your learning in our online communities.

Power Platform 2019 Release Wave 2 Plan

Power Platform 2019 Release Wave 2 Plan

Features releasing from October 2019 through March 2020

thirdimage

Flow Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

fifthimage

Microsoft Learn

Learn how to build the business apps that you need

sixthImage

Power Platform World Tour

Find out where you can attend!

seventhimage

Webinars & Video Gallery

Watch & learn from the Flow Community Video Gallery!

Top Kudoed Authors
Users Online
Currently online: 260 members 4,922 guests
Please welcome our newest community members: