I have previously used PQ to access information about scheduled sports matched on a webpage that is discontinued and replaced by an API-service.
The host of the information is the Norwegian Handball federation and the information is publicly accessible, no tokens, credentials etc...
As an alternative to API-option, the page on the following address https://www.handball.no/system/banedagbok/ is generating the same information I previously accessed, but you have to select your venue and the date range in order to get the correct output.
Knowing the venue ID I need info for, I can use the "direct" URL: https://www.handball.no/system/banedagbok/?venueUnitId=4425
However, after filter to the correct venue or accessing the venue URL directly, the page URL does not change/show more detail after selecting date range and clicking "Vis kamper" (Translated: "Show games"). Additionally I need to have the checkmark for "Vis flere detaljer" active to get the right dataset.
I can use the URL directly in PQ for getting data from a website, but how would I configure the query to select the correct start/end date?
This would be 'fixed' dates as I would always use the same date range (01.08.24 - 01.07.25) to get a similar dataset each time I refresh my spreadsheet where the queary is to be used.
Looking for input on how to modify PQ source details so that I can access the output of correct venue and start/end date and pull this into a table for further transforming and use.
![Picture of venue information.png Picture of venue information.png](https://chandoo.org/forum/data/attachments/88/88402-1ede52c3d1d52155b4f717333caccbd2.jpg)
The host of the information is the Norwegian Handball federation and the information is publicly accessible, no tokens, credentials etc...
As an alternative to API-option, the page on the following address https://www.handball.no/system/banedagbok/ is generating the same information I previously accessed, but you have to select your venue and the date range in order to get the correct output.
Knowing the venue ID I need info for, I can use the "direct" URL: https://www.handball.no/system/banedagbok/?venueUnitId=4425
However, after filter to the correct venue or accessing the venue URL directly, the page URL does not change/show more detail after selecting date range and clicking "Vis kamper" (Translated: "Show games"). Additionally I need to have the checkmark for "Vis flere detaljer" active to get the right dataset.
I can use the URL directly in PQ for getting data from a website, but how would I configure the query to select the correct start/end date?
This would be 'fixed' dates as I would always use the same date range (01.08.24 - 01.07.25) to get a similar dataset each time I refresh my spreadsheet where the queary is to be used.
Looking for input on how to modify PQ source details so that I can access the output of correct venue and start/end date and pull this into a table for further transforming and use.
![Picture of venue information.png Picture of venue information.png](https://chandoo.org/forum/data/attachments/88/88402-1ede52c3d1d52155b4f717333caccbd2.jpg)