Skip to main content
Question

Return Array of References

  • September 19, 2024
  • 2 replies
  • 16 views

Apologies for the long subject title!

I have a field that I need to extract data from.

Sometimes, the field value would be “ABC1234, A Short Description Here”. I can extract the “ABC1234” successfully to use as a reference to find and update a record in another system.

However, on occasion, the reference may be “ABC1234, DEF1234, GHI1234, A Short Description Here”.

Is there any easy way to collect all the references without the “A Short Description Here”, then loop through these references to find the records in another system, and subsequently update them all with their own values?

So, in the above case I would need to find and update ABC1234, then find and update DEF1234, and finally find and update GHI1234.

Thank you!

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.

2 replies

Troy Tessalone
Forum|alt.badge.img+14
  • Zapier Expert
  • 30739 replies
  • September 19, 2024

Hi @AndyPAV 

The Looping app can be used to iterate once you have the array of items: https://zapier.com/apps/looping/help

There would need to be something consistent about the codes and/or the descriptions to be able to parse those out from a string.

Can you provide real examples of the data you are trying to work with?


  • Author
  • Beginner
  • 5 replies
  • September 23, 2024

@Troy Tessalone Amazing, thank you!

I’ve managed to create an array and successfully loop through each record.