Retrieve rows

Processes data requests and returns the result. Note that this operation uses a dynamic limit on the number of rows returned based on the number and type of columns; use the provided cursor to paginate and retrieve all data.

Securityoidc-token or oauth2-client-credentials or oauth2-open-industrial-data or oauth2-auth-code
Request
Request Body schema: application/json
required

Description of data requested.

One of:

A request for datapoints stored.

start
integer <int64>
Default: 0

Lowest row number included.

end
integer <int64>

Get rows up to, but excluding, this row number. Default - No limit.

limit
integer <int32> [ 1 .. 10000 ]
Default: 100

Maximum number of rows returned in one request. API might return less even if there's more data, but it will provide a cursor for continuation. If there's more data beyond this limit, a cursor will be returned to simplify further fetching of data.

cursor
string

Cursor for pagination returned from a previous request. Apart from this cursor, the rest of the request object is the same as for the original request.

columns
Array of strings [ 1 .. 400 ] items

Columns to include. Specified as a list of the externalId of each column to include. If this filter isn't set, all available columns will be returned.

id
required
integer <int64> (CogniteInternalId) [ 1 .. 9007199254740991 ]

A server-generated ID for the object.

Responses
200

Response with the sequence data found.

post/sequences/data/list
Request samples
application/json
{
  • "start": 0,
  • "end": 1,
  • "limit": 1,
  • "cursor": "string",
  • "columns": [
    • "string"
    ],
  • "id": 1
}
Response samples
application/json
{
  • "id": 1112,
  • "externalId": "DL/DRILL412/20190103/T3",
  • "columns": [
    • {
      },
    • {
      },
    • {
      }
    ],
  • "rows": [
    • {
      }
    ],
  • "nextCursor": "string"
}
➔ Next to Retrieve sequences