Zoho Workdrive: Getting Team Folder IDhttp://mail.joellipman.com/articles/crm/zoho/zoho-workdrive-getting-team-folder-id.html

11 September 2024 m_Params); r_WorkdriveFolder = invokeurl [ url :"https://www.zohoapis.com/workdrive/api/v1/files" type :POST parameters:m_Data.toString() headers:m_Header connection:"my_workdrive_connection" ]; if(!isNull(r_WorkdriveFolder.get("id"))) {...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

ZohoCRM & Xero: Function to pull most recent invoiceshttp://mail.joellipman.com/articles/crm/zoho/zohocrm-xero-function-to-pull-most-recent-invoices.html

09 October 2025 r_AllXeroInvoices = invokeurl [ url :v_DataEndpoint + "/Invoices" + v_FilterReceivables type :GET parameters:m_Params headers:m_Header ]; if(b_Debug) { info r_AllXeroInvoices; } if(!isnull(r_AllXeroInvoices.get("Invoices"))) { for each m_ThisInvoice in...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

ZohoCRM & Xero: Function to pull most recent quoteshttp://mail.joellipman.com/articles/crm/zoho/zohocrm-xero-function-to-pull-most-recent-quotes.html

13 October 2025 DESC"); // // get the first page of Xero Quotes r_AllXeroQuotes = invokeurl [ url :v_DataEndpoint + "/Quotes" type :GET parameters:m_Params headers:m_Header ]; if(b_Debug) { info r_AllXeroQuotes; } // if(!isnull(r_AllXeroQuotes.get("Quotes"))) { for...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Using MetaMod to hide buttons from logged in usershttp://mail.joellipman.com/articles/cms/joomla/using-metamod-to-hide-buttons-from-logged-in-users.html

22 September 2009 and rename it to metamod_pubmenu, set "Access Level" to 'public' and "Menu Items" to 'All'. 5. On right side in "Module Parameters" "Show Quick Modules To" choose - 'non-logged in users only' then scroll down to the list of available modules and find...

• Type: Article
• Author: Joel Lipman
• Category: Joomla
• Language: *

SQL Calendar in Business Intelligence Development Studiohttp://mail.joellipman.com/articles/database/t-sql/sql-calendar-in-business-intelligence-development-studio.html

14 January 2011 you should get the below: Formatting In other words, making it look pretty. I'm doing this now because you may not need parameters or events. The above should create your calendar, the steps that follow are to display it in a recognizable calendar...

• Type: Article
• Author: Joel Lipman
• Category: Transact-SQL
• Language: en-GB

URL passed settings in Reporting Serviceshttp://mail.joellipman.com/articles/microsoft/ssrs/url-passed-settings-in-reporting-services.html

11 February 2011 &rc:Toolbar=False To hide just the parameters (default is True) http:///ReportServer/Pages/ReportViewer.aspx?%2fMYREPORTS%2fDemos%2fRB+Report+for+Me&rs:Command=Render &rc:Parameters=False To change the Rendering modes (defaults to HTML4.0)...

• Type: Article
• Author: Joel Lipman
• Category: SQL Server Reporting Services
• Language: en-GB

Joes Quicklist Weblinks (JQW)http://mail.joellipman.com/component/content/article/joes-quicklist-weblinks-jqw.html?catid=40

03 July 2011 Admins/Users. Due to several requests, the module has been modified to accommodate any Joomla! group (specified in the parameters). It is NOT RECOMMENDED to set this to normal users as this will use up your entitlement to FREE prints extremely quickly....

• Type: Article
• Author: Joel Lipman
• Category: Product Documentation
• Language: *

SSRS Retrieving Oracle Stored Procedure Success or ErrorLevelhttp://mail.joellipman.com/articles/microsoft/ssrs/ssrs-retrieving-oracle-stored-procedure-success-or-errorlevel.html

04 November 2011 to run the stored procedure. This requires using 2 data sources in SSRS. A user will specify the student reference in the parameters of the first report (the one with all the main details), as well as a job reference (for audit purposes) and click "View...

• Type: Article
• Author: Joel Lipman
• Category: SQL Server Reporting Services
• Language: en-GB

Data Randomization Function in Oracle PL/SQLhttp://mail.joellipman.com/articles/database/pl-sql/data-randomization-function-in-oracle-plsql.html

22 August 2012 be returned BEGIN IF p_original_value IS NULL THEN v_returnedval := NULL; ELSIF p_original_datatype='INT' THEN -- Check Parameters and assign proper default values IF p_original_range_1 IS NULL THEN v_rand_param1 := POWER(10,...

• Type: Article
• Author: Joel Lipman
• Category: Oracle PL/SQL
• Language: en-GB

Search a database for a value and count matching rowshttp://mail.joellipman.com/articles/database/search-a-database-for-a-value-and-count-matching-rows.html

05 November 2012 3rd incremental load). How? The below stored procedure can be reduced to just a script as long as you declare and set the parameters after the BEGIN and extract the script from BEGIN to END (excluding the words BEGIN and END - avoids the need to create...

• Type: Article
• Author: Joel Lipman
• Category: Databases
• Language: en-GB

Joes Syntax Styler (JSS)http://mail.joellipman.com/component/content/article/joes-syntax-styler-jss.html?catid=40

06 April 2013 CSS file for overall look. This is still in development! Currently this plugin is mostly hard-coded and most of the parameters have no effect. It was initially built for someone as a quick syntax highlighter that recognizes SQL; but I am working on...

• Type: Article
• Author: Joel Lipman
• Category: Product Documentation
• Language: *

SSRS: Performance Improvements: SELECT TOPhttp://mail.joellipman.com/articles/microsoft/ssrs/ssrs-performance-improvements-select-top.html

07 March 2014 this person... Refine your search. -- This "where" clause returns zero rows if dob, reference, -- forename and surname parameters are not populated. In addition, we also need a second dataset in our report which gets the total count of all the rows...

• Type: Article
• Author: Joel Lipman
• Category: SQL Server Reporting Services
• Language: en-GB

Joes Word Cloud (JWC) Downloadhttp://mail.joellipman.com/component/content/article/joes-word-cloud-jwc-downloads.html?catid=92

07 September 2015 if only one exclusion category selected - Date Uploaded: Thu, 27th Mar 2014 3.2.1 JoomlaGate- Enhancement: Label parameters in XML and language file review - Date Uploaded: Tue, 18th Mar 2014 3.2- Fixed Bug: Redeclare function issue when used multiple...

• Type: Article
• Author: Joel Lipman
• Category: Downloads
• Language: *

Zoho Deluge - Update Creator from CRMhttp://mail.joellipman.com/articles/crm/zoho/zoho-deluge-update-creator-from-crm.html

18 February 2019 The code to update a form (sample data for demonstration purposes). Note that the payload here is submitted through URL parameters: v_AccessToken = "123abc456def789abc123def456abc"; v_Criteria = "ID=1234567890123456789"; v_EndPoint =...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: en-GB

Zoho Deluge: Associate/Link an Invoice to a Sales Orderhttp://mail.joellipman.com/articles/crm/zoho/zoho-deluge-associate-link-an-invoice-to-a-sales-order.html

10 March 2020 ); r_Associate = invokeUrl [ url: "https://www.zohoapis.eu/books/v3/invoices/mapwithorder" type: POST parameters: m_Params connection: "zbooks" ] m_Params = Map(); m_Params.put("line_items", ); m_Params.put("organization_id", ); r_Associate = invokeUrl...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Zoho Deluge: Search Records with Special Characters (COQL)http://mail.joellipman.com/articles/crm/zoho/zoho-deluge-search-records-with-special-characters-coql.html

28 August 2020 // build up COQL query v_CoqlQuery = "select id from Accounts where Account_Name='" + v_SearchName + "'"; // // build up parameters m_Params = Map(); m_Params.put("select_query",v_CoqlQuery); // // invokeurl r_Coql = invokeurl [ url...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Zoho Creator: Button on Report for Merging Multiple Selected Recordshttp://mail.joellipman.com/articles/crm/zoho/zoho-creator-button-on-report-for-merging-multiple-selected-records.html

06 December 2020 go into more detail: Create a function that accepts a form of records Create a workflow that understands the function parameters Create a function Why are we doing this first? Well when I create a workflow, it will ask me to run a function, the Creator...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Zoho CRM: Mapping a Multi-User or Multi-Lookup field using Delugehttp://mail.joellipman.com/articles/crm/zoho/zoho-crm-mapping-a-multi-user-or-multi-lookup-field-using-deluge.html

28 April 2021 r_AssociateMultiUserLookup = invokeurl [ url: "https://www.zohoapis.eu/crm/v8/Quotes" type: PUT parameters: m_AssociateMultiUserLookup.toString() connection: "my_crm_connection" ]; info "Response from associating user " + _ApprovalUser.get("id"); info...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Zoho CRM REST API: Stop Workflow from Triggeringhttp://mail.joellipman.com/articles/crm/zoho/zoho-crm-rest-api-stop-workflow-from-triggering.html

16 June 2021 = "https://www.zohoapis.eu/crm/v2.1/Quotes/" + input.CRM_Quote_ID; r_CreateCrmQuote = invokeurl [ url :v_Url type :PUT parameters:m_Data.toString() connection:"ascentbusiness" ]; or l_Quotes = List(); l_Quotes.add(m_CreateCrmQuote); m_Data = Map();...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Zoho Deluge: Text (SMS) reminder using Twilio API (LocalSense)http://mail.joellipman.com/articles/crm/zoho/zoho-deluge-text-sms-using-twilio-api-localsense.html

16 December 2021 m_Data.put("To",v_CustomerNumber); // // 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 off a scheduled workflow of...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *