PHP Script: Make your own Thumbnail Generator via APIhttps://www.joellipman.com/articles/crm/zoho/php-script-make-your-own-thumbnail-generator-via-api.html

29 May 2025 into a web-accessible directory on your server (for example, public_html/api/thumbnailer.php). It will be called as a JSON API over GET and does not render a webpage. Create Storage Folders In the same directory, create two writable subfolders: _origs/...

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

Zoho Deluge: Connect to Shopifyhttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-connect-to-shopify.html

15 July 2025 to include in the invokeURL headers and payload. Previously on... m_Header = Map(); m_Header.put("Content-Type","application/json"); // // app specific (retrieving from a ZohoCreator record that stores all these credentials) r_ShopifyAPI =...

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

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

18 September 2025 invokeUrl wants its parameters changed using .toString()... sometimes it doesn't, as it did in this case. EXTRA_KEY_FOUND_IN_JSON {"errorCode":8542,"errorMessage":"Unknown JSON attribute(s) found in the parameter CONFIG."}: This was because I was trying...

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

Zoho Survey & Zoho Analytics: Query to generate individual responses and grouped pageshttps://www.joellipman.com/articles/crm/zoho/zoho-survey-zoho-analytics-query-to-generate-individual-responses-and-grouped-pages.html

25 September 2025 = Map(); m_Params.put("ZOHO_ACTION","EXPORT"); m_Params.put("ZOHO_OUTPUT_FORMAT","IMAGE"); m_Params.put("ZOHO_ERROR_FORMAT","JSON"); m_Params.put("ZOHO_API_VERSION","1.0"); f_ChartExport = invokeurl [ url :v_Endpoint type :POST parameters:m_Params...

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

Zoho Survey: Zoho CRM Webhookhttps://www.joellipman.com/articles/crm/zoho/zoho-survey-zoho-crm-webhook.html

01 October 2025 > Triggers > Webhook > Manage 3. Post URL is the REST API URL of the ZohoCRM function (this function) 4. Set Request Body to JSON with name 'Survey' and within specify Response ID, Email, and Survey ID mapping as appropriate. 5. Click on 'Save' button...

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

Zoho Deluge - Some Useful Regular Expressionshttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-some-useful-regular-expressions.html

31 May 2019 // yields Joe\'s \"Amazing\" Skill \& \ Grunt Replace new lines in returned JSON (invalid in Zoho): v_MyString = "{"MyKey":"MyValue "}"; // the long way (and cos the regex for this isn't working) v_FormattedString = v_MyString.replaceAll("\r","",false);...

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

Autohotkey - Chrome Profiles in Alphabetical Orderhttps://www.joellipman.com/articles/automation/autohotkey/autohotkey-chrome-profiles-in-alphabetical-order.html

07 January 2020 AutoHotkey GUI Loop through Google Chrome Profile folders named "Profile 1", "Profile 2", etc. Scan the preferences file for JSON key "name" and extract value. Hide the first column in the list view (contains "Profile 1", "Profile 2",...) Sort the...

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

Zoho Deluge - InvokeConnector and useful snippetshttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-invokeconnector-and-useful-snippets.html

23 January 2020 } List CRM Users (ActiveUsers) from Creator or other Zoho App Note the use of .toMap() required for other apps to read this JSON string response: l_Users= List(); m_UserType = Map(); m_UserType.put("type","ActiveUsers"); r_Response =...

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

Zoho CRM/Creator - Common Errors & Gotchashttps://www.joellipman.com/articles/crm/zoho/zoho-crm-creator-common-errors-gotchas.html

