Zoho Deluge - Update Creator from CRMhttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-update-creator-from-crm.html

18 February 2019 For example: https://creator.zoho.eu/api/myAdminAccount/json/myApp/form/myForm/record/update The code to update a form (sample data for demonstration purposes). Note that the payload here is submitted through URL parameters: v_AccessToken =...

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

Zoho Creator: Download File from ZohoCRM field type "File Upload" (not attachments)https://www.joellipman.com/articles/crm/zoho/zoho-creator-download-file-from-zohocrm-field-type-file-upload-not-attachments.html

02 February 2021 know, when you queried CRM for that field, you received a JSON response somewhat similar to the following: // this is sample JSON with replaced IDs "My_CRM_File": [ { "extn": "pdf", "is_Preview_Available": true, "download_Url":...

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

Zoho CRM: Mapping a Multi-User or Multi-Lookup field using Delugehttps://www.joellipman.com/articles/crm/zoho/zoho-crm-mapping-a-multi-user-or-multi-lookup-field-using-deluge.html

28 April 2021 = zoho.crm.searchRecords("Vendors_X_Users",v_SearchCriteria); Code to Add a value to a multi-lookup (on Create Record): // sample code when creating a record in a module that contains a lookup m_Create = Map(); m_Create.put("Name","Joels Amazing Test");...

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

Zoho CRM: Schedule a Call using Delugehttps://www.joellipman.com/articles/crm/zoho/zoho-crm-schedule-a-call-with-deluge.html

18 November 2021 date time start in US format v_CustomerAppointmentDateTimeStart = v_CustomerCallTime.toString("MM/dd/yy h:mma z"); // // sample lead owner ID and lead ID record v_LeadOwnerID = 5432109876543210987; v_LeadID = 4321098765432109876; v_CustomerName = "Test...

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

ZohoFlow & ZohoSign: Retrieve a Zoho Sign document request and add attachments to CRM recordhttps://www.joellipman.com/articles/crm/zoho/zohoflow-zohosign-retrieve-a-zoho-sign-document-request-and-add-attachments-to-crm-record.html

17 October 2022 zoho.com or zoho.eu v_TLD = "com"; // // enter client ID, secret and refresh token as noted from above steps (the below are sample ones and will not work) v_ClientID = "1000.ABCDEFGHIJKLMNOPQRSTUVWXYZ1234"; v_ClientSecret =...

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

ZohoRecruit: Create Linking Table for Candidates and Associated Job Openingshttps://www.joellipman.com/articles/crm/zoho/zohorecruit-create-linking-table-for-candidates-and-associated-job-openings.html

08 February 2023 parameter(s) missing"}: Not sure why as the only mandatory field I had was the name field. Create a sample record with just the name field (placed at top of request) and comment out the other fields from the rest of the request to test. Once you have...

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

Zoho Creator: Sendmail a list of attachmentshttps://www.joellipman.com/articles/crm/zoho/zoho-creator-send-mail-a-list-of-attachments.html

20 July 2023 l_Downloads.add(r_Download1); r_Download2 = invokeUrl [ url: "https://www.africau.edu/images/default/sample.pdf" type: GET ]; r_Download2.setParamName("file"); l_Downloads.add(r_Download2); // sendmail [ from: zoho.adminuserid to: "info@joellipman.com"...

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

Zoho Books: Error 7008: There are no contact persons associated with this Invoicehttps://www.joellipman.com/articles/crm/zoho/zohobooks-error-7008-there-are-no-contact-persons-associated-with-this-invoice.html

07 March 2024 (array/list). Instead the below script will show you how to use this API having a few email addresses as the recipients: A sample code snippet: For the below, I have a connection to ZohoBooks from ZohoCreator called "zbooks". It has fullaccess as a...

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

ZohoCreator: Basic Widget with Zoho Datahttps://www.joellipman.com/articles/crm/zoho/zohocreator-basic-widget-with-zoho-data.html

14 March 2024 } }); } catch(e) { document.getElementById('debug').innerHTML = "Sorry! We don't have any matching records."; } }); /* SAMPLE TO GET ONE RECORD - Working as of March 2024 ZOHO.CREATOR.init() .then(function(data) { var config = { appName :...

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

MySQL Commands to display all columnshttps://www.joellipman.com/articles/database/mysql/mysql-commands-to-display-all-columns.html

28 October 2010 The following is a MYSQL query that finds all columns that had the data_type TEXT across a specified database (eg. sample_db): SELECT CONCAT(TABLE_NAME, '.', COLUMN_NAME) AS value FROM information_schema.COLUMNS WHERE DATA_TYPE='text' AND...

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

Zoho Projects: Deluge to Submit Custom Fieldshttps://www.joellipman.com/articles/crm/zoho/zoho-projects-deluge-to-submit-custom-fields.html

17 June 2021 API would only show responses rather than requests. Sure it lists fields that are required in the request but not a sample request packaged to be sent. How? Let's assume that my custom fields have as identifiers UDF_CHAR8 (which is a Zoho ID) and...

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