PowerBuilder / Microsoft Graph / Register schema
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
li_rc = loo_Http.ConnectToNewObject("Chilkat_9_5_0.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.
// {
// "baseType": "microsoft.graph.externalItem",
// "properties": [
// {
// "name": "id",
// "type": "string",
// "isSearchable": false,
// "isRetrievable": true,
// "isQueryable": false,
// "labels": [
// ],
// "aliases": [
// ]
// },
// {
// "name": "title",
// "type": "string",
// "isSearchable": true,
// "isRetrievable": true,
// "isQueryable": true,
// "labels": [
// "title"
// ],
// "aliases": [
// ]
// },
// {
// "name": "extension",
// "type": "string",
// "isSearchable": true,
// "isRetrievable": true,
// "isQueryable": true,
// "labels": [
// ],
// "aliases": [
// ]
// },
// {
// "name": "createdBy",
// "type": "string",
// "isSearchable": true,
// "isRetrievable": true,
// "isQueryable": true,
// "labels": [
// "createdBy"
// ],
// "aliases": [
// ]
// },
// {
// "name": "createdDateTime",
// "type": "dateTime",
// "isSearchable": false,
// "isRetrievable": true,
// "isQueryable": true,
// "labels": [
// "createdDateTime"
// ],
// "aliases": [
// ]
// },
// {
// "name": "lastModifiedBy",
// "type": "string",
// "isSearchable": false,
// "isRetrievable": true,
// "isQueryable": true,
// "labels": [
// ],
// "aliases": [
// ]
// },
// {
// "name": "lastModifiedDate",
// "type": "dateTime",
// "isSearchable": false,
// "isRetrievable": true,
// "isQueryable": true,
// "labels": [
// "lastModifiedDateTime"
// ],
// "aliases": [
// ]
// },
// {
// "name": "url",
// "type": "string",
// "isSearchable": false,
// "isRetrievable": true,
// "isQueryable": false,
// "labels": [
// "url"
// ],
// "aliases": [
// ]
// },
// {
// "name": "description",
// "type": "string",
// "isSearchable": false,
// "isRetrievable": true,
// "isQueryable": false,
// "labels": [
// ],
// "aliases": [
// ]
// },
// {
// "name": "authors",
// "type": "stringCollection",
// "isSearchable": false,
// "isRetrievable": true,
// "isQueryable": false,
// "labels": [
// "authors"
// ],
// "aliases": [
// ]
// }
// ]
// }
loo_Json = create oleobject
li_rc = loo_Json.ConnectToNewObject("Chilkat_9_5_0.JsonObject")
loo_Json.UpdateString("baseType","microsoft.graph.externalItem")
loo_Json.UpdateString("properties[0].name","id")
loo_Json.UpdateString("properties[0].type","string")
loo_Json.UpdateBool("properties[0].isSearchable",0)
loo_Json.UpdateBool("properties[0].isRetrievable",1)
loo_Json.UpdateBool("properties[0].isQueryable",0)
loo_Json.UpdateNewArray("properties[0].labels")
loo_Json.UpdateNewArray("properties[0].aliases")
loo_Json.UpdateString("properties[1].name","title")
loo_Json.UpdateString("properties[1].type","string")
loo_Json.UpdateBool("properties[1].isSearchable",1)
loo_Json.UpdateBool("properties[1].isRetrievable",1)
loo_Json.UpdateBool("properties[1].isQueryable",1)
loo_Json.UpdateString("properties[1].labels[0]","title")
loo_Json.UpdateNewArray("properties[1].aliases")
loo_Json.UpdateString("properties[2].name","extension")
loo_Json.UpdateString("properties[2].type","string")
loo_Json.UpdateBool("properties[2].isSearchable",1)
loo_Json.UpdateBool("properties[2].isRetrievable",1)
loo_Json.UpdateBool("properties[2].isQueryable",1)
loo_Json.UpdateNewArray("properties[2].labels")
loo_Json.UpdateNewArray("properties[2].aliases")
loo_Json.UpdateString("properties[3].name","createdBy")
loo_Json.UpdateString("properties[3].type","string")
loo_Json.UpdateBool("properties[3].isSearchable",1)
loo_Json.UpdateBool("properties[3].isRetrievable",1)
loo_Json.UpdateBool("properties[3].isQueryable",1)
loo_Json.UpdateString("properties[3].labels[0]","createdBy")
loo_Json.UpdateNewArray("properties[3].aliases")
loo_Json.UpdateString("properties[4].name","createdDateTime")
loo_Json.UpdateString("properties[4].type","dateTime")
loo_Json.UpdateBool("properties[4].isSearchable",0)
loo_Json.UpdateBool("properties[4].isRetrievable",1)
loo_Json.UpdateBool("properties[4].isQueryable",1)
loo_Json.UpdateString("properties[4].labels[0]","createdDateTime")
loo_Json.UpdateNewArray("properties[4].aliases")
loo_Json.UpdateString("properties[5].name","lastModifiedBy")
loo_Json.UpdateString("properties[5].type","string")
loo_Json.UpdateBool("properties[5].isSearchable",0)
loo_Json.UpdateBool("properties[5].isRetrievable",1)
loo_Json.UpdateBool("properties[5].isQueryable",1)
loo_Json.UpdateNewArray("properties[5].labels")
loo_Json.UpdateNewArray("properties[5].aliases")
loo_Json.UpdateString("properties[6].name","lastModifiedDate")
loo_Json.UpdateString("properties[6].type","dateTime")
loo_Json.UpdateBool("properties[6].isSearchable",0)
loo_Json.UpdateBool("properties[6].isRetrievable",1)
loo_Json.UpdateBool("properties[6].isQueryable",1)
loo_Json.UpdateString("properties[6].labels[0]","lastModifiedDateTime")
loo_Json.UpdateNewArray("properties[6].aliases")
loo_Json.UpdateString("properties[7].name","url")
loo_Json.UpdateString("properties[7].type","string")
loo_Json.UpdateBool("properties[7].isSearchable",0)
loo_Json.UpdateBool("properties[7].isRetrievable",1)
loo_Json.UpdateBool("properties[7].isQueryable",0)
loo_Json.UpdateString("properties[7].labels[0]","url")
loo_Json.UpdateNewArray("properties[7].aliases")
loo_Json.UpdateString("properties[8].name","description")
loo_Json.UpdateString("properties[8].type","string")
loo_Json.UpdateBool("properties[8].isSearchable",0)
loo_Json.UpdateBool("properties[8].isRetrievable",1)
loo_Json.UpdateBool("properties[8].isQueryable",0)
loo_Json.UpdateNewArray("properties[8].labels")
loo_Json.UpdateNewArray("properties[8].aliases")
loo_Json.UpdateString("properties[9].name","authors")
loo_Json.UpdateString("properties[9].type","stringCollection")
loo_Json.UpdateBool("properties[9].isSearchable",0)
loo_Json.UpdateBool("properties[9].isRetrievable",1)
loo_Json.UpdateBool("properties[9].isQueryable",0)
loo_Json.UpdateString("properties[9].labels[0]","authors")
loo_Json.UpdateNewArray("properties[9].aliases")
loo_Http.SetRequestHeader("Content-Type","application/json")
// Adds the "Authorization: Bearer <access_token>" header.
loo_Http.AuthToken = "<access_token>"
loo_Http.SetRequestHeader("prefer","respond-async")
loo_Resp = loo_Http.PostJson3("https://graph.microsoft.com/v1.0/external/connections/sampleConnectionId/schema","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 "Authorization: Bearer <access_token>"
-H "Content-Type: application/json"
-H "prefer: respond-async"
-d '{
"baseType": "microsoft.graph.externalItem",
"properties": [
{
"name": "id",
"type": "string",
"isSearchable": false,
"isRetrievable": true,
"isQueryable": false,
"labels": [],
"aliases": []
},
{
"name": "title",
"type": "string",
"isSearchable": true,
"isRetrievable": true,
"isQueryable": true,
"labels": [
"title"
],
"aliases": []
},
{
"name": "extension",
"type": "string",
"isSearchable": true,
"isRetrievable": true,
"isQueryable": true,
"labels": [],
"aliases": []
},
{
"name": "createdBy",
"type": "string",
"isSearchable": true,
"isRetrievable": true,
"isQueryable": true,
"labels": [
"createdBy"
],
"aliases": []
},
{
"name": "createdDateTime",
"type": "dateTime",
"isSearchable": false,
"isRetrievable": true,
"isQueryable": true,
"labels": [
"createdDateTime"
],
"aliases": []
},
{
"name": "lastModifiedBy",
"type": "string",
"isSearchable": false,
"isRetrievable": true,
"isQueryable": true,
"labels": [],
"aliases": []
},
{
"name": "lastModifiedDate",
"type": "dateTime",
"isSearchable": false,
"isRetrievable": true,
"isQueryable": true,
"labels": [
"lastModifiedDateTime"
],
"aliases": []
},
{
"name": "url",
"type": "string",
"isSearchable": false,
"isRetrievable": true,
"isQueryable": false,
"labels": [
"url"
],
"aliases": []
},
{
"name": "description",
"type": "string",
"isSearchable": false,
"isRetrievable": true,
"isQueryable": false,
"labels": [],
"aliases": []
},
{
"name": "authors",
"type": "stringCollection",
"isSearchable": false,
"isRetrievable": true,
"isQueryable": false,
"labels": [
"authors"
],
"aliases": []
}
]
}'
https://graph.microsoft.com/v1.0/external/connections/sampleConnectionId/schema
Postman Collection Item JSON
{
"name": "Register schema",
"event": [
{
"listen": "test",
"script": {
"exec": [
"postman.setEnvironmentVariable(\"OperationUrl\", pm.response.headers.get(\"Location\"));"
],
"type": "text/javascript"
}
}
],
"request": {
"method": "POST",
"header": [
{
"key": "Content-Type",
"name": "Content-Type",
"type": "text",
"value": "application/json"
},
{
"key": "prefer",
"type": "text",
"value": "respond-async"
}
],
"body": {
"mode": "raw",
"raw": "{\r\n \"baseType\": \"microsoft.graph.externalItem\",\r\n \"properties\": [\r\n {\r\n \"name\": \"id\",\r\n \"type\": \"string\",\r\n \"isSearchable\": false,\r\n \"isRetrievable\": true,\r\n \"isQueryable\": false,\r\n \"labels\": [],\r\n \"aliases\": []\r\n },\r\n {\r\n \"name\": \"title\",\r\n \"type\": \"string\",\r\n \"isSearchable\": true,\r\n \"isRetrievable\": true,\r\n \"isQueryable\": true,\r\n \"labels\": [\r\n \"title\"\r\n ],\r\n \"aliases\": []\r\n },\r\n {\r\n \"name\": \"extension\",\r\n \"type\": \"string\",\r\n \"isSearchable\": true,\r\n \"isRetrievable\": true,\r\n \"isQueryable\": true,\r\n \"labels\": [],\r\n \"aliases\": []\r\n },\r\n {\r\n \"name\": \"createdBy\",\r\n \"type\": \"string\",\r\n \"isSearchable\": true,\r\n \"isRetrievable\": true,\r\n \"isQueryable\": true,\r\n \"labels\": [\r\n \"createdBy\"\r\n ],\r\n \"aliases\": []\r\n },\r\n {\r\n \"name\": \"createdDateTime\",\r\n \"type\": \"dateTime\",\r\n \"isSearchable\": false,\r\n \"isRetrievable\": true,\r\n \"isQueryable\": true,\r\n \"labels\": [\r\n \"createdDateTime\"\r\n ],\r\n \"aliases\": []\r\n },\r\n {\r\n \"name\": \"lastModifiedBy\",\r\n \"type\": \"string\",\r\n \"isSearchable\": false,\r\n \"isRetrievable\": true,\r\n \"isQueryable\": true,\r\n \"labels\": [],\r\n \"aliases\": []\r\n },\r\n {\r\n \"name\": \"lastModifiedDate\",\r\n \"type\": \"dateTime\",\r\n \"isSearchable\": false,\r\n \"isRetrievable\": true,\r\n \"isQueryable\": true,\r\n \"labels\": [\r\n \"lastModifiedDateTime\"\r\n ],\r\n \"aliases\": []\r\n },\r\n {\r\n \"name\": \"url\",\r\n \"type\": \"string\",\r\n \"isSearchable\": false,\r\n \"isRetrievable\": true,\r\n \"isQueryable\": false,\r\n \"labels\": [\r\n \"url\"\r\n ],\r\n \"aliases\": []\r\n },\r\n {\r\n \"name\": \"description\",\r\n \"type\": \"string\",\r\n \"isSearchable\": false,\r\n \"isRetrievable\": true,\r\n \"isQueryable\": false,\r\n \"labels\": [],\r\n \"aliases\": []\r\n },\r\n {\r\n \"name\": \"authors\",\r\n \"type\": \"stringCollection\",\r\n \"isSearchable\": false,\r\n \"isRetrievable\": true,\r\n \"isQueryable\": false,\r\n \"labels\": [\r\n \"authors\"\r\n ],\r\n \"aliases\": []\r\n }\r\n ]\r\n}"
},
"url": {
"raw": "https://graph.microsoft.com/v1.0/external/connections/sampleConnectionId/schema",
"protocol": "https",
"host": [
"graph",
"microsoft",
"com"
],
"path": [
"v1.0",
"external",
"connections",
"sampleConnectionId",
"schema"
]
}
},
"response": [
]
}
