Search - Joel Lipman .Com

1. ZohoCRM: Using Criteria with Module Record Count: / Zoho /; ... as the one used in the Search API call. Code-wise using the same criteria variable for both calls might offer some consistency. Notes on the attribute: Criteria You can't compare a date time value ...; Created on 14 November 2023
2. Zoho Books: System Values Maps: / Zoho /; ... statements, I can feed these maps a textual value and it returns the ID to use. Some of these can be found elsewhere in my site but I'm putting all of them here just for quick reference. How? Note ...; Created on 07 November 2023
3. Zoho Books: Generate Bank Text File for Download: / Zoho /; ... as well as from the system as it contains bank details. You can skip this step if you're not bothered about storing this file on the system. Note that if you use the endpoint to delete the attachment ...; Created on 02 October 2023
4. ZohoBooks: Error Code 15: Ensure Billing Address has less than 100 characters: / Zoho /; ... these in her estimate template... But I'm sending them anyway. Note(s) The following code accesses APIs on the EU datacenter. I have a connection called "zbooks" which has the necessary scope(s) ...; Created on 18 September 2023
5. Zoho Books: Get Invoice Payment Terms via API: / Zoho /; ... { r_InvoiceSO = zoho.books.createRecord("invoices",v_BooksOrgID,m_InvoiceDetails,"abzohobooks"); } Note(s): There are 2 other payment terms which is by setting payment terms to 0 whic ...; Created on 06 July 2023
6. Zoho Deluge: Determine if Daylight Savings are in effect: / Zoho /; What? If you're lucky enough to build an application for a client based in a country that changes its clocks twice a year, then I'm opening this article without a 100% certain solution as I need to wait ...; Created on 03 July 2023
7. Zoho CRM: Change System Field Length: / Zoho /; ... but it is a workaround I have used and that worked when converting a lead to a deal. Note that this hack doesn't work on the system field label name (I tried) just on the length field. Use the translations ...; Created on 19 June 2023
8. Zoho: Email Deliverability / SPF / DKIM / DMARC / Toolkit: / Zoho /; ... how to troubleshoot issues with this. One important thing to note is that the setup needs to be done by whoever manages the domain for the client. Who owns the domain (eg. mycompany.com) So this ...; Created on 04 May 2023
9. ZohoCRM Webhook: Create ZohoInventory Records from an eBay order: / Zoho /; What? This is a not-so-quick article that queries an eBay order and creates the relevant ZohoInventory item, contact, sales order, package slip, shipment order, invoice, payment records... Why? ...; Created on 27 April 2023
10. Zoho Deluge: Get All Orders from eBay: / Zoho /; ... = Map(); l_JsonOrders = List(); // // start preparing CSV file to email for export v_ReportCSV = "Date,Order ID,Status,Amount,Currency,Notes"; l_CsvFileRows = List(); l_CsvFileRows.add(v_ReportCSV); // // ...; Created on 29 March 2023
11. ZohoDeluge: Check Shipment Status via DHL API: / Zoho /; What? A quick note here on how to connect to the DHL API and check on a package given a tracking number. Why? In our megafunction to generate a customer, a product/item, a sales order, an invoice, ...; Created on 21 March 2023
12. ZohoAnalytics: Pivot Campaigns vs Contacts: / Zoho /; ... Pivot" cp ON cp."Contact Id"=c."Id" Caveat(s) You may have noted a few caveats with this solution: This query needs each campaign name specified to see the results per contact person. You can ...; Created on 20 March 2023
13. ZohoCRM: Integrate ChatGPT to ZohoZIA: / Zoho /; ... invokeurl (note the Zoho endpoint here will depend on your datacenter; .com / .eu) r_Coql = invokeurl [ url :"https://www.zohoapis.eu/crm/v2/coql" type :POST parameters:m_Params.toString() ...; Created on 06 March 2023
14. ZohoCRM: Get All eBay Active Listings: / Zoho /; ... "Fn - eBay - Get Active Products" and give it the internal name as "fn_GetEbayActiveProducts" without any arguments. Something to note in the below is that it asks you to set an estimated number of products ...; Created on 01 March 2023
15. ZohoDeluge: Get All eBay Orders Given a From and Till Date: / Zoho /; ... that were in practice added to the same function and that worked at time of print. Note that this uses the old Trading API as the new API is only available in Sandbox??? I won't go into how to generate ...; Created on 28 February 2023
16. Zoho Creator: Disable/Hide the add and delete subform row buttons: / Zoho /; ... of print, this is the only way I know: add a note field to inject some CSS into it and hide the delete icon as well as the "Add new row" link. In Design mode: Add a special field of type "Add Notes" ...; Created on 28 February 2023
17. Zoho Deluge: Shopify API: Get all active products with GraphQL and Pagination: / Zoho /; ... = l_CsvFileRow.toString(); l_CsvFileRows.add(v_CsvRow); // // note the cursor so that we resume from the last cursor v_Cursor = r_Node.get("cursor"); // // ...; Created on 20 February 2023
18. Zoho Cliq: Integrate OpenAI and ChatGPT 3.5 Turbo: / Zoho /; What? A quick article on my adaptation of some code posted by Poorvik Palanikumar on the Zoho Community Forums to connect a ZohoCliq to the OpenAI API and ChatGPT... Note that I have another article ...; Created on 13 February 2023
19. Joel's Reference to MidJourney v4 Prompt: / Graphic Design /; ... prompt combining any of the following in a table (this is not an exhaustive / limited list). Do note that the images below were generated using MidJourney v4: Type of Photography Nature Photography ...; Created on 11 February 2023
20. 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