Bigin Zoho - Unable to update the date for the update action event

[Sikhar]

Your Task History ID

IjU3NjUwNTZiMDYzMDA0MzI1MjZmNTUzMDUxM2Ei_pc

Hi,

I need assistance in figuring out the issue while updating a date field in the "Update Contact" action for Bigin CRM. I am getting this "invalid data" error.

Workflow - https://connect.pabbly.com/workflow/mapping/IjU3NjUwNTZiMDYzMDA0MzI1MjZmNTUzMDUxM2Ei_pc
Execution History - https://connect.pabbly.com/task/his...d=IjU3NjUwNTZiMDYzMDA0MzI1MjZmNTUzMDUxM2Ei_pc

Data 0 Code	INVALID_DATA
Data 0 Details Expected Data Type	datetime
Data 0 Details Api Name	Strategy_Call_Date
Data 0 Message	invalid data
Data 0 Status	error

 

[Supreme]

Hey @Sikhar

Regarding this problem, we suggest formatting the date and time correctly by incorporating the Date/Time formatter into your action step. This adjustment will ensure the smooth functioning of your workflow, eliminating any date and time-related issues you may have experienced.

 

[Sikhar]

I will try that and revert. There is a related question. The time value that we get from Calendly uses GMT timezone. How can we convert it into India time zone (GMT + 5 hours 30 minutes) so that we can the values in IST in Bigin?

 

[Sikhar]

Hi, I implemented the Date/Time formatter, I also took care of time zone change. But it did not work. Please see the task id -

IjU3NmMwNTZkMDYzNTA0MzE1MjZhNTUzMjUxM2I1MTYxNTQzMCI_3D_pc​

 

[ArshilAhmad]

Could you please share a screenshot showing the format in which you manually enter the date in the Strategy Call Date field?

 

[Sikhar]

I have attached the document that shows it in Bigin.

 

[ArshilAhmad]

We suggest that you convert the date to this format and then map it in your Zoho Bigin action step.

 

[Sikhar]

The format that you suggested, I am not seeing that in the drop down. I am getting only these options.
Do you want me try with the format highlighted in red?

 

[Supreme]

Kindly toggle the map button and then try passing the format -

Format - MMM DD, YYYY hh:mm A

 

[Sikhar]

I have made the changes, but the issue persists. Can you please have a look at the workflow again https://connect.pabbly.com/workflow/mapping/IjU3NjUwNTZiMDYzMDA0MzI1MjZmNTUzMDUxM2Ei_pc

 

[Supreme]

Please check your workflow now I have corrected the format with this - YYYY-MM-DDTHH:mm:ss and seems to be working now.

 

[Sikhar]

Thanks a lot for fixing it. It's working fine now