Search - Joel Lipman .Com

1. Zoho Deluge: Convert Map to URL Parameters: / Zoho /; What? A quick article on converting a Map (associative array with keys and values) into a URL string to pass as URL parameters. How? Let's first define a map: m_Payload = Map(); m_Payload.put("client_id","my-unique-client-id"); m_Payload.put("redirect_uri","https://www.joellipman.com"); m_Payload.put("response_type","code"); m_Payload.put("scope","my_api_scopes"); m_Payload.put("prompt","login"); Great! ...; Created on 09 March 2020
2. SSRS Parameters in Oracle Stored Procedure: / SQL Server Reporting Services /; ... add parameters to a Stored Procedure of an Oracle database from within Microsoft SQL Server Reporting Services. The Error ORA-00911: invalid character ORA-06512: at "SYS.DBMS_UTILITY", line 114 ...; Created on 02 September 2011
3. MySQL parameters in Excel 2007 PivotTables: / MySQL /; ... number my bosses want - 7h 24m or 26640s is 1 person day)... With date range as parameters ...ouch... ...and it was so easy up to here... Tables of interest StaffActivities ...; Created on 24 August 2011
4. SSRS Querying on either of 2 Parameters: / SQL Server Reporting Services /; ... of this article). The end-user must be able to search on EITHER the student's username or the student's ID (2 report parameters: @StudentADAccount [varchar] and @StudentReference [int] respectively). ...; Created on 19 July 2011
5. Parameters not being used in report processing: / SQL Server Reporting Services /; ... 2.0 and when previewing the report, the parameters are not accounted for (ie. the SQL query creating the dataset does not use the parameters in its query). Problems: Given a date, the date format ...; Created on 07 January 2011
6. Zoho CRM: Updating a CRM record Custom Line Items using API v7: / Zoho /; ... these from triggering. m_Data.put("trigger",List()); v_Endpoint = "https://www.zohoapis.com/crm/v7/Quotes/" + p_QuoteID; r_QuoteDetails = invokeurl [ url :v_Endpoint type :PUT parameters:m_Data.toString() connection:"zcrm" ]; info ...; Created on 18 December 2024
7. Zoho Books: Estimates/Quotes: Accept & Decline Buttons on Template: / Zoho /; ... > New Function Give it a function name, I'm calling mine fn_ZohoBooks_Estimates_AcceptDecline with the parameters: p_Intent (string), p_QuoteRef (string), p_CxID (string) The display name I'm giving ...; Created on 04 November 2024
8. Zoho Workdrive: Getting Team Folder ID: / Zoho /; ... :POST parameters:m_Data.toString() headers:m_Header connection:"my_workdrive_connection" ]; if(!isNull(r_WorkdriveFolder.get("id"))) { v_WorkdriveFolderID = r_WorkdriveFolder.get("id"); // // ...; Created on 11 September 2024
9. Zoho CRM & Zoho Sign: Send CRM Merged Template for Zoho Sign: / Zoho /; ... purposes if(!isNull(r_Contact) && !isNull(r_Contact.get("Email"))) { v_RecipientEmail = r_Contact.get("Email"); v_RecipientFullName = r_Contact.get("Full_Name"); // _ m_Parameters = Map(); m_Data ...; Created on 06 August 2024
10. Zoho Projects: Get All Events: / Zoho /; ... from ZohoProjects. How? The bit that stumped me was making a call to the Events endpoint as it would just come back with a blank response... The reason it was blank was due to my parameters; ...; Created on 22 July 2024
11. ZohoAnalytics & ZohoBooks: Custom Related List from Analytics: / Zoho /; ... = Map(); // sometimes parameters need to be a string... but this is working m_Config.put("CONFIG",m_Params); v_Endpoint = "https://analyticsapi.zoho.eu/restapi/v2/workspaces/" + v_ZA_WorkspaceID + "/views/" ...; Created on 09 July 2024
12. 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
13. ZohoCRM: Daily Follow Up and Remind Record Owner to Convert Lead: / Zoho /; ... but without the correct additional parameters omitted/needed (in my case the UNTIL given a CRM/Atom date time format). m_Recurrer.put("RRULE","FREQ=DAILY;INTERVAL=1;DTSTART=" + v_StartDate + ";UNTIL=" ...; Created on 14 May 2024
14. Zoho Webhooks & Shopify API: Keep Disappearing: / Zoho /; ... :POST parameters:m_Params.toString() headers:m_Header ]; } // // create inventory level update webhook if(b_RestoreInventoryLevelWebhook) { m_Webhook = Map(); m_Webhook.put("format","json"); m_Webhook.put("topic","inventory_levels/update"); m_Webhook.put("address",v_CrmInventoryLevelWebhook); m_Params ...; Created on 22 April 2024
15. 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
16. ZohoCreator: Basic Widget with Zoho Data: / Zoho /; ... var v_ShopifyID = ""; var v_ShopifyEmail = ""; var v_GreetingName = ""; // Try and catch try{ // Get Creator Parameters Passed in URL - Cannot ...; Created on 14 March 2024
17. Zoho Books: Error 7008: There are no contact persons associated with this Invoice: / Zoho /; ... to_mail_ids in the URL instead of the body parameters ******************************************************************************* */ v_BooksOrgID = "12345678901"; v_BooksInvoiceID = 0; v_ZB_CustomerID ...; Created on 07 March 2024
18. ZohoDesk & ZohoAnalytics: Display Ticket Attachments in Analytics Report: / Zoho /; ... = "https://analyticsapi.zoho.eu/restapi/v2/workspaces/"+v_WorkspaceID+"/views/"+v_TableID+"/rows"; r_AddRow = invokeurl [ url: v_Endpoint2 type: POST parameters: m_Params.toString() headers: ...; Created on 05 December 2023
19. ZohoCRM & ZohoWriter: Generate Rich-Text / HTML Email Signatures in CRM: / Zoho /; ... = Map(); m_Params.put("data",m_Data); r_Permissions = invokeurl [ url :"https://www.zohoapis.eu/workdrive/api/v1/permissions" type :POST parameters:m_Params.toString() headers:m_Headers connection:"zworkdrive" ]; inf ...; Created on 05 December 2023
20. ZohoBooks: Error Code 15: Ensure Billing Address has less than 100 characters: / Zoho /; ... + p_QuoteID type :GET parameters:m_ApprovedConverted connection:"zcrm" ]; // should be checking here that data contains any rows but I'm going on the basis that this quote exists in CRM an ...; Created on 18 September 2023