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.

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.

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.

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!

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