Get data from Web with date in the link

[mikalhsxxx]

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....

[mikalhsxxx]

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....

---

[v-juanli-msft]

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.

[Nolock]

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.