Zoho Flow trying to Fetch record from Zoho Creator
Hello,
I am trying to (search) fetch a Creator record from within Zoho Flow. Later I want to update that Record using the Record ID I am trying to obtain through this search.
How do I parameterize the "Zoho Creator - Fetch record" node correctly to lookup a record based on a specific value?
Trying to get the Record where "booksID" = ${SO_update_trigger.salesorder_id}
When I set up the "Zoho Creator - Fetch record" node I can choose the Creator Application, the Form, the Report and the Field name.
I could pass a "Value" but that is not used as filter criteria for "Field name" provided (booksID).
The corresponding input for "Fetch record" is:
{
"Status": "",
"Account": "",
"End Customer": "",
"Record ID": "",
"Sales Order Number": "",
"Form": "Sales_Orders",
"Report": "Sales_Orders_Report",
"Amount": "",
"Subtotal": "",
"Field name": "booksID",
"raw": "",
"End Customer URL": "",
"Books URL": "",
"Subject": "",
"Account URL": "",
"Reference Number": "",
"Currency": "",
"Value": 301864000001375752,
"Sales Order Date": "",
"Books Instance": "",
"Application": "datasync",
"booksID": ""
}
But I want to search for the "booksID".
Only thing that gives a result is entering a Record ID in the node setup. But I do not have the Record ID since that is what I am looking for.
Any ideas?
Best regards,
Christoph