I’m hoping someone a little smarter than I can provide some assistance…..Either that or I’ve found a bug :)
Companies we deal with are called “Organisations” in Zoho CRM. In iAuditor we have an inspection template with the same name as the corresponding organisation in Zoho. Every customer has their own template.
When an audit is completed I want a custom module entry created in Zoho CRM. This entry is to be linked to an organisation based on the iAuditor template name.
I cannot get the custom module entry to link to the organisation in Zoho by using the iAuditor template name (Which is the same as the Organisation name in Zoho). If I select the organisation manually from Zoho list of organisations in Zapier it works.
Unable to create entry in module: Audit. Error : Invalid data for the field id. Detail : expected_data_type long, parent_api_name Organisation
I have tried adjusting the length of the template name/organistation name to one word. I have also tried to use a different field in the template. Neither of these worked.
Any help would be appreciated.
Best answer by Troy Tessalone
As mentioned before, you will need to add a step in the Zap before to find the existing Organization record in order to get the Zoho system ID for that record.
You are correct that you are creating a new record for the Audits module, but as part of creating the new Audits module record you are trying to linking it to an existing record (in this case an Organization).
The Organization field is expecting an ID, which is common and proper software practices.
You can tell this by looking at the list generated in the dropdown which shows a system ID under the friendly name. (also seen in your screenshot included again below)
This is because the name of the friendly Organization may change, but the underlying system ID will not.