Search - Joel Lipman .Com

1. Zoho Deluge: Determine your Statement Execution Limit: / Zoho /; What? A very quick article on how to check what the statement execution limit is on the Zoho application you are working in. Why? Our use-case is that an application we built in Zoho Creator was ...; Created on 31 July 2024
2. Convert a delimited string to table: / Databases /; What? This is a quick note to show you how to convert a given comma delimited string into a database table: Given: "Title,Forenames,Surname" Return: ID Value ------ ---------------- ...; Created on 26 October 2012
3. Getting the mysql where in delimited string to work: / MySQL /; ... this work is not mine and comes from a clever function by Chris Stubben in the MySQL Forums: BEGIN DECLARE i INT DEFAULT 0; -- total number of delimiters DECLARE ctr INT DEFAULT 0; -- counter for ...; Created on 02 January 2012
4. Zoho Workdrive: Getting Team Folder ID: / Zoho /; ... a timestamped duplicate if exists so need to check if it exists first) // https://workdrive.zoho.com/home//teams//ws//folders/files m_SubfolderNames = Map(); r_Subfolders = invokeurl [ url :"https://www.zohoapis.com/workdrive/api/v1/teamfolders//folders?page%5Blimit%5D=50&page%5Boffset%5D=0" type ...; Created on 11 September 2024
5. Zoho Books / Inventory: Get Item Rate from a Price Book/List: / Zoho /; What? A quick article on how to get the pricebook entry using Zoho Deluge for a specific product in your ZohoBooks or ZohoInventory instance. Why? This took me the best part of an hour to determine ...; Created on 23 May 2024
6. ZCRM Client Script: Correct Decimal Fields OnLoad: / Zoho /; What? This is an article detailing the client script to fix any fields which exceed their decimal places limit in ZohoCRM. Why? So we have a customer that has some decimal fields on the products ...; Created on 13 December 2023
7. Zoho Creator: Find Duplicates by Customer Name for Large Datasets: / Zoho /; ... that key. I can't sit there entering one customer at a time. Even a loop would hit a statement execution limit. Why? My use-case is that I need this done over a dataset of 20k+ contact records ...; Created on 12 July 2023
8. ZohoDeluge: Check Shipment Status via DHL API: / Zoho /; ... "Message: " + r_ZohoShipmentUpdate.get("message"); } } } } } } } } Caveat(s): Limited to 250 requests per day (can be upgraded at a cost) Source(s): DH ...; Created on 21 March 2023
9. ZohoAnalytics: Pivot Campaigns vs Contacts: / Zoho /; ... I always resort to a query when I get confused with the GUI: Query 1 Due to the limit of sub-query levels we can go down, I want to join this to the contacts data table. So I'm going to make this ...; Created on 20 March 2023
10. ZohoBooks: Stripe Terminal Integration: / Zoho /; ... Pin 65 Payment Declined withdrawal_count_limit_exceeded 75 Pin try exceeded ******************************************************************************* */ v_BooksOrgID = organization.get("organization_id"); // // ...; Created on 16 March 2023
11. Zoho Cliq: Integrate OpenAI and ChatGPT 3.5 Turbo: / Zoho /; ... + v_FromTime + "&limit=50"; r_ChatDetails = invokeurl [ url: v_Endpoint type: GET connection: "ab_cliq" ]; // // let's build up the conversation thread if(!isnull(r_ChatDetails.get("data"))) { for ...; Created on 13 February 2023
12. Joel's Reference to MidJourney v4 Prompt: / Graphic Design /; ... default as you experiment and become more familiar with the tool would be better as changes to your settings may limit your discovery of the variations and styles. Type /settings then enter/return twice ...; Created on 11 February 2023
13. ZohoCRM: Import Attachments: / Zoho /; ... the filename appended. Because of MS Windows 11 limitations (any MS OS really), you need to ensure that long hyphens (#151) and some other funny characters are replaced out as the OS won't allow the file ...; Created on 16 January 2023
14. Zoho Creator: Shopify API Integration Oauth 2.0 - Update 2022 (Search by SKU GraphQL): / Zoho /; ... previous version was limited by our ability to search by product SKU. The new version, taking advantage of GraphQL, will be able to search by SKU and retrieve the correct product ID, variant ID, and inventory ...; Created on 14 February 2022
15. Zoho CRM: searchRecords with sorted results: / Zoho /; ... in mind script execution limits set by Zoho. Set the search criteria string to your specific requirements (:equals:, :starts_with:, |=|). If 1 expression then you can omit the parenthesis. If multiple ...; Created on 10 February 2022
16. Zoho Deluge: Regex Rounding and/or Removing Trailing Zeros: / Zoho /; ... are zeros... But I'm keen on avoiding using loops where possible so we don't breach a statement execution limit in the Zoho app function. How? If we're not going to use loops, then the next best thing ...; Created on 08 February 2022
17. Zoho Creator: Receive eBay Notification and Create Shopify Order: / Zoho /; What? This is an article documenting how to parse the notification from eBay and using it to create an order in Shopify. Why? Previously, we would receive an eBay notification and create an ...; Created on 21 January 2022
18. Zoho Creator: Public URL of an Image field / Upload to Shopify API: / Zoho /; ... for every photo uploaded, an API call is used up. If you have low limits, even 2000, this means you can only upload 100 products a day if they each have 20 photos (even less products then that as the ...; Created on 17 October 2021
19. Zoho Creator / Shopify: Get all Active Products: / Zoho /; ... + "/products.json?status=active&limit=250&fields=id&order=id+asc&since_id=" + v_LastID; r_GetProducts = invokeurl [ url :v_Endpoint type :GET headers:m_Header ]; for each r_ShopifyProduct ...; Created on 12 October 2021
20. Zoho Deluge: Handle Commas between Quotes in a CSV (and New Lines): / Zoho /; ... v_FormattedString; // yields: 00011,Joel Lipman,"Flat 8|mySpecialComma| House Corner",Brummieland // split into a list (string delimited by commas) l_StringParts = v_FormattedString.toList(); // ...; Created on 26 August 2021