Skip to main content
POST
/
sequences
/
data
JavaScript SDK
const rows = [
 { rowNumber: 0, values: [1, 2.2, 'three'] },
 { rowNumber: 1, values: [4, 5, 'six'] }
];
await client.sequences.insertRows([{ id: 123, rows, columns: ['one', 'two', 'three'] }]);
from cognite.client.data_classes import Sequence, SequenceColumn
seq = client.sequences.create(Sequence(columns=[SequenceColumn(value_type="String", external_id="col_a"),
    SequenceColumn(value_type="Double", external_id ="col_b")]))
data = [(1, ['pi',3.14]), (2, ['e',2.72]) ]
client.sequences.data.insert(columns=["col_a","col_b"], rows=data, id=1)

data = [{"rowNumber": 123, "values": ['str',3]}, {"rowNumber": 456, "values": ["bar",42]} ]
client.sequences.data.insert(data, id=1, columns=["col_a","col_b"]) # implicit columns are retrieved from metadata

data = {123 : ['str',3], 456 : ['bar',42] }
client.sequences.data.insert(columns=['stringColumn','intColumn'], rows=data, id=1)

data = client.sequences.data.retrieve(id=2,start=0,end=10)
client.sequences.data.insert(rows=data, id=1,columns=None)
import pandas as pd
df = pd.DataFrame({'col_a': [1, 2, 3], 'col_b': [4, 5, 6]}, index=[1, 2, 3])
client.sequences.data.insert_dataframe(df, id=123)
from cognite.client.data_classes import Sequence, SequenceColumn
seq = client.sequences.create(Sequence(columns=[SequenceColumn(value_type="String", external_id="col_a"),
    SequenceColumn(value_type="Double", external_id ="col_b")]))
data = [(1, ['pi',3.14]), (2, ['e',2.72]) ]
client.sequences.data.insert(columns=["col_a","col_b"], rows=data, id=1)

data = [{"rowNumber": 123, "values": ['str',3]}, {"rowNumber": 456, "values": ["bar",42]} ]
client.sequences.data.insert(data, id=1, columns=["col_a","col_b"]) # implicit columns are retrieved from metadata

data = {123 : ['str',3], 456 : ['bar',42] }
client.sequences.data.insert(columns=['stringColumn','intColumn'], rows=data, id=1)

data = client.sequences.data.retrieve(id=2,start=0,end=10)
client.sequences.data.insert(rows=data, id=1,columns=None)
import pandas as pd
df = pd.DataFrame({'col_a': [1, 2, 3], 'col_b': [4, 5, 6]}, index=[1, 2, 3])
client.sequences.data.insert_dataframe(df, id=123)
List<SequenceMetadata> upsertSequencesList = DataGenerator.generateSequenceMetadata(); 
client.sequences().upsert(upsertSequencesList); 

 SequenceBody body = SequenceBody.newBuilder() 
 .setExternalId(upsertSequencesList.get(1).getExternalId()) 
 .addAllColumns(List.of(SequenceColumn.newBuilder().setExternalId("10").build())) 
 .addAllRows(List.of(SequenceRow.newBuilder().setRowNumber(1).addAllValues(List.of(Value.newBuilder().setNumberValue(10).build())).build())) 
 .build(); 
 List<SequenceBody> upsertSequenceBodyResponse = client.sequences().rows().upsert(List.of(body)); 

curl --request POST \
  --url https://{cluster}.cognitedata.com/api/v1/projects/{project}/sequences/data \
  --header 'Authorization: Bearer <token>' \
  --header 'Content-Type: application/json' \
  --data '
{
  "items": [
    {
      "externalId": "DL/DRILL412/20190103/T3",
      "columns": [
        "Depth",
        "DepthSource",
        "PowerSetting"
      ],
      "rows": [
        {
          "rowNumber": 1,
          "values": [
            23331.3,
            "s2",
            61
          ]
        }
      ]
    }
  ]
}
'
<?php

$curl = curl_init();

curl_setopt_array($curl, [
  CURLOPT_URL => "https://{cluster}.cognitedata.com/api/v1/projects/{project}/sequences/data",
  CURLOPT_RETURNTRANSFER => true,
  CURLOPT_ENCODING => "",
  CURLOPT_MAXREDIRS => 10,
  CURLOPT_TIMEOUT => 30,
  CURLOPT_HTTP_VERSION => CURL_HTTP_VERSION_1_1,
  CURLOPT_CUSTOMREQUEST => "POST",
  CURLOPT_POSTFIELDS => json_encode([
    'items' => [
        [
                'externalId' => 'DL/DRILL412/20190103/T3',
                'columns' => [
                                'Depth',
                                'DepthSource',
                                'PowerSetting'
                ],
                'rows' => [
                                [
                                                                'rowNumber' => 1,
                                                                'values' => [
                                                                                                                                23331.3,
                                                                                                                                's2',
                                                                                                                                61
                                                                ]
                                ]
                ]
        ]
    ]
  ]),
  CURLOPT_HTTPHEADER => [
    "Authorization: Bearer <token>",
    "Content-Type: application/json"
  ],
]);

$response = curl_exec($curl);
$err = curl_error($curl);

curl_close($curl);

if ($err) {
  echo "cURL Error #:" . $err;
} else {
  echo $response;
}
package main

import (
	"fmt"
	"strings"
	"net/http"
	"io"
)

func main() {

	url := "https://{cluster}.cognitedata.com/api/v1/projects/{project}/sequences/data"

	payload := strings.NewReader("{\n  \"items\": [\n    {\n      \"externalId\": \"DL/DRILL412/20190103/T3\",\n      \"columns\": [\n        \"Depth\",\n        \"DepthSource\",\n        \"PowerSetting\"\n      ],\n      \"rows\": [\n        {\n          \"rowNumber\": 1,\n          \"values\": [\n            23331.3,\n            \"s2\",\n            61\n          ]\n        }\n      ]\n    }\n  ]\n}")

	req, _ := http.NewRequest("POST", url, payload)

	req.Header.Add("Authorization", "Bearer <token>")
	req.Header.Add("Content-Type", "application/json")

	res, _ := http.DefaultClient.Do(req)

	defer res.Body.Close()
	body, _ := io.ReadAll(res.Body)

	fmt.Println(string(body))

}
require 'uri'
require 'net/http'

url = URI("https://{cluster}.cognitedata.com/api/v1/projects/{project}/sequences/data")

http = Net::HTTP.new(url.host, url.port)
http.use_ssl = true

request = Net::HTTP::Post.new(url)
request["Authorization"] = 'Bearer <token>'
request["Content-Type"] = 'application/json'
request.body = "{\n  \"items\": [\n    {\n      \"externalId\": \"DL/DRILL412/20190103/T3\",\n      \"columns\": [\n        \"Depth\",\n        \"DepthSource\",\n        \"PowerSetting\"\n      ],\n      \"rows\": [\n        {\n          \"rowNumber\": 1,\n          \"values\": [\n            23331.3,\n            \"s2\",\n            61\n          ]\n        }\n      ]\n    }\n  ]\n}"

response = http.request(request)
puts response.read_body
{}

Authorizations

Authorization
string
header
required

Access token issued by the CDF project's configured identity provider. Access token must be an OpenID Connect token, and the project must be configured to accept OpenID Connect tokens. Use a header key of 'Authorization' with a value of 'Bearer $accesstoken'. The token can be obtained through any flow supported by the identity provider.

Body

application/json

Data posted.

items
(Select by Id · object | Select by ExternalId · object)[]
required
Required array length: 1 - 1000 elements

Data from a sequence.

Example:
{
  "columns": ["Depth", "DepthSource", "PowerSetting"],
  "rows": [
    {
      "rowNumber": 1,
      "values": [23331.3, "s2", 61]
    }
  ]
}

Response

200 - application/json

Empty response.

The response is of type object.

Last modified on July 10, 2026