Skip to main content
Question

Getting data from nested array within API

  • November 16, 2023
  • 5 replies
  • 293 views

Hey, I got a problem with gettin data from an external API in Zapier, which is more nested within the API.

The data I am not able to get are the “Categories” under “JopOpening” (see screenshot attached), which are again having arrays of data, from which I would like to get the “name” Element and insert it within wordpress.

This should just be added as text elements seperated by “,” within a metafield of the wordpress post.

I also attached some screenshot of my zap, the second step was a try to reformat those data, but did not work.

Does anyone have an idea if and how this is possible?

Thanks a lot.

Best regards

Ronja

 

 

 

Did this topic help you find an answer to your question?
This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

5 replies

Troy Tessalone
Forum|alt.badge.img+14

Hi @ronjabaumann 

Observation

You probably want to remove the static “profile” value on the right side.

 


  • Author
  • Beginner
  • 2 replies
  • November 17, 2023

@Troy Tessalone Yes thanks I also deleted this, did not see before. But the main problem is to get the data from the “categories” path, still do not know how to do this.


Troy Tessalone
Forum|alt.badge.img+14

@ronjabaumann 

Try searching for the value of “professional” to narrow down the matching variables to match.

 


  • Author
  • Beginner
  • 2 replies
  • November 29, 2023

Hello again and sorry for the late reply.

I made some progress on the topic, but still did not manage to solve this.

Was able to extract some item list out of the array, but now I only want to get the terms after the highlightes numbers in my list and could not figure out, how to do this. Anyone has an idea?

@Troy Tessalone Thanks for your tips so far!

 


Troy Tessalone
Forum|alt.badge.img+14

@ronjabaumann 

Since the data is output as an Array of items, you’d likely need to use a custom Code step to parse and prep that data.