Zoho Deluge: Shopify API: Get all active products with GraphQL and Paginationhttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-shopify-api-get-all-active-products-with-graphql-and-pagination.html

20 February 2023 same as on the Shopify website. Included in this is the feature to export all the data as a CSV and to email it to myself: void API.fn_ShopifyQuery_UpdateAllProducts() { // init v_CountTotal = 0; v_CountUpdated = 0; v_PerPage = 10; b_HasNextPage =...

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

ZohoCRM: Get Organization Business Hours using Deluge/APIhttps://www.joellipman.com/articles/crm/zoho/zohocrm-get-organization-business-hours-via-deluge-api.html

28 March 2023 in the Zoho order, but that of the normal week (in other words, not alphabetical, numerical, or completely random order): void JoelLipman.fn_SetStaffUsualShift() { // // build a standard usual shift subform from CRM r_OrgDetails = invokeUrl [ url:...

• 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 is missing is the .setParamName() but for those who have spent time to find this function, they'll already know this. void fn_Joel_Test() { /*** - tried with getUrl() but this doesn't work. - has to be an invokeUrl - set param name required - if file...

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

ZohoDesk & ZohoAnalytics: Display Ticket Attachments in Analytics Reporthttps://www.joellipman.com/articles/crm/zoho/zohodesk-zohoanalytics-display-ticket-attachments-in-analytics-report.html

05 December 2023 I give it the following code: /* ******************************************************************************* Function: void fn_Tickets_OnCreateEdit(int p_Ticket) Label: Fn - Tickets - On Create or Edit Trigger: Off a workflow when a ticket is...

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

Zoho Creator: Get Images in Report to be Exported to PDFhttps://www.joellipman.com/articles/crm/zoho/zoho-creator-get-images-in-report-to-be-exported-to-pdf.html

26 January 2024 records, and then when given just one ticket reference; will create or update the images associated in the subform: void Standalone.fn_DownloadAndCacheAttachments(string p_TicketRef) { v_TicketRef = ifnull(p_TicketRef,""); c_TicketRecords =...

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

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

25 March 2024 error seems to be at the end of a function which has already done a lot of processing. Here's a quick test snippet of code: void fn_UploadTest() { // // selecting a record which has a file upload field that we want to upload to c_Check = My_Form[ID ==...

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

ZohoCRM: Daily Follow Up and Remind Record Owner to Convert Leadhttps://www.joellipman.com/articles/crm/zoho/zohocrm-follow-up-and-remind-record-owner-to-convert-lead.html

14 May 2024 being the Lead Record ID: /* ******************************************************************************* Function: void fn_Leads_FollowUpNonConverted(Int p_LeadID) Label: Fn - Leads - Follow Up Non Converted Lead Trigger: Triggered 24 hours after a...

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

Zoho Analytics & Zoho People: Monitor DataSource Sync https://www.joellipman.com/articles/crm/zoho/zoho-analytics-zoho-people-monitor-datasource-sync.html

02 July 2024 The code /* ******************************************************************************* Function: void Check_DataSources_Sync_to_ZohoAnalytics () Label: Check DataSources Sync to ZohoAnalytics Trigger: Scheduled daily at 1am starting from tomorrow...

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

Zoho Deluge: Using Remove Key on a Map and Copying Record Tagshttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-using-remove-key-on-a-map.html

03 March 2025 to create a list map of tags and add these to the deal record. The key take-away to remember here is that remove() is a void function, similar to the sort() function; in that if you try to assign this to a new variable name, it will fail. In other...

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