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 connection is required, the following 113 results were found.

  1. Zoho Deluge: Duplicate/Clone a Recordhttps://www.joellipman.com/articles/crm/zoho/zoho-deluge/zoho-deluge-duplicate-clone-a-record.html

    = List(); r_Fields = invokeurl [ url :"https://www.zohoapis.eu/crm/v2/settings/fields?module=Invoices" type :GET connection:"myzohoconnector" ]; if(!isnull(r_Fields.get("fields"))) { for each r_Field in r_Fields.get("fields") {...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Deluge
    • Language: *
  2. Zoho CRM REST API: Stop Workflow from Triggeringhttps://www.joellipman.com/articles/crm/zoho/zoho-crm/zoho-crm-rest-api-stop-workflow-from-triggering.html

    + 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(); m_Data.put("data",l_Quotes);...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
  3. ZohoCRM to ZohoBooks: Please ensure that the shipping_address has less than 100 characters.https://www.joellipman.com/articles/crm/zoho/zoho-books/zohocrm-to-zohobooks-please-ensure-that-the-shipping_address-has-less-than-100-characters.html

    m_ShippingAddress.put("is_update_customer",false); // send the request via API (change connection name to your own) r_UpdateSO = invokeurl [ url: v_Endpoint type: PUT parameters: m_ShippingAddress.toString() connection: "joels_connector" ]; info...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Books
    • Language: *
  4. Zoho Cliq: Integrate OpenAI and ChatGPT 3.5 Turbohttps://www.joellipman.com/articles/crm/zoho/zoho-other/zoho-cliq-integrate-openai-and-chatgpt-3-5-turbo.html

    + "/messages?fromtime=" + v_FromTime + "&limit=50"; r_ChatDetails = invokeurl [ url: v_Endpoint type: GET connection: "ab_cliq" ]; // // let's build up the conversation thread if(!isnull(r_ChatDetails.get("data"))) { for each r_MessageData in...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Other
    • Language: *
  5. Zoho Books: Get Invoice Payment Terms via APIhttps://www.joellipman.com/articles/crm/zoho/zoho-books/zoho-books-get-invoice-payment-terms-via-api.html

    = invokeurl [ url :"https://www.zohoapis.com/books/v3/settings/paymentterms?organization_id=" + v_BooksOrgID type :GET connection:"zbooks" ]; info r_PaymentTerms; } Deprecated pre domain change: void fn_ReturnCurrentPaymentTerms() { v_BooksOrgID =...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Books
    • Language: *
  6. Zoho Books: Error 7008: There are no contact persons associated with this Invoicehttps://www.joellipman.com/articles/crm/zoho/zoho-books/zohobooks-error-7008-there-are-no-contact-persons-associated-with-this-invoice.html

    you how to use this API having a few email addresses as the recipients: A sample code snippet: For the below, I have a connection to ZohoBooks from ZohoCreator called "zbooks". It has fullaccess as a scope but I'm sure you can lock it down to just the...

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

    r_CreateRecord = zoho.creator.createRecord("myOwnerName","myAppName","myFormName",m_CreateRecord,m_Blank,"myCreatorConnection"); // // build the hash based on the payload body v_Data = ifnull(m_Payload.get("body"),""); v_VerifyHash =...

    • Type: Article
    • Author: Joel Lipman
    • Category: Shopify
    • Language: *
  8. ZohoAnalytics & ZohoBooks: Custom Related List from Analyticshttps://www.joellipman.com/articles/crm/zoho/zoho-books/zohoanalytics-zohobooks-custom-related-list-from-analytics.html

    "/data"; // // send request r_PurchaseOrders = invokeurl [ url :v_Endpoint type :GET parameters:m_Config headers:m_Header connection:"my_analytics_connection" ]; // // parse response l_DataRows = ifnull(r_PurchaseOrders.get("data"),List()); // // build...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Books
    • Language: *
  9. Zoho CRM: Remove Duplicate Product Recordshttps://www.joellipman.com/articles/crm/zoho/zoho-crm/zoho-crm-remove-duplicate-product-records.html

    r_CoqlUniqueProducts = invokeurl [ url :"https://www.zohoapis.eu/crm/v7/coql" type :POST parameters:m_Params.toString() connection:"zcrm" ]; l_UniqueProducts = ifnull(r_CoqlUniqueProducts.get("data"),List()); for each m_Product in l_UniqueProducts {...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
  10. Zoho Deluge: Connect to Shopifyhttps://www.joellipman.com/articles/crm/zoho/zoho-deluge/zoho-deluge-connect-to-shopify.html

    // app specific (retrieving from a ZohoCreator record that stores all these credentials) r_ShopifyAPI = API_Integration[Connection_Name == "Shopify API"]; // // client id from the shopify admin and registering a custom app // eg....

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Deluge
    • Language: *
  11. SSIS Skip Rows in Excel Source filehttps://www.joellipman.com/component/content/article/ssis-skip-rows-in-excel-source-file.html?catid=74&Itemid=165

    file when using as the DataSource. Why? If you are simply using a text file as your data source, then the options in the connection manager will let you skip rows and specify column datatypes. You don't get that with Excel but you can still control the...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Integration Services
    • Language: en-GB
  12. Run commands for Windowshttps://www.joellipman.com/component/content/article/run-commands-for-windows.html?catid=80&Itemid=165

    mshearts Help and Support helpctr HyperTerminal hypertrm Iexpress Wizard iexpress Indexing Service ciadv.msc Internet Connection Wizard icwconn1 Internet Explorer iexplore Internet Properties inetcpl.cpl Internet Setup Wizard inetwiz IP Configuration...

    • Type: Article
    • Author: Joel Lipman
    • Category: Windows OS
    • Language: en-GB
  13. Export/Import Database using MySQL Workbenchhttps://www.joellipman.com/articles/else/database/mysql/export-import-database-using-mysql-workbench.html

    How? So this is the HOME tab when you open MySQL Workbench. We're going to go on the basis that you already setup a connection to your database under the SQL Development section. Export/Import happens under the Server Administration section: Let's...

    • Type: Article
    • Author: Joel Lipman
    • Category: MySQL
    • Language: en-GB
  14. Foreign Characters create symbols in PHP and MySQLhttps://www.joellipman.com/articles/cms/website-development/php/foreign-characters-create-symbols-in-php-and-mysql.html

    true), ENT_COMPAT, 'UTF-8'); My other fix (for Croatian characters and Western languages): // insert after database connection and prior to database query (where $db_conn is your mysqli connection) mysqli_set_charset($db_conn,"utf8"); // decode and...

    • Type: Article
    • Author: Joel Lipman
    • Category: Personal Home Page
    • Language: en-GB
  15. SSRS Subscriptions cannot be createdhttps://www.joellipman.com/component/content/article/ssrs-subscriptions-cannot-be-created.html?catid=75&Itemid=165

    section). The report being subscribed to is hidden in tile view. Cases where this would NOT work Reports where the connection string to the data source is held in the parameters (though, with more time, we could have tried changing the "connection...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: en-GB
  16. PC Build 2022: 5 Monitors connected to 1 PC using 1 GPUhttps://www.joellipman.com/component/content/article/pc-build-2022-5-monitors-connected-to-1-pc-using-1-gpu.html?catid=45&Itemid=165

    Total: £2,059.65 Not Used Case Fans 2 fans from the 3rd pack of the CoolMoon 120mm Crystal - - The Result: Monitor cable connections I need to practice what I preach: "it's a poor workman who blames his tools". Let's make do with what we have. The 2...

    • Type: Article
    • Author: Joel Lipman
    • Category: Articles
    • Language: *
  17. Disclaimerhttps://www.joellipman.com/component/content/article/disclaimer.html?catid=50&Itemid=165

    consequential loss or damage, or any loss or damage whatsoever arising from loss of data or profits arising out of, or in connection with, the use of this website. Through this website you are able to link to other websites which are not under the...

    • Type: Article
    • Author: Joel Lipman
    • Category: Static Items
    • Language: *
  18. Zoho Deluge - Get Refresh/Access Token API v2https://www.joellipman.com/articles/crm/zoho/zoho-deluge/zoho-deluge-get-refresh-access-token.html

    Re-create the connectors with the latter: r_RecordUpdate = invokeUrl [ url :v_EndPoint type :PUT parameters:m_Data connection: myconnector ]; {"code":4,"message":"Invalid value passed for JSONString"}: Can happen when posting to ZohoBooks and you...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Deluge
    • Language: en-GB
  19. Zoho People: Reject an Application for Leave in Deluge based on Criteriahttps://www.joellipman.com/articles/crm/zoho/zoho-people/zoho-people-reject-an-application-for-leave-in-deluge.html

    of staff who already booked the requested dates as leave. [Warning: red herring ahead] For this process, we setup connections choosing to make use of the Zoho People API and we could update any of the fields EXCEPT for "ApprovalStatus" and would get the...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho People
    • Language: *
  20. Zoho CRM & Zoho Books: Custom Related Lists Delugehttps://www.joellipman.com/articles/crm/zoho/zoho-books/zoho-crm-zoho-books-custom-related-lists-deluge.html

    r_SearchResults = zoho.creator.getRecords(v_OwnerName,v_AppLinkName,v_ViewLinkName,v_Condition,1,100,"joels_connection"); v_ResponseCode = ifnull(r_SearchResults.get("code"),500).toLong(); // // if found records if(v_ResponseCode == 3000) {...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Books
    • Language: *
Results 61 - 80 of 113