SLslopesoftware
DataTables

Get a data table's data.

Either the data table ID must be provided, or the data table's name along with its associated table structure ID must be provided. <br/>If the data table is file only, then a file path to the file along with the file version will be returned so that it can be used with the GetDownloadUrl endpoint. <br/>For other data tables the rows are returned in the response up to the limit. The default limit is 2,000 and the max limit is 10,000. <br/>If the row limit is reached, then an offset is returned that can be used in a subsequent request to get the next set of rows. <br/>The response includes the TableStructureId of the table structure the data table is a part of, even when the requested data table is not the latest version.

get/api/v1/DataTables/Data

Request

Query parameters

DataTableIdinteger

Data Table ID

Namestring

Data Table Name

Versioninteger

Data Table Version

TableStructureIdinteger

Table Structure ID

Fieldsstring

Optional parameter to filter the top-level fields that are returned. The list must be in CSV format. Example: field1,field2,field3

Limitinteger

Optional parameter to limit the number of items returned. Default is 200.

Offsetinteger

Optional parameter to offset the items returned. Default is 0.

Response

OK

idinteger
namestring nullable
tableStructureIdinteger nullable
filePathstring nullable
fileVersioninteger nullable
offsetinteger nullable

Changes

No recorded changes to this operation across all 1 revision of this API.