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 Creator: Public URL of an Image field / Upload to Shopify API: / Zoho /; ... held in v_ListingPublishKey and lastly, my datacenter is .COM: URL Syntax #1 // works in eBay v_ImageSrc = "https://creator.zoho.com/file" + zoho.appuri + "Portal_Listing_Report/" + input.ID + "/Main_Photo/image-download/" ...; Created on 17 October 2021
3. Zoho Creator / eBay: Get all Active Products: / Zoho /; ... More Info: - API Explorer Test Tool: https://developer.ebay.com/DevZone/build-test/test-tool/default.aspx?index=0&env=production&api=trading - GetMyeBaySelling Documentation: https://developer.ebay.com/devzone/xml/docs/reference/ebay/getmyebayselling.html ...; Created on 13 October 2021
4. Zoho Creator / Shopify: Get all Active Products: / Zoho /; ... your shopify details v_ClientID = ""; v_ClientSecret = ""; v_ShopID = "example.myshopify.com"; v_ShopifyURL = "https://" + v_ClientID + ":" + v_ClientSecret + "@" + v_ShopID; v_ShopifyApiVersion ...; Created on 12 October 2021
5. Zoho CRM: Get Unique Values of a Text Field: / Zoho /; ... = invokeUrl [ url :"https://www.zohoapis.eu/crm/v2/coql" type :POST parameters: m_Params.toString() connection: "joels_coql_connection" ]; // // output info r_Coql; But ...; Created on 08 October 2021
6. Zoho CRM: Upload a Product Photo using Deluge: / Zoho /; ... TLD) v_Endpoint1 = "https://creatorapp.zoho.com" + v_CreatorPhotoUrl; r_CreatorPhoto = invokeUrl [ url: v_Endpoint1 type: GET connection: "joels_creator" ]; info r_CreatorPhoto; // // ...; Created on 27 September 2021
7. Zoho CRM & Zoho Books: Get Books Currency and Tax IDs: / Zoho /; ... check the URL for whether it will be https://books.zoho.eu or https://books.zoho.com. You will also need your own CRM to Books connection name (joel_books) with scope to read settings: // our made ...; Created on 24 September 2021
8. ZohoCRM to ZohoBooks: Please ensure that the shipping_address has less than 100 characters.: / Zoho /; ... US DC v_Endpoint = "https://books.zoho.eu/api/v3/salesorders/"+v_SalesOrderID+"/address/shipping?organization_id=" + v_BooksOrgID; // saw this in the documentation example so will hopefully do what ...; Created on 22 September 2021
9. Zoho CRM & Zoho Books: Custom Related Lists Deluge: / Zoho /; ... = v_Index + 1; v_RelatedListXML = v_RelatedListXML + ""; // // retrieve v_CreatorQuoteID = r_Result.get("ID"); v_LinkUrl2 = "https://creatorapp.zoho.eu/" + v_OwnerName + "/" + v_AppLinkName ...; Created on 30 July 2021
10. Zoho CRM REST API: Stop Workflow from Triggering: / Zoho /; ... = Map(); m_Data.put("data",l_Quotes); l_Triggers = List(); l_Triggers.add("none"); m_Data.put("trigger",l_Triggers); v_Url = "https://www.zohoapis.eu/crm/v2.1/Quotes/" + input.CRM_Quote_ID; r_CreateCrmQuote ...; Created on 16 June 2021
11. Zoho CRM: Update a custom field in line items / product details using REST API v2.1: / Zoho /; ... list to stop or prevent these from triggering. m_Data.put("triggers",[]); // // send via REST API v2.1 on EU datacenter r_CreateCrmQuote = invokeurl [ url :"https://www.zohoapis.eu/crm/v2.1/Quotes" type ...; Created on 17 May 2021
12. Zoho Projects: Add a Time Log to an Issue using Deluge: / Zoho /; ... a")); m_CreateTimeLog.put("end_time",v_EndTime.toString("hh:mm a")); m_CreateTimeLog.put("notes",v_WorkNotes); v_Url = "https://projects.zoho.eu/restapi/portal/"+v_PortalID+"/projects/"+v_ProjectID+"/"+v_TaskOrIssue+"/"+v_IssueID+"/logs/"; r_CreateTimeLo ...; Created on 30 April 2021
13. Zoho Deluge: Post a multi-dimensional or nested array to a 3rd-party API: / Zoho /; ... 's Awesome Life"); m_NestedRequest.put("data[item_price]","priceless"); r_PostResponse = invokeurl [ url :"https://api.joellipman.com/my_test_api.php" type :POST parameters:m_NestedRequest ]; ...; Created on 03 February 2021
14. Zoho Creator: Download File from ZohoCRM field type "File Upload" (not attachments: / Zoho /; ... "link_Docs": 0 } ], The most logical thinkers would say that you simply need the download_Url value and prepend the CRM base URL such as https://crm.zoho.com + v_download_Url... But that ...; Created on 02 February 2021
15. Zoho People: Reject an Application for Leave in Deluge based on Criteria: / Zoho /; ... r_ApiResponse= invokeurl [ url :"https://people.zoho.com/people/api/leave/getEmployeesOnLeave" type :POST parameters: c_Params.toMap() connection: “peoplecf” ]; v_EmployeeCo ...; Created on 10 December 2020
16. Zoho Creator: Set Up Custom Domain for Customer Portal: / Zoho /; ... need to give the full path of the custom domain (eg. https://mysubdomain.joellipman.com), I include the app owner and app name. Then you need to give them edit access by doing the following: Go to your ...; Created on 17 November 2020
17. Zoho Creator: info/alert/modal/popup notification for any user: / Zoho /; ... base URL such as https://creatorapp.zoho.com/myowner/myapp/#Page:Notify. CSS styling affects all contents: Any styling on an embedded form on the popup would need to apply specifically to the contents ...; Created on 06 November 2020
18. Zoho Creator: Create a Widget which uses JavaScript: / Zoho /; ... is required - includes Zoho One) macOS Catalina v10.15.7 Safari v14.0 MS Visual Studio Code v1.48.2 Prerequisites Download nodejs source code from https://nodejs.org/en/download/. Don' ...; Created on 24 October 2020
19. Zoho Creator Page: Toggle On/Off Switch: Hide/Display a Div: / Zoho /; What? So this is an article documenting how to create an on/off toggle switch that hides and displays between 2 div layers in a Zoho Creator Page (so not a form or report but a page). Why? This ...; Created on 22 October 2020
20. Zoho Deluge: Search Records with Special Characters (COQL): / Zoho /; ... says: https://zoho.com/ then use the endpoint https://www.zohoapis.com/crm/v2/coql https://zoho.eu/ then use the endpoint https://www.zohoapis.eu/crm/v2/coql https://zoho.com.cn/ then use the endpoint ...; Created on 28 August 2020