Download tool - adding an integer to an api request url

[jackdaniels]

the api that I am trying to use needs an integer in the middle of the request url. How can I build this url in the download tool?

http://api.lmiforall.org.uk/api/v1/ashe/estimatePay?soc=11&breakdown=gender

[BenMoss]

Hi!

You should look to create your URL in a formula tool

I assume the problem is that you have this value stored in a field and you want to make the request dynamic, in which case you can simply use the tostring() function or change the data type of the field prior to building your URL, for example...

“http://...?soc=”+tostring([SOCFIELD])+”&breakdown...”

[jackdaniels]

Hi Ben!

Thanks for the suggestion. It's solved, but the problem was something else entirely.