API Data Provider - Online Help

Base Tables

The provider models the data in API into a list of tables that can be queried using standard SQL statements.

Generally, querying API tables is the same as querying a table in a relational database. Sometimes there are special cases, for example, including a certain column in the WHERE clause might be required to get data for certain columns in the table. This is typically needed for situations where a separate request must be made for each row to get certain columns. These types of situations are clearly documented at the top of the table page linked below.

Base Tables

Name Description
Categories Generated schema file.
DeliveryCompanies Generated schema file.
ItemCategories Generated schema file.
ItemDetails Generated schema file.
ItemOptions Generated schema file.
Items Generated schema file.
ItemVariations Generated schema file.
OrderDetails Generated schema file.
OrderItemOptions Generated schema file.
OrderItems Generated schema file.
Orders Generated schema file.
OrderUserBalanceLogs Generated schema file.
Savings Generated schema file.

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8487.0