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

10 February 2022 converted values supported in additional parameters, I find the below works in CRM just fine: As of 2025, this method no longer works. Please refer to method 2 using a search API or a COQL query (see below). // ****************** CODE USING...

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

Zoho Inventory: Mark a package slip as delivered and shippedhttp://mail.joellipman.com/articles/crm/zoho/zoho-inventory-mark-a-package-slip-as-delivered-and-shipped.html

14 July 2022 code snippet to mark a package as shipped and delivered in Zoho Inventory. Why? As usual, any task like this that takes me longer than an hour, I'd like to document for future use. The use-case is the client has their own delivery drivers and want them...

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

Zoho Inventory: Enable Tracking using the APIhttp://mail.joellipman.com/articles/crm/zoho/zoho-inventory-enable-tracking-using-the-api.html

04 May 2023 stock...? How? So the quick answer is one missing parameter to send through which is "item_type=inventory"... A little longer, is do ensure you have Zoho Inventory enabled. But to flesh that out a little more along with setting the other options under...

• 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 to upload a file. Please check and try again. If I test my connection or even change how I upload the file, this error no longer appears. This error seems to be at the end of a function which has already done a lot of processing. Here's a quick test...

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

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

15 July 2025 have woken up to the news that including a username and password, or a client and secret in the endpoint of a URL will no longer be supported in the Zoho Deluge invokeURL task... This article exists because I spent 2 hours going down the rabbit hole of...

• 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 recent invoices - along with their Contacts and Items (accounts/contact & products respectively). Why? This took me so much longer than I thought it would. It was meant to be based on the pull from invoices article I wrote earlier but with quotes from...

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

First and Last Entry on a Page using Modulus Remainderhttp://mail.joellipman.com/articles/web-development/php/first-and-last-entry-on-a-page-using-modulus-remainder.html

26 September 2011 I know it's quite a long title but I'm not sure what I'll be searching next time. It has taken me a lot longer than I thought it would mostly out of frustration and the inability to know exactly what I'm looking for... always difficult. After a cup of...

• Type: Article
• Author: Joel Lipman
• Category: Personal Home Page
• Language: *

Strip HTML in MySQLhttp://mail.joellipman.com/articles/database/mysql/strip-html-in-mysql.html

06 December 2011 to a new system. From a MediaWiki CMS to a SaaS called Service-Now. The previous interlinking between images could no longer be used. How? There were a few functions out there. One called "strip_tags" crashed in the running of the query. The function...

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

SSRS Subscriptions cannot be createdhttp://mail.joellipman.com/articles/microsoft/ssrs/ssrs-subscriptions-cannot-be-created.html

22 November 2013 cannot be created because the credentials used to run the report are not stored, or if a linked report, the link is no longer valid. How? I'd like to say that the solution is far more complicated then this, but it isn't. This is one of those rare...

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

VBScript to retrieve Windows Product Keyhttp://mail.joellipman.com/articles/microsoft/windows-os/vbscript-to-retrieve-windows-product-key.html

23 September 2015 7 Professional 32-bit operating system. I didn't want to dig through my CD/DVDs to find my original windows 7 disc and no longer have access to the email account when I purchased Windows 7 (my university one). How? I'm going to use my trusty notepad...

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

Zoho Finance Suite Schedule: PATTERN NOT MATCHEDhttp://mail.joellipman.com/articles/crm/zoho/zoho-finance-suite-schedule-pattern-not-matched.html

12 June 2023 you go in and try to save it again. How? The super quick answer is remove any spaces from the name of the schedule. The longer answer is demonstrated in the following screenshots: Error: Solution

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