Skip to main content
Question

Why is number string being interpreted as a date in Zapier?


Hello-

 

Here are the details of my issue.

I have a trigger that executes and then action will follow it and do a particular work.
In this trigger we have a filed named as  “insured_insured_id”. This field is string in nature.
End user can put either number or alphanumeric. e.g 100698 or 123ABC .
When user enter number like 100698 , zapier gives the following error.
 

Field "insured_insured_id" is not a valid ISO-8601 date in latest task (task ID: 00a2cd57-0646-ad14-83b6-fe2f097714e1).

We are very close to publish over application but this issue is the main hurdle.
Kindly help to fix this bug.

 

I am also attaching the images for reference.

 

Many Thanks-

Did this topic help you find an answer to your question?
This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

9 replies

Troy Tessalone
Forum|alt.badge.img+14

cc: @ikbelkirasan 


ikbelkirasan
Forum|alt.badge.img+12
  • Zapier Expert
  • 555 replies
  • August 13, 2021

Hi @NowCerts - Try checking the sample & the output fields definition in the trigger and see if the field insured_insured_id has the same type as in the latest task.


  • Author
  • Beginner
  • 7 replies
  • August 13, 2021

@ikbelkirasan , thanks for your reply.
I am attaching four images for your reference .In sampling it is in string.
In real time data it is in string. Kindly refer to these images and please suggest a possible solution.

Let me know if you need more explanation/control.

Your help is highly appreciated. Thanks.

 


ikbelkirasan
Forum|alt.badge.img+12
  • Zapier Expert
  • 555 replies
  • August 13, 2021

@NowCerts - Thanks for the additional screenshots!

Actually, what I meant was in the Zapier Platform. If you go to Triggers <Your Trigger Name> → API Configuration then scroll down to the Step 3 Define your Output, you’ll see the Sample Data and the Output fields. Any field in both of them needs to have the same type as in the latest task to remove that warning. Hope this makes sense.

 


  • Author
  • Beginner
  • 7 replies
  • August 14, 2021

@ikbelkirasan ,

I am not using that field in output sampling.I am attaching the image for reference.

Kindly guide in this case.

 

Thanks.


ikbelkirasan
Forum|alt.badge.img+12
  • Zapier Expert
  • 555 replies
  • August 14, 2021

@NowCerts What if you add that field to the sample then run the check again? Let me know if that fixes the issue. Thanks!


  • Author
  • Beginner
  • 7 replies
  • August 14, 2021

@ikbelkirasan -
I tried your suggestion, but its still the same error.I am attaching the images for reference.
 

Kindly guide in this case.

 

Thanks.


  • Author
  • Beginner
  • 7 replies
  • August 16, 2021

@ikbelkirasan ..waiting for your reply.

 

 


ikbelkirasan
Forum|alt.badge.img+12
  • Zapier Expert
  • 555 replies
  • August 16, 2021

@NowCerts Hmm well, in that case, I’m not sure what’s causing it. Try contacting the support here https://zapier.com/app/get-help, they can take a look at your app and provide better answers.