Multiple inputs for Request Parameters (Filterable Attributes) for API

Question

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!

text input snip.JPG

payload.JPG

Yoshiro_Fujimori · Answer

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

CountyTextaabcbbcdccdeddef

Filter Conditions

Countyac

Expected Output

CountyTextaabcccde

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

I hope this helps. Good luck.

1277206.yxmd

iracine · Answer

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!