Important Community update: The process for changing your account details was updated on June 25th. Learn how this impacts your Community experience and the actions we suggest you take to secure your account here.

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Multiple inputs for Request Parameters (Filterable Attributes) for API

Bigdog1923
5 - Atom

I'm using the download tool to pull down information from an API connection. 

 

I'm able to use a text input field to filter by county - but what do I need to change to filter by more than 1 county at a time? 

 

New to Alteryx so any help is much appreciated!

 

 

 

 

2 REPLIES 2
iracine
7 - Meteor

Hello, @Bigdog1923 perhaps your api Is able to receive multiple counties by a comma separated string? county1, county2, county 3

If so you can concatenate your counties using the summary tool and renaming the field to county

The other option would be to send multiple requests by the counties you want to download data from. Each row would be a request to the api. 

 

Have a fantastic day! 

Yoshiro_Fujimori
15 - Aurora

Hi @Bigdog1923 ,

 

I assume you have a list of counties to use as a filter and apply it to the downloaded data (which has [county] field) as below.

 

Data from Download Tool

CountyText
aabc
bbcd
ccde
ddef

 

Filter Conditions

County
a
c

 

Expected Output

CountyText
aabc
ccde

 

In this case, you can use Join Tool as a filter.

1277206_Workflow.png

 

I hope this helps. Good luck.

Labels