ZohoCRM: Integrate ChatGPT to ZohoZIAhttp://mail.joellipman.com/articles/crm/zoho/zohocrm-integrate-chatgpt-to-zohozia.html

06 March 2023 release - Queries OpenAI ChatGPT Date Modified: 2023-03-11 (Joel Lipman) - Stores conversation messages / thread in CRM records - Retrieves and builds up conversation trail to send to OpenAI ChatGPT API...

• 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 generate a customer, a product/item, a sales order, an invoice, a package slip/delivery 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...

• 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 m_CreateBooksItem.put("track_batch_number",true); // // let's try creating it r_CreateItem = zoho.inventory.createRecord("items",v_BooksOrgID,m_CreateBooksItem,"zinventory"); info "ITEM CREATE RESPONSE FOR " + v_ItemID; info r_CreateItem.get("message");...

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

Zoho Creator: Find Duplicates by Customer Name for Large Datasetshttp://mail.joellipman.com/articles/crm/zoho/zoho-creator-find-duplicates-by-customer-name-for-large-datasets.html

12 July 2023 you how to deduplicate a contact but usually involve entering a customer name or other key to check if there are already records in the system with that key. I can't sit there entering one customer at a time. Even a loop would hit a statement execution...

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

ZohoDesk & ZohoAnalytics: Display Ticket Attachments in Analytics Reporthttp://mail.joellipman.com/articles/crm/zoho/zohodesk-zohoanalytics-display-ticket-attachments-in-analytics-report.html

05 December 2023 org ID noted earlier v_AnalyticsOrgID = 23456789012; // // let's get the ticket details r_TicketDetails = zoho.desk.getRecordById(v_DeskOrgID,"tickets",p_TicketID); r_Attachments = invokeurl [ url :"https://desk.zoho.eu/api/v1/tickets/" + p_TicketID +...

• 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 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 = API_Integration[Connection_Name == "Shopify API"]; // // client id from...

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

Reminder on SSRS row separatorhttp://mail.joellipman.com/articles/microsoft/ssrs/reminder-on-ssrs-row-seperator.html

26 October 2011 Office 09:00 17:00 Notes Tuesday 04/10/2011 Another Office 09:00 17:00 Notes Row Seperator This follows on from my T-SQL Record Separator article. If you are using SQL Server Reporting Services (in my case version 2008 R2), then yes, you won't need to...

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

Oracle: order by subquery missing right parenthesishttp://mail.joellipman.com/articles/database/pl-sql/oracle-order-by-subquery-missing-right-parenthesis.html

05 December 2013 A quick note on how I got round one this one. Why? Often enough, our requirement is that the latest record from another table is associated with the current row, and often enough we get the latest by ordering the dataset of the subquery. In T-SQL and...

• Type: Article
• Author: Joel Lipman
• Category: Oracle PL/SQL
• Language: *

SITS: XET format for Export not availablehttp://mail.joellipman.com/articles/web-development/xml/sits-xet-format-for-export-not-available.html

08 August 2014 Trying to export a STU record but I want to use the XET template I created rather than the pre-installed XML export formats. When I try to export using data format XET, the system has never heard of it. Why? To test the XET I created, I want to see what...

• Type: Article
• Author: Joel Lipman
• Category: Extensible Markup Language
• Language: *