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

  1. ZohoCRM: Using Criteria with Module Record Counthttps://www.joellipman.com/articles/crm/zoho/zohocrm-using-criteria-with-module-record-count.html

    or ZohoCRM.settings.ALL as well; I've called it "zcrm". Standard Call for Module Record Count: v_PerPage = 200; v_Endpoint = "https://www.zohoapis.com/crm/v5/Quotes/actions/count"; r_MaximumCount = invokeurl [ url :v_Endpoint type :GET connection:"zcrm"...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  2. ZohoCRM GetRelatedRecords INVALID_DATAhttps://www.joellipman.com/articles/crm/zoho/zohocrm-getrelatedrecords-invalid_data.html

    */ // // initialize v_CountTotal = 0; v_CountUpdated = 0; l_Pages = {1}; v_PerPage = 1; // for each v_Page in l_Pages { l_Deals = zoho.crm.getRecords("Deals", v_Page, v_PerPage, {"cvid":123456000012345678}); for each m_Deal in l_Deals {...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  3. Zoho Deluge and Wordpress/WooCommerce API: Get All Productshttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-and-wordpress-woocommerce-api-get-all-products.html

    initialize l_AllProducts = List(); v_TotalCategories = 0; v_TotalProducts = 0; v_Page = 1; // do not set this to zero!!! v_PerPage = 100; // // API keys v_MyWordPressSiteUrl = "https://mysite.com"; v_ConsumerKey =...

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

    */ // v_CountUnique = 0; v_CountTotal = 0; v_CountDeleted = 0; // // pagination v_PerPage = 500; // // loop through pages to fetch as many as possible for each v_Page in {1,2} { info "Page #" + v_Page; v_PageFactor = v_Page - 1; v_Offset = v_PageFactor...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  5. Zoho Creator / eBay: Get all Active Productshttps://www.joellipman.com/articles/crm/zoho/zoho-creator-ebay-get-all-active-products.html

    doesn't get overwhelmed with the amount of data in the response: map API.fn_eBayQuery_GetActiveProducts(int p_Page, int p_PerPage) { /* Function: fn_eBayQuery_GetActiveProducts() Purpose: Fetches current listings / active products Date Created:...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  6. ZohoRecruit: Create Linking Table for Candidates and Associated Job Openingshttps://www.joellipman.com/articles/crm/zoho/zohorecruit-create-linking-table-for-candidates-and-associated-job-openings.html

    */ // // list of pages to loop through (note: issues with multiple pages, do 1 at a time) l_Pages = {1}; v_PerPage = 200; for each v_Page in l_Pages { v_CountTotal = 0; v_CountProcessed = 0; v_FromIndex = (v_Page - 1) * v_PerPage; v_ToIndex =...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  7. Zoho Deluge: Shopify API: Get all active products with GraphQL and Paginationhttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-shopify-api-get-all-active-products-with-graphql-and-pagination.html

    and to email it to myself: void API.fn_ShopifyQuery_UpdateAllProducts() { // init v_CountTotal = 0; v_CountUpdated = 0; v_PerPage = 10; b_HasNextPage = true; v_Cursor = ""; l_CsvFileRows = List(); // // start preparing CSV file to email for debugging...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  8. ZohoCRM: Get All eBay Active Listingshttps://www.joellipman.com/articles/crm/zoho/zohocrm-get-all-ebay-active-listings.html

    https://developer.ebay.com/devzone/xml/docs/reference/ebay/getmyebayselling.html */ // // declare v_Page = 1; v_PerPage = 100; l_Pages = List(); // // specify page to start from v_StartingPageIndex = 1; // // specify the maximum number of products you...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  9. Zoho Deluge: Get All Orders from eBayhttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-get-all-orders-from-ebay.html

    Number: https://developer.ebay.com/devzone/xml/docs/Reference/ebay/Errors/errormessages.htm */ // // declare v_Page = 1; v_PerPage = 100; l_Pages = List(); // // specify the maximum number of orders you think you have on eBay (check eBay homepage and...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  10. Zoho Deluge: Search Records with Special Characters (COQL)https://www.joellipman.com/articles/crm/zoho/zoho-deluge-search-records-with-special-characters-coql.html

    400"; // returns 2 deals after the first 400 records // OR v_PageOffset = v_Page - 1; v_PageOffset = v_PageOffset * v_PerPage; v_CoqlQuery = "select id, Deal_Name from Deals where ((Amount=0) and (Stage != 'Cancelled')) limit " + v_PerPage + " offset "...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  11. ZohoCRM: Process all records of a modulehttps://www.joellipman.com/articles/crm/zoho/zohocrm-process-all-records-of-a-module.html

    usually completes all 1000 every 5-10 minutes: // init v_CountFound = 0; v_CountUpdated = 0; l_Pages = {1,2,3,4,5}; v_PerPage = 200; for each v_Page in l_Pages { m_SortCriteria = Map(); m_SortCriteria.put("sort_order","asc");...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  12. Zoho Creator: eBay: Get Item Transactionhttps://www.joellipman.com/articles/crm/zoho/zoho-creator-ebay-get-item-transaction.html

    */ v_Found = 0; v_Updated = 0; v_Page = 1; v_PerPage = 10; m_Output = Map(); r_Api = API_Integration[Connection_Name == "eBay API (Production)"]; if(r_Api.count() > 0) { v_AccessToken = thisapp.API.fn_eBayConnect_AccessToken(); v_TradingAPIVersion =...

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

    } } Method #2: using COQL // ****************** CODE USING GETRECORDS **************** // init l_Pages = {1,2,3,4,5}; v_PerPage = 200; // // get other products with the same name (set in order of oldest first and keep only first one, delete the others)...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  14. Zoho Deluge: Using Remove Key on a Map and Copying Record Tagshttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-using-remove-key-on-a-map.html

    there is an existing tag with the same name), then it only copies over the name: v_TotalCount = 0; v_TotalProcessed = 0; v_PerPage = 100; v_CoqlQuery = "select id, Contact_Name.Tag 'Tag' from Deals where Tag is null and Contact_Name.Tag is not null...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  15. ZohoCRM Webhook: Create ZohoInventory Records from an eBay orderhttps://www.joellipman.com/articles/crm/zoho/zohocrm-webhook-create-zohoinventory-records-from-an-ebay-order.html

    = zoho.currentdate.toString("yyyy-MM-dd"); v_OrderDate = zoho.currentdate.toString("yyyy-MM-dd"); v_Page = 1; v_PerPage = 10; m_Output = Map(); l_Costs = {11,13,15,17,20}; b_DebugMode = true; l_DebugMessages = List(); l_DebugMessages.add("eBay Order ID:...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
Results 1 - 15 of 15

Please publish modules in offcanvas position.