Back to Collection Items
#include <C_CkHttpW.h>
#include <C_CkJsonObjectW.h>
#include <C_CkHttpResponseW.h>
void ChilkatSample(void)
{
HCkHttpW http;
BOOL success;
HCkJsonObjectW json;
HCkHttpResponseW resp;
// This example assumes the Chilkat API to have been previously unlocked.
// See Global Unlock Sample for sample code.
http = CkHttpW_Create();
// 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
// ]
// }
// ]
// }
// ]
// }
json = CkJsonObjectW_Create();
CkJsonObjectW_UpdateString(json,L"items[0].externalId",L"DL/DRILL412/20190103/T3");
CkJsonObjectW_UpdateString(json,L"items[0].columns[0]",L"Depth");
CkJsonObjectW_UpdateString(json,L"items[0].columns[1]",L"DepthSource");
CkJsonObjectW_UpdateString(json,L"items[0].columns[2]",L"PowerSetting");
CkJsonObjectW_UpdateInt(json,L"items[0].rows[0].rowNumber",1);
CkJsonObjectW_UpdateNumber(json,L"items[0].rows[0].values[0]",L"23331.3");
CkJsonObjectW_UpdateString(json,L"items[0].rows[0].values[1]",L"s2");
CkJsonObjectW_UpdateInt(json,L"items[0].rows[0].values[2]",61);
CkHttpW_SetRequestHeader(http,L"content-type",L"application/json");
CkHttpW_SetRequestHeader(http,L"api-key",L"{{api-key}}");
resp = CkHttpW_PostJson3(http,L"https://domain.com/api/v1/projects/{{project}}/sequences/data",L"application/json",json);
if (CkHttpW_getLastMethodSuccess(http) == FALSE) {
wprintf(L"%s\n",CkHttpW_lastErrorText(http));
CkHttpW_Dispose(http);
CkJsonObjectW_Dispose(json);
return;
}
wprintf(L"%d\n",CkHttpResponseW_getStatusCode(resp));
wprintf(L"%s\n",CkHttpResponseW_bodyStr(resp));
CkHttpResponseW_Dispose(resp);
CkHttpW_Dispose(http);
CkJsonObjectW_Dispose(json);
}
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]}]}]}"
}
}
}