Chilkat Online Tools

PowerBuilder / Atlassian Confluence Cloud / Get content templates

Back to Collection Items

integer li_rc
oleobject loo_Http
integer li_Success
oleobject loo_QueryParams
oleobject loo_Resp
oleobject loo_SbResponseBody
oleobject loo_JResp
integer li_RespStatusCode
string ls_TemplateId
string ls_Name
string ls_Description
string ls_TemplateType
string ls_Body
string ls_Value
string ls_Representation
string ls_Content
string ls_AllValue
string ls_CssValue
string ls_JsValue
string ls_DataValue
string ls_SuperbatchValue
integer j
integer li_Count_j
string ls_Prefix
string ls_Id
string ls_Label
string ls_EntityIdValue
string ls_EntityValue
string ls_Value
integer li_Start
integer li_Limit
integer li_Size
integer i
integer li_Count_i

// 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

loo_QueryParams = create oleobject
li_rc = loo_QueryParams.ConnectToNewObject("Chilkat_9_5_0.JsonObject")

loo_QueryParams.UpdateString("spaceKey","<string>")
loo_QueryParams.UpdateInt("start",0)
loo_QueryParams.UpdateInt("limit",25)
loo_QueryParams.UpdateString("expand","<string>")
loo_QueryParams.UpdateString("expand","<string>")

// Adds the "Authorization: Bearer <access_token>" header.
loo_Http.AuthToken = "<access_token>"

loo_Resp = loo_Http.QuickRequestParams("GET","https://your-domain.atlassian.net/wiki/rest/api/template/page",loo_QueryParams)
if loo_Http.LastMethodSuccess = 0 then
    Write-Debug loo_Http.LastErrorText
    destroy loo_Http
    destroy loo_QueryParams
    return
end if

loo_SbResponseBody = create oleobject
li_rc = loo_SbResponseBody.ConnectToNewObject("Chilkat_9_5_0.StringBuilder")

loo_Resp.GetBodySb(loo_SbResponseBody)

loo_JResp = create oleobject
li_rc = loo_JResp.ConnectToNewObject("Chilkat_9_5_0.JsonObject")

loo_JResp.LoadSb(loo_SbResponseBody)
loo_JResp.EmitCompact = 0

Write-Debug "Response Body:"
Write-Debug loo_JResp.Emit()

li_RespStatusCode = loo_Resp.StatusCode
Write-Debug "Response Status Code = " + string(li_RespStatusCode)
if li_RespStatusCode >= 400 then
    Write-Debug "Response Header:"
    Write-Debug loo_Resp.Header
    Write-Debug "Failed."
    destroy loo_Resp
    destroy loo_Http
    destroy loo_QueryParams
    destroy loo_SbResponseBody
    destroy loo_JResp
    return
end if

destroy loo_Resp

// Sample JSON response:
// (Sample code for parsing the JSON response is shown below)