06 February 2020 is empty and 'get' function cannot be applied Following a post similar to the above example by InvokeURL and then getting a JSON response back, the response does not seem to be read as a map: r_Response = invokeurl [ url :v_DataEndpoint type :POST...

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

Zoho Creator: Receive eBay Order Notifications via Webhookhttps://www.joellipman.com/articles/crm/zoho/zoho-creator-receive-ebay-order-notifications-via-webhook.html

20 September 2021 m_Payload = crmAPIRequest; v_Type = "Unknown"; l_SoapActions = List(); if(!isnull(m_Payload.getJSON("headers"))) { l_SoapActions = m_Payload.getJSON("headers").getJSON("soapaction"); for each v_SoapAction in l_SoapActions { l_SoapActionParts =...

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

Zoho Creator / eBay: Get all Active Productshttps://www.joellipman.com/articles/crm/zoho/zoho-creator-ebay-get-all-active-products.html

13 October 2021 The example below is a function which, if given the page number and the number of entries per page, returns these in JSON as a Zoho Map datatype. How? I'm not going to go into detail on how I create an access token to query the eBay Trading API as you...

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

Zoho CRM/Deluge: Get TimeZone Based on GeoCoded Address (Lat/Lng)https://www.joellipman.com/articles/crm/zoho/zoho-crm-deluge-get-timezone-based-on-geocoded-address-lat-lng.html

15 December 2021 to get your own at https://timezonedb.com/references/get-time-zone) l_Params.add("key=123456789ABCD"); l_Params.add("format=json"); l_Params.add("lat=" + r_GeoCode.get("latitude")); l_Params.add("lng=" + r_GeoCode.get("longitude"));...

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

ZohoCRM & Xero Real-Time Invoices: Receive Webhookhttps://www.joellipman.com/articles/crm/zoho/zohocrm-xero-real-time-invoices-receive-webhook.html

10 January 2022 } } m_Header = Map(); m_Header.put("Authorization","Bearer " + v_AccessToken); m_Header.put("Accept","application/json"); m_Header.put("Xero-tenant-id",v_TenantID); // // ******************************************************************************* //...

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

Zoho Analytics: Setup DataSource via FTP Connectionhttps://www.joellipman.com/articles/crm/zoho/zoho-analytics-setup-datasource-via-ftp-connection.html

12 January 2022 - 136.143.190.255 The file on the FTP server to download can be of type: CSV, TSV, Text, Excel, MS Access DB, HTML, JSON, XML and others: Supports server types of FTP, FTPS - File Transfer over Explicit TLS/SSL, FTPS - File Transfer Over Implicit...

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

Zoho Creator: Receive eBay Notification and Create Shopify Orderhttps://www.joellipman.com/articles/crm/zoho/zoho-creator-receive-ebay-notification-and-create-shopify-order.html

21 January 2022 articles for more information on these: Zoho Creator: Receive eBay Order Notifications via Webhook Zoho Creator: Receive JSON via a Shopify Webhook This time, the objective is to have an eBay notification be sent to Zoho CRM (can receive webhooks) which...

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

Zoho CRM: Schedule a Meeting using Delugehttps://www.joellipman.com/articles/crm/zoho/zoho-crm-schedule-a-meeting-using-deluge.html

02 March 2022 or an Event using Zoho Deluge. Why? Because at time of print, I couldn't find that much information on how to build up a JSON request to create a meeting (previously known as Event) in Zoho CRM. Here's a quick snippet of code to remind me. How? Similar...

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

ZohoCRM: Get All eBay Active Listingshttps://www.joellipman.com/articles/crm/zoho/zohocrm-get-all-ebay-active-listings.html

01 March 2023 + v_Increment); } v_TotalNumberOfPages = l_Pages.size(); // // declare variables to store order details in a JSON or ZohoDeluge Map format m_Response = Map(); l_JsonProducts = List(); // // start preparing CSV file to email for export v_ReportCSV =...

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

Zoho Deluge: Get All Orders from eBayhttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-get-all-orders-from-ebay.html

29 March 2023 { l_Pages.add(v_Increment + 1); } v_TotalNumberOfPages = l_Pages.size(); // // declare variables to store order details in a JSON or ZohoDeluge Map format m_Response = Map(); l_JsonOrders = List(); // // start preparing CSV file to email for export...

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

Zoho Books: Get Invoice Payment Terms via APIhttps://www.joellipman.com/articles/crm/zoho/zoho-books-get-invoice-payment-terms-via-api.html

06 July 2023 set their due dates differently. How? The following snippet of code will query the metadata api in Zoho Books and return a JSON of what the payment terms are. void fn_ReturnCurrentPaymentTerms() { v_BooksOrgID = "12345678901"; r_PaymentTerms = invokeurl...

• 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 a contact person to email - Superceded by including "send=true" in the invoice creation request More Info: Error 1038: JSON is not well formed - Encountered when trying to use the send an invoice API - Was sending to_mail_ids in the URL instead of the...

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