Skip to main content

Get Support
Have a question? Let's get you an answer!

How Do I...? Troubleshooting Code & Webhooks Developer Zone

Other Help Resources
Wait, there's more! Check out these Community sourced spaces for additional resources.

Zapier Help Center Hire an Expert

Learning Resources
All of our best learning resources can be found here.

Featured Articles Show & Tell Zapier's products AI Hub Zapier Tools Hub

Share your knowledge
Give back to the Community by sharing your automation wins and helping to answer questions.

Share your success See unanswered questions User Groups

Other Learning Resources
Some of our favorite additional ways to upskill your Zapier knowledge.

Zapier Learn Zapier Blog Zapier Webinars

Product Updates
Check out what is new and upcoming with Zapier with our regular product updates.

Product Updates

Early Access Program
Want to join Early Access? Learn more here.

Hi Everyone,

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.

 

Wanted Outcome

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.

 

Issue
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.

 

Error Code

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.

Believe you’ll need to add a step to the Zap to Find Module Entry.

Then use the ID of the found module entry in the next step.

ID fields in Zoho are going to expect the ID of the module record.

The error indicates it’s an ID field and that the field expects a data type of long which is a number.

Otherwise, please provide screenshots of your Zap steps.

Hi Troy,

 

Thanks for the response. It shouldn’t need to find a module entry as the zap is creating one. I’ve attached screenshots of what I’m talking about. The differences in screenshot 3 and 4 show’s the non working and working config.

In screenshot 5 the Organisation “Cleanstate” has unique number under it. If I add this field in the iAuditor Template would it work?

I should also add the Organisation field in Zoho that I’m trying to populate this data to is a “Look up” field.

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.

 

Thanks Troy. That has worked. 

Terms & Conditions