Scrape data single URL multiple pages with Power Query

[Gargamelbarbosa]

Hi,
I need scrape data from https://www.tradingview.com/markets/cryptocurrencies/prices-all/ with all pages. But URL address always same and I can't select other pages
Example : Performance - Oscillators etc..

Thank you for your help.

 

[Nebu]

Hi:

Find the attached, I have written a function to paginate through all the pages in API connection.

Thanks
Nebu

 

[Gargamelbarbosa]

Hi:

Find the attached, I have written a function to paginate through all the pages in API connection.

Thanks
Nebu

Thank you very much for your example file. I solved %50 of my problem. Another problem is with SUBPAGES. I can't get data from "Performance" ,"Oscillators" and "Trend-Following " .Becasue when i click that pages main URL doesn't change. I can always get same page. I hope I could explain my other problem.
Than you so much again,

 

[Nebu]

Hi:

I believe if you pay for the service they will give you the APIs needed for these tabs unless you get the REST APIs for these tabs it cannot be extracted as these are separate tables.

Thanks

 

[Gargamelbarbosa]

Thank you..