Chilkat Online Tools

PowerBuilder / Cognite API v1 / Create extraction pipelines

Back to Collection Items

integer li_rc
oleobject loo_Http
integer li_Success
oleobject loo_Json
oleobject loo_Resp

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

loo_Http = create oleobject
// Use "Chilkat_9_5_0.Http" for versions of Chilkat < 10.0.0
li_rc = loo_Http.ConnectToNewObject("Chilkat.Http")
if li_rc < 0 then
    destroy loo_Http
    MessageBox("Error","Connecting to COM object failed")
    return
end if

// 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": [
//     {
//       "dataSetId": 6090952878084188,
//       "externalId": "est proident quis Ut",
//       "name": "proident",
//       "description": "quis",
//       "rawTables": [
//       ],
//       "schedule": "On trigger",
//       "contacts": [
//       ],
//       "metadata": {},
//       "source": "dolore voluptate la",
//       "documentation": "esse laborum sed laboris"
//     },
//     {
//       "dataSetId": 6120166289297592,
//       "externalId": "ut culpa do pariatur cupidatat",
//       "name": "cupidatat ipsum",
//       "description": "est veniam dolor irure",
//       "rawTables": [
//       ],
//       "schedule": "829335,97665155,6988,0,1,2,50219644,344,13985954*/63 */9171156653970,43,5805075,70450,3,2805,27,88393 26748250436,0615963873,916395,181210,914594,3428,679355",
//       "contacts": [
//       ],
//       "metadata": {},
//       "source": "ad Duis",
//       "documentation": "quis reprehenderit"
//     }
//   ]
// }

loo_Json = create oleobject
// Use "Chilkat_9_5_0.JsonObject" for versions of Chilkat < 10.0.0
li_rc = loo_Json.ConnectToNewObject("Chilkat.JsonObject")

loo_Json.UpdateInt("items[0].dataSetId",123)
loo_Json.UpdateString("items[0].externalId","est proident quis Ut")
loo_Json.UpdateString("items[0].name","proident")
loo_Json.UpdateString("items[0].description","quis")
loo_Json.UpdateNewArray("items[0].rawTables")
loo_Json.UpdateString("items[0].schedule","On trigger")
loo_Json.UpdateNewArray("items[0].contacts")
loo_Json.UpdateNewObject("items[0].metadata")
loo_Json.UpdateString("items[0].source","dolore voluptate la")
loo_Json.UpdateString("items[0].documentation","esse laborum sed laboris")
loo_Json.UpdateInt("items[1].dataSetId",123)
loo_Json.UpdateString("items[1].externalId","ut culpa do pariatur cupidatat")
loo_Json.UpdateString("items[1].name","cupidatat ipsum")
loo_Json.UpdateString("items[1].description","est veniam dolor irure")
loo_Json.UpdateNewArray("items[1].rawTables")
loo_Json.UpdateString("items[1].schedule","829335,97665155,6988,0,1,2,50219644,344,13985954*/63 */9171156653970,43,5805075,70450,3,2805,27,88393 26748250436,0615963873,916395,181210,914594,3428,679355")
loo_Json.UpdateNewArray("items[1].contacts")
loo_Json.UpdateNewObject("items[1].metadata")
loo_Json.UpdateString("items[1].source","ad Duis")
loo_Json.UpdateString("items[1].documentation","quis reprehenderit")

loo_Http.SetRequestHeader("content-type","application/json")
loo_Http.SetRequestHeader("api-key","{{api-key}}")

loo_Resp = loo_Http.PostJson3("https://domain.com/api/v1/projects/{{project}}/extpipes","application/json",loo_Json)
if loo_Http.LastMethodSuccess = 0 then
    Write-Debug loo_Http.LastErrorText
    destroy loo_Http
    destroy loo_Json
    return
end if

Write-Debug string(loo_Resp.StatusCode)
Write-Debug loo_Resp.BodyStr
destroy loo_Resp


destroy loo_Http
destroy loo_Json

Curl Command

curl -X POST
	-H "api-key: {{api-key}}"
	-H "content-type: application/json"
	-d '{
    "items": [
        {
            "dataSetId": 6090952878084188,
            "externalId": "est proident quis Ut",
            "name": "proident",
            "description": "quis",
            "rawTables": [],
            "schedule": "On trigger",
            "contacts": [],
            "metadata": {},
            "source": "dolore voluptate la",
            "documentation": "esse laborum sed laboris"
        },
        {
            "dataSetId": 6120166289297592,
            "externalId": "ut culpa do pariatur cupidatat",
            "name": "cupidatat ipsum",
            "description": "est veniam dolor irure",
            "rawTables": [],
            "schedule": "829335,97665155,6988,0,1,2,50219644,344,13985954*/63 */9171156653970,43,5805075,70450,3,2805,27,88393 26748250436,0615963873,916395,181210,914594,3428,679355",
            "contacts": [],
            "metadata": {},
            "source": "ad Duis",
            "documentation": "quis reprehenderit"
        }
    ]
}'
https://domain.com/api/v1/projects/{{project}}/extpipes

Postman Collection Item JSON

{
  "id": "createExtPipes",
  "name": "Create extraction pipelines",
  "request": {
    "url": {
      "host": "{{baseUrl}}",
      "path": [
        "api",
        "v1",
        "projects",
        "{{project}}",
        "extpipes"
      ],
      "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": "Creates multiple new extraction pipelines. A maximum of 1000 extraction pipelines can be created per request.",
    "body": {
      "mode": "raw",
      "raw": "{\n    \"items\": [\n        {\n            \"dataSetId\": 6090952878084188,\n            \"externalId\": \"est proident quis Ut\",\n            \"name\": \"proident\",\n            \"description\": \"quis\",\n            \"rawTables\": [],\n            \"schedule\": \"On trigger\",\n            \"contacts\": [],\n            \"metadata\": {},\n            \"source\": \"dolore voluptate la\",\n            \"documentation\": \"esse laborum sed laboris\"\n        },\n        {\n            \"dataSetId\": 6120166289297592,\n            \"externalId\": \"ut culpa do pariatur cupidatat\",\n            \"name\": \"cupidatat ipsum\",\n            \"description\": \"est veniam dolor irure\",\n            \"rawTables\": [],\n            \"schedule\": \"829335,97665155,6988,0,1,2,50219644,344,13985954*/63 */9171156653970,43,5805075,70450,3,2805,27,88393 26748250436,0615963873,916395,181210,914594,3428,679355\",\n            \"contacts\": [],\n            \"metadata\": {},\n            \"source\": \"ad Duis\",\n            \"documentation\": \"quis reprehenderit\"\n        }\n    ]\n}"
    }
  }
}