Creating a project with Zoho Flow and with date custom field fails

Creating a project with Zoho Flow and with date custom field fails

Hello,

I think I found a inconsistency in how Zoho handles dates. Let me explain, as it took me 2 hours to figure out where the roblem lies, and didn't found a solution

I'm using a Zoho Flow flow triggered by a Zoho CRM new Deal.
The Deal has 2 date fields : Date_de_debut, Date_de_fin.
When the deal is created, the flow reads the data send by the CRM, and use it to create a Zoho Project project.
The flow adds the relevant fields along with the Date_de_debut as " Start Date" and Date_de_fin as "End Date" fields.

Extract of the JSON received from CRM by Zoho Flow (input)
  1. {
    "Date_de_debut": "2021-01-01",
    "Date_de_fin": "2021-01-03", }
Here is an extract of the JSON send to Zoho Project (input)

  1. {
    	"Start Date": "2021-01-01",
    	"End Date": "2021-01-03",
    }
Which results in the following output:

  1. Zoho Projects says "Input Parameter Does not Match the Pattern Specified"
I found the following ticket which give me some hint:

Is it correct that The different Zoho applications handles API date differently, and how do we know the correct format ? (from a non developper point of view, as we are talking using Flow here).

It seems from this flow, that I need to convert date from Zoho CRM format to Zoho Project format. Which on a development point of view is very odd. I wish Zoho Project uses the more standard yyyy-mm-dd format (standard for API and consistency, not human display).

Talking about Zoho Flow, this conversion should be handled automatically ;) Non developer user will get angry about this rapidly.

In between, how am I suppose to convert dates between Zoho apps, in Flow ?

Regards
    Zoho Desk Resources

    • Desk Community Learning Series


    • Digest


    • Functions


    • Meetups


    • Kbase


    • Resources


    • Glossary


    • Desk Marketplace


    • MVP Corner


    • Word of the Day


      Zoho CRM Plus Resources

        Zoho Books Resources


          Zoho Subscriptions Resources

            Zoho Projects Resources


              Zoho Sprints Resources


                Zoho Orchestly Resources


                  Zoho Creator Resources


                    Zoho WorkDrive Resources



                      Zoho Campaigns Resources

                        Zoho CRM Resources

                        • CRM Community Learning Series

                          CRM Community Learning Series


                        • Tips

                          Tips

                        • Functions

                          Functions

                        • Meetups

                          Meetups

                        • Kbase

                          Kbase

                        • Resources

                          Resources

                        • Digest

                          Digest

                        • CRM Marketplace

                          CRM Marketplace

                        • MVP Corner

                          MVP Corner




                          Zoho Writer Writer

                          Get Started. Write Away!

                          Writer is a powerful online word processor, designed for collaborative work.

                            Zoho CRM コンテンツ




                              ご検討中の方