Foxpro / Cognite API v1 / Create transformations
Back to Collection Items
LOCAL loHttp
LOCAL lnSuccess
LOCAL loJson
LOCAL loResp
* This example assumes the Chilkat API to have been previously unlocked.
* See Global Unlock Sample for sample code.
loHttp = CreateObject('Chilkat_9_5_0.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": [
* {
* "name": "ipsum ut sed d",
* "ignoreNullFields": false,
* "externalId": "proident eu mollit",
* "query": "qui non sint ut",
* "destination": {
* "type": "assets"
* },
* "conflictMode": "aliquip dolore nulla c",
* "isPublic": false,
* "sourceApiKey": "esse dolore aliqua in",
* "destinationApiKey": "nulla in tempor",
* "sourceOidcCredentials": {
* "clientId": "p",
* "clientSecret": "amet",
* "tokenUri": "sit voluptate dolore ",
* "cdfProjectName": "aliquip velit incididunt",
* "scopes": "consectetur cillum",
* "audience": "non magna"
* },
* "destinationOidcCredentials": {
* "clientId": "est culpa",
* "clientSecret": "cillum exercitation",
* "tokenUri": "do ea sint culpa",
* "cdfProjectName": "officia proident",
* "scopes": "cupidatat Lorem elit adipisicing",
* "audience": "nisi veniam"
* }
* },
* {
* "name": "in occaecat ut",
* "ignoreNullFields": false,
* "externalId": "magna Lorem",
* "query": "cillum dolor ea",
* "destination": {
* "type": "relationships"
* },
* "conflictMode": "pariatur laborum eiusmod Ut consectetur",
* "isPublic": true,
* "sourceApiKey": "ullamco eu velit elit",
* "destinationApiKey": "dolore in",
* "sourceOidcCredentials": {
* "clientId": "Ut",
* "clientSecret": "minim commodo Lorem in",
* "tokenUri": "culpa ipsum aliquip pariatur",
* "cdfProjectName": "minim",
* "scopes": "deserunt cillum in non mollit",
* "audience": "elit ea"
* },
* "destinationOidcCredentials": {
* "clientId": "elit eu exercitation",
* "clientSecret": "fugiat",
* "tokenUri": "velit mollit",
* "cdfProjectName": "tempor enim exercitation voluptate dolore",
* "scopes": "ipsum Lorem ullamco consequat",
* "audience": "ullamco"
* }
* }
* ]
* }
loJson = CreateObject('Chilkat_9_5_0.JsonObject')
loJson.UpdateString("items[0].name","ipsum ut sed d")
loJson.UpdateBool("items[0].ignoreNullFields",0)
loJson.UpdateString("items[0].externalId","proident eu mollit")
loJson.UpdateString("items[0].query","qui non sint ut")
loJson.UpdateString("items[0].destination.type","assets")
loJson.UpdateString("items[0].conflictMode","aliquip dolore nulla c")
loJson.UpdateBool("items[0].isPublic",0)
loJson.UpdateString("items[0].sourceApiKey","esse dolore aliqua in")
loJson.UpdateString("items[0].destinationApiKey","nulla in tempor")
loJson.UpdateString("items[0].sourceOidcCredentials.clientId","p")
loJson.UpdateString("items[0].sourceOidcCredentials.clientSecret","amet")
loJson.UpdateString("items[0].sourceOidcCredentials.tokenUri","sit voluptate dolore ")
loJson.UpdateString("items[0].sourceOidcCredentials.cdfProjectName","aliquip velit incididunt")
loJson.UpdateString("items[0].sourceOidcCredentials.scopes","consectetur cillum")
loJson.UpdateString("items[0].sourceOidcCredentials.audience","non magna")
loJson.UpdateString("items[0].destinationOidcCredentials.clientId","est culpa")
loJson.UpdateString("items[0].destinationOidcCredentials.clientSecret","cillum exercitation")
loJson.UpdateString("items[0].destinationOidcCredentials.tokenUri","do ea sint culpa")
loJson.UpdateString("items[0].destinationOidcCredentials.cdfProjectName","officia proident")
loJson.UpdateString("items[0].destinationOidcCredentials.scopes","cupidatat Lorem elit adipisicing")
loJson.UpdateString("items[0].destinationOidcCredentials.audience","nisi veniam")
loJson.UpdateString("items[1].name","in occaecat ut")
loJson.UpdateBool("items[1].ignoreNullFields",0)
loJson.UpdateString("items[1].externalId","magna Lorem")
loJson.UpdateString("items[1].query","cillum dolor ea")
loJson.UpdateString("items[1].destination.type","relationships")
loJson.UpdateString("items[1].conflictMode","pariatur laborum eiusmod Ut consectetur")
loJson.UpdateBool("items[1].isPublic",1)
loJson.UpdateString("items[1].sourceApiKey","ullamco eu velit elit")
loJson.UpdateString("items[1].destinationApiKey","dolore in")
loJson.UpdateString("items[1].sourceOidcCredentials.clientId","Ut")
loJson.UpdateString("items[1].sourceOidcCredentials.clientSecret","minim commodo Lorem in")
loJson.UpdateString("items[1].sourceOidcCredentials.tokenUri","culpa ipsum aliquip pariatur")
loJson.UpdateString("items[1].sourceOidcCredentials.cdfProjectName","minim")
loJson.UpdateString("items[1].sourceOidcCredentials.scopes","deserunt cillum in non mollit")
loJson.UpdateString("items[1].sourceOidcCredentials.audience","elit ea")
loJson.UpdateString("items[1].destinationOidcCredentials.clientId","elit eu exercitation")
loJson.UpdateString("items[1].destinationOidcCredentials.clientSecret","fugiat")
loJson.UpdateString("items[1].destinationOidcCredentials.tokenUri","velit mollit")
loJson.UpdateString("items[1].destinationOidcCredentials.cdfProjectName","tempor enim exercitation voluptate dolore")
loJson.UpdateString("items[1].destinationOidcCredentials.scopes","ipsum Lorem ullamco consequat")
loJson.UpdateString("items[1].destinationOidcCredentials.audience","ullamco")
loHttp.SetRequestHeader("content-type","application/json")
loHttp.SetRequestHeader("api-key","{{api-key}}")
loResp = loHttp.PostJson3("https://domain.com/api/v1/projects/{{project}}/transformations","application/json",loJson)
IF (loHttp.LastMethodSuccess = 0) THEN
? loHttp.LastErrorText
RELEASE loHttp
RELEASE loJson
CANCEL
ENDIF
? STR(loResp.StatusCode)
? loResp.BodyStr
RELEASE loResp
RELEASE loHttp
RELEASE loJson
Curl Command
curl -X POST
-H "api-key: {{api-key}}"
-H "content-type: application/json"
-d '{
"items": [
{
"name": "ipsum ut sed d",
"ignoreNullFields": false,
"externalId": "proident eu mollit",
"query": "qui non sint ut",
"destination": {
"type": "assets"
},
"conflictMode": "aliquip dolore nulla c",
"isPublic": false,
"sourceApiKey": "esse dolore aliqua in",
"destinationApiKey": "nulla in tempor",
"sourceOidcCredentials": {
"clientId": "p",
"clientSecret": "amet",
"tokenUri": "sit voluptate dolore ",
"cdfProjectName": "aliquip velit incididunt",
"scopes": "consectetur cillum",
"audience": "non magna"
},
"destinationOidcCredentials": {
"clientId": "est culpa",
"clientSecret": "cillum exercitation",
"tokenUri": "do ea sint culpa",
"cdfProjectName": "officia proident",
"scopes": "cupidatat Lorem elit adipisicing",
"audience": "nisi veniam"
}
},
{
"name": "in occaecat ut",
"ignoreNullFields": false,
"externalId": "magna Lorem",
"query": "cillum dolor ea",
"destination": {
"type": "relationships"
},
"conflictMode": "pariatur laborum eiusmod Ut consectetur",
"isPublic": true,
"sourceApiKey": "ullamco eu velit elit",
"destinationApiKey": "dolore in",
"sourceOidcCredentials": {
"clientId": "Ut",
"clientSecret": "minim commodo Lorem in",
"tokenUri": "culpa ipsum aliquip pariatur",
"cdfProjectName": "minim",
"scopes": "deserunt cillum in non mollit",
"audience": "elit ea"
},
"destinationOidcCredentials": {
"clientId": "elit eu exercitation",
"clientSecret": "fugiat",
"tokenUri": "velit mollit",
"cdfProjectName": "tempor enim exercitation voluptate dolore",
"scopes": "ipsum Lorem ullamco consequat",
"audience": "ullamco"
}
}
]
}'
https://domain.com/api/v1/projects/{{project}}/transformations
Postman Collection Item JSON
{
"id": "createTransformations",
"name": "Create transformations",
"request": {
"url": {
"host": "{{baseUrl}}",
"path": [
"api",
"v1",
"projects",
"{{project}}",
"transformations"
],
"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 a maximum of 1000 transformations per request.",
"body": {
"mode": "raw",
"raw": "{\n \"items\": [\n {\n \"name\": \"ipsum ut sed d\",\n \"ignoreNullFields\": false,\n \"externalId\": \"proident eu mollit\",\n \"query\": \"qui non sint ut\",\n \"destination\": {\n \"type\": \"assets\"\n },\n \"conflictMode\": \"aliquip dolore nulla c\",\n \"isPublic\": false,\n \"sourceApiKey\": \"esse dolore aliqua in\",\n \"destinationApiKey\": \"nulla in tempor\",\n \"sourceOidcCredentials\": {\n \"clientId\": \"p\",\n \"clientSecret\": \"amet\",\n \"tokenUri\": \"sit voluptate dolore \",\n \"cdfProjectName\": \"aliquip velit incididunt\",\n \"scopes\": \"consectetur cillum\",\n \"audience\": \"non magna\"\n },\n \"destinationOidcCredentials\": {\n \"clientId\": \"est culpa\",\n \"clientSecret\": \"cillum exercitation\",\n \"tokenUri\": \"do ea sint culpa\",\n \"cdfProjectName\": \"officia proident\",\n \"scopes\": \"cupidatat Lorem elit adipisicing\",\n \"audience\": \"nisi veniam\"\n }\n },\n {\n \"name\": \"in occaecat ut\",\n \"ignoreNullFields\": false,\n \"externalId\": \"magna Lorem\",\n \"query\": \"cillum dolor ea\",\n \"destination\": {\n \"type\": \"relationships\"\n },\n \"conflictMode\": \"pariatur laborum eiusmod Ut consectetur\",\n \"isPublic\": true,\n \"sourceApiKey\": \"ullamco eu velit elit\",\n \"destinationApiKey\": \"dolore in\",\n \"sourceOidcCredentials\": {\n \"clientId\": \"Ut\",\n \"clientSecret\": \"minim commodo Lorem in\",\n \"tokenUri\": \"culpa ipsum aliquip pariatur\",\n \"cdfProjectName\": \"minim\",\n \"scopes\": \"deserunt cillum in non mollit\",\n \"audience\": \"elit ea\"\n },\n \"destinationOidcCredentials\": {\n \"clientId\": \"elit eu exercitation\",\n \"clientSecret\": \"fugiat\",\n \"tokenUri\": \"velit mollit\",\n \"cdfProjectName\": \"tempor enim exercitation voluptate dolore\",\n \"scopes\": \"ipsum Lorem ullamco consequat\",\n \"audience\": \"ullamco\"\n }\n }\n ]\n}"
}
}
}
