Search - Joel Lipman .Com

1. Zoho Analytics: Create a Monitoring System with Images: / Zoho /; ... 1), 'https://analytics.zoho.eu/clientapi/imageLibrary/fetchImage?ZDBFILEID=12345000012345678&ZSOID=20240725001', if(to_date("Modified Time") > sub_date(to_date(now()), 5), 'https://analytics.zoho.eu/clientapi/imageLibrary/fetchImage?ZDBFILEID=12345000023456789&ZSOID=20240725001', ...; Created on 25 July 2024
2. Zoho Projects: Get All Events: / Zoho /; ... want one v_ProjectName = "My Project Board"; v_ProjectID = "1234567000001234567"; // // get all users (optional here) v_EndpointUsers = v_BaseURL + "/restapi/portal/" + v_PortalID + "/projects/" + ...; Created on 22 July 2024
3. Zoho Analytics & Zoho People: Monitor DataSource Sync: / Zoho /; ... to get workspace ID, look at the URL in ZohoAnalytics and take the number straight after the word "workspace/" v_WorkspaceID = "12345000001234567"; // // to get the Analytics Org ID, login to Zoho Analytics, ...; Created on 02 July 2024
4. Zoho Webhooks & Shopify API: Keep Disappearing: / Zoho /; ... when generating the access token should be entered here v_ClientSecret = "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"; // // store the record in ZohoCreator // I have a custom form in ZC with the fields ...; Created on 22 April 2024
5. ZohoDesk & ZohoAnalytics: Display Ticket Attachments in Analytics Report: / Zoho /; ... m_Columns.toString()); // // in analytics, browse to the "Attachments" table and note the URL IDs after workspace and view v_WorkspaceID = "123456000000123456"; v_TableID = "12345600000123457"; v_Endpoint ...; Created on 05 December 2023
6. Zoho Creator: Error Code 2945: EXTRA KEY FOUND IN JSON: / Zoho /; What? A quick article on how I resolved this error and how the online forums and documentation did not. Why? I don't often do this to create a Creator record but I'm going to use the shortcode ...; Created on 04 October 2023
7. Zoho Books: Get Invoice Payment Terms via API: / Zoho /; ... This should yield something as follows: { "code": 0, "message": "success", "data": { "payment_terms": [ { "payment_terms_id": "123456000000000123", "payment_terms": ...; Created on 06 July 2023
8. 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
9. ZohoCRM: Get Organization Business Hours using Deluge/API: / Zoho /; ... "id": "123456789000000123456789", "type": "custom" } } Tidied Up Want that in a practical format for use in ZohoCreator? Preferably not in the Zoho order, but that of the normal wee ...; Created on 28 March 2023
10. ZohoBooks: Stripe Terminal Integration: / Zoho /; ... = "IN: " + invoice.get("invoice_number") + " ID: " + invoice.get("invoice_id"); m_Params.put("description",v_DescriptionString); // Later Add Code to "customer_id": "123456700000001234567", get customer ...; Created on 16 March 2023
11. Zoho Deluge: Shopify API: Get all active products with GraphQL and Pagination: / Zoho /; ... = "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2222"; v_Endpoint = "https://" + v_ShopID + "/admin/api/" + v_ShopifyApiVersion.toString() + "/graphql.json"; // // set header parameters m_Header = Map(); m_Header.put("Content-Type","application/json"); m_Header.put("X-Shopify-Access-Token",v_AccessToken); // // ...; Created on 20 February 2023
12. ZohoCRM: Import Attachments: / Zoho /; ... ID which has to be unique as you may have many files called "image001.jpg" but for other records. Parent Id: The CRM Record ID you are going to attach the file to (eg. "zcrm_123450000000000123456"). ...; Created on 16 January 2023
13. Zoho Creator: Shopify API Integration Oauth 2.0 - Update 2022 (Search by SKU GraphQL): / Zoho /; ... "sku": "ABC123456", "title": "Default Title", "barcode": "0000012345", "inventoryItem": { "id": "gid://shopify/InventoryItem/23456789123456" ...; Created on 14 February 2022
14. Zoho CRM & Zoho Writer: Button to Merge Template, Send, and Attach: / Zoho /; ... and attach r_DownloadResponse = zoho.writer.mergeAndDownload("aaaabbbbccccddddeeeeffff000011112222333344445555", "pdf", m_MergedData, "joels_connector"); r_AttachResponse = zoho.crm.attachFile("Contacts" ...; Created on 21 October 2021
15. Zoho CRM: Get Unique Values of a Text Field: / Zoho /; ... this returns something like the following (I've reduced the 200 records to about 6 of them): { "data": [ { "Currency": "EUR", "id": "123456789000000001" }, { "Currency": ...; Created on 08 October 2021
16. Zoho Deluge: Handle Commas between Quotes in a CSV (and New Lines): / Zoho /; ... sample data v_Test = "00011,Joel Lipman,\"Flat 8, House Corner\",Brummieland"; // regex to replace a comma found between 2 double-quotes to a string of your choice v_FormattedString = v_Test.replaceAll("(\"[^\",]+)[,]([^\"]+\")","$1|mySpecialComma|$2",false); info ...; Created on 26 August 2021
17. ZohoCRM: zoho.crm.searchRecords only returns certain records: / Zoho /; ... an example showing how you can get all results irrespective of whether they are converted or approved: response = zoho.crm.searchRecords("Quotes", "(Ref:equals:QU-00001)",1,200,); Done. Ta daa! ...; Created on 29 July 2021
18. Zoho Deluge - Counting in a Map dataType: / Zoho /; ... us assume we have the following in a form/report called "Stock_Upload": RowID Name SKU Account Email 0001 Test Product 1 TEST001 This email address is being protected from spambots. You need JavaScript enabled to view it. 0002 Test Product ...; Created on 02 September 2019
19. Zoho Deluge - Modify the product line items in an invoice module: / Zoho /; ... Item: "Product_Details": [ { "product": { "Product_Code": null, "Currency": "USD", "name": "Test Product", "id": "1642130000000104087" ...; Created on 22 August 2019
20. MS Excel - Open CSV with Long Numbers: / Excel /; ... ID,Name,Phone,Record ID 1457102000000135533,Joel,00441234567890,1457102000000165989 1457102000000135566,Stanley,01709123456,1457102000000167543 1457102000000135608,David,00331234567890,1457102000000166795 My ...; Created on 23 July 2019