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

  1. ZohoFlow & ZohoSign: Retrieve a Zoho Sign document request and add attachments to CRM recordhttps://joellipman.com/articles/crm/zoho/zohoflow-zohosign-retrieve-a-zoho-sign-document-request-and-add-attachments-to-crm-record.html

    describing a custom function built into Zoho Flow that will accept as parameter the document_id and request_id. It then retrieves the Deal Reference (entered by an office signee) on the ZohoSign document and searches for the relevant Deal record in CRM....

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  2. FTP on Mac: Failed to retrieve directory listinghttps://joellipman.com/articles/web-development/ftp/ftp-on-mac-failed-to-retrieve-directory-listing.html

    FTP directory listing as it was working on my Windows PC but not on my Mac. The error I was getting was Error: Failed to retrieve directory listing though I could access the folders if I browsed the existing folders by entering it in the remote...

    • Type: Article
    • Author: Joel Lipman
    • Category: File Transfer Protocol
    • Language: *
  3. JDatabase: using the Joomla database with exampleshttps://joellipman.com/articles/cms/joomla/jdatabase-using-the-joomla-database.html

    results as a list of stdClass objects (see later for more options on retrieving data). $rows = $db->loadObjectList(); // Retrieve each value in the ObjectList foreach( $rows as $row ) { $this_user_id = $row->user_id; $this_user_name = $row->username;...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: en-GB
  4. ZohoCRM: ZDK Client Script to retrieve Contact Emailhttps://joellipman.com/articles/crm/zoho/zohocrm-zdk-client-script-to-retrieve-contact-email.html

    An article on one of my first client scripts for ZohoCRM. This retrieves and populates an email field based on when a contact is selected in a lookup field. Why? I could do a normal automation/workflow on save of the record, but the client wants the...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  5. VBScript to retrieve Windows Product Keyhttps://joellipman.com/articles/microsoft/windows-os/vbscript-to-retrieve-windows-product-key.html

    A quick article with the code to retrieve your product key in Windows 7 with a small VB script file. There are other articles on the web about this but the ones I found returned errors such as WshShell not valid. This article has a working example...

    • Type: Article
    • Author: Joel Lipman
    • Category: Windows OS
    • Language: en-GB
  6. Zoho Creator: Retrieve record with case-insensitive queryhttps://joellipman.com/articles/crm/zoho/zoho-creator-retrieve-record-with-case-insensitive.html

    What? Thought I'd put an article here to remind me how to make the retrieval of a record case-insensitive. Why? Consider that I have the following creator table: Product_Name Product_SKU -------------- ------------- MyProduct1 TEST01 Myproduct2 TEST02...

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

    An article to resolve my frustration in being able to ONLY retrieve the first 100 products using GraphQL, so page 1 of Shopify products. Why? Our use-case is that we retrieve the 100 most recently modified products at the end of each day and run some...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  8. Zoho Creator: Download uploaded file and attach to Sales Order in Zoho Bookshttps://joellipman.com/articles/crm/zoho/zoho-creator-download-uploaded-file-and-attach-to-sales-order-in-zoho-books.html

    { if(!isnull(r_SoBooks.get("salesorder_number"))) { v_CrmSoRef = r_SoBooks.get("salesorder_number").toString(); } } // // retrieve crm id if(v_CrmSoRef != "") { r_SearchResults = zoho.crm.searchRecords(v_CrmSoModule,"(Name:equals:" + v_CrmSoRef + ")");...

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

    This is an article to document a function used in Zoho Creator to retrieve the Product IDs of all the active products in a client's Shopify. Why? The use-case was that I wanted to search Shopify using a Product SKU. Community forums could only suggest...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  10. Zoho Creator: Shopify API Integration Oauth 2.0 - Update 2022 (Search by SKU GraphQL)https://joellipman.com/articles/crm/zoho/zoho-creator-shopify-api-integration-oauth-2-0-update-2022.html

    by our ability to search by product SKU. The new version, taking advantage of GraphQL, will be able to search by SKU and retrieve the correct product ID, variant ID, and inventory ID from Shopify. How? The below details on how we set up an access token...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  11. Zoho Inventory & eBay Picture Services: UploadSiteHostedPictureshttps://joellipman.com/articles/crm/zoho/zoho-inventory-ebay-picture-services-uploadsitehostedpictures.html

    Get Zoho Creator to generate a published / public URL of the file Get Zoho CRM to scan Creator for the public URL and retrieve this Get Zoho CRM to generate an XML request to upload the photo to eBay's Hosted Picture Services Get Zoho CRM to parse the...

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

    parameters:m_Params.toString() headers:m_Header detailed:true ]; if(r_ChatGPTResponse.get("responseCode") == 200) { // // retrieve the answer in text l_Choices = r_ChatGPTResponse.get("responseText").get("choices"); for each m_Choice in l_Choices {...

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

    include the code to count the total number of products, and then finallly show the code to loop through all the pages to retrieve every product from the WooCommerce system. API connection in WooCommerce So we need to get an API connection to ensure we...

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

    = ifnull(m_Payload.get("body"),""); v_VerifyHash = zoho.encryption.hmacsha256(v_ClientSecret,v_Data,"base64"); // // retrieve Shopify's Hmac SHA256 from the header v_ShopifyHash = ""; if(m_Payload.get("headers") != null) {...

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

    will advise you to get the ID of the Shipping Address... But let's say I don't know how to create a shipping address and retrieve its ID then here's the method I use: Create the sales order in ZohoBooks (either in Zoho Deluge or however you're doing...

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

    This is an article to document a function used in Zoho Creator to retrieve the Product IDs of all the active products in a client's eBay store. Why? The use-case was that I wanted to retrieve a list of all the listed active products in a fixed price...

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

    duplicates by updating record with existing name if exists v_Name = v_CandidateZohoID + "" + r_Data.get("id"); // // retrieve client's own candidate ref from candidate record r_CandidateDetails =...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  18. ZohoCRM: Integrate ChatGPT to ZohoZIAhttps://joellipman.com/articles/crm/zoho/zohocrm-integrate-chatgpt-to-zohozia.html

    parameters:m_Params.toString() headers:m_Header detailed:true ]; if(r_ChatGPTResponse.get("responseCode") == 200) { // // retrieve the answer in text l_Choices = r_ChatGPTResponse.get("responseText").get("choices"); for each m_Choice in l_Choices {...

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

    = m_Action.get("process_payment_intent"); v_PaymentIntentID = m_ProcessPaymentIntent.get("payment_intent"); // // Retrieve details on the Payment Intent v_PaymentIntentEndpoint = "https://api.stripe.com/v1/payment_intents/" + v_PaymentIntentID;...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  20. ZohoDeluge: Check Shipment Status via DHL APIhttps://joellipman.com/articles/crm/zoho/zohodeluge-check-shipment-status-via-dhl-api.html

    = zoho.currentdate.subDay(v_Index).toString("yyyy-MM-dd"); info v_Date; // // set criteria of what shipment orders to retrieve m_Criteria = Map(); m_Criteria.put("date",v_Date); // // retrieve all shipment orders for that day from ZohoInventory...

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

Please publish modules in offcanvas position.