Zoho Deluge: Shopify API: Get all active products with GraphQL and Paginationhttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-shopify-api-get-all-active-products-with-graphql-and-pagination.html

20 February 2023 number of products per page: The GraphQL The key value to retrieve is "cursor"; we're also going to use "hasNextPage" to determine if we need to keep looping: { productVariants(first: 10, query: "updated_at:>'2023-02-20T00:00:00+0000'") { edges { node {...

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

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

06 March 2023 // // initialize m_Blank = Map(); v_Response = previousParam; m_Response = Map(); m_Response.put("todo","prompt"); // // determine name of logged in user (and make owner?) v_LoggedInUserID = 0; l_Users= List(); m_UserType = Map();...

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

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

18 September 2023 { m_Taxes.put(r_Tax.get("tax_percentage").toString(),r_Tax.get("tax_id")); } // // ---------------------- DETERMINE ZOHOBOOKS CUSTOMER ID ---------------------- if(!isnull(r_QuoteDetails.get("Account_Name"))) { v_AccountID =...

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

Zoho Books: Error 7008: There are no contact persons associated with this Invoicehttps://www.joellipman.com/articles/crm/zoho/zohobooks-error-7008-there-are-no-contact-persons-associated-with-this-invoice.html

07 March 2024 if(r_ZB_InvoiceDetails.get("invoice") != null) { m_ZB_InvoiceDetails = r_ZB_InvoiceDetails.get("invoice"); // // determine recipients l_ZB_InvoiceRecipients = List(); r_ZohoBooks_CustomerDetails =...

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

Zoho Books / Inventory: Get Item Rate from a Price Book/Listhttps://www.joellipman.com/articles/crm/zoho/zoho-books-inventory-get-item-rate-from-a-price-book-list.html

23 May 2024 Deluge for a specific product in your ZohoBooks or ZohoInventory instance. Why? This took me the best part of an hour to determine by going through forum posts from 7 years to 2 years ago. The following will work in May 2024 following the API domain...

• 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 = ""; v_RequestID = 0; m_Body = ifnull(crmAPIRequest.get("body"),Map()); v_DebugMessage = "Body: " + m_Body + " "; // // determine type of document done if(!isNull(m_Body.get("requests"))) { v_RequestName =...

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

MacOs: Transcribe Training Video using OpenAI Whisperhttps://www.joellipman.com/articles/apple/macos-transcribe-training-video-using-openai-whisper.html

23 June 2025 -c "import numpy; print(numpy.__version__)" Use OpenAI Whisper Install Whisper using PIP: pip3 install -U openai-whisper Determine PATH of Whisper: find ~/.local/bin /usr/local/bin ~/Library/Python/*/bin -name whisper 2>/dev/null Add to PATH Edit your...

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

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

26 September 2011 makes sense (see my 10 mod table below). This article is a quick note (so I never spend as long again) in PHP on how to determine when looping through a loop, which entry was first and which was last. This is incredibly useful for pagination. The...

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