Adding parameters with specific formatting.

[Don_Davis]

I am trying to add parameters to an API call.

The final format would be:

https://some.url.com:0000/api/3/endpint?page=0?size=20

I am passing in:

https://some.url.com/:0000

I need to add the [x] as it will change throughout the pipeline.

/api/3/endpoint

and then add on the parameters

?page=0?size=20

I will also need to change the page# as I iterate thought the pages but that is the next hurdle.

I have tried adding params to the payload in the downloads tool as:

Name       Value                      

params

'&'['page=0&size=500']

I have also tried putting the params in the text input tool as:

URL                      params
https:/someurl      index=0
                             size=20

and also tried using the formula tool:

params

'?page=0size=20'

all to no avail. Some guidance would be nice TY

[Felipe_Ribeir0 · Accepted solution]

Hi @Don_Davis 

Take a look at this example, it is doing exactly the same thing for another API (creating the url with formula and iterating through the pages using iterative macro), you can take the ideas from here and adapt to your situation.

SurveyGizmo/Alchemer API - GET survey data - Alteryx Community

You can keep the fixed parameters in a text tool and use the formula to concatenate them.

If the provided answer helped you to solve the problem/was correct, please accept it as a solution :)

Thanks.