Back to Collection Items
#include <CkHttpW.h>
#include <CkJsonObjectW.h>
#include <CkHttpResponseW.h>
void ChilkatSample(void)
{
// This example assumes the Chilkat API to have been previously unlocked.
// See Global Unlock Sample for sample code.
CkHttpW http;
bool success;
// Use this online tool to generate code from sample JSON: Generate Code to Create JSON
// The following JSON is sent in the request body.
// {
// "items": [
// {
// "externalId": "DL/DRILL412/20190103/T3",
// "columns": [
// "Depth",
// "DepthSource",
// "PowerSetting"
// ],
// "rows": [
// {
// "rowNumber": 1,
// "values": [
// 23331.3,
// "s2",
// 61
// ]
// }
// ]
// }
// ]
// }
CkJsonObjectW json;
json.UpdateString(L"items[0].externalId",L"DL/DRILL412/20190103/T3");
json.UpdateString(L"items[0].columns[0]",L"Depth");
json.UpdateString(L"items[0].columns[1]",L"DepthSource");
json.UpdateString(L"items[0].columns[2]",L"PowerSetting");
json.UpdateInt(L"items[0].rows[0].rowNumber",1);
json.UpdateNumber(L"items[0].rows[0].values[0]",L"23331.3");
json.UpdateString(L"items[0].rows[0].values[1]",L"s2");
json.UpdateInt(L"items[0].rows[0].values[2]",61);
http.SetRequestHeader(L"content-type",L"application/json");
http.SetRequestHeader(L"api-key",L"{{api-key}}");
CkHttpResponseW *resp = http.PostJson3(L"https://domain.com/api/v1/projects/{{project}}/sequences/data",L"application/json",json);
if (http.get_LastMethodSuccess() == false) {
wprintf(L"%s\n",http.lastErrorText());
return;
}
wprintf(L"%d\n",resp->get_StatusCode());
wprintf(L"%s\n",resp->bodyStr());
delete resp;
}
Curl Command
curl -X POST
-H "api-key: {{api-key}}"
-H "content-type: application/json"
-d '{"items":[{"externalId":"DL/DRILL412/20190103/T3","columns":["Depth","DepthSource","PowerSetting"],"rows":[{"rowNumber":1,"values":[23331.3,"s2",61]}]}]}'
https://domain.com/api/v1/projects/{{project}}/sequences/data
Postman Collection Item JSON
{
"id": "postSequenceData",
"name": "Insert rows",
"request": {
"url": {
"host": "{{baseUrl}}",
"path": [
"api",
"v1",
"projects",
"{{project}}",
"sequences",
"data"
],
"query": [
],
"variable": [
]
},
"method": "POST",
"header": [
{
"key": "api-key",
"value": "{{api-key}}",
"description": "An admin can create API keys in the Cognite console."
},
{
"key": "content-type",
"value": "application/json"
}
],
"description": "Inserts rows into a sequence. This overwrites data in rows and columns that exist.",
"body": {
"mode": "raw",
"raw": "{\"items\":[{\"externalId\":\"DL/DRILL412/20190103/T3\",\"columns\":[\"Depth\",\"DepthSource\",\"PowerSetting\"],\"rows\":[{\"rowNumber\":1,\"values\":[23331.3,\"s2\",61]}]}]}"
}
}
}