Zoho Deluge: Post a multi-dimensional or nested array to a 3rd-party APIhttp://mail.joellipman.com/articles/crm/zoho/zoho-deluge-post-a-multi-dimensional-or-nested-array-to-a-3rd-party-api.html

03 February 2021 a solution which worked for me. Note that usually I could customize the receiving PHP script to receive a JSON request and process it that way but my usage was to send data to a Third-Party API over which I had no control. What I need to send to the...

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

Zoho CRM: Update a custom field in line items / product details using REST API v2.1http://mail.joellipman.com/articles/crm/zoho/zoho-crm-update-a-custom-field-in-line-items-product-details.html

17 May 2021 "line_tax": [ { "percentage": 20, "name": "Sales Tax", "value": 0.99 } ] } ] } Updating with REST API v2.1 The new process doesn't just require you to add in this custom field per line item, but also requires a change to the other fields in the line...

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

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

10 January 2022 the Xero webhook. You're going to need to respond to Xero with valid and invalid HTTP statuses as their webhook validation process is a little stricter than Zoho's. Setup a Zoho CRM Function: Login to Zoho CRM > Setup > Functions > New Function Function...

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

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

21 January 2022 we would receive an eBay notification and create an order record in Zoho Creator. We did the same for when Shopify would process an order. You can see my following articles for more information on these: Zoho Creator: Receive eBay Order Notifications...

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

Zoho CRM: searchRecords with sorted resultshttp://mail.joellipman.com/articles/crm/zoho/zoho-crm-searchrecords-with-sorted-results.html

10 February 2022 connection:"zcrm" ]; l_SortedProducts = ifnull(r_CoqlSortedProducts.get("data"), List()); Source(s): Joel Lipman - ZohoCRM: Process all records of a module Zoho Deluge - Search Records in Zoho CRM Zoho Deluge - Get Records from Zoho CRM

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

Zoho Creator: Shopify API Integration Oauth 2.0 - Update 2022 (Search by SKU GraphQL)http://mail.joellipman.com/articles/crm/zoho/zoho-creator-shopify-api-integration-oauth-2-0-update-2022.html

14 February 2022 variant ID, and inventory ID from Shopify. How? The below details on how we set up an access token in Shopify using the new process. Preparation: You don't have to do this, but I store all the keys in a Zoho Creator form (I call mine "API Integration")...

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

Zoho Inventory & eBay Picture Services: UploadSiteHostedPictureshttp://mail.joellipman.com/articles/crm/zoho/zoho-inventory-ebay-picture-services-uploadsitehostedpictures.html

31 March 2022 This is an article documenting the process of publishing a Zoho Inventory image to eBay's Picture Hosting Services (EPS). Why? Because I couldn't find any other article in the whole world wide web that had a working solution. My use-case here is that I...

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

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

17 October 2022 entered and the document signed and returned, it attached the signed document to the Deal record. How? The following is the process from registering the app to call on the full API (grant code > refresh token > access token) and then the code to attach...

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

Zoho Books: Generate Bank Text File for Downloadhttp://mail.joellipman.com/articles/crm/zoho/zoho-books-generate-bank-text-file-for-download.html

02 October 2023 + "/documents/" + v_DocumentID + "?organization_id=123456789" type :DELETE connection:"zbooks" ]; Caveat(s) The delete process may need to be in a schedule: you can use a custom module in ZohoBooks to store the necessary information of what to delete....

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

ZohoCRM & ZohoWriter: Generate Rich-Text / HTML Email Signatures in CRMhttp://mail.joellipman.com/articles/crm/zoho/zohocrm-zohowriter-generate-rich-email-signatures-in-crm.html

05 December 2023 to, using Deluge code, generate all the email signatures in the user profile in ZohoCRM. Why? To simplify the on-boarding process. A client of ours has a rather rich HTML email signature with a profile photo included. When sending an email from CRM,...

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

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

