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. 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
8. 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
9. 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
10. 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
11. 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
12. ZohoDeluge: Check Shipment Status via DHL API: / Zoho /; ... that asked, in this case Zoho Inventory. So for this, I've set up a nightly schedule which checks on all the shipments from a certain date and updates the shipment status for items that have been delivered: ...; Created on 21 March 2023
13. Zoho Deluge: Shopify API: Get all active products with GraphQL and Pagination: / Zoho /; ... 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'") ...; Created on 20 February 2023
14. ZohoRecruit: Create Linking Table for Candidates and Associated Job Openings: / Zoho /; ... // update the record (note the API name being used here) r_Create = zoho.recruit.addRecord("CustomModule6",m_Create,0,false,"jl_recruit"); //info r_Create; } } } } For historica ...; Created on 08 February 2023
15. ZohoCRM: Import Attachments: / Zoho /; ... static MD5_DIGEST_LENGTH := 16 hModule := DllCall("LoadLibrary", "Str", "advapi32.dll", "Ptr") , VarSetCapacity(MD5_CTX, 104, 0), DllCall("advapi32\MD5Init", "Ptr", &MD5_CTX) , DllCall("advapi32\MD5Update", ...; Created on 16 January 2023
16. Zoho CRM: Manage a subform using Client Script: / Zoho /; ... a rate without any preset values. Rates will be taken from the Opportunity record. If these are blank then enter the rates manually below: Rate Year 1.0, Rate Year 1.5, ..."); } // updat ...; Created on 09 December 2022
17. Zoho Recruit: Rollup Number of Recruit Candidates to CRM Account: / Zoho /; ... to the same school and updates some number fields on the matched CRM account. Why? For reporting purposes. Although Zoho Analytics can use data imported from both ZohoCRM and ZohoRecruit, it was ...; Created on 19 October 2022
18. ZohoFlow & ZohoSign: Retrieve a Zoho Sign document request and add attachments to CRM record: / Zoho /; ... if Deal ID is not zero, then it was found! if(v_DealID != 0) { r_DealDetails = zoho.crm.getRecordById("Deals",v_DealID,); // // do stuff here such as updating the deal if required m_UpdateDeal ...; Created on 17 October 2022
19. Zoho CRM / Deluge: Send an email with a CRM Quote using a given CRM template: / Zoho /; ... v_OutputMessage; Update: What is the URL to download the PDF in Zoho Books? Found this today so thought I'd add it to this article: Invoice: https://books.zoho.com/api/v3/invoices/pdf?organization_id=&invoice_ids= ...; Created on 18 August 2022
20. Zoho Books/Inventory: Trigger a workflow when an invoice has been paid: / Zoho /; What? An article on something that has taken me several days to get working: Get Zoho Books or Zoho Inventory that when an invoice is marked as paid, update 2 custom fields with the Payment Method, and ...; Created on 17 August 2022