API Data Provider - Online Help

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

InfoMart Tables

Name Description
BuyerInvoiceData Generated schema file.
BuyerInvoiceDataBanks Generated schema file.
BuyerInvoiceDataDetails Generated schema file.
BuyerJournalMasterAcc Generated schema file.
BuyerJournalMasterBurdenSectors Generated schema file.
BuyerJournalMasterJnlSpcrs Generated schema file.
OAuthProcess.rsd This service does not define any meta-information (see the keyword rsb:info in RSBScript guide). Please encourage the administrator of this service to describe the API of this service. Simple meta-information not only clarifies the usage but also facilitates calling the service using software tools.
SellerInvoiceBanks Generated schema file.
SellerInvoiceDetails Generated schema file.
SellerInvoices Generated schema file.

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