// {
//   "results": [
//     {
//       "templateId": "pariatur adipisicing non Ut",
//       "name": "enim ullamco officia eu",
//       "description": "culpa",
//       "labels": [
//         {
//           "prefix": "Ut id pariatur",
//           "name": "amet ipsum reprehenderit",
//           "id": "ipsum",
//           "label": "do consectetur"
//         },
//         {
//           "prefix": "irure elit",
//           "name": "laboris cillum dolor pariatur aliquip",
//           "id": "deserunt consectetur d",
//           "label": "nisi ex"
//         }
//       ],
//       "templateType": "sunt eu",
//       "_expandable": {
//         "body": "Excepteur velit aliquip"
//       },
//       "_links": {},
//       "body": {
//         "value": "sint dolor mollit",
//         "representation": "view",
//         "_expandable": {
//           "content": "dolor"
//         },
//         "embeddedContent": [
//           {
//             "entityId": {
//               "value": "<Error: Too many levels of nesting to fake this schema>"
//             },
//             "entity": {
//               "value": "<Error: Too many levels of nesting to fake this schema>"
//             }
//           },
//           {
//             "entityId": {
//               "value": "<Error: Too many levels of nesting to fake this schema>"
//             },
//             "entity": {
//               "value": "<Error: Too many levels of nesting to fake this schema>"
//             }
//           }
//         ],
//         "webresource": {
//           "keys": [
//             {
//               "value": "<Error: Too many levels of nesting to fake this schema>"
//             },
//             {
//               "value": "<Error: Too many levels of nesting to fake this schema>"
//             }
//           ],
//           "contexts": [
//             {
//               "value": "<Error: Too many levels of nesting to fake this schema>"
//             },
//             {
//               "value": "<Error: Too many levels of nesting to fake this schema>"
//             }
//           ],
//           "uris": {
//             "all": {
//               "value": "<Error: Too many levels of nesting to fake this schema>"
//             },
//             "css": {
//               "value": "<Error: Too many levels of nesting to fake this schema>"
//             },
//             "js": {
//               "value": "<Error: Too many levels of nesting to fake this schema>"
//             }
//           },
//           "tags": {
//             "all": {
//               "value": "<Error: Too many levels of nesting to fake this schema>"
//             },
//             "css": {
//               "value": "<Error: Too many levels of nesting to fake this schema>"
//             },
//             "data": {
//               "value": "<Error: Too many levels of nesting to fake this schema>"
//             },
//             "js": {
//               "value": "<Error: Too many levels of nesting to fake this schema>"
//             }
//           },
//           "superbatch": {
//             "value": "<Error: Too many levels of nesting to fake this schema>"
//           }
//         }
//       }
//     },
//     {
//       "templateId": "qui officia aute",
//       "name": "deserunt",
//       "description": "velit laborum cupidatat anim",
//       "labels": [
//         {
//           "prefix": "magna Ut",
//           "name": "culpa quis Duis",
//           "id": "et enim eiusmod quis",
//           "label": "elit qui"
//         },
//         {
//           "prefix": "eu proident",
//           "name": "pariatur non",
//           "id": "magna adipisicing ea amet sunt",
//           "label": "qui"
//         }
//       ],
//       "templateType": "nulla exercitation",
//       "_expandable": {
//         "body": "amet"
//       },
//       "_links": {},
//       "body": {
//         "value": "in ea consectetur",
//         "representation": "storage",
//         "_expandable": {
//           "content": "aliquip magna eu do "
//         },
//         "embeddedContent": [
//           {
//             "entityId": {
//               "value": "<Error: Too many levels of nesting to fake this schema>"
//             },
//             "entity": {
//               "value": "<Error: Too many levels of nesting to fake this schema>"
//             }
//           },
//           {
//             "entityId": {
//               "value": "<Error: Too many levels of nesting to fake this schema>"
//             },
//             "entity": {
//               "value": "<Error: Too many levels of nesting to fake this schema>"
//             }
//           }
//         ],
//         "webresource": {
//           "keys": [
//             {
//               "value": "<Error: Too many levels of nesting to fake this schema>"
//             },
//             {
//               "value": "<Error: Too many levels of nesting to fake this schema>"
//             }
//           ],
//           "contexts": [
//             {
//               "value": "<Error: Too many levels of nesting to fake this schema>"
//             },
//             {
//               "value": "<Error: Too many levels of nesting to fake this schema>"
//             }
//           ],
//           "uris": {
//             "all": {
//               "value": "<Error: Too many levels of nesting to fake this schema>"
//             },
//             "css": {
//               "value": "<Error: Too many levels of nesting to fake this schema>"
//             },
//             "js": {
//               "value": "<Error: Too many levels of nesting to fake this schema>"
//             }
//           },
//           "tags": {
//             "all": {
//               "value": "<Error: Too many levels of nesting to fake this schema>"
//             },
//             "css": {
//               "value": "<Error: Too many levels of nesting to fake this schema>"
//             },
//             "data": {
//               "value": "<Error: Too many levels of nesting to fake this schema>"
//             },
//             "js": {
//               "value": "<Error: Too many levels of nesting to fake this schema>"
//             }
//           },
//           "superbatch": {
//             "value": "<Error: Too many levels of nesting to fake this schema>"
//           }
//         }
//       }
//     }
//   ],
//   "start": -93900983,
//   "limit": -84771492,
//   "size": -63798652,
//   "_links": {}
// }

// Sample code for parsing the JSON response...
// Use this online tool to generate parsing code from sample JSON: Generate JSON Parsing Code

