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)
{
"Date_de_debut": "2021-01-01","Date_de_fin": "2021-01-03", }
Here is an extract of the JSON send to Zoho Project (input)
- {
"Start Date": "2021-01-01", "End Date": "2021-01-03", }
Which results in the following output:
- 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
Access your files securely from anywhere
Zoho Developer Community
New to Zoho LandingPage?
Zoho LandingPage Resources
New to Zoho Survey?
New to Zoho CRM Plus?
Deliver unforgettable customer experiences
New to Zoho CRM Plus?
Deliver unforgettable customer experiences
New to Zoho Marketing Plus?
Everything you need to run your marketing
New to Zoho Marketing Plus?
Everything you need to run your marketing
New to Bigin?
Topic Participants
Olivier
Monica P
Geoff Boulden
Shyam Sundar S
Marek Nartowicz
New to Zoho TeamInbox?
Zoho TeamInbox Resources
Zoho DataPrep Resources
Zoho CRM Plus Resources
Zoho Books Resources
Zoho Subscriptions Resources
Zoho Projects Resources
Zoho Sprints Resources
Qntrl Resources
Zoho Creator Resources
Zoho Campaigns Resources
Zoho CRM Resources
Design. Discuss. Deliver.
Zoho Show Resources
Get Started. Write Away!
Writer is a powerful online word processor, designed for collaborative work.
Zoho CRM コンテンツ
-
オンラインヘルプ
-
Webセミナー
-
機能活用動画
-
よくある質問
-
Ebook
-
-
Zoho Campaigns
- Zoho サービスのWebセミナー