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