Zoho Inventory

Any instance where an entry in the below configuration has a leading $ represents a parameter that needs to be replaced with a static value.

Parameters in this document:

• $base_url - The Base URL will follow the below format:

  Data Center	Base URL
  United States	https://www.zohoapis.com
  Europe	https://www.zohoapis.eu
  India	https://www.zohoapis.in
  Australia	https://www.zohoapis.com.au
  Canada	https://www.zohoapis.ca

• $client_id and $client_secret - The Client ID and Client Secret will be used to authenticate calls to the Zoho Inventory API. To obtain these parameters, you will need to register an application with Zoho's Developer Console. When registering, be sure to include https://platform.panoply.io/sources/callback.html as an Authorized Redirect URI. After completing the registration of your client, you will receive a Client ID and Client Secret. For a complete walkthrough of the Zoho Inventory OAuth2.0 process, see Zoho documentation here.
• $organization_id - The Organization ID is a unique identifier for your Zoho Inventory organization. This value can be found by logging into your Zoho Inventory account and selecting the dropdown on your Account Name in the upper-righthand corner.
• $resource_name - The Resource Name represents the name of the resource to be appended and used as part of the Destination Table name. The value that should be used here can be found in the API Resources table below.
• $endpoint - The Endpoint represents the data that you would like to ingest into Panoply from the Zoho Inventory API. The value of this parameter can be found in the API Resources section below.
• $scope - The Scope represents the permission-level that is granted to a set of credentials, thus granting them access to different API endpoints. The value that should be used here can be found in the API Resources table below. If applying multiple scopes to a single Authentication process, each value will need to be comma-separated.
• $data_key - The Data Key represents the location of the data in the API response from Zoho Inventory. The value that should be used here can be found in the API Resources table below.
• $primary_key - Primary Keys are used to ensure the uniqueness of the rows in a table. The Primary Key is comprised of one or more columns that can be used to identify the row in the data warehouse. The process guarantees that no two rows have the same value in their primary key. The value that should be used here can be found in the API Resources table below.
• $auth_base_url - The Base URL will follow the below format:

  Data Center	Base URL
  United States	https://accounts.zoho.com
  Europe	https://accounts.zoho.eu
  India	https://accounts.zoho.in
  Australia	https://accounts.zoho.com.au
  Canada	https://accounts.zohocloud.ca

Destination Table naming convention is ultimately up to you as the data owner. One common structure used for this API is zoho_inventory_$resource_name.