Forum Discussion
date range web query help
Hi baltibeginner,
You can create a new table via Enter Data:
Then Invoke Custom Function, add a new column. Click on highlighted button can expand rows:
Best Regards,
Qiuyun Yu
Hi baltibeginner,
Based on my test, you can refer to below steps:
1.Get data from web and use the advanced function, divide your URL into two paragraphs like the picture below.
2.Choose the Table 0 and click the edit.
3.Open the Advanced Editor and insert the "(para as text) as table =>" before the word "let" and use the "para" to replace the "2018-01" like the picture below.
4.Click "done" you can get a function window. When you enter the different date, you can get the result links with the data.
Best Regards,
Qiuyun Yu
Thank you v-qiuyu-msft. This was very helpful. Instead of inputting each date. Am I able to pull a range of dates at once?
Hi baltibeginner,
You can create a new table via Enter Data:
Then Invoke Custom Function, add a new column. Click on highlighted button can expand rows:
Best Regards,
Qiuyun Yu