Search - Joel Lipman .Com

1. $_SERVER['http_referer'] returns blank in Internet Explore: / Microsoft /; Thought I'd put a note about this as I spent ages rewriting an entire system. The HTTP_REFERER environment variable can be changed by the user anyway but I was using it as an additional validation check. ...; Created on 19 October 2009
2. Zoho Books: Estimates/Quotes: Accept & Decline Buttons on Template: / Zoho /; ... = true; // // Mark the estimate as accepted r_Accept = invokeurl [ url :"https://www.zohoapis.com/books/v3/estimates/" + v_EstimateID + "/status/accepted?organization_id=" + v_OrgId type ...; Created on 04 November 2024
3. Zoho Workdrive: Getting Team Folder ID: / Zoho /; ... on "My Folders" and then checking the URL https://workdrive.zoho.com/home//privatespace/folders/ Getting the teamfolder ID: Access the folder in workdrive and check the URL: https://workdrive.zoho.com/home//teams//ws//folders/files or https://workdrive.zoho.com/home//teams//ws//folders/ ...; Created on 11 September 2024
4. Zoho CRM & Zoho Sign: Send CRM Merged Template for Zoho Sign: / Zoho /; ... Modified: 2024-08-21 (Joel Lipman) - Creates a recipient and event record in CRM More Information: https://www.zoho.com/deluge/help/sign/get-template-by-id.html ...; Created on 06 August 2024
5. 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
6. Zoho Projects: Get All Events: / Zoho /; ... send to. Here's some code to get the last 50 events: // // *********************************** // get Zoho Projects information v_BaseURL = "https://projectsapi.zoho.com"; v_Heading = ""; // // ...; Created on 22 July 2024
7. ZohoAnalytics & ZohoBooks: Custom Related List from Analytics: / Zoho /; ... - Initial release Date Modified: ??? - ??? More Information: https://www.zoho.com/analytics/api/v2/bulk-api/export-data.html ******************************************************************************* ...; Created on 09 July 2024
8. Zoho Analytics & Zoho People: Monitor DataSource Sync: / Zoho /; ... - Initial release Date Modified: ??? - ??? More Information: https://www.zoho.com/analytics/api/v2/metadata-api/datasources.html ******************************************************************************* ...; Created on 02 July 2024
9. Zoho Books / Inventory: Get Item Rate from a Price Book/List: / Zoho /; ... "sales"); v_PriceBookEndpoint = "https://www.zohoapis.com/books/v3/items/pricebookrate"; r_ThisPriceBook = invokeurl [ url : v_PriceBookEndpoint type :GET parameters: m_Params connection:"zbooks" ]; // // ...; Created on 23 May 2024
10. Zoho Creator: Render to PDF with margins and page numbers: / Zoho /; ... product photo c_Product = Products[ID == c_Quote.Product]; if(c_Product.count() > 0) { v_ProductPhotoFile = c_Model.Product.getSuffix("http").getPrefix("\"").getSuffix("/image/"); v_ProductPhotoURL ...; Created on 07 May 2024
11. Zoho Webhooks & Shopify API: Keep Disappearing: / Zoho /; ... */ // // set your own REST API endpoints for the webhooks here (we are only checking order update or inventory level update) v_CrmOrderUpdateWebhook = "https://www.zohoapis.com/crm/v2/functions/fn_shopify_webhook_orderupdate/actions/execute?auth_type=apikey&zapikey=1003.aaaabbbbccccddddeeeeffff00001111.22223333444455556666777788889999"; v_CrmInventoryLevelWebhook ...; Created on 22 April 2024
12. Zoho Deluge and Wordpress/WooCommerce API: Get All Products: / Zoho /; ... = "https://mysite.com"; v_ConsumerKey = "ck_aaaabbbbccccddddeeeeffff1111222233334444"; v_ConsumerSecret = "cs_555566667777888899990000aaaabbbbccccdddd"; // // connection parameters l_ConnectionParams ...; Created on 15 April 2024
13. ZohoCreator: Using .toFile and Uploading to a Creator field: / Zoho /; ... "All Documents", and the file upload field is called "Document File": // // now upload updated file v_Endpoint = "https://creator.zoho.com/api/v2.1"+zoho.appuri+"report/All_Documents/"+v_ZC_DocumentRecordID+"/Document_File/upload"; r_Upload ...; Created on 25 March 2024
14. Zoho Books: Error 7008: There are no contact persons associated with this Invoice: / Zoho /; ... = "https://www.zohoapis.com/books/v3/invoices/" + v_BooksInvoiceID + "/email?organization_id=" + v_BooksOrgID; r_SendInvoice = invokeurl [ url :v_Endpoint type :POST parameters:m_Params.toString() connection:"zbooks" ]; info ...; Created on 07 March 2024
15. Zoho Creator: Get Images in Report to be Exported to PDF: / Zoho /; ... + 1).toLowerCase(); // // All_Documents is the report, File_field is the field. v_ThisDocSrc = "https://creator.zoho.eu/file" + zoho.appuri + "All_Documents/" + c_Document.ID + "/File_field/download/" ...; Created on 26 January 2024
16. ZCRM Client Script: Correct Decimal Fields OnLoad: / Zoho /; ... */ // freezes the GUI? ZDK.UI.freeze(true); // attempt try { // taken from stackoverflow: https://stackoverflow.com/questions/17369098/simplest-way-of-getting-the-number-of-decimals-in-a-number-in-javascript ...; Created on 13 December 2023
17. ZohoDesk & ZohoAnalytics: Display Ticket Attachments in Analytics Report: / Zoho /; ... ticket details r_TicketDetails = zoho.desk.getRecordById(v_DeskOrgID,"tickets",p_TicketID); r_Attachments = invokeurl [ url :"https://desk.zoho.eu/api/v1/tickets/" + p_TicketID + "/attachments" typ ...; Created on 05 December 2023
18. ZohoCRM & ZohoWriter: Generate Rich-Text / HTML Email Signatures in CRM: / Zoho /; ... = ifnull(p_DownloadImageUrl,"https://joellipman.com/tmp/icon_linkedin.jpg"); v_FileName = v_ImageToDownload.subString(v_ImageToDownload.lastIndexOf("/") + 1); // // get file object f_File = invokeurl [ url ...; Created on 05 December 2023
19. ZohoCRM: Using Criteria with Module Record Count: / Zoho /; ... I've called it "zcrm". Standard Call for Module Record Count: v_PerPage = 200; v_Endpoint = "https://www.zohoapis.com/crm/v5/Quotes/actions/count"; r_MaximumCount = invokeurl [ url :v_Endpoint type ...; Created on 14 November 2023
20. 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