Get & Transform/Power Query - stop URL changing from %2f to / in web query

gazmeist

New Member
Joined
Mar 10, 2012
Messages
4
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
 

Excel Facts

How to calculate loan payments in Excel?
Use the PMT function: =PMT(5%/12,60,-25000) is for a $25,000 loan, 5% annual interest, 60 month loan.

Forum statistics

Threads
1,224,542
Messages
6,179,424
Members
452,914
Latest member
echoix

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top