Advanced Search

Here are a few examples of how you can use the search feature:

Entering this and that into the search form will return results containing both "this" and "that".

Entering this not that into the search form will return results containing "this" and not "that".

Entering this or that into the search form will return results containing either "this" or "that".

Search results can also be filtered using a variety of criteria. Select one or more filters below to get started.

Assuming parameters is required, the following 108 results were found.

  1. Zoho Projects: Get All Eventshttps://joellipman.com/articles/crm/zoho/zoho-projects/zoho-projects-get-all-events.html

    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; the key item to remember is that status is a mandatory field and it can either be "closed" or "open". If you have used...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Projects
    • Language: *
  2. Zoho CRM & Zoho Sign: Send CRM Merged Template for Zoho Signhttps://joellipman.com/articles/crm/zoho/zoho-crm/zoho-crm-zoho-sign-send-crm-merged-template-for-zoho-sign.html

    { v_RecipientEmail = r_Contact.get("Email"); v_RecipientFullName = r_Contact.get("Full_Name"); // _ m_Parameters = Map(); m_Data = Map(); m_Templates = Map(); m_Actions = Map(); m_FieldData = Map(); m_FieldTextData = Map(); m_FieldBooleanData = Map();...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
  3. Zoho People: Get Performance Records over APIhttps://joellipman.com/articles/crm/zoho/zoho-people/zoho-people-get-performance-records-over-api.html

    info v_Endpoint2; // r_AddRow = invokeUrl [ url: v_Endpoint2 type: POST parameters: m_Params headers: m_Header connection: "zanalytics" ]; info r_AddRow; } } // // used while debugging / remove once in production if(v_CountTotal >= 3) { break; } }...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho People
    • Language: *
  4. Zoho Survey & Zoho Analytics: Query to generate individual responses and grouped pageshttps://joellipman.com/articles/crm/zoho/zoho-analytics/zoho-survey-zoho-analytics-query-to-generate-individual-responses-and-grouped-pages.html

    m_Params.put("ZOHO_API_VERSION","1.0"); f_ChartExport = invokeurl [ url :v_Endpoint type :POST parameters:m_Params connection:"zanalytics" ]; */ // // -------------------------------------------------------------------- // using Analytics API v2.0 (this...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Analytics
    • Language: *
  5. SSRS Dropdown parameter cannot be blank!https://joellipman.com/component/content/article/ssrs-dropdown-to-allow-blank-values.html?catid=75&Itemid=165

    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 dropdown populated by a list of all available reports. Why? I want the report to be run with the 3rd...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: en-GB
  6. Error during processing - Converting Date/Timehttps://joellipman.com/articles/else/database/t-sql/error-during-processing-converting-datetime.html

    time from character string. Basically I had to look at a previous report and it was just the way I was inserting the parameters into my query. Once you've added your parameters (date/time type): Right-click on the DataSet. Select 'DataSet Properties....

    • Type: Article
    • Author: Joel Lipman
    • Category: Transact-SQL
    • Language: *
  7. MS-DOS: Copy folders without overwriting fileshttps://joellipman.com/component/content/article/ms-dos-copy-folders-without-overwriting-files.html?catid=51&Itemid=165

    No Job Header. /NJS :: No Job Summary. /UNICODE :: output status as UNICODE. :: :: Job Options : :: /JOB:jobname :: take parameters from the named JOB file. /SAVE:jobname :: SAVE parameters to the named job file /QUIT :: QUIT after processing command...

    • Type: Article
    • Author: Joel Lipman
    • Category: MS-DOS
    • Language: en-GB
  8. Joes Search Module (JSM)https://joellipman.com/component/content/article/joes-search-module-jsm.html?catid=53&Itemid=165

    as documentation for a Joomla extension I have released which is a copy of the built-in Joomla Search module but with the parameters embedded (set in the administration section). Why? A client has a repository of PDF documents that are uploaded to a...

    • Type: Article
    • Author: Joel Lipman
    • Category: Product Documentation
    • Language: *
  9. Zoho CRM/Creator - Common Errors & Gotchashttps://joellipman.com/articles/crm/zoho/zoho-crm/zoho-crm-creator-common-errors-gotchas.html

    r_Response = invokeurl [ url :v_DataEndpoint type :POST parameters:m_CreateRecord headers:m_Header ]; Solution: My endpoint was the same as a create/add record when it should be suffixed with the ID of the item to update: v_DataEndpoint =...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
  10. Zoho Projects: Add a Time Log to an Issue using Delugehttps://joellipman.com/articles/crm/zoho/zoho-projects/zoho-projects-add-a-time-log-to-an-issue-using-deluge.html

    r_CreateTimeLog = invokeurl [ url :v_Url type :POST parameters:m_CreateTimeLog connection:"joels_connector" ]; info r_CreateTimeLog; Example #2: Pushing a time log defaulting to the current time as start time: // // init (from dropdowns you have made...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Projects
    • Language: *
  11. Zoho CRM: searchRecords with sorted resultshttps://joellipman.com/articles/crm/zoho/zoho-crm/zoho-crm-searchrecords-with-sorted-results.html

    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: As of 2025, this method no longer works. Please refer to method 2 using a search API or a...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
  12. ZohoBooks: Stripe Terminal Integrationhttps://joellipman.com/articles/crm/zoho/zoho-books/zohobooks-stripe-terminal-integration.html

    } } r_CreatePaymentIntent = invokeurl [ url :v_PaymentIntentEndpoint type :POST parameters:m_Params headers:m_Headers ]; info "Payment Intent Create"; info r_CreatePaymentIntent; // v_CheckObject = ifnull(r_CreatePaymentIntent.get("object"),"-");...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Books
    • Language: *
  13. ZohoBooks: Error Code 15: Ensure Billing Address has less than 100 charactershttps://joellipman.com/articles/crm/zoho/zoho-books/zohobooks-code-15-ensure-billing-address-has-less-than-100-characters.html

    = List(); r_CrmProductLineItems = invokeurl [ url :"https://www.zohoapis.eu/crm/v2.1/Quotes/" + 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...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Books
    • Language: *
  14. ZohoCRM & ZohoWriter: Generate Rich-Text / HTML Email Signatures in CRMhttps://joellipman.com/articles/crm/zoho/zoho-crm/zohocrm-zohowriter-generate-rich-email-signatures-in-crm.html

    r_Permissions = invokeurl [ url :"https://www.zohoapis.eu/workdrive/api/v1/permissions" type :POST parameters:m_Params.toString() headers:m_Headers connection:"zworkdrive" ]; info "Workdrive Permissions:"; info r_Permissions; // // response returns...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
  15. Zoho Webhooks & Shopify API: Keep Disappearinghttps://joellipman.com/articles/else/e-commerce/shopify/zoho-webhooks-shopify-api-automatically-restore.html

    + "/admin/api/" + v_APIVersion + "/webhooks.json"; r_ShopifyOrderWebhook = invokeurl [ url :v_Endpoint type :POST parameters:m_Params.toString() headers:m_Header ]; } // // create inventory level update webhook if(b_RestoreInventoryLevelWebhook) {...

    • Type: Article
    • Author: Joel Lipman
    • Category: Shopify
    • Language: *
  16. Zoho Workdrive: Getting Team Folder IDhttps://joellipman.com/articles/crm/zoho/zoho-workdrive/zoho-workdrive-getting-team-folder-id.html

    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 Workdrive
    • Language: *
  17. Zoho CRM: Updating a CRM record Custom Line Items using API v7https://joellipman.com/articles/crm/zoho/zoho-crm/zoho-crm-updating-a-crm-record-using-api-v7.html

    = "https://www.zohoapis.com/crm/v7/Quotes/" + p_QuoteID; r_QuoteDetails = invokeurl [ url :v_Endpoint type :PUT parameters:m_Data.toString() connection:"zcrm" ]; info r_QuoteDetails; } Creating a record Pretty much the same as above but instead of the...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
  18. Zoho Deluge: Nested Catch Statementshttps://joellipman.com/articles/crm/zoho/zoho-deluge/zoho-deluge-nested-catch-statements.html

    invokeURL command rather than just an info output. try { r_GeneratePDF = invokeurl [ url: v_EndpointServer1 type: POST parameters: m_Html headers: m_Headers1 ]; } catch(e) { try { r_GeneratePDF = invokeurl [ url: v_EndpointServer2 type: POST parameters:...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Deluge
    • Language: *
  19. ZohoCRM & Xero: Function to pull most recent invoiceshttps://joellipman.com/articles/crm/zoho/zoho-crm/zohocrm-xero-function-to-pull-most-recent-invoices.html

    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 CRM
    • Language: *
  20. ZohoCRM & Xero: Function to pull most recent quoteshttps://joellipman.com/articles/crm/zoho/zoho-crm/zohocrm-xero-function-to-pull-most-recent-quotes.html

    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 CRM
    • Language: *
Results 21 - 40 of 108