ZohoCRM: Process all records of a modulehttps://www.joellipman.com/articles/crm/zoho/zohocrm-process-all-records-of-a-module.html

24 August 2021 thought of an alternative that I now use frequently in client systems. How? The gist is that we add a checkbox called "Processed" which will have a datatype Boolean. Our function will then loop through each record and do what it has to do. The...

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

ZohoCRM GetRelatedRecords INVALID_DATAhttps://www.joellipman.com/articles/crm/zoho/zohocrm-getrelatedrecords-invalid_data.html

30 January 2025 = zoho.crm.bulkUpdate("Sales_Orders", l_UpdateSOs); // // cancel all related invoices // (...) // // mark the deal as processed r_UpdateDeal = zoho.crm.updateRecord("Deals", m_Deal.get("id"), {"Cancelled_Related_Records":true}, {"trigger":{}});...

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

SSIS Script: convert UPPERCASE to Mixed-Case using TitleCasehttps://www.joellipman.com/articles/microsoft/ssis/ssis-script-convert-uppercase-to-mixed-case-using-titlecase.html

04 October 2013 MyConvertToProperTransform : PipelineComponent { // Create a variable which is used to identify the data column being processed private int[] inputBufferColumnIdx; // Create variables used in debug logging (when it is enabled) private byte[] emptyBytes...

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

Zoho People: Get Performance Records over APIhttps://www.joellipman.com/articles/crm/zoho/zoho-people-get-performance-records-over-api.html

18 September 2025 for each m_GoalRecord in l_GoalRecords { // // start an increment for counting the records processed v_CountTotal = v_CountTotal + 1; // // for the response structure, we need to extrat the first key as the Zoho ID l_GoalKeys = m_GoalRecord.keys();...

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

A quick run through of setting up an export process in SITShttps://www.joellipman.com/articles/web-development/xml/a-quick-run-through-of-setting-up-an-export-process-in-sits.html

21 August 2014 a SMG, date range and it will give you an overview of the DOT, EOT, TOT, TIN, DIN run. Testing: No records are being processed despite relevant ones existing and all monitors run I would get this issue if I cloned an existing process (released an...

• Type: Article
• Author: Joel Lipman
• Category: Extensible Markup Language
• 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 with multiple pages, do 1 at a time) l_Pages = {1}; v_PerPage = 200; for each v_Page in l_Pages { v_CountTotal = 0; v_CountProcessed = 0; v_FromIndex = (v_Page - 1) * v_PerPage; v_ToIndex = v_FromIndex + v_PerPage - 1; // // note that ordering here...

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