25 March 2024 I thought I could simply update the field with the new file but as I'm not downloading it, this is apparently not the process. How? As a high-level overview: we'll generate the CSV rows and then a file; then we'll use invokeURL to upload the file....

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

Zoho Analytics: Create a Monitoring System with Imageshttp://mail.joellipman.com/articles/crm/zoho/zoho-analytics-create-a-monitoring-system-with-images.html

25 July 2024 use-case here is to build a system which monitors a Zoho App for when records were last modified and if a synchronization process starts to fail, there should be images or icons warning or advising of failures. How? The key trick to use here the ability...

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

Zoho Books: Estimates/Quotes: Accept & Decline Buttons on Templatehttp://mail.joellipman.com/articles/crm/zoho/zoho-books-estimates-quotes-accept-decline-buttons-on-template.html

04 November 2024 name): // // initialize b_ValidResponse = false; v_EstimateID = "-"; v_OrgId = "123456789"; v_Output = "Unable to process request"; // // evaluate v_Intent = ifnull(input.p_Intent,"-"); v_QuoteRef = ifnull(input.p_QuoteRef,"-"); v_CustomerID =...

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

ZohoCRM to ZohoBooks API: Rounding the cents or pennies when creating an invoicehttp://mail.joellipman.com/articles/crm/zoho/zohocrm-to-zohobooks-api-half-a-cent-or-penny-off-when-creating-an-invoice.html

20 March 2025 } It's a cop-out I know, but it beats the accounts staff having to enter the adjustment each time. The create invoice process would be treated the same. The below are all the various methods I tried to resolve this but the truth is that I do not have a...

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

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

29 May 2025 When the user first loads up the webpage containing the widget, 10k images are downloaded. I have put in a lazy loading process where it will load the first few images and as the user scrolls down the dropdown, more are loaded. This still gets buggy on...

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

Converting SQL date in PHP to European date format and vice-versahttp://mail.joellipman.com/articles/web-development/php/converting-sql-date-in-php-to-european-date-format-and-vice-versa.html

17 September 2009 Issue If you've ever made PHP scripts to process data within a LAMP environment (Linux, Apache, MySQL, PHP) then this happens a lot. In the following example, our HTML form will allow the user to specify a date (so excludes hours, minutes and seconds)....

• Type: Article
• Author: Joel Lipman
• Category: Personal Home Page
• Language: en-GB

How to make a HTML form post its variables to itselfhttp://mail.joellipman.com/articles/web-development/html/how-to-make-a-html-form-post-its-variables-to-itself.html

17 September 2009 The Issue You have a PHP page which generates a HTML form. When the user submits the form, you want the same PHP page to process the data. Solution I've seen a lot of people write CGI requests but if you left the action attribute blank, this would do...

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

Making a CD copy with only one drivehttp://mail.joellipman.com/articles/microsoft/windows-os/making-a-cd-copy-with-only-one-drive.html

23 September 2009 dialog box to appear Insert your blank disk into the drive With the disc in the drive, click on RETRY In the Record CD Process dialog box, click on OK Eject your disc and close the Easy CD Creator software

• Type: Article
• Author: Joel Lipman
• Category: Windows OS
• Language: *

Comparing two mediawiki siteshttp://mail.joellipman.com/articles/cms/mediawiki/comparing-two-mediawiki-sites.html

17 September 2010 of the same MediaWiki site. I want to add the SQL queries I used to this article but I'm in the middle of carrying out this process and it's due in two hours. Checking both MediaWiki have the same article content: Print Special:AllPages from both sites...

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

Zoho Deluge - MD5 functionhttp://mail.joellipman.com/articles/crm/zoho/zoho-deluge-md5-function.html

19 November 2018 search results) make no mention of using MD5 in an encryption task. Why? I'm trying to create an ETag for a synchronization process between Zoho Creator and Zoho CRM. Combining all the fields to compare into a single field can't be done via the...

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