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