Chilkat Online Tools

SQL Server / Cognite API v1 / Insert rows

Back to Collection Items

System.OutOfMemoryException: Insufficient memory to continue the execution of the program.
   at System.Runtime.InteropServices.Marshal.StringToHGlobalUni(String s)
   at Chilkat.CkMarshal.StringToX(String s, XString* x)
   at Chilkat.Xml.LoadXml(String xmlData)
   at ChilkatApi.XClass.LoadClass(String className, Log log)
   at ChilkatApi.ApiCache.getApiClass(String className, Log log)
   at ChilkatApi.ApiCache.methodExists(String className, String methodName)
   at ChilkatCode.CodeGen.checkMethodCall(Xml xml)
   at ChilkatCode.Parser.fnCall(Xml xml)
   at ChilkatCode.Parser.subCall()
   at ChilkatCode.Parser.statement()
   at ChilkatCode.Parser.Chilkat()
   at ChilkatCode.Parser.Parse()
   at ChilkatCode.Compile.CompileForToolsIO(String srcCode, String langHashKey, StringBuilder sbHtmlOut)

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]}]}]}"
    }
  }
}