JeffGrant
Well-known Member
- Joined
- Apr 7, 2021
- Messages
- 558
- Office Version
- 365
- Platform
- Windows
HI all,
at the moment, I run queries that look like this everyday. (except for the API Key)
= Csv.Document(Web.Contents("https://old.puntingform.com.au/api/formdataservice/GetTrainerStrikeRateData/12-Jan-2023?ApiKey=XXXXXXXXXXXXXXXX"),[Delimiter=","])
The only part that changes is the date just before the API key. (in Red and Bold)
How can I set the query up so that the data is automatically changed to todays date without me having to edit every query?
Thaks for yoru help.
at the moment, I run queries that look like this everyday. (except for the API Key)
= Csv.Document(Web.Contents("https://old.puntingform.com.au/api/formdataservice/GetTrainerStrikeRateData/12-Jan-2023?ApiKey=XXXXXXXXXXXXXXXX"),[Delimiter=","])
The only part that changes is the date just before the API key. (in Red and Bold)
How can I set the query up so that the data is automatically changed to todays date without me having to edit every query?
Thaks for yoru help.