'I am trying to get list of estimates from zoho books to zoho creator but its giving me error of data type mismatch

Please check this image for more details and code its simple code but i am getting datatype mismatch error https://i.stack.imgur.com/rDYH6.png

zohozohobooks


Solution 1:[1]

This is the common format to get list of records in zoho books module.

<variable> = zoho.books.getRecords(<module_name>, <org_ID>, <search>, <connection>);

module_name: Name of the module

org_id: Your organization id

search: specifies the values based on which the records will be filtered. You can specify an empty string or an empty map for this param, in which case all the records will be fetched

connection: Name of the connection

In order to get list of estimates Please do the following,

response = zoho.books.getRecords("Estimates", "54654632", "", "zbooks");

For further clarification refer this document https://www.zoho.com/deluge/help/books/fetch-records.html

If you have any other queries reach out to us at [email protected]

Solution 2:[2]

You are using single quotes for strings which Deluge intercepts as date or date-time strings. Use double quotes instead.

Solution 3:[3]

The error shown on the screenshot is caused by the single quote you're using instead of double quotes (").

You can use as following:

data = zoho.books.getRecords("Estimmates","OrganizationID","Connection");

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source
Solution 1 Yago Biermann
Solution 2 Mohamed El-Refaie
Solution 3 Stephen Ostermiller

Related Questions