li_Start = loo_JResp.IntOf("start")
li_Limit = loo_JResp.IntOf("limit")
li_Size = loo_JResp.IntOf("size")
i = 0
li_Count_i = loo_JResp.SizeOfArray("results")
do while i < li_Count_i
    loo_JResp.I = i
    ls_TemplateId = loo_JResp.StringOf("results[i].templateId")
    ls_Name = loo_JResp.StringOf("results[i].name")
    ls_Description = loo_JResp.StringOf("results[i].description")
    ls_TemplateType = loo_JResp.StringOf("results[i].templateType")
    ls_Body = loo_JResp.StringOf("results[i]._expandable.body")
    ls_Value = loo_JResp.StringOf("results[i].body.value")
    ls_Representation = loo_JResp.StringOf("results[i].body.representation")
    ls_Content = loo_JResp.StringOf("results[i].body._expandable.content")
    ls_AllValue = loo_JResp.StringOf("results[i].body.webresource.uris.all.value")
    ls_CssValue = loo_JResp.StringOf("results[i].body.webresource.uris.css.value")
    ls_JsValue = loo_JResp.StringOf("results[i].body.webresource.uris.js.value")
    ls_AllValue = loo_JResp.StringOf("results[i].body.webresource.tags.all.value")
    ls_CssValue = loo_JResp.StringOf("results[i].body.webresource.tags.css.value")
    ls_DataValue = loo_JResp.StringOf("results[i].body.webresource.tags.data.value")
    ls_JsValue = loo_JResp.StringOf("results[i].body.webresource.tags.js.value")
    ls_SuperbatchValue = loo_JResp.StringOf("results[i].body.webresource.superbatch.value")
    j = 0
    li_Count_j = loo_JResp.SizeOfArray("results[i].labels")
    do while j < li_Count_j
        loo_JResp.J = j
        ls_Prefix = loo_JResp.StringOf("results[i].labels[j].prefix")
        ls_Name = loo_JResp.StringOf("results[i].labels[j].name")
        ls_Id = loo_JResp.StringOf("results[i].labels[j].id")
        ls_Label = loo_JResp.StringOf("results[i].labels[j].label")
        j = j + 1
    loop
    j = 0
    li_Count_j = loo_JResp.SizeOfArray("results[i].body.embeddedContent")
    do while j < li_Count_j
        loo_JResp.J = j
        ls_EntityIdValue = loo_JResp.StringOf("results[i].body.embeddedContent[j].entityId.value")
        ls_EntityValue = loo_JResp.StringOf("results[i].body.embeddedContent[j].entity.value")
        j = j + 1
    loop
    j = 0
    li_Count_j = loo_JResp.SizeOfArray("results[i].body.webresource.keys")
    do while j < li_Count_j
        loo_JResp.J = j
        ls_Value = loo_JResp.StringOf("results[i].body.webresource.keys[j].value")
        j = j + 1
    loop
    j = 0
    li_Count_j = loo_JResp.SizeOfArray("results[i].body.webresource.contexts")
    do while j < li_Count_j
        loo_JResp.J = j
        ls_Value = loo_JResp.StringOf("results[i].body.webresource.contexts[j].value")
        j = j + 1
    loop
    i = i + 1
loop


destroy loo_Http
destroy loo_QueryParams
destroy loo_SbResponseBody
destroy loo_JResp

Curl Command

curl -G -d "spaceKey=%3Cstring%3E"
	-d "start=0"
	-d "limit=25"
	-d "expand=%3Cstring%3E"
	-d "expand=%3Cstring%3E"
	-H "Authorization: Bearer <access_token>"
https://your-domain.atlassian.net/wiki/rest/api/template/page

Postman Collection Item JSON

{
  "name": "Get content templates",
  "request": {
    "auth": {
      "type": "oauth2"
    },
    "method": "GET",
    "header": [
    ],
    "url": {
      "raw": "{{baseUrl}}/api/template/page?spaceKey=<string>&start=0&limit=25&expand=<string>&expand=<string>",
      "host": [
        "{{baseUrl}}"
      ],
      "path": [
        "api",
        "template",
        "page"
      ],
      "query": [
        {
          "key": "spaceKey",
          "value": "<string>",
          "description": "The key of the space to be queried for templates. If the `spaceKey`\nis not specified, global templates will be returned."
        },
        {
          "key": "start",
          "value": "0",
          "description": "The starting index of the returned templates."
        },
        {
          "key": "limit",
          "value": "25",
          "description": "The maximum number of templates to return per page.\nNote, this may be restricted by fixed system limits."
        },
        {
          "key": "expand",
          "value": "<string>",
          "description": "A multi-value parameter indicating which properties of the template\nto expand.\n\n- `body` returns the content of the template in storage format."
        },
        {
          "key": "expand",
          "value": "<string>",
          "description": "A multi-value parameter indicating which properties of the template\nto expand.\n\n- `body` returns the content of the template in storage format."
        }
      ]
    },
    "description": "Returns all content templates. Use this method to retrieve all global\ncontent templates or all content templates in a space.\n\n**[Permissions](https://confluence.atlassian.com/x/_AozKw) required**:\n'Admin' permission for the space to view space templates and 'Confluence\nAdministrator' global permission to view global templates."
  },
  "response": [
    {
      "name": "Returned if the requested templates are returned.",
      "originalRequest": {
        "method": "GET",
        "header": [
          {
            "description": {
              "content": "Added as a part of security scheme: oauth2",
              "type": "text/plain"
            },
            "key": "Authorization",
            "value": "<token>"
          }
        ],
        "url": {
          "raw": "{{baseUrl}}/api/template/page?spaceKey=<string>&start=0&limit=25&expand=<string>&expand=<string>",
          "host": [
            "{{baseUrl}}"
          ],
          "path": [
            "api",
            "template",
            "page"
          ],
          "query": [
            {
              "key": "spaceKey",
              "value": "<string>"
            },
            {
              "key": "start",
              "value": "0"
            },
            {
              "key": "limit",
              "value": "25"
            },
            {
              "key": "expand",
              "value": "<string>"
            },
            {
              "key": "expand",
              "value": "<string>"
            }
          ]
        }
      },
      "status": "OK",
      "code": 200,
      "_postman_previewlanguage": "json",
      "header": [
        {
          "key": "Content-Type",
          "value": "application/json"
        }
      ],
      "cookie": [
      ],
      "body": "{\n \"results\": [\n  {\n   \"templateId\": \"pariatur adipisicing non Ut\",\n   \"name\": \"enim ullamco officia eu\",\n   \"description\": \"culpa\",\n   \"labels\": [\n    {\n     \"prefix\": \"Ut id pariatur\",\n     \"name\": \"amet ipsum reprehenderit\",\n     \"id\": \"ipsum\",\n     \"label\": \"do consectetur\"\n    },\n    {\n     \"prefix\": \"irure elit\",\n     \"name\": \"laboris cillum dolor pariatur aliquip\",\n     \"id\": \"deserunt consectetur d\",\n     \"label\": \"nisi ex\"\n    }\n   ],\n   \"templateType\": \"sunt eu\",\n   \"_expandable\": {\n    \"body\": \"Excepteur velit aliquip\"\n   },\n   \"_links\": {},\n   \"body\": {\n    \"value\": \"sint dolor mollit\",\n    \"representation\": \"view\",\n    \"_expandable\": {\n     \"content\": \"dolor\"\n    },\n    \"embeddedContent\": [\n     {\n      \"entityId\": {\n       \"value\": \"<Error: Too many levels of nesting to fake this schema>\"\n      },\n      \"entity\": {\n       \"value\": \"<Error: Too many levels of nesting to fake this schema>\"\n      }\n     },\n     {\n      \"entityId\": {\n       \"value\": \"<Error: Too many levels of nesting to fake this schema>\"\n      },\n      \"entity\": {\n       \"value\": \"<Error: Too many levels of nesting to fake this schema>\"\n      }\n     }\n    ],\n    \"webresource\": {\n     \"keys\": [\n      {\n       \"value\": \"<Error: Too many levels of nesting to fake this schema>\"\n      },\n      {\n       \"value\": \"<Error: Too many levels of nesting to fake this schema>\"\n      }\n     ],\n     \"contexts\": [\n      {\n       \"value\": \"<Error: Too many levels of nesting to fake this schema>\"\n      },\n      {\n       \"value\": \"<Error: Too many levels of nesting to fake this schema>\"\n      }\n     ],\n     \"uris\": {\n      \"all\": {\n       \"value\": \"<Error: Too many levels of nesting to fake this schema>\"\n      },\n      \"css\": {\n       \"value\": \"<Error: Too many levels of nesting to fake this schema>\"\n      },\n      \"js\": {\n       \"value\": \"<Error: Too many levels of nesting to fake this schema>\"\n      }\n     },\n     \"tags\": {\n      \"all\": {\n       \"value\": \"<Error: Too many levels of nesting to fake this schema>\"\n      },\n      \"css\": {\n       \"value\": \"<Error: Too many levels of nesting to fake this schema>\"\n      },\n      \"data\": {\n       \"value\": \"<Error: Too many levels of nesting to fake this schema>\"\n      },\n      \"js\": {\n       \"value\": \"<Error: Too many levels of nesting to fake this schema>\"\n      }\n     },\n     \"superbatch\": {\n      \"value\": \"<Error: Too many levels of nesting to fake this schema>\"\n     }\n    }\n   }\n  },\n  {\n   \"templateId\": \"qui officia aute\",\n   \"name\": \"deserunt\",\n   \"description\": \"velit laborum cupidatat anim\",\n   \"labels\": [\n    {\n     \"prefix\": \"magna Ut\",\n     \"name\": \"culpa quis Duis\",\n     \"id\": \"et enim eiusmod quis\",\n     \"label\": \"elit qui\"\n    },\n    {\n     \"prefix\": \"eu proident\",\n     \"name\": \"pariatur non\",\n     \"id\": \"magna adipisicing ea amet sunt\",\n     \"label\": \"qui\"\n    }\n   ],\n   \"templateType\": \"nulla exercitation\",\n   \"_expandable\": {\n    \"body\": \"amet\"\n   },\n   \"_links\": {},\n   \"body\": {\n    \"value\": \"in ea consectetur\",\n    \"representation\": \"storage\",\n    \"_expandable\": {\n     \"content\": \"aliquip magna eu do \"\n    },\n    \"embeddedContent\": [\n     {\n      \"entityId\": {\n       \"value\": \"<Error: Too many levels of nesting to fake this schema>\"\n      },\n      \"entity\": {\n       \"value\": \"<Error: Too many levels of nesting to fake this schema>\"\n      }\n     },\n     {\n      \"entityId\": {\n       \"value\": \"<Error: Too many levels of nesting to fake this schema>\"\n      },\n      \"entity\": {\n       \"value\": \"<Error: Too many levels of nesting to fake this schema>\"\n      }\n     }\n    ],\n    \"webresource\": {\n     \"keys\": [\n      {\n       \"value\": \"<Error: Too many levels of nesting to fake this schema>\"\n      },\n      {\n       \"value\": \"<Error: Too many levels of nesting to fake this schema>\"\n      }\n     ],\n     \"contexts\": [\n      {\n       \"value\": \"<Error: Too many levels of nesting to fake this schema>\"\n      },\n      {\n       \"value\": \"<Error: Too many levels of nesting to fake this schema>\"\n      }\n     ],\n     \"uris\": {\n      \"all\": {\n       \"value\": \"<Error: Too many levels of nesting to fake this schema>\"\n      },\n      \"css\": {\n       \"value\": \"<Error: Too many levels of nesting to fake this schema>\"\n      },\n      \"js\": {\n       \"value\": \"<Error: Too many levels of nesting to fake this schema>\"\n      }\n     },\n     \"tags\": {\n      \"all\": {\n       \"value\": \"<Error: Too many levels of nesting to fake this schema>\"\n      },\n      \"css\": {\n       \"value\": \"<Error: Too many levels of nesting to fake this schema>\"\n      },\n      \"data\": {\n       \"value\": \"<Error: Too many levels of nesting to fake this schema>\"\n      },\n      \"js\": {\n       \"value\": \"<Error: Too many levels of nesting to fake this schema>\"\n      }\n     },\n     \"superbatch\": {\n      \"value\": \"<Error: Too many levels of nesting to fake this schema>\"\n     }\n    }\n   }\n  }\n ],\n \"start\": -93900983,\n \"limit\": -84771492,\n \"size\": -63798652,\n \"_links\": {}\n}"
    },
    {
      "name": "Returned if the calling user does not have permission to view the\ncontent templates.",
      "originalRequest": {
        "method": "GET",
        "header": [
          {
            "description": {
              "content": "Added as a part of security scheme: oauth2",
              "type": "text/plain"
            },
            "key": "Authorization",
            "value": "<token>"
          }
        ],
        "url": {
          "raw": "{{baseUrl}}/api/template/page?spaceKey=<string>&start=0&limit=25&expand=<string>&expand=<string>",
          "host": [
            "{{baseUrl}}"
          ],
          "path": [
            "api",
            "template",
            "page"
          ],
          "query": [
            {
              "key": "spaceKey",
              "value": "<string>"
            },
            {
              "key": "start",
              "value": "0"
            },
            {
              "key": "limit",
              "value": "25"
            },
            {
              "key": "expand",
              "value": "<string>"
            },
            {
              "key": "expand",
              "value": "<string>"
            }
          ]
        }
      },
      "status": "Forbidden",
      "code": 403,
      "_postman_previewlanguage": "text",
      "header": [
        {
          "key": "Content-Type",
          "value": "text/plain"
        }
      ],
      "cookie": [
      ],
      "body": ""
    }
  ]
}