Parsing Complex json

Hello everyone,

I am trying to build a workflow that will connect to some json and parse through to pull out Italian football match data:

https://api2-mtc.gazzetta.it/api/v1/sports/calendar?day=3&sportId=1&competitionId=21

I am interested in

date
shortTeamName under both awayTeam and homeTeam

How can I run through this json in n8n?

I am picking up the json via an HTTP Request.

Many thanks for any help you can offer!

Hey @britaliano,
you can use the Item Lists node to split out games and matches and use the Set node to get the AwayTeam and HomeTeam.

Here is an example workflow

2 Likes

That’s amazing! You’re amazing!

I’ve been playing with it a bit, how would I drill down to “teamName” inside AwayTeam and HomeTeam?

I tried adding another split but couldn’t get the reference right.

Thank you so much, this gives me a massive step forward!

1 Like

Oh! I did it!

Thanks again, I’ll learn huge amounts from understanding your work!

1 Like

Great to hear that you were able to progress :+1: