Zoho Deluge - Get Refresh/Access Token API v2https://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 queryhttps://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 foundhttps://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 fieldhttps://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 invoicehttps://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: *

SSRS Report Builder 2.0 - Error during processinghttps://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 functionhttps://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