Hey All
Apologies if this has been covered anywhere but searches have been no joy for me.
Excel 2016 - Web Query (Get & Transform) is prompted to retrieve API data from an address that contains this in the later portion of the URL
...FLEMINGTON%20R05%2020%2F01?jurisdiction=NSW&fixedOdds=true
The query fails, as the process is automatically coverting the %2f to / (which is not desired in this case)
...FLEMINGTON%20R05%2020/01?jurisdiction=NSW&fixedOdds=true' (404): Not Found
Does anyone know any way to prevent this? I've explored the settings on the "Source" where the error takes place, and it's opening the file as 'Json' with File Origin set to 'None". Have tried a number of other file origins but they have no impact.
Cheers guys
Apologies if this has been covered anywhere but searches have been no joy for me.
Excel 2016 - Web Query (Get & Transform) is prompted to retrieve API data from an address that contains this in the later portion of the URL
...FLEMINGTON%20R05%2020%2F01?jurisdiction=NSW&fixedOdds=true
The query fails, as the process is automatically coverting the %2f to / (which is not desired in this case)
...FLEMINGTON%20R05%2020/01?jurisdiction=NSW&fixedOdds=true' (404): Not Found
Does anyone know any way to prevent this? I've explored the settings on the "Source" where the error takes place, and it's opening the file as 'Json' with File Origin set to 'None". Have tried a number of other file origins but they have no impact.
Cheers guys
