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 Dropdown parameter cannot be blank!: / SQL Server Reporting Services /; What? I have created an SSRS report which can compare 4 reports side by side and brings up their latest execution times to the nearest millisecond. The report has 4 parameters. Each parameter is a ...; Created on 14 December 2011
3. SSRS AlphaNumeric Parameter Validation: / SQL Server Reporting Services /; Intro If you ever want to check the parameters submitted with a report for alpha numeric characters (so it doesn't contain symbols, punctuations, etc) then you should do this at the database level, and ...; Created on 07 November 2011
4. 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
5. 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
6. 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
7. Set default parameter dates to start and end of month: / SQL Server Reporting Services /; ... specifying the one day. If the second parameter (ToDate) is the same as the first (FromDate), then the range is for that particular date. Solution Easy for some but anything that I spend 30 minutes ...; Created on 05 April 2011
8. SSRS Use T-SQL Like with a Parameter: / SQL Server Reporting Services /; ... rb.[ContactName] LIKE '%@GivenName%' -- WARNING: 0 matching rows This returns nothing. Took me a while to figure why but it's the parameter that's the issue. You don't enclose it with apostrophes ...; Created on 04 April 2011
9. 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
10. 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
11. 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
12. 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
13. 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
14. 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
15. 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
16. ZohoCRM: Daily Follow Up and Remind Record Owner to Convert Lead: / Zoho /; ... since go live and simply specified "All Leads". I'm calling my function fn_Leads_FollowUpNonConverted with the parameter being the Lead Record ID: /* ******************************************************************************* Function: ...; Created on 14 May 2024
17. 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
18. 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
19. ZohoCreator: Basic Widget with Zoho Data: / Zoho /; ... but the revised instructions here should also help. Then lastly, I'll post the snippet of code using in the widget to connect to Zoho based on a parameter passed in the URL that a Zoho Creator Page can ...; Created on 14 March 2024
20. 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