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 Creator: Embed Forms/Reports on a Page: / Zoho /; ... snippet for a Zoho Creator page. We set the parameters of the form/report. Then this shows how to embed using a DIV layer which allows for CSS styling. The last part shows how to embed using an IFRAME ...; Created on 05 May 2022
11. Zoho Inventory & eBay Picture Services: UploadSiteHostedPictures: / Zoho /; ... Name: fn_eBay_UploadPhoto Display Name: Fn - eBay - Upload Photo Description: What it says on the tin Category: Standalone Click on Create Give it the parameter/argument p_InventoryitemID as ...; Created on 31 March 2022
12. Zoho Creator: Shopify API Integration Oauth 2.0 - Update 2022 (Search by SKU GraphQL): / Zoho /; ... = r_ShopifyAPI.API_Version; v_AccessToken = r_ShopifyAPI.Access_Token; // // set header parameters m_Header = Map(); m_Header.put("Content-Type","application/json"); m_Header.put("X-Shopify-Access-Token", ...; Created on 14 February 2022
13. Zoho CRM: searchRecords with sorted results: / Zoho /; ... Contrary to the documentation saying there are only the approved and converted values supported in additional parameters, I find the below works in CRM just fine: // ****************** CODE USING ...; Created on 10 February 2022
14. Zoho Creator: eBay: Get Item Transaction: / Zoho /; What? This is the function to get the line item order/transaction from eBay if you give it the eBay Item ID as a parameter. Why? Mostly for debugging but here's the code that will quickly get the ...; Created on 22 January 2022
15. 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
16. ZohoCRM & Xero Real-Time Invoices: Receive Webhook: / Zoho /; ... these into data for invoices and contacts. Category: Standalone Click on Create Give it the parameter: crmAPIRequest (string) Dump in the following code: // enter the webhooks key for your app ...; Created on 10 January 2022
17. Zoho Deluge: Text (SMS) reminder using Twilio API (LocalSense): / Zoho /; ... JSON request r_TwilioResponse = invokeurl [ url :v_Endpoint type :POST parameters:m_Data ]; // // display to user/developer the response return r_TwilioResponse; Adapting it to trigger ...; Created on 16 December 2021
18. Zoho CRM: Schedule a Task: Timesheet Reminder: / Zoho /; What? A quick article to demonstrate code that creates a task in CRM based on the time logged against an Event/Meeting. Why? As developers, we're keep account of our time and we are currently ...; Created on 02 December 2021
19. Zoho Creator: Public URL of an Image field / Upload to Shopify API: / Zoho /; ... + "/images.json"; r_UploadPhoto = invokeurl [ url :v_Endpoint type :POST headers:m_Header parameters: m_Params.toString() ]; v_Output = r_UploadPhoto; } return v_Output; } Sends ...; Created on 17 October 2021
20. Zoho Creator / eBay: Get all Active Products: / Zoho /; ... request XML as a string r_ResponseXML = invokeurl [ url :v_Endpoint type :POST parameters:x_Params headers:m_Headers ]; // // output response info r_ResponseXML; // // ...; Created on 13 October 2021