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

  1. 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

    parameters: m_GraphQl.toString() headers:m_Header ]; return r_GetProduct.toMap(); } Job done! Yields something like: { "data": { "productVariants": { "edges": [ { "node": { "id": "gid://shopify/ProductVariant/123456789012345", "price": "450.95", "sku":...

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

    on the tin Category: Standalone Click on Create Give it the parameter/argument p_InventoryitemID as an Integer/Long/Number datatype As the first part of your code, enter the following as code (you'll need to speify your own App Owner and App Name): //...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  3. Zoho Analytics & Zoho People: Monitor DataSource Sync https://joellipman.com/articles/crm/zoho/zoho-analytics-zoho-people-monitor-datasource-sync.html

    A quick article on how to setup an automation that checks if a datasource synchronization between Zoho People and Zoho Analytics failed. This can be adapted to any data source for Zoho Analytics. Why? We're assisting a client implement Zoho People as...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  4. SSRS Subscriptions cannot be createdhttps://joellipman.com/articles/microsoft/ssrs/ssrs-subscriptions-cannot-be-created.html

    please refer to my article on SSRS External Images don't display. The answer to this error is your report needs to use a datasource with the credentials stored, here are the details to our report As developers, we connect to the datasource directly...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: en-GB
  5. Anti-Spam override for all submitted datahttps://joellipman.com/articles/cms/joomla/anti-spam-override-for-all-submitted-data.html

    Are you getting a lot of spam, or junk messages sent via your Joomla site? I know certain components of Joomla let you put banned words but I know of even more that don't. If you find all your forms need extra plugins and captchas (such as...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: *
  6. Zoho CRM & Zoho Creator: Query returns some fields missing other data on the recordhttps://joellipman.com/articles/crm/zoho/zoho-crm-zoho-creator-query-returns-some-fields-missing-other-data-on-the-record.html

    What? A super quick article to demonstrate how an idiot like myself can misread the documentation. This particular article shows you how to customize the search results or response from using zoho.creator.getRecordById(). Why? My use case scenario is...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  7. Create Read-Only Database User in SQL Serverhttps://joellipman.com/articles/database/create-read-only-database-user-in-sql-server.html

    following describes how to setup a database user with read-only access to the AdventureWorks database. Using SQL Server Management Studio 2008: Connect to your database server. Expand Security > Logins. Right-click on the user who will be set as having...

    • Type: Article
    • Author: Joel Lipman
    • Category: Databases
    • Language: *
  8. No rows returned in Oracle causes SP to failhttps://joellipman.com/articles/database/pl-sql/no-rows-returned-in-oracle-causes-sp-to-fail.html

    query will retrieve a student ID number where the input parameter is the student's username. The second query will return data using the student ID number found in the first query. The stored procedure compiles successfully and without any warnings. So...

    • Type: Article
    • Author: Joel Lipman
    • Category: Oracle PL/SQL
    • Language: en-GB
  9. Zoho Deluge: Zoho Bookings Get Available Slotshttps://joellipman.com/articles/crm/zoho/zoho-deluge-zoho-bookings-get-available-slots.html

    to documentation = zoho.bookings.getAvailableSlots(, , , ); Set up your connector with the following scope: zohobookings.data.CREATE Get the workspaces: // // get workspaces r_WorkspaceResults = zoho.bookings.getWorkspaces("joels_connector");...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  10. Zoho CRM: Schedule a Call using Delugehttps://joellipman.com/articles/crm/zoho/zoho-crm-schedule-a-call-with-deluge.html

    r_ScheduleCall = zoho.crm.createRecord("Calls", m_ScheduleCall); info r_ScheduleCall; Error(s) Encountered: {"code":"INVALID_DATA","details":{"expected_data_type":"datetime","api_name":"Call_Start_Time"},"message":"invalid data","status":"error"}...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  11. Zoho Books: System Values Mapshttps://joellipman.com/articles/crm/zoho/zoho-books-system-values-maps.html

    domain name change from https://books.zoho.com to https://www.zohoapis.com/books and changed the Top Level Domain (or Zoho DataCenter) from EU to COM as I was using this for a client on the US datacenter. I have a connection called "zbooks" and the...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  12. Privacy Policyhttps://joellipman.com/static-items/privacy-policy.html

    information about your preferences. We use traffic log cookies to identify which pages are being used. This helps us analyse data about webpage traffic and improve our website in order to tailor it to customer needs. We only use this information for...

    • Type: Article
    • Author: Joel Lipman
    • Category: Static Items
    • Language: en-GB
  13. Creating a Top 10 chart with less codehttps://joellipman.com/articles/web-development/php/creating-a-top-10-chart-with-less-code.html

    is when using a MySQL query within a PHP script. The process is used often to do a statistics table or top ten chart of your data (eg. movies, music, etc). My aim is to do the following: retrieve data from a table, count the number of times each data...

    • Type: Article
    • Author: Joel Lipman
    • Category: Personal Home Page
    • Language: *
  14. Report Builder 2.0 - Hide Series1https://joellipman.com/articles/microsoft/ssrs/report-builder-20-hide-series1.html

    a "solution" to my situation and environment. Our setup is: SQL Server 2008 Report Builder 2.0 BMC Service Desk Express 9.8 DataSet1: Incident # Group Name Close Date & Time Assigned to Full Name Incident Type The objective of this article is to explain...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: en-GB
  15. Joe's CSV Chart Generator (JCG)https://joellipman.com/component/content/article/joellipmans-csv-chart-generator.html?catid=40

    that can take an exported CSV list from a standard MS Windows eventlog or eventviewer log and generate a chart from the data. What my program does is convert all the data into a settings and data file that can be used by the charting system...

    • Type: Article
    • Author: Joel Lipman
    • Category: Product Documentation
    • Language: *
  16. A quick run through of setting up an export process in SITShttps://joellipman.com/articles/web-development/xml/a-quick-run-through-of-setting-up-an-export-process-in-sits.html

    2012 (SP1) - 11.0.3128.0 What? "Quick" may not be the right word, so this is a somewhat summarized article on how to get data out of SITS, up to running the monitors and populating an OUTPUT table in the SITS database. Note that this does not include...

    • Type: Article
    • Author: Joel Lipman
    • Category: Extensible Markup Language
    • Language: *
  17. MS Excel - Split Workbook into separate files per sheethttps://joellipman.com/articles/microsoft/excel/ms-excel-split-workbook-into-separate-files-per-sheet.html

    (ensure editing is enabled) hold down ALT and press F11 (Alt+F11) Go to Insert > Module and paste the below code Sub SplitData() Dim WorkRng As Range Dim xRow As Range Dim SplitRow As Integer Dim xWs As Worksheet On Error Resume Next xTitleId =...

    • Type: Article
    • Author: Joel Lipman
    • Category: Excel
    • Language: en-GB
  18. Zoho CRM/Creator - Common Errors & Gotchashttps://joellipman.com/articles/crm/zoho/zoho-crm-creator-common-errors-gotchas.html

    already exists."}. Documentation advises that the payload is empty which is not true in my case. This is my invokeUrl: v_DataEndpoint = "https://inventory.zoho.com/api/v1/items?organization_id=123456789"; r_Response = invokeurl [ url :v_DataEndpoint...

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

    and will need to be adapted for your needs. Note that I have used 2 URL methods of linking to the Creator app and some data formatting that I tend to use regularly for my benefit later on when I simply copy & paste the below code templates. Zoho CRM //...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  20. Zoho CRM & Zoho Inventory: Upload Image to Item Record using Delugehttps://joellipman.com/articles/crm/zoho/zoho-crm-zoho-inventory-upload-image-to-item-record.html

    and uploaded to the Zoho Inventory record for the respective record. As Zoho Books and Zoho Subscriptions uses the same database tables as Zoho Inventory, and there's more documentation on the API for Zoho Books, we're going to apply this solution to...

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

Please publish modules in offcanvas position.