Retrieve rows from a table

Securityoidc-token or oauth2-client-credentials or oauth2-open-industrial-data or oauth2-auth-code
Request
path Parameters
dbName
required
string

Name of the database.

tableName
required
string

Name of the table.

query Parameters
limit
integer <int32> [ 1 .. 10000 ]
Default: 25

Limit the number of results. The API may return fewer than the specified limit.

columns
string

Ordered list of column keys, separated by commas. Leave empty for all, use single comma to retrieve only row keys.

Example: columns=column1,column2
cursor
string

Cursor for paging through results.

Example: cursor=4zj0Vy2fo0NtNMb229mI9r1V3YG5NBL752kQz1cKtwo
minLastUpdatedTime
integer <int64> (EpochTimestamp) >= 0

An exclusive filter, specified as the number of milliseconds that have elapsed since 00:00:00 Thursday, 1 January 1970, Coordinated Universal Time (UTC), minus leap seconds.

Example: minLastUpdatedTime=1730204346000
maxLastUpdatedTime
integer <int64> (EpochTimestamp) >= 0

An inclusive filter, specified as the number of milliseconds that have elapsed since 00:00:00 Thursday, 1 January 1970, Coordinated Universal Time (UTC), minus leap seconds.

Example: maxLastUpdatedTime=1730204346000
Responses
200

Rows returned

get/raw/dbs/{dbName}/tables/{tableName}/rows
Request samples 
await client.raw.listRows('My company', 'Employees', { columns: ['last_name'] });
Response samples
{
  • "items": [
    • {
      }
    ],
  • "nextCursor": "string"
}
➔ Next to Extraction Pipelines