ZohoCRM Webhook: Create ZohoInventory Records from an eBay orderhttps://www.joellipman.com/articles/crm/zoho/zohocrm-webhook-create-zohoinventory-records-from-an-ebay-order.html

27 April 2023 re-upload of photo for item on any modification Date Modified: 2023-03-20 (Joel Lipman) - Check if payment has already been recorded before creating a new one. - Fixed reference_number being included on customer payment. Date Modified: 2023-03-21 (Joel...

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

ZohoCRM: Using Criteria with Module Record Counthttps://www.joellipman.com/articles/crm/zoho/zohocrm-using-criteria-with-module-record-count.html

14 November 2023 find an example of how to use this API call with search filters or criteria. Not sure about the rest of you, but I've been using this for pagination purposes and for the system to work out how many pages or loops in total it would need to do. How?...

• 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 The above demo uses the EU datacenter (zoho.eu) rather than the US datacenter (zoho.com). Update 2023: This solution has been superceded by instead directing the ZohoTicket Attachment trigger (internal webhook in ZohoDesk rather than on Ticket Edit) and...

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

Zoho Deluge and Wordpress/WooCommerce API: Get All Productshttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-and-wordpress-woocommerce-api-get-all-products.html

15 April 2024 in Zoho Inventory and this feeds the website. More than often, however, this request comes in when the customer has already been setting their Zoho environment up and the Wordpress site has the more information. How? So first, this article shows you how...

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

Zoho Webhooks & Shopify API: Keep Disappearinghttps://www.joellipman.com/articles/crm/zoho/zoho-webhooks-shopify-api-automatically-restore.html

22 April 2024 Fn - Shopify - Restore Webhook Trigger: Scheduled function to check on Shopify webhooks and to restore them if they have been removed. Inputs: - Outputs: - Date Created: 2024-04-22 (Joel Lipman) - Initial release Date Modified: ??? - ???...

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

ZohoAnalytics & ZohoBooks: Custom Related List from Analyticshttps://www.joellipman.com/articles/crm/zoho/zohoanalytics-zohobooks-custom-related-list-from-analytics.html

09 July 2024 sent to another supplier for grading, and then sent on to the end user/customer. A custom field against the item record has been added which is a lookup to the Sales Order module. This means that on a purchase order, and per line item, the staff can...

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

Zoho CRM & Zoho Sign: Send CRM Merged Template for Zoho Signhttps://www.joellipman.com/articles/crm/zoho/zoho-crm-zoho-sign-send-crm-merged-template-for-zoho-sign.html

06 August 2024 when ZohoSign sees a completed document Purpose: This function is used as a webhook when ZohoSign detects a document has been completed Inputs: crmAPIRequest Outputs: crmAPIResponse Date Created: 2024-08-06 (Joel Lipman) - Initial release - Modified to...

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

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

11 September 2024 the CSV export file containing the Data. "; // if(!isBlank(v_PermaLink)) { v_Message = v_Message + " The export file has been uploaded to the workdrive. The direct link to the file is " + v_UploadFilename + ". "; } // v_Message = v_Message + "This file...

• 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 ID were necessary in the end, I can use shortcode for getting the tag. Note that on a fresh CRM instance where no tags have been used previously, I would use the code above to maintain tag colors. Here's the shortened version where the system chooses...

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

ZohoDeluge: eBay marketplace account deletion/closure notificationshttps://www.joellipman.com/articles/crm/zoho/zohodeluge-ebay-marketplace-account-deletion-closure-notifications.html

13 March 2025 when current notification was sent notification.publishAttemptCount integer indicating how many times the notification has been sent to this specific callback URL notification.data.username this string is the publicly known eBay user ID...

• 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 (in other words, queries that work in Zoho Analytics) as I couldn't find any examples online on how to do this. Why? I've been tasked with generating a radar/spider/web chart based on the results from a survey. Apparently this will be done in Zoho...

• 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 } /* OPTIONAL: Send yourself an email sendmail [ from :zoho.adminuserid to :"me@mycompany.com" subject :"TEST: Survey has been submitted" message :crmAPIRequest ] */ // // build response to Zoho Survey (hard-coded a ok) m_ResponseHeader = Map();...

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

Advanced RokStories Stylinghttps://www.joellipman.com/articles/cms/joomla/advanced-rokstories-styling.html

01 July 2009 RokStories has been overhauled to provide the spectacular display that you see on this demo. The module adapts depending on your image size, so no need to manually create rounded corners on your images, RokStories will do the rest. The custom features...

• Type: Article
• Author: Webmaster
• Category: Joomla
• Language: *

404: Page Not Foundhttps://www.joellipman.com/static-items/404.html

11 February 2015 typed an address. We have revamped this website as of September 2015 and tidied up some of our URLs. Some sections will have been moved about but all the content that was on the old site is still to be found on our new website at www.joellipman.com. The...

• Type: Article
• Author: Joel Lipman
• Category: Static Items
• Language: *

Thank You!https://www.joellipman.com/static-items/thank-you.html

31 May 2009 feedback has been successfully submitted and is much appreciated. This filters through to an account which is checked regularly and you should get a quick response.

• Type: Article
• Author: Joel Lipman
• Category: Static Items
• Language: *

Hide Menu Item from Registered and Special https://www.joellipman.com/articles/cms/joomla/hide-menu-item-from-registered-and-special.html

06 September 2009 at this date/time. Can't simply hide an item but can hide a menu (of course the menu could have been created with just one item with no title and positioned at the bottom of another menu; this would look like it was all part of one menu). toubkal wrote:...

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

How to run a .RUN filehttps://www.joellipman.com/articles/linux/how-to-run-a-run-file.html

19 September 2009 I've been told of two ways of running a downloaded .RUN file. Note: Bear in mind that the following is all case-sensitive. Through the terminal server Download the .RUN file to your desktop Open a terminal by going to Application > Accessories >...

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

Increment a column in MySQL using the UPDATE queryhttps://www.joellipman.com/articles/database/mysql/increment-a-column-in-mysql-using-the-update-query.html

18 February 2010 you have a column in your table that you use as a counter (storing the value of the counter - eg. times an article has been displayed). Basically what I used to do is something similar to the following: SELECT counter_field_value FROM table1 WHERE...

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

SSRS Report Builder 2.0 - Error during processinghttps://www.joellipman.com/articles/microsoft/ssrs/ssrs-report-builder-20-error-during-processing.html

06 May 2010 occurred during report processing. Query execution failed for dataset 'DataSet1'. The variable name '@GroupName' has already been declared. Variable names must be unique within a query batch or stored procedure. The Quick Fix Return to the Design...

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

Invalid arguments passed in router.php on line 325https://www.joellipman.com/articles/cms/joomla/invalid-arguments-passed-in-routerphp-on-line-325.html

03 August 2010 supposedly holds the two functions to: convert a system URL to a SEF URL convert a SEF URL back to a system URL My site has been switched to SEF in the global configuration (where all SEO settings are set to "Yes") and works fine irrespectively. In...

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