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:

I am interested in

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


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: