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. 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
11. Zoho Inventory: Enable Tracking using the API: / Zoho /; ... for anything else than tracking stock...? How? So the quick answer is one missing parameter to send through which is "item_type=inventory"... A little longer, is do ensure you have Zoho Inventory ...; Created on 04 May 2023
12. ZohoCRM Webhook: Create ZohoInventory Records from an eBay order: / Zoho /; ... the method of "mega-functions", here is the code snippet for one function which will accept as parameter the eBay order reference and generate all the respective records in Zoho Inventory. We're using a ...; Created on 27 April 2023
13. Zoho Deluge: Get All Orders from eBay: / Zoho /; ... to eBay:"; //info x_Params; // // send the request XML as a string x_ResponseBody = invokeurl [ url :v_Endpoint type :POST parameters:x_Params headers:m_Headers ]; //info "Respons ...; Created on 29 March 2023
14. ZohoCRM: Integrate ChatGPT to ZohoZIA: / Zoho /; ... The question can be asked by clicking the button "Ask ChatGPT" Add the parameter: I'm calling it "banter" of type "String" with a prompt message of "What is your question?" click on "Save ...; Created on 06 March 2023
15. ZohoCRM: Get All eBay Active Listings: / Zoho /; ... eBay:"; // info x_Params; // // send the request XML as a string x_ResponseBody = invokeurl [ url :v_Endpoint type :POST parameters:x_Params headers:m_Headers ]; if(v_Page==1) { // / ...; Created on 01 March 2023
16. ZohoDeluge: Get All eBay Orders Given a From and Till Date: / Zoho /; ... as a string x_ResponseBody = invokeurl [ url :v_Endpoint type :POST parameters:x_Params headers:m_Headers ]; Parsing the response into JSON or a Deluge Map This can be appended to the ...; Created on 28 February 2023
17. Zoho Deluge: Shopify API: Get all active products with GraphQL and Pagination: / Zoho /; ... = "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2222"; v_Endpoint = "https://" + v_ShopID + "/admin/api/" + v_ShopifyApiVersion.toString() + "/graphql.json"; // // set header parameters m_Header = Map(); m_Header.put("Content-Type","application/json"); m_Header.put("X-Shopify-Access-Token",v_AccessToken); // // ...; Created on 20 February 2023
18. Zoho Cliq: Integrate OpenAI and ChatGPT 3.5 Turbo: / Zoho /; ... = invokeurl [ url :"https://api.openai.com/v1/chat/completions" type :POST parameters:m_Params.toString() headers:m_Header detailed:true ]; if(r_ChatGPTResponse.get("responseCode") == ...; Created on 13 February 2023
19. Joel's Reference to MidJourney v4 Prompt: / Graphic Design /; ... on how to do this: Youtube - Matt Wolfe - Install Stable Diffusion Locally. Ok it isn't MidJourney... But it's free. Defaulting some parameters to be added to every prompt /prefer suffix This ...; Created on 11 February 2023
20. ZohoRecruit: Create Linking Table for Candidates and Associated Job Openings: / Zoho /; What? This article is just in case it comes up again (has twice now) where a client wants a report on candidates and associated job openings in Zoho Recruit. Why? We're creating a custom module ...; Created on 08 February 2023