URL : how to validate question when connecting

[78ChrisPW]

Hello

When connecting manually to this URL 
https://maree.info/7?d=20230206 
we have to accept conditions unless the parameter ?d=20230206  is ignored and we get the current week

Is it possible when connecting with PowerQuery to send the answer so to get the informations concerning the week given by the paramater ?

Thanks a lot for your help

Chris

[78ChrisPW]

Hello

I am very sorry as March 06th is a monday as February 06th, I did not noticed that it was still the current week 😭 that was displayed and not the 20230206 week

The paramater &accept=1 does not answer the question about the conditions...

Another idea ?

Thanks

Chris

[78ChrisPW]

Thanks a lot to DataSlayer, this is perfect 😀
Chris

[MAwwad · Accepted solution]

It is possible to pass a parameter to a URL using Power Query in order to get the information for a specific week. Here is an example of how you can achieve this:

1. Open Power Query Editor in Power BI Desktop or Excel.
2. In the "Home" tab, click on "From Web" in the "Get Data" section.
3. In the "From Web" dialog box, enter the URL "https://maree.info/7" and click "OK".
4. In the "Navigator" dialog box, click on "Edit" to open the Power Query Editor.
5. In the Power Query Editor, click on "Add Column" in the "Add Column" tab.
6. Select "Custom Column" and enter the following formula in the formula bar:

= Web.Contents("https://maree.info/7?d=20230206&accept=1")

Replace "20230206" with the date for the week you want to retrieve information for. The "&accept=1" parameter is added to indicate that the user has accepted the conditions. 7. Click "OK" to create the new column. This will send a request to the URL with the specified parameter and retrieve the information for the specified week.

Note: Depending on the website's terms of use, automated data scraping may not be allowed. Please ensure that you have permission to access and use the data from this website.