Search - Joel Lipman .Com

1. Outputting PHP files into different file formats: / Personal Home Page /; I'm beginning a list as I've just spent an age trying to get PHP output to create a text file. Then my client showed me how she then opens the text file in Excel, so I said we could get the script to do ...; Created on 12 February 2010
2. Zoho Inventory & eBay Picture Services: UploadSiteHostedPictures: / Zoho /; ... Another REST API CRM function which generates an eBay Access Token for me r_Response = getUrl("https://www.zohoapis.eu/crm/v2/functions/fn_ebay_getaccesstoken/actions/execute?auth_type=apikey&zapikey=1003."); if(!isnull(r_Response.toMap().get("details"))) { if(!isnull(r_Response.toMap().get("details").get("output"))) { v_AccessToke ...; Created on 31 March 2022
3. PC Build 2022: 5 Monitors connected to 1 PC using 1 GPU: / Articles /; ... Previous Setup Diagram: Home PC has a graphics card with 1x HDMI, 1x DVI, and 1x VGA output ports: I connected the 2 acer monitors which both accepted DVI. Work PC has a graphics card with 1x ...; Created on 12 March 2022
4. Zoho CRM: Schedule a Meeting using Deluge: / Zoho /; ... Mins"); // // the meeting status m_ScheduleMeeting.put("Status","Not Started"); // // send request and create record r_CreateMeeting = zoho.crm.createRecord("Events",m_ScheduleMeeting); // // outpu ...; Created on 02 March 2022
5. Zoho Creator: Shopify API Integration Oauth 2.0 - Update 2022 (Search by SKU GraphQL): / Zoho /; ... = invokeurl [ url :v_Endpoint type :GET headers:m_Header ]; // // output info r_GetProduct; GraphQL: Usage example: And here's a quick test to retrieve the 5 recent products ...; Created on 14 February 2022
6. Zoho CRM: Using a function for validation rules (or restricting specific picklist options by user profile): / Zoho /; ... String crmAPIRequest Outputs: output message to user Date Created: 2022-02-11 (JoelLipman.com - Joel Lipman) - Initial release - Checks the user profile ...; Created on 11 February 2022
7. Zoho CRM: searchRecords with sorted results: / Zoho /; ... true); r_UpdateAccount = zoho.crm.updateRecord("Accounts", v_AccountID, m_UpdateAccount); // optional: output response of update request info v_AccountID + "::" + r_UpdateAccount.toString(); } ...; Created on 10 February 2022
8. Zoho Deluge: a HTML Entity Decoder: / Zoho /; ... = v_StringToDecode.replaceAll(v_HtmlKey, m_HtmlEntity.get(v_HtmlKey), true); } // // output return v_StringToDecode; } Usage: v_TestString = "Father & Sons"; v_DecodedString = thisapp.DataCleansing.fn_DecodeHtmlEntities(v_TestString); info ...; Created on 27 January 2022
9. Zoho Creator: eBay: Get Item Transaction: / Zoho /; ... */ v_Found = 0; v_Updated = 0; v_Page = 1; v_PerPage = 10; m_Output = Map(); r_Api = API_Integration[Connection_Name == "eBay API (Production)"]; if(r_Api.count() > 0) { v_AccessToken ...; Created on 22 January 2022
10. Zoho Creator: Receive eBay Notification and Create Shopify Order: / Zoho /; What? This is an article documenting how to parse the notification from eBay and using it to create an order in Shopify. Why? Previously, we would receive an eBay notification and create an ...; Created on 21 January 2022
11. ZohoCRM & Xero Real-Time Invoices: Receive Webhook: / Zoho /; ... = ""; v_AccessToken = ""; r_Response = getUrl("https://www.zohoapis.com/crm/v2/functions/fn_api_getxeroaccesstoken/actions/execute?auth_type=apikey&zapikey="); if(!isnull(r_Response.toMap().get("details"))) { if(!isnull(r_Response.toMap().get("details").get("output"))) { v_AccessToken ...; Created on 10 January 2022
12. Zoho Deluge: Calculate start and end of Daylight Savings Time: / Zoho /; ... } v_CheckDateEnd = v_ToMonthDate1.subDay(v_DayIndex); if(v_CheckDateEnd.toString("E")=="Sun") { v_DST_EndTime = v_CheckDateEnd; } } // // output info "Start Date (Current ...; Created on 07 December 2021
13. Zoho CRM & Zoho Writer: Button to Merge Template, Send, and Attach: / Zoho /; ... going to ZohoCRM > Setup > Customization > Modules and Fields > Contacts > Links and Buttons > Create Button where the function arguments will be p_ContactID = Contacts.Contact_ID v_OutputMessage = ...; Created on 21 October 2021
14. Zoho Creator: Public URL of an Image field / Upload to Shopify API: / Zoho /; ... p_Position, int p_ProductID) { v_Output = ""; m_Header = Map(); m_Header.put("Content-Type","application/json"); // // your shopify details v_ClientID = ""; v_ClientSecret = ""; v_ShopID ...; Created on 17 October 2021
15. Zoho Creator / eBay: Get all Active Products: / Zoho /; ... */ v_Page = ifnull(p_Page,1); v_PerPage = ifnull(p_PerPage,200); m_Output = Map(); r_Api = API_Integration[Connection_Name == "eBay API (Production)"]; if(r_Api.count() > 0) { v_AccessToken ...; Created on 13 October 2021
16. Zoho Creator / Shopify: Get all Active Products: / Zoho /; ... It then outputs a JSON list as a response and the total record count: void API.fn_ShopifyQuery_GetActiveProducts() { m_Header = Map(); m_Header.put("Content-Type","application/json"); // // ...; Created on 12 October 2021
17. 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
18. ZohoCRM to ZohoBooks: Please ensure that the shipping_address has less than 100 characters.: / Zoho /; ... = zoho.books.createRecord("salesorders",v_BooksOrgID,m_BooksCreateSO,"ab_books"); // output response info r_CreateSO; // read response if(!isnull(r_CreateSO.get("salesorder"))) { v_SalesOrderID = r_CreateSO.get("salesorder").get("salesorder_id"); // v_AddressIndex ...; Created on 22 September 2021
19. Zoho Creator: Receive eBay Order Notifications via Webhook: / Zoho /; ... on the function that generates an access token from a refresh token: string API.fn_eBayConnect_AccessToken() { b_SandboxMode = false; v_Output = ""; if(b_SandboxMode) { r_Api = API_Integration[Connection_Name ...; Created on 20 September 2021
20. Zoho Creator: Prevent Endless Loops On User Input of a Field: / Zoho /; ... stuff here ... eg getting data fields, generating a title and setting the title: input.Title = "Hello World "; // // output input.Note_Preview = input.Title; // // re-enable auto-update preview input.Update_Preview=true; To ...; Created on 19 September 2021