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

Active Campaign error 422 custom date field

  • 13 November 2023
  • 4 replies
  • 184 views
K
Userlevel 1

Hi Zapier community!

I seek help for a WooCommerce → Active Campaign zap, where I transfer subscription data from Woo to create-update records in AC, including dates in some custom date fields. Zap is straight forward except I receive error on testing the Action step: "The value for custom date field ID 7 looks invalid. Please use this format: YYYY-MM-DD. (422)".

I use a Formatter step to convert all dates from Woo format to Active Campaign format (YYYY-MM-DD). I’ve played with a few output options, and still receive the same error.

Any advice to troubleshoot? For example, how do I identity which field is ID 7, and so causing this issue?

Many thanks for suggestions! Screenshots below.

Error message
Action step with one of three date outputs

 

icon

Best answer by Troy Tessalone 13 November 2023, 20:13

View original

4 replies

Troy Tessalone
Userlevel 7
Badge +14

Hi @Katie Glassman 

Good question.

Try testing with just the output from Step 2.

 

⚡ Troy Tessalone - AutomationAce.com | Premier Certified Zapier Expert | #1 Zapier Community Contributor
K
Userlevel 1

Hi Troy

Thank you! You’re a rock star!

This worked and an obvious mistake in hindsight. I appreciate the swift and so helpful response. 

Cheers!

ken.a
Userlevel 7
Badge +6

That’s an amazing news @Katie Glassman! Big thanks to Troy for pointing you in the right direction!

If you have any other questions, please don’t hesitate to reach out to the Community. We’re always happy to help! 😊

K
Userlevel 1

Will do - It does appear that I already have another question, for which I’ll search existing threads first to see if it’s already answered.

Meanwhile, this issue has been solved for me. Thanks again.

Reply


Terms & Conditions