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

01 March 2023 demand. Why not in Zoho Inventory or any other Zoho app? Because we like to challenge ourselves... Once again, I'm not going into how to generate an access token / connection from Zoho to eBay, that is documented in my article: Zoho Creator: Push to...

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

ZohoBooks: Stripe Terminal Integrationhttp://mail.joellipman.com/articles/crm/zoho/zohobooks-stripe-terminal-integration.html

16 March 2023 } return r_ReaderPaymentHandOff; The incoming webhook You now need to receive the Stripe webhook when it comes back into ZohoBooks to record it against the invoice. Note how we added the invoice reference and Zoho ID in the description of the payment...

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

ZohoDeluge: Check Shipment Status via DHL APIhttp://mail.joellipman.com/articles/crm/zoho/zohodeluge-check-shipment-status-via-dhl-api.html

21 March 2023 note, a shipment order; as well as record any payments, inventory adjustments, status changes; all from an eBay Order coming into the system via a webhook... I would like to mark a shipment as delivered only if the courier, in this case DHL, confirms...

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

ZohoBooks: Error Code 15: Ensure Billing Address has less than 100 charactershttp://mail.joellipman.com/articles/crm/zoho/zohobooks-code-15-ensure-billing-address-has-less-than-100-characters.html

18 September 2023 Another article on something I learned today despite never running into this issue before; but sending a billing/shipping address included in a request to create or update an estimate in ZohoBooks will fail... Why? I have a function to push a ZohoCRM...

• 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 intact) Generate the file The code here is a cut down version just to demonstrate generating a text file and storing this into a variable: // // initialize v_CSVString = "Bank Sort Code,Bank Acc. No,Account Holder"; v_CSVString = v_CSVString +...

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

Zoho Creator: Error Code 2945: EXTRA KEY FOUND IN JSONhttp://mail.joellipman.com/articles/crm/zoho/zoho-creator-error-code-2945-extra_key_found_in_json.html

04 October 2023 the solution to whenever you get the above error; I'm just saying this what I was doing and this is what fixed it when I ran into this error: // initialize m_QuoteRecord = Map(); // // build quote request...

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

Zoho Workdrive: Getting Team Folder IDhttp://mail.joellipman.com/articles/crm/zoho/zoho-workdrive-getting-team-folder-id.html

11 September 2024 The direct link to the file is " + v_UploadFilename + ". "; } // v_Message = v_Message + "This file is ready for importing into the system. Kind Regards, The Development Team."; // // list of recipients l_RecipientsEmails =...

• 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 be good as well; but I couldn't spend time finding fields that can be 'placeheld', other than what the interface offers, into the template. the CRM webhook API function So let's do my favorite method of creating a REST API function in CRM Login to...

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

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

03 March 2025 ID key and value pair. It would then tell me the list was null when I thought I was adding the map with the ID removed back into a list. The map itself was null. How? We are using an API action called "Add_Tags". I'm going to get the tags of the contact...

• 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 The numbers at the end still need to match what's in CRM and with ZohoBooks rounding differently can make cent/penny errors into 100s of dollar/pound errors. Zoho CRM has a fun way of rounding which differs to Zoho Books so when pushing an invoice,...

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

ZohoCRM Client Script: On Change of Dropdown: Subform Rewrite: REST Functionhttp://mail.joellipman.com/articles/crm/zoho/zohocrm-client-script-on-change-of-dropdown-subform-rewrite-rest-function.html

01 April 2025 // insert a product line item called "Deposit" var o_NewLineItem = {}; // the record ID of the product "Deposit" is inserted into Product_Name o_NewLineItem.List_Price = v_DepositAmount; o_NewLineItem.Product_Name = {}; o_NewLineItem.Product_Name.name =...

• 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 a working script every time. The PHP Script: I'm calling it thumbnailer.php Deploy the Script Place thumbnailer.php 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...

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

Zoho CRM: JS Widget: Generic Script to pass the Record ID to a CRM functionhttp://mail.joellipman.com/articles/crm/zoho/zoho-crm-js-widget-generic-script-to-pass-the-record-id-to-a-crm-function.html

18 August 2025 response contains the expected structure let output = r_SubData?.details?.output; // If the output is JSON text, parse it into a real object let parsedOutput; try { // Attempt to parse the output as JSON parsedOutput = JSON.parse(output); } catch (e) {...

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

Zoho Survey: Zoho CRM Webhookhttp://mail.joellipman.com/articles/crm/zoho/zoho-survey-zoho-crm-webhook.html

01 October 2025 Trigger: Webhook when a suvey is submitted in Zoho Survey Purpose: Push the calculated score and results from Analytics into the corresponding Zoho CRM record. Inputs: String crmAPIRequest Outputs: - Date Created: 2025-09-19 (Joel Lipman) - Initial...

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

ZohoCRM & Xero: Function to pull most recent quoteshttp://mail.joellipman.com/articles/crm/zoho/zohocrm-xero-function-to-pull-most-recent-quotes.html

13 October 2025 Standalone / On-Demand / Callable Purpose: Function to get the first page of most recent quotes from Xero and pull them into ZohoCRM Inputs: - Outputs: - Date Created: 2025-10-13 (Joel Lipman) - Initial release - Parsing Xero Dates and Times to include...

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

Add a template to the dropdown in Kunenahttp://mail.joellipman.com/articles/cms/joomla/add-a-template-to-the-dropdown-in-kunena.html

20 September 2009 the Template package. Open your FTP Connection and go to \components\com_kunena\template\ Extract the folder "Template Name" into this directory ^ If in the package the folder "lib" contains, extract the files in the directory \components\com_kunena\lib\

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

Cranberry flapjackhttp://mail.joellipman.com/articles/_other-misc/cranberry-flapjack.html

07 July 2009 cranberries. This should form a thick batter. 2. Melt the butter in a thick based non-stick frying pan. Spoon the mixture into small rounds. 3. Fry for 2-3 minutes on each side until golden. 4. For the caramel sauce, in a hot pan, add the butter and...

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

Peanut Butter Milkshake Recipehttp://mail.joellipman.com/articles/_other-misc/peanut-butter-milkshake-recipe.html

05 September 2009 vanilla 1 vanilla ice cream Recipe Preparation Fill a tall glass or mug with as much milk as you wish (I use 1 cup); pour into blender, and add the vanilla and peanut butter. Whirl for 1 minute; add 2 scoops ice cream, then whirl 1 minute more....

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

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 CD TO HARD DRIVE FIRST is selected Click on COPY and wait for the CHECK MEDIA 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...

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

MyALN.bournemouth.ac.ukhttp://mail.joellipman.com/component/content/article/myalnbournemouthacuk.html?catid=33

07 September 2010 the original developer ended their support for the site. I was called in to fix several underlying issues and integrate it into the university systems. The Additional Learning Needs team at Bournemouth University use their website to reduce the...

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