Retrieve last row

Retrieves the last row in one or more sequences. Note that the last row in a sequence is the one with the highest row number, which is not necessarily the one that was ingested most recently.

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 the last row.

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.

before
integer <int64> >= 1

Get rows up to, but not including, this row number.

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/latest
Request samples
application/json
{
  • "columns": [
    • "string"
    ],
  • "before": 1,
  • "id": 1
}
Response samples
application/json
{
  • "id": 1112,
  • "externalId": "DL/DRILL412/20190103/T3",
  • "columns": [
    • {
      },
    • {
      },
    • {
      }
    ],
  • "rows": [
    • {
      }
    ]
}
➔ Next to Retrieve rows