Skip to main content

Get Support
Have a question? Let's get you an answer!

How Do I...? Troubleshooting Code & Webhooks Developer Zone

Other Help Resources
Wait, there's more! Check out these Community sourced spaces for additional resources.

Zapier Help Center Hire an Expert

Learning Resources
All of our best learning resources can be found here.

Featured Articles Show & Tell Zapier's products AI Hub Zapier Tools Hub

Share your knowledge
Give back to the Community by sharing your automation wins and helping to answer questions.

Share your success See unanswered questions User Groups

Other Learning Resources
Some of our favorite additional ways to upskill your Zapier knowledge.

Zapier Learn Zapier Blog Zapier Webinars

Product Updates
Check out what is new and upcoming with Zapier with our regular product updates.

Product Updates

Early Access Program
Want to join Early Access? Learn more here.

  • Home
  • Get Help
  • How Do I
  • How do I extract product_name and product_id from a multidimensional array in Zapier to use in my CRM?

Hi

I am relatively new to Zapier. We have a data source in our first step that includes what looks like a multidimensional array data structure called ‘Orders’

 

All fine so far.

However when we try extract this data for inclusion in a CRM database in step 3, this “orders-lines“ variable is combined into a comma separated string (see below) and we are unable to split the values open to use in different fields.

 

 

How do We can access product_name and product_id from that array?

 

Thank you

Hey @Rachel at JUSTSO 

 

Before i share the solution, can you tell me what are you trying to achieve? What kind of record are you creating in CRM?

Hey @Rachel at JUSTSO 

 

Before i share the solution, can you tell me what are you trying to achieve? What kind of record are you creating in CRM?

 

We have built our store using an eCommerce Platform Called DecoNetwork. 

We are trying to move all the order information from DecoNetwork to Our Marketing CRM using LeadConnector. 

 

 

Hey @Rachel at JUSTSO ,

 

Understood. Well you can use Formatter by Zapier OR Code by Zapier to extract the item name and qty. 

Hey @Rachel at JUSTSO ,

 

Understood. Well you can use Formatter by Zapier OR Code by Zapier to extract the item name and qty. 

 

Hi @jayeshkumarbhatia 

I am having problem to loop through data to fetch required value. Do I need nested loop for for loop?

- Rachel

 

Terms & Conditions