Zoho Deluge - Get Refresh/Access Token API v2http://mail.joellipman.com/articles/crm/zoho/zoho-deluge-get-refresh-access-token.html

17 July 2019 ones. A code lasts between 1 to 10 minutes. {"code": "AUTHENTICATION_FAILURE","details": [],"message": "Authentication failed","status": "error"}: I have had this error with API v2 when I'm using PHP/cURL and not deluge to get a list of contact records....

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: en-GB

Zoho Creator: Retrieve record with case-insensitive queryhttp://mail.joellipman.com/articles/crm/zoho/zoho-creator-retrieve-record-with-case-insensitive.html

21 November 2019 It tries to insert into the product table, but returns the error "Result: Error on Execution" > "Error details: Execution Failed Due to invalid expressions insert statement is terminated Line:(99)" > "Duplicate entry 'MyProduct1' for key 'Product_Name'...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Zoho Creator/Deluge: UnPredictable exception, Invalid statement foundhttp://mail.joellipman.com/articles/crm/zoho/zoho-creator-deluge-unpredictable-exception,-invalid-statement-found.html

17 November 2021 a function with perhaps too many for each loops within a for loop. How? The following is 1 fix for the error: Execution Failed UnPredictable exception, Invalid statement found Line:(20) I cannot guarantee that this error doesn't appear for other reasons...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

ZohoCreator: Using .toFile and Uploading to a Creator fieldhttp://mail.joellipman.com/articles/crm/zoho/zohocreator-using-tofile-and-uploading-to-a-creator-field.html

25 March 2024 the file upload field, with the file object directly, eg. .=. 2945: UPLOAD_RULE_NOT_CONFIGURED Also got this error if I failed to add the setParamName such as: f_CSVFile.setParamName("file"); 3700: Unable to upload a file. Please check and try again. If...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

ZohoCRM to ZohoBooks API: Rounding the cents or pennies when creating an invoicehttp://mail.joellipman.com/articles/crm/zoho/zohocrm-to-zohobooks-api-half-a-cent-or-penny-off-when-creating-an-invoice.html

20 March 2025 m_ZB_Update, "zbooks"); } } else if(!isNull(r_UpdateBooksInvoice.get("message"))) { v_OutputResponse = "FAILED: " + r_UpdateBooksInvoice.get("message"); } It's a cop-out I know, but it beats the accounts staff having to enter the adjustment each time....

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

ZohoCRM & Xero: Function to pull most recent invoiceshttp://mail.joellipman.com/articles/crm/zoho/zohocrm-xero-function-to-pull-most-recent-invoices.html

09 October 2025 if(b_Error) { info m_ThisInvoice.get("InvoiceNumber") + ": FAILED: " + m_ResponseData; info m_UpsertCrmInvoice; } } if(v_Action == "insert") { v_Count_Created = v_Count_Created + 1; } else if(v_Action == "update") { v_Count_Updated = v_Count_Updated +...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

ZohoBooks: Broken UK Banking Feedhttp://mail.joellipman.com/articles/crm/zoho/zohobooks-broken-uk-banking-feed.html

16 October 2025 menu option (“Refresh Feeds”) had been replaced with only “Automatic Import.” Attempts to make the account inactive failed with the message that it was “linked with an integration.” This message doesn’t necessarily mean a third-party app; it usually...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

SSRS Report Builder 2.0 - Error during processinghttp://mail.joellipman.com/articles/microsoft/ssrs/ssrs-report-builder-20-error-during-processing.html

06 May 2010 error: An error occurred during local report processing. An error has occurred during report processing. Query execution failed for dataset 'DataSet1'. The variable name '@GroupName' has already been declared. Variable names must be unique within a...

• Type: Article
• Author: Joel Lipman
• Category: SQL Server Reporting Services
• Language: en-GB

Zoho Deluge - MD5 functionhttp://mail.joellipman.com/articles/crm/zoho/zoho-deluge-md5-function.html

19 November 2018 function: v_Etag = zoho.encryption.base64encode(v_Combined_Fields); // returns error Error on Execution Execution Failed Due to invalid expressions insert statement is terminated Line:(102) Value of the field Etag length should be lesser than or equal...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: en-GB