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.

Question

Error when running a zap between webhook to Mailjet

  • 7 March 2024
  • 9 replies
  • 31 views
C

Hi,

I setup a new zap that catch a webhook and than supposed to “Subscribe Contact to Mailjet List in Mailjet”.

 

The data from the webhook retrieved correctly, but something in the action on Mailjet not working.

I’m getting this error message:
 

This Mailjet step hit an error

Error message: The app returned `{"message":"Error while making /contactdata API call - [{ \"dateneeded\" : \"CM09 \"05/01/2024\" is not a valid datetime value for key dateneeded\" }]"} What happened: Executing creates.subscribe_to_list.operation.perform with bundle

Can you please guide me what could cause this error?

9 replies

Troy Tessalone
Userlevel 7
Badge +14

Hi @comparethecloud 

We will need to see screenshots with how the step is outlined and configured, in order to have full context.

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

Attached screenshots

 

Troy Tessalone
Userlevel 7
Badge +14

@comparethecloud 

Error seems to indicate the date/time values was not in the right format.

Try this format: YYYY-MM-DD

Don’t see where this field and value are configured in the screenshots from the Zap EDIT mode.

 

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

Thank you, but it is still not working.

I added the format change but still getting the same error.

Any other option?

 

Troy Tessalone
Userlevel 7
Badge +14

@comparethecloud 

Check the field description for possible guidance.

 

Help article from Mailjet to reference for valid timestamp formats:

https://documentation.mailjet.com/hc/en-us/articles/360042706774-Which-date-formats-are-supported-by-Mailjet

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

Thank you.
It seems like the mm/dd/yyyy format is supported but error is still shown.

Troy Tessalone
Userlevel 7
Badge +14

@comparethecloud 

You may have to try reaching out to Mailjet Support for help troubleshooting with their Zap app integration.

 

 

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

Will do. thank you

ken.a
Userlevel 7
Badge +6

Hi @comparethecloud,

I’m jumping in to see if I can help!

I did some digging into our notes, and it seems like the issue here is due to the format of the date. Could you please use a Date/Time Formatter step to convert the date to the format: YYYY-MM-DDTHH:mm:ssZ (2006-01-22T23:04:05-0000)? Mailjet likes this much better.

Also, be sure to define the From format in your Formatter step!

Kindly give it a try and let me know how it goes? I'll keep an eye out for your response!

Reply


Terms & Conditions