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

Question

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

Answer 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]

Answer 2

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

Answer 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");