Alteryx designer Discussions

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

API Setlist.FM

Highlighted
5 - Atom

Hi I'm a new user to Alteryx. I'm struggling to use it to extract data from the setlist.fm api. I'm searched both here and on the web for more documentation but I'm still struggling to understand how to use it. I've trying to get artist setlist data. It's my first time trying to use an API in this way. And I can't find any good explainers. 

 

The documentation is here: https://api.setlist.fm/docs/1.0/index.html

 

So far I've the Input Data tool, with an url column and an api_key column

 

An example from setlist.fm gives this example Curl request. 

 

How do I configure this in alteryx? Do I use the headers in the Download tool?

 

 

curl -X GET --header 'Accept: application/xml' --header 'x-api-key: qbcdef12345' 'https://api.setlist.fm/rest/1.0/artist/b10bbbfc-cf9e-42e0-be17-e2c3e1d2600d/setlists?p=1'

 

Also is there a way to increment the "p=1"?

 

Apologies for the elementary questions. Thanks for any help!

 

Highlighted
Alteryx Certified Partner

HI @urimpresp ,

 

Attached is a solution showing how to configure the download tool properly and also showing how to add pages.

Since I'm not sure if there is a way to find the max number of pages, I'm using a generate rows to create 5 lines.

fmvizcaino_0-1583368340940.png

 

Example attached.

Best,

Fernando Vizcaino

 

Labels