Search - Joel Lipman .Com

1. Zoho Creator: Shopify API Integration Oauth 2.0 - Update 2022 (Search by SKU GraphQL): / Zoho /; What? This is an article which is the updated version of my article Zoho Deluge: Push Item to Shopify API for 2022 using the new policy that Shopify have implemented when creating a custom app. Why? ...; Created on 14 February 2022
2. Zoho CRM: Update a custom field in line items / product details using REST API v2.1: / Zoho /; What? This is a quick article documenting how to update custom fields in a line items or product details section of a transactional module such as Quotes, Sales Orders or Invoices using code: Zoho Deluge. ...; Created on 17 May 2021
3. Zoho Deluge - Update Creator from CRM: / Zoho /; What? This is an article documenting how to update Creator from a workflow written in a Deluge Script held in ZohoCRM. Why? I've also started this article to document an issue we encountered where ...; Created on 18 February 2019
4. Quickly update all content in mySQL database replacing a string: / MySQL /; ... 1 yes no no Hello World Hello World 2 Article 2 yes no no Hello World Hello World 3 Article 3 yes no no Hello World Hello World Now update them SET @stringtoFind=''; SET @stringtoReplaceWith=''; UPDATE `MYTABLE_content` SET `introtext` ...; Created on 03 February 2013
5. Increment a column in MySQL using the UPDATE query: / MySQL /; ... following: SELECT counter_field_value FROM table1 WHERE column1='this_article' Add 1 to counter_field_value UPDATE table1 SET counter_field_value= WHERE column1='this_article' Combined ...; Created on 18 February 2010
6. Can't play music after Firmware Update Version 3.: / IT Support /; Well we're all happy that the iPlayer from the BBC has come to PS3 in Europe but I'm less impressed about the multi-audio output. My setup is that the sound goes from the Playstation to the Sound System ...; Created on 21 September 2009
7. Zoho CRM & Zoho Sign: Send CRM Merged Template for Zoho Sign: / Zoho /; ... from within ZohoCRM ZohoCRM webhook updates the tracking record (ZohoSign Document) and attaches the signed document to the contact record Button Code: /* ******************************************************************************* Function: ...; Created on 06 August 2024
8. Zoho Webhooks & Shopify API: Keep Disappearing: / Zoho /; ... and restore them. The Code Snippets: The Shopify Order Update notification First create a CRM function called Shopify - Webhook - Order Notification. It's a standalone function but you'll need to ...; Created on 22 April 2024
9. ZohoCreator: Using .toFile and Uploading to a Creator field: / Zoho /; ... photos and a bit of fuzzy logic. I thought I could simply update the field with the new file but as I'm not downloading it, this is apparently not the process. How? As a high-level overview: ...; Created on 25 March 2024
10. Zoho Books: Error 7008: There are no contact persons associated with this Invoice: / Zoho /; ... true which will automatically send it and mark it as sent. As the function I use before this to generate the invoice, also updates an invoice, I wanted to keep the action of sending separate so that staff ...; Created on 07 March 2024
11. Zoho Creator: Get Images in Report to be Exported to PDF: / Zoho /; ... in Zoho Creator Staff can access the report via Zoho Creator and export it to PDF. They can then send the PDF to the supplier. Technical Information Automations in the background, on update ...; Created on 26 January 2024
12. ZohoDesk & ZohoAnalytics: Display Ticket Attachments in Analytics Report: / Zoho /; ... You would need to record the attachment ID and only push it to Analytics if Analytics doesn't have that attachment ID in its table already... or updates it if it does. You might want to add to the code ...; Created on 05 December 2023
13. ZohoCRM & ZohoWriter: Generate Rich-Text / HTML Email Signatures in CRM: / Zoho /; ... get all active users in CRM m_UserMapping = Map(); v_Endpoint = "https://www.zohoapis.eu/crm/v4/users?type=ActiveUsers"; r_Users = invokeurl [ url :v_Endpoint type :GET connection:"zcrm" ]; l_UserUpdates ...; Created on 05 December 2023
14. Zoho Books: System Values Maps: / Zoho /; ... that for the below, I recently updated this article (2024-05-21) due to the API domain name change from https://books.zoho.com to https://www.zohoapis.com/books and changed the Top Level Domain (or Zoho ...; Created on 07 November 2023
15. Zoho Creator: Error Code 2945: EXTRA KEY FOUND IN JSON: / Zoho /; ... zoho.creator.createRecord() and wanted to update the first name of a name field but I was getting the following error: { "code": 2945, "description": "EXTRA_KEY_FOUND_IN_JSON" } How? So the ...; Created on 04 October 2023
16. ZohoBooks: Error Code 15: Ensure Billing Address has less than 100 characters: / Zoho /; What? Another article on something I learned today despite never running into this issue before; but sending a billing/shipping address included in a request to create or update an estimate in ZohoBooks ...; Created on 18 September 2023
17. Zoho Books: Get Invoice Payment Terms via API: / Zoho /; ... l_InvoiceLineItems.add(m_NewLineItem); } m_InvoiceDetails.put("line_items",l_InvoiceLineItems); // // create or update if(v_BooksInvoiceID != 0) { r_InvoiceSO = zoho.books.updateRecord("invoices",v_BooksOrgID,v_BooksInvoiceID.toString(),m_InvoiceDetails,"abzohobooks"); } el ...; Created on 06 July 2023
18. Zoho Inventory: Enable Tracking using the API: / Zoho /; ... build the update or create request m_CreateBooksItem = Map(); m_CreateBooksItem.put("name",v_ItemTitle); m_CreateBooksItem.put("sku",v_ItemSKU); m_CreateBooksItem.put("rate",v_ItemPrice.toDecimal()); // // ...; Created on 04 May 2023
19. ZohoCRM Webhook: Create ZohoInventory Records from an eBay order: / Zoho /; ... API for the eBay store /* Function: fn_eBay_GetOrderInfoCreateUpdateZohoSO(string p_eBayOrderRef) Purpose: Queries eBay for information about an order and then creates item/contact/sales ...; Created on 27 April 2023
20. ZohoCRM: Get Organization Business Hours using Deluge/API: / Zoho /; ... to make a subform equal the collection rather than inserting the collection into the subform using insert(). Invalid update task found corresponding properties: Trying to update a time field with a ...; Created on 28 March 2023