Chilkat Online Tools

DataFlex / Cognite API v1 / Create sequences

Back to Collection Items

Use ChilkatAx-win32.pkg

Procedure Test
    Handle hoHttp
    Boolean iSuccess
    Variant vJson
    Handle hoJson
    Variant vResp
    Handle hoResp
    String sTemp1
    Integer iTemp1

    // This example assumes the Chilkat API to have been previously unlocked.
    // See Global Unlock Sample for sample code.

    Get Create (RefClass(cComChilkatHttp)) To hoHttp
    If (Not(IsComObjectCreated(hoHttp))) Begin
        Send CreateComObject of hoHttp
    End

    // 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": [
    //     {
    //       "columns": [
    //         {
    //           "externalId": "dolore sint Ut nostrud voluptate",
    //           "name": "",
    //           "description": "minim labore id consectetur",
    //           "valueType": "DOUBLE",
    //           "metadata": {}
    //         },
    //         {
    //           "externalId": "cillum sit",
    //           "name": "laborum nostrud in",
    //           "description": "id",
    //           "valueType": "DOUBLE",
    //           "metadata": {}
    //         }
    //       ],
    //       "name": "dolore tempor qui ul",
    //       "description": "ut sint aliquip eiusmod Duis",
    //       "assetId": -23229265,
    //       "externalId": "ut velit ipsum irure",
    //       "metadata": {},
    //       "dataSetId": 3324920627170116
    //     },
    //     {
    //       "columns": [
    //         {
    //           "externalId": "sed aliquip ullamco non",
    //           "name": "sit Lorem sunt ullamco enim",
    //           "description": "eu qui proident ",
    //           "valueType": "DOUBLE",
    //           "metadata": {}
    //         },
    //         {
    //           "externalId": "proident ex in",
    //           "name": "cillum Excepteur ex laborum ipsum",
    //           "description": "commodo nisi ut consequat magna",
    //           "valueType": "DOUBLE",
    //           "metadata": {}
    //         }
    //       ],
    //       "name": "Exce",
    //       "description": "dolor ipsum ad",
    //       "assetId": -40853595,
    //       "externalId": "anim dolor dolore",
    //       "metadata": {},
    //       "dataSetId": 4440527212504684
    //     }
    //   ]
    // }

    Get Create (RefClass(cComChilkatJsonObject)) To hoJson
    If (Not(IsComObjectCreated(hoJson))) Begin
        Send CreateComObject of hoJson
    End
    Get ComUpdateString Of hoJson "items[0].columns[0].externalId" "dolore sint Ut nostrud voluptate" To iSuccess
    Get ComUpdateString Of hoJson "items[0].columns[0].name" "" To iSuccess
    Get ComUpdateString Of hoJson "items[0].columns[0].description" "minim labore id consectetur" To iSuccess
    Get ComUpdateString Of hoJson "items[0].columns[0].valueType" "DOUBLE" To iSuccess
    Get ComUpdateNewObject Of hoJson "items[0].columns[0].metadata" To iSuccess
    Get ComUpdateString Of hoJson "items[0].columns[1].externalId" "cillum sit" To iSuccess
    Get ComUpdateString Of hoJson "items[0].columns[1].name" "laborum nostrud in" To iSuccess
    Get ComUpdateString Of hoJson "items[0].columns[1].description" "id" To iSuccess
    Get ComUpdateString Of hoJson "items[0].columns[1].valueType" "DOUBLE" To iSuccess
    Get ComUpdateNewObject Of hoJson "items[0].columns[1].metadata" To iSuccess
    Get ComUpdateString Of hoJson "items[0].name" "dolore tempor qui ul" To iSuccess
    Get ComUpdateString Of hoJson "items[0].description" "ut sint aliquip eiusmod Duis" To iSuccess
    Get ComUpdateInt Of hoJson "items[0].assetId" -23229265 To iSuccess
    Get ComUpdateString Of hoJson "items[0].externalId" "ut velit ipsum irure" To iSuccess
    Get ComUpdateNewObject Of hoJson "items[0].metadata" To iSuccess
    Get ComUpdateInt Of hoJson "items[0].dataSetId" 123 To iSuccess
    Get ComUpdateString Of hoJson "items[1].columns[0].externalId" "sed aliquip ullamco non" To iSuccess
    Get ComUpdateString Of hoJson "items[1].columns[0].name" "sit Lorem sunt ullamco enim" To iSuccess
    Get ComUpdateString Of hoJson "items[1].columns[0].description" "eu qui proident " To iSuccess
    Get ComUpdateString Of hoJson "items[1].columns[0].valueType" "DOUBLE" To iSuccess
    Get ComUpdateNewObject Of hoJson "items[1].columns[0].metadata" To iSuccess
    Get ComUpdateString Of hoJson "items[1].columns[1].externalId" "proident ex in" To iSuccess
    Get ComUpdateString Of hoJson "items[1].columns[1].name" "cillum Excepteur ex laborum ipsum" To iSuccess
    Get ComUpdateString Of hoJson "items[1].columns[1].description" "commodo nisi ut consequat magna" To iSuccess
    Get ComUpdateString Of hoJson "items[1].columns[1].valueType" "DOUBLE" To iSuccess
    Get ComUpdateNewObject Of hoJson "items[1].columns[1].metadata" To iSuccess
    Get ComUpdateString Of hoJson "items[1].name" "Exce" To iSuccess
    Get ComUpdateString Of hoJson "items[1].description" "dolor ipsum ad" To iSuccess
    Get ComUpdateInt Of hoJson "items[1].assetId" -40853595 To iSuccess
    Get ComUpdateString Of hoJson "items[1].externalId" "anim dolor dolore" To iSuccess
    Get ComUpdateNewObject Of hoJson "items[1].metadata" To iSuccess
    Get ComUpdateInt Of hoJson "items[1].dataSetId" 123 To iSuccess

    Send ComSetRequestHeader To hoHttp "content-type" "application/json"
    Send ComSetRequestHeader To hoHttp "api-key" "{{api-key}}"

    Get Create (RefClass(cComChilkatHttpResponse)) To hoResp
    If (Not(IsComObjectCreated(hoResp))) Begin
        Send CreateComObject of hoResp
    End
    Get pvComObject of hoJson to vJson
    Get pvComObject of hoResp to vResp
    Get ComHttpJson Of hoHttp "POST" "https://domain.com/api/v1/projects/{{project}}/sequences" vJson "application/json" vResp To iSuccess
    If (iSuccess = False) Begin
        Get ComLastErrorText Of hoHttp To sTemp1
        Showln sTemp1
        Procedure_Return
    End

    Get ComStatusCode Of hoResp To iTemp1
    Showln iTemp1
    Get ComBodyStr Of hoResp To sTemp1
    Showln sTemp1


End_Procedure

Curl Command

curl -X POST
	-H "api-key: {{api-key}}"
	-H "content-type: application/json"
	-d '{
    "items": [
        {
            "columns": [
                {
                    "externalId": "dolore sint Ut nostrud voluptate",
                    "name": "",
                    "description": "minim labore id consectetur",
                    "valueType": "DOUBLE",
                    "metadata": {}
                },
                {
                    "externalId": "cillum sit",
                    "name": "laborum nostrud in",
                    "description": "id",
                    "valueType": "DOUBLE",
                    "metadata": {}
                }
            ],
            "name": "dolore tempor qui ul",
            "description": "ut sint aliquip eiusmod Duis",
            "assetId": -23229265,
            "externalId": "ut velit ipsum irure",
            "metadata": {},
            "dataSetId": 3324920627170116
        },
        {
            "columns": [
                {
                    "externalId": "sed aliquip ullamco non",
                    "name": "sit Lorem sunt ullamco enim",
                    "description": "eu qui proident ",
                    "valueType": "DOUBLE",
                    "metadata": {}
                },
                {
                    "externalId": "proident ex in",
                    "name": "cillum Excepteur ex laborum ipsum",
                    "description": "commodo nisi ut consequat magna",
                    "valueType": "DOUBLE",
                    "metadata": {}
                }
            ],
            "name": "Exce",
            "description": "dolor ipsum ad",
            "assetId": -40853595,
            "externalId": "anim dolor dolore",
            "metadata": {},
            "dataSetId": 4440527212504684
        }
    ]
}'
https://domain.com/api/v1/projects/{{project}}/sequences

Postman Collection Item JSON

{
  "id": "createSequence",
  "name": "Create sequences",
  "request": {
    "url": {
      "host": "{{baseUrl}}",
      "path": [
        "api",
        "v1",
        "projects",
        "{{project}}",
        "sequences"
      ],
      "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": "Create one or more sequences.",
    "body": {
      "mode": "raw",
      "raw": "{\n    \"items\": [\n        {\n            \"columns\": [\n                {\n                    \"externalId\": \"dolore sint Ut nostrud voluptate\",\n                    \"name\": \"\",\n                    \"description\": \"minim labore id consectetur\",\n                    \"valueType\": \"DOUBLE\",\n                    \"metadata\": {}\n                },\n                {\n                    \"externalId\": \"cillum sit\",\n                    \"name\": \"laborum nostrud in\",\n                    \"description\": \"id\",\n                    \"valueType\": \"DOUBLE\",\n                    \"metadata\": {}\n                }\n            ],\n            \"name\": \"dolore tempor qui ul\",\n            \"description\": \"ut sint aliquip eiusmod Duis\",\n            \"assetId\": -23229265,\n            \"externalId\": \"ut velit ipsum irure\",\n            \"metadata\": {},\n            \"dataSetId\": 3324920627170116\n        },\n        {\n            \"columns\": [\n                {\n                    \"externalId\": \"sed aliquip ullamco non\",\n                    \"name\": \"sit Lorem sunt ullamco enim\",\n                    \"description\": \"eu qui proident \",\n                    \"valueType\": \"DOUBLE\",\n                    \"metadata\": {}\n                },\n                {\n                    \"externalId\": \"proident ex in\",\n                    \"name\": \"cillum Excepteur ex laborum ipsum\",\n                    \"description\": \"commodo nisi ut consequat magna\",\n                    \"valueType\": \"DOUBLE\",\n                    \"metadata\": {}\n                }\n            ],\n            \"name\": \"Exce\",\n            \"description\": \"dolor ipsum ad\",\n            \"assetId\": -40853595,\n            \"externalId\": \"anim dolor dolore\",\n            \"metadata\": {},\n            \"dataSetId\": 4440527212504684\n        }\n    ]\n}"
    }
  }
}