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{}Required capabilities:
sequencesAcl:WRITE
Inserts rows into a sequence. This overwrites data in rows and columns that exist.
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
oidc-tokenoauth2-client-credentialsoauth2-open-industrial-dataoauth2-auth-code
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.
Required array length:
1 - 1000 elementsData from a sequence.
- Select by Id
- Select by ExternalId
Show child attributes
Show child attributes
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
Was this page helpful?
⌘I