Back to Collection Items
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
</head>
<body>
<%
' This example assumes the Chilkat API to have been previously unlocked.
' See Global Unlock Sample for sample code.
' For versions of Chilkat < 10.0.0, use CreateObject("Chilkat_9_5_0.Http")
set http = Server.CreateObject("Chilkat.Http")
' 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
' ]
' }
' ]
' }
' ]
' }
' For versions of Chilkat < 10.0.0, use CreateObject("Chilkat_9_5_0.JsonObject")
set json = Server.CreateObject("Chilkat.JsonObject")
success = json.UpdateString("items[0].externalId","DL/DRILL412/20190103/T3")
success = json.UpdateString("items[0].columns[0]","Depth")
success = json.UpdateString("items[0].columns[1]","DepthSource")
success = json.UpdateString("items[0].columns[2]","PowerSetting")
success = json.UpdateInt("items[0].rows[0].rowNumber",1)
success = json.UpdateNumber("items[0].rows[0].values[0]","23331.3")
success = json.UpdateString("items[0].rows[0].values[1]","s2")
success = json.UpdateInt("items[0].rows[0].values[2]",61)
http.SetRequestHeader "content-type","application/json"
http.SetRequestHeader "api-key","{{api-key}}"
' resp is a Chilkat.HttpResponse
Set resp = http.PostJson3("https://domain.com/api/v1/projects/{{project}}/sequences/data","application/json",json)
If (http.LastMethodSuccess = 0) Then
Response.Write "<pre>" & Server.HTMLEncode( http.LastErrorText) & "</pre>"
Response.End
End If
Response.Write "<pre>" & Server.HTMLEncode( resp.StatusCode) & "</pre>"
Response.Write "<pre>" & Server.HTMLEncode( resp.BodyStr) & "</pre>"
%>
</body>
</html>
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]}]}]}"
}
}
}
