About Zapier Community
New to our Community? Get to know more about our space and how to make the most of your time here.

Code of Conduct Community FAQ's Zapier Common Questions What to Expect

Get Started With Zapier
New to Zapier? We have got you covered with our Zapier 101 Resources.

Zapier Essentials

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

Zapier Products
Learn more about Zapier's new products.

Zapier Tables Zapier Interfaces

Zapier Reading
All of our best learning resources can be found here.

Featured Articles Show & Tell AI Hub Zapier Tools Hub

Learning Groups
Excited to meet other builders? Check out our interest areas full of doers, dreamers, and in-betweeners.

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.

Best answer

Creating a Foreach Loop in Code by Zapier to create objects from a CSV file

  • 28 July 2020
  • 3 replies
  • 831 views
Ibanez1998
Userlevel 1

Hi,  I am importing a CSV I get from an email and parsing that CSV, but when I go to add the data as contact records in the Mojo app (a CMS system which by the way doesn’t appear to support line items) I get funky results and errors like State: FL, FL, FL, FL (Failed to add record, state abbreviations must be 2 letters only, yours has 12).  So…  I would like to use Code by Zapier to create a ForEach Loop to overcome this issue.  I want the CSV file to be read but only sent 1 line at a time.  I’m struggling with a way to do this.  Does anyone have any suggestions?  I can write to Google Sheets if absolutely necessary, but I’d rather just do this in code and remove additional dependencies.  I have enough dependencies already.

icon

Best answer by TimS 1 September 2020, 19:44

View original
This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

3 replies

steph.n
Userlevel 7
Badge +8

Hi there @Ibanez1998 - Thanks for the question. It sounds like you were on the right track, especially if you want line item support. Our go to is usually Google Sheets but also, have you checked out Formatter by Zapier, specifically the Utilities function that has line item support? Let us know if you have further questions or still need additional support.

TimS
Userlevel 7
Badge +3

Hi @Ibanez1998 !

I spotted your question, and just in case you’re still looking for a way to do this with code, I recently wrote up an article about this in the community here: 

One limitation to be aware of is the maximum number of iterations a Code Step can run through is 250. Are your CSVs less than 250 rows of data?

Please take a look and let me know if you have any questions!

Ibanez1998
Userlevel 1

Hi @Ibanez1998 !

I spotted your question, and just in case you’re still looking for a way to do this with code, I recently wrote up an article about this in the community here: 

One limitation to be aware of is the maximum number of iterations a Code Step can run through is 250. Are your CSVs less than 250 rows of data?

Please take a look and let me know if you have any questions!

Thanks Tim.  At this point I forgot what I was trying to do.  I either did what I needed with a spreadsheet, or I just gave up.

Terms & Conditions