Get JSON data from Ticketmaster API

Hi All

I am interested in getting JSON data from the Ticketmaster API and generating a CSV file from the data
I was thinking about writing some code to do this, but since I am enjoying using Make, I am wondering if it is possible to run a query from Make and then format the response maybe into a CSV file

Maybe someone knows an overview of the steps I would need to take

Thanks
Gar

I don’t see why you can’t do that. Make does have JSON and CSV modules.

2 Likes

Ok thanks, I did make some headway in getting the data with a HTTP request, it looks like the data is in JSON format

I do have some knowledge of JSON and XML formats

But not sure of the various Body Types Here

Not sure how to get the data that I want out of here, and possibly put it in a CSV file
For instance I want the Value for the name and the Value for the 16_9 url

Thanks
Gar

You forgot to turn “Parse Response” on:

Screenshot_2023-12-31_191236

If you want to learn more about Make, you can read up in the Help Center. I also recommend doing the tutorials in the Make Academy, and learn advanced skills like how to make custom apps to any API in the Make Partner Training Portal - both have certificates for successful completion.

3 Likes

How can you then get all this data into Google Sheets/ Microsoft Excel?

The JSON structure is impossible to map inside MAKE, its really massive in the structure with arrays inside arrays.

(I am using a different API)

@Samuel_N Welcome to the Make community!

That looks like a new question, could you please create a separate topic for this?

While it’s tempting to hop onto an existing thread, a more effective approach would be to start a new topic just for your question. Why? It helps community experts find and respond to your query quicker, and keeps our space organised for everyone. If you start a new conversation you are also more likely to get help from other users. Thank you for understanding and keeping our community neat and tidy.

Let’s click that “New Topic” link in the top-right of the header and submit your question there!

Screenshot_2023-12-19_091207

2 Likes