cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
mikalhsxxx Frequent Visitor
Frequent Visitor

Get data from Web with date in the link

Hello Community.

 

I have a woocommerce website and an Export module installed on the site.

the export module provides 3 links. The first triggers the report creation. The second returns the status...proccessing...complete and the 3rd that downloads the file (Excel).

 

I want to use Power Query to do the job. I.e. trigger, wait, when status is complete to download the file and bring it for transformation.

 

Can you help me on how to do that So Far I see only Get Data -> From Web but only allows one link to be inserted....

3 REPLIES 3
Community Support Team
Community Support Team

Re: Get data from Web with date in the link

Hi @mikalhsxxx 

Based on my knowledge for Power BI, i'm afraid these requirements are unable with Power BI.

 

Best Regards
Maggie

 

Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Super User
Super User

Re: Get data from Web with date in the link

Hi @mikalhsxxx,

it won't be simple but I'm sure it is possible. You can't just click it all in the UI but you have to write your PowerQuery query which does the job for you. What you need is the following function: Invoke.After. You use this function for calling your web requests after a defined amount of time.

 

mikalhsxxx Frequent Visitor
Frequent Visitor

Re: Get data from Web with date in the link

Thanks....it seems that I have to try the Invoke.After and see if I can implement it!


@mikalhsxxx wrote:

Hello Community.

 

I have a woocommerce website and an Export module installed on the site.

the export module provides 3 links. The first triggers the report creation. The second returns the status...proccessing...complete and the 3rd that downloads the file (Excel).

 

I want to use Power Query to do the job. I.e. trigger, wait, when status is complete to download the file and bring it for transformation.

 

Can you help me on how to do that So Far I see only Get Data -> From Web but only allows one link to be inserted....


 

Helpful resources

Announcements
New Ranks and Rank Icons in 2020

New Ranks and Rank Icons in 2020

Read the announcement for more information!

New Kudos Given Badges Coming

New Kudos Given Badges Coming

We're rolling out new Kudos Given badges. Find out how many Kudos you've given.

Power Platform World Tour

Power Platform World Tour

Find out where you can attend!

Top Solution Authors
Top Kudoed Authors (Last 30 Days)