SQL Server / Atlassian Confluence Cloud / Find source entities related to a target entity
Back to Collection Items
-- Important: See this note about string length limitations for strings returned by sp_OAMethod calls.
--
CREATE PROCEDURE ChilkatSample
AS
BEGIN
DECLARE @hr int
DECLARE @iTmp0 int
-- Important: Do not use nvarchar(max). See the warning about using nvarchar(max).
DECLARE @sTmp0 nvarchar(4000)
-- This example assumes the Chilkat API to have been previously unlocked.
-- See Global Unlock Sample for sample code.
DECLARE @http int
-- Use "Chilkat_9_5_0.Http" for versions of Chilkat < 10.0.0
EXEC @hr = sp_OACreate 'Chilkat.Http', @http OUT
IF @hr <> 0
BEGIN
PRINT 'Failed to create ActiveX component'
RETURN
END
DECLARE @success int
DECLARE @queryParams int
-- Use "Chilkat_9_5_0.JsonObject" for versions of Chilkat < 10.0.0
EXEC @hr = sp_OACreate 'Chilkat.JsonObject', @queryParams OUT
EXEC sp_OAMethod @queryParams, 'UpdateString', @success OUT, 'sourceStatus', '<string>'
EXEC sp_OAMethod @queryParams, 'UpdateString', @success OUT, 'targetStatus', '<string>'
EXEC sp_OAMethod @queryParams, 'UpdateString', @success OUT, 'sourceVersion', '<integer>'
EXEC sp_OAMethod @queryParams, 'UpdateString', @success OUT, 'targetVersion', '<integer>'
EXEC sp_OAMethod @queryParams, 'UpdateString', @success OUT, 'expand', '<string>'
EXEC sp_OAMethod @queryParams, 'UpdateString', @success OUT, 'expand', '<string>'
EXEC sp_OAMethod @queryParams, 'UpdateInt', @success OUT, 'start', 0
EXEC sp_OAMethod @queryParams, 'UpdateInt', @success OUT, 'limit', 25
-- Adds the "Authorization: Bearer <access_token>" header.
EXEC sp_OASetProperty @http, 'AuthToken', '<access_token>'
DECLARE @resp int
EXEC sp_OAMethod @http, 'QuickRequestParams', @resp OUT, 'GET', 'https://your-domain.atlassian.net/wiki/rest/api/relation/:relationName/to/:targetType/:targetKey/from/:sourceType', @queryParams
EXEC sp_OAGetProperty @http, 'LastMethodSuccess', @iTmp0 OUT
IF @iTmp0 = 0
BEGIN
EXEC sp_OAGetProperty @http, 'LastErrorText', @sTmp0 OUT
PRINT @sTmp0
EXEC @hr = sp_OADestroy @http
EXEC @hr = sp_OADestroy @queryParams
RETURN
END
DECLARE @sbResponseBody int
-- Use "Chilkat_9_5_0.StringBuilder" for versions of Chilkat < 10.0.0
EXEC @hr = sp_OACreate 'Chilkat.StringBuilder', @sbResponseBody OUT
EXEC sp_OAMethod @resp, 'GetBodySb', @success OUT, @sbResponseBody
DECLARE @jResp int
-- Use "Chilkat_9_5_0.JsonObject" for versions of Chilkat < 10.0.0
EXEC @hr = sp_OACreate 'Chilkat.JsonObject', @jResp OUT
EXEC sp_OAMethod @jResp, 'LoadSb', @success OUT, @sbResponseBody
EXEC sp_OASetProperty @jResp, 'EmitCompact', 0
PRINT 'Response Body:'
EXEC sp_OAMethod @jResp, 'Emit', @sTmp0 OUT
PRINT @sTmp0
DECLARE @respStatusCode int
EXEC sp_OAGetProperty @resp, 'StatusCode', @respStatusCode OUT
PRINT 'Response Status Code = ' + @respStatusCode
IF @respStatusCode >= 400
BEGIN
PRINT 'Response Header:'
EXEC sp_OAGetProperty @resp, 'Header', @sTmp0 OUT
PRINT @sTmp0
PRINT 'Failed.'
EXEC @hr = sp_OADestroy @resp
EXEC @hr = sp_OADestroy @http
EXEC @hr = sp_OADestroy @queryParams
EXEC @hr = sp_OADestroy @sbResponseBody
EXEC @hr = sp_OADestroy @jResp
RETURN
END
EXEC @hr = sp_OADestroy @resp
-- Sample JSON response:
-- (Sample code for parsing the JSON response is shown below)
-- {
-- "results": [
-- {
-- "name": "eiusmod sunt laboris",
-- "_expandable": {
-- "relationData": "velit veniam",
-- "source": "eiusmod",
-- "target": "ea consectetur cupidatat ad adipisicing"
-- },
-- "_links": {},
-- "relationData": {
-- "createdBy": {
-- "type": "user",
-- "accountId": "velit in exercitation laboris",
-- "accountType": "atlassian",
-- "email": "id voluptate",
-- "publicName": "deserunt",
-- "profilePicture": {
-- "path": "ut fugiat",
-- "width": -38683687,
-- "height": 65248683,
-- "isDefault": true
-- },
-- "displayName": "velit commodo ullamco ipsum",
-- "_expandable": {
-- "operations": "id veniam",
-- "details": "pariatur",
-- "personalSpace": "enim nostrud exercitation consequat"
-- },
-- "_links": {},
-- "username": "sed ullamco",
-- "userKey": "esse quis elit",
-- "operations": [
-- {
-- "operation": "read",
-- "targetType": "attachment"
-- },
-- {
-- "operation": "read",
-- "targetType": "page"
-- }
-- ],
-- "details": {
-- "business": {
-- "value": "<Error: Too many levels of nesting to fake this schema>"
-- },
-- "personal": {
-- "value": "<Error: Too many levels of nesting to fake this schema>"
-- }
-- },
-- "personalSpace": {
-- "id": -57606158,
-- "key": "sunt cillum aute",
-- "name": "dolore elit ea in",
-- "type": "non in",
-- "status": "aliquip et anim",
-- "_expandable": {
-- "settings": "ex dolor deserunt anim",
-- "metadata": "dolore qui officia Duis",
-- "operations": "sed laboris",
-- "lookAndFeel": "Duis elit dolore veniam",
-- "permissions": "dolor dolore in",
-- "icon": "reprehenderit pariatur magna labore irure",
-- "description": "Duis aute est fugiat laborum",
-- "theme": "qui nulla est",
-- "history": "non fugiat do",
-- "homepage": "nisi"
-- },
-- "_links": {},
-- "icon": {
-- "path": "est labore",
-- "width": -327281,
-- "height": -79671930,
-- "isDefault": false
-- },
-- "description": {
-- "plain": {
-- "value": "esse dolore",
-- "representation": "view",
-- "embeddedContent": [
-- {
-- "value": "<Error: Too many levels of nesting to fake this schema>"
-- },
-- {
-- "value": "<Error: Too many levels of nesting to fake this schema>"
-- }
-- ]
-- },
-- "view": {
-- "value": "commodo",
-- "representation": "view",
-- "embeddedContent": [
-- {
-- "value": "<Error: Too many levels of nesting to fake this schema>"
-- },
-- {
-- "value": "<Error: Too many levels of nesting to fake this schema>"
-- }
-- ]
-- }
-- },
-- "homepage": {
-- "value": "<Circular reference to #/components/schemas/Content detected>"
-- },
-- "metadata": {
-- "labels": {
-- "results": [
-- {
-- "value": "<Error: Too many levels of nesting to fake this schema>"
-- },
-- {
-- "value": "<Error: Too many levels of nesting to fake this schema>"
-- }
-- ],
-- "start": -56637757,
-- "limit": 1062771,
-- "size": 37957067,
-- "_links": {}
-- }
-- },
-- "operations": [
-- {
-- "operation": "update",
-- "targetType": "page"
-- },
-- {
-- "operation": "move",
-- "targetType": "attachment"
-- }
-- ],
-- "permissions": [
-- {
-- "subjects": {
-- "_expandable": {
-- "value": "<Error: Too many levels of nesting to fake this schema>"
-- },
-- "user": {
-- "value": "<Error: Too many levels of nesting to fake this schema>"
-- },
-- "group": {
-- "value": "<Error: Too many levels of nesting to fake this schema>"
-- }
-- },
-- "operation": {
-- "operation": "purge_version",
-- "targetType": "page"
-- },
-- "anonymousAccess": false,
-- "unlicensedAccess": false
-- },
-- {
-- "subjects": {
-- "_expandable": {
-- "value": "<Error: Too many levels of nesting to fake this schema>"
-- },
-- "user": {
-- "value": "<Error: Too many levels of nesting to fake this schema>"
-- },
-- "group": {
-- "value": "<Error: Too many levels of nesting to fake this schema>"
-- }
-- },
-- "operation": {
-- "operation": "purge",
-- "targetType": "page"
-- },
-- "anonymousAccess": false,
-- "unlicensedAccess": false
-- }
-- ],
-- "settings": {
-- "routeOverrideEnabled": true,
-- "_links": {}
-- },
-- "theme": {},
-- "lookAndFeel": {
-- "headings": {
-- "color": "se"
-- },
-- "links": {
-- "color": "sit"
-- },
-- "menus": {
-- "hoverOrFocus": {
-- "value": "<Error: Too many levels of nesting to fake this schema>"
-- },
-- "color": {
-- "value": "<Error: Too many levels of nesting to fake this schema>"
-- }
-- },
-- "header": {
-- "backgroundColor": {
-- "value": "<Error: Too many levels of nesting to fake this schema>"
-- },
-- "button": {
-- "value": "<Error: Too many levels of nesting to fake this schema>"
-- },
-- "primaryNavigation": {
-- "value": "<Error: Too many levels of nesting to fake this schema>"
-- },
-- "secondaryNavigation": {
-- "value": "<Error: Too many levels of nesting to fake this schema>"
-- },
-- "search": {
-- "value": "<Error: Too many levels of nesting to fake this schema>"
-- }
-- },
-- "content": {
-- "screen": {
-- "value": "<Error: Too many levels of nesting to fake this schema>"
-- },
-- "container": {
-- "value": "<Error: Too many levels of nesting to fake this schema>"
-- },
-- "header": {
-- "value": "<Error: Too many levels of nesting to fake this schema>"
-- },
-- "body": {
-- "value": "<Error: Too many levels of nesting to fake this schema>"
-- }
-- },
-- "bordersAndDividers": {
-- "color": "magna consequat"
-- }
-- },
-- "history": {
-- "createdDate": "1951-04-28T13:26:19.420Z"
-- }
-- }
-- },
-- "createdDate": "1945-06-14T04:34:24.316Z",
-- "friendlyCreatedDate": "reprehenderit "
-- },
-- "source": {},
-- "target": {}
-- },
-- {
-- "name": "consectetur Ut enim occaec",
-- "_expandable": {
-- "relationData": "in est qui",
-- "source": "incididunt",
-- "target": "laborum magna proident amet aliquip"
-- },
-- "_links": {},
-- "relationData": {
-- "createdBy": {
-- "type": "user",
-- "accountId": "cillu",
-- "accountType": "app (if this user is a bot user created on behalf of an Atlassian app)",
-- "email": "enim eu",
-- "publicName": "eu aute in",
-- "profilePicture": {
-- "path": "non",
-- "width": -48499479,
-- "height": 87770702,
-- "isDefault": true
-- },
-- "displayName": "dolore ut",
-- "_expandable": {
-- "operations": "magna pariatur eiusmod nisi",
-- "details": "non consectetur",
-- "personalSpace": "nostrud"
-- },
-- "_links": {},
-- "username": "anim aliquip eu amet",
-- "userKey": "dolore ullamco nostrud laboris",
-- "operations": [
-- {
-- "operation": "administer",
-- "targetType": "comment"
-- },
-- {
-- "operation": "export",
-- "targetType": "space"
-- }
-- ],
-- "details": {
-- "business": {
-- "value": "<Error: Too many levels of nesting to fake this schema>"
-- },
-- "personal": {
-- "value": "<Error: Too many levels of nesting to fake this schema>"
-- }
-- },
-- "personalSpace": {
-- "id": 96005227,
-- "key": "elit eiusmod ad",
-- "name": "in tempor ad",
-- "type": "et elit officia",
-- "status": "dolore",
-- "_expandable": {
-- "settings": "ad aliquip nisi sed",
-- "metadata": "ut cupidatat",
-- "operations": "veniam sit",
-- "lookAndFeel": "anim ex",
-- "permissions": "mollit qui Lorem nulla quis",
-- "icon": "amet fugiat dolor cupidatat",
-- "description": "consequat anim",
-- "theme": "ipsum",
-- "history": "aliqua Dui",
-- "homepage": "voluptate consectetur do Ut ut"
-- },
-- "_links": {},
-- "icon": {
-- "path": "ex minim consectetur",
-- "width": -35571565,
-- "height": -58278363,
-- "isDefault": false
-- },
-- "description": {
-- "plain": {
-- "value": "dolor exercitation",
-- "representation": "plain",
-- "embeddedContent": [
-- {
-- "value": "<Error: Too many levels of nesting to fake this schema>"
-- },
-- {
-- "value": "<Error: Too many levels of nesting to fake this schema>"
-- }
-- ]
-- },
-- "view": {
-- "value": "velit irure laborum id nostrud",
-- "representation": "view",
-- "embeddedContent": [
-- {
-- "value": "<Error: Too many levels of nesting to fake this schema>"
-- },
-- {
-- "value": "<Error: Too many levels of nesting to fake this schema>"
-- }
-- ]
-- }
-- },
-- "homepage": {
-- "value": "<Circular reference to #/components/schemas/Content detected>"
-- },
-- "metadata": {
-- "labels": {
-- "results": [
-- {
-- "value": "<Error: Too many levels of nesting to fake this schema>"
-- },
-- {
-- "value": "<Error: Too many levels of nesting to fake this schema>"
-- }
-- ],
-- "start": 36294069,
-- "limit": -28282967,
-- "size": 56940014,
-- "_links": {}
-- }
-- },
-- "operations": [
-- {
-- "operation": "administer",
-- "targetType": "blogpost"
-- },
-- {
-- "operation": "read",
-- "targetType": "application"
-- }
-- ],
-- "permissions": [
-- {
-- "subjects": {
-- "_expandable": {
-- "value": "<Error: Too many levels of nesting to fake this schema>"
-- },
-- "user": {
-- "value": "<Error: Too many levels of nesting to fake this schema>"
-- },
-- "group": {
-- "value": "<Error: Too many levels of nesting to fake this schema>"
-- }
-- },
-- "operation": {
-- "operation": "purge",
-- "targetType": "attachment"
-- },
-- "anonymousAccess": false,
-- "unlicensedAccess": false
-- },
-- {
-- "subjects": {
-- "_expandable": {
-- "value": "<Error: Too many levels of nesting to fake this schema>"
-- },
-- "user": {
-- "value": "<Error: Too many levels of nesting to fake this schema>"
-- },
-- "group": {
-- "value": "<Error: Too many levels of nesting to fake this schema>"
-- }
-- },
-- "operation": {
-- "operation": "create",
-- "targetType": "space"
-- },
-- "anonymousAccess": false,
-- "unlicensedAccess": false
-- }
-- ],
-- "settings": {
-- "routeOverrideEnabled": false,
-- "_links": {}
-- },
-- "theme": {},
-- "lookAndFeel": {
-- "headings": {
-- "color": "dolore consequat occaeca"
-- },
-- "links": {
-- "color": "occaecat ut sit"
-- },
-- "menus": {
-- "hoverOrFocus": {
-- "value": "<Error: Too many levels of nesting to fake this schema>"
-- },
-- "color": {
-- "value": "<Error: Too many levels of nesting to fake this schema>"
-- }
-- },
-- "header": {
-- "backgroundColor": {
-- "value": "<Error: Too many levels of nesting to fake this schema>"
-- },
-- "button": {
-- "value": "<Error: Too many levels of nesting to fake this schema>"
-- },
-- "primaryNavigation": {
-- "value": "<Error: Too many levels of nesting to fake this schema>"
-- },
-- "secondaryNavigation": {
-- "value": "<Error: Too many levels of nesting to fake this schema>"
-- },
-- "search": {
-- "value": "<Error: Too many levels of nesting to fake this schema>"
-- }
-- },
-- "content": {
-- "screen": {
-- "value": "<Error: Too many levels of nesting to fake this schema>"
-- },
-- "container": {
-- "value": "<Error: Too many levels of nesting to fake this schema>"
-- },
-- "header": {
-- "value": "<Error: Too many levels of nesting to fake this schema>"
-- },
-- "body": {
-- "value": "<Error: Too many levels of nesting to fake this schema>"
-- }
-- },
-- "bordersAndDividers": {
-- "color": "deserunt Duis laborum ad"
-- }
-- },
-- "history": {
-- "createdDate": "1977-01-29T01:15:06.769Z"
-- }
-- }
-- },
-- "createdDate": "2018-11-14T12:56:13.456Z",
-- "friendlyCreatedDate": "reprehenderit laborum"
-- },
-- "source": {},
-- "target": {}
-- }
-- ],
-- "start": -48357202,
-- "limit": 5335291,
-- "size": 43833338,
-- "_links": {}
-- }
-- Sample code for parsing the JSON response...
-- Use this online tool to generate parsing code from sample JSON: Generate JSON Parsing Code
DECLARE @name nvarchar(4000)
DECLARE @RelationData nvarchar(4000)
DECLARE @Source nvarchar(4000)
DECLARE @Target nvarchar(4000)
DECLARE @v_Type nvarchar(4000)
DECLARE @AccountId nvarchar(4000)
DECLARE @AccountType nvarchar(4000)
DECLARE @v_Email nvarchar(4000)
DECLARE @PublicName nvarchar(4000)
DECLARE @Path nvarchar(4000)
DECLARE @Width int
DECLARE @Height int
DECLARE @IsDefault int
DECLARE @DisplayName nvarchar(4000)
DECLARE @Operations nvarchar(4000)
DECLARE @Details nvarchar(4000)
DECLARE @PersonalSpace nvarchar(4000)
DECLARE @Username nvarchar(4000)
DECLARE @UserKey nvarchar(4000)
DECLARE @Value nvarchar(4000)
DECLARE @PersonalValue nvarchar(4000)
DECLARE @Id int
DECLARE @Key nvarchar(4000)
DECLARE @Name nvarchar(4000)
DECLARE @PersonalSpaceType nvarchar(4000)
DECLARE @Status nvarchar(4000)
DECLARE @Settings nvarchar(4000)
DECLARE @Metadata nvarchar(4000)
DECLARE @v_expandableOperations nvarchar(4000)
DECLARE @LookAndFeel nvarchar(4000)
DECLARE @Permissions nvarchar(4000)
DECLARE @Icon nvarchar(4000)
DECLARE @Description nvarchar(4000)
DECLARE @Theme nvarchar(4000)
DECLARE @History nvarchar(4000)
DECLARE @Homepage nvarchar(4000)
DECLARE @IconPath nvarchar(4000)
DECLARE @IconWidth int
DECLARE @IconHeight int
DECLARE @IconIsDefault int
DECLARE @PlainValue nvarchar(4000)
DECLARE @Representation nvarchar(4000)
DECLARE @ViewValue nvarchar(4000)
DECLARE @ViewRepresentation nvarchar(4000)
DECLARE @HomepageValue nvarchar(4000)
DECLARE @Start int
DECLARE @Limit int
DECLARE @Size int
DECLARE @RouteOverrideEnabled int
DECLARE @Color nvarchar(4000)
DECLARE @LinksColor nvarchar(4000)
DECLARE @HoverOrFocusValue nvarchar(4000)
DECLARE @ColorValue nvarchar(4000)
DECLARE @BackgroundColorValue nvarchar(4000)
DECLARE @ButtonValue nvarchar(4000)
DECLARE @PrimaryNavigationValue nvarchar(4000)
DECLARE @SecondaryNavigationValue nvarchar(4000)
DECLARE @SearchValue nvarchar(4000)
DECLARE @ScreenValue nvarchar(4000)
DECLARE @ContainerValue nvarchar(4000)
DECLARE @HeaderValue nvarchar(4000)
DECLARE @BodyValue nvarchar(4000)
DECLARE @BordersAndDividersColor nvarchar(4000)
DECLARE @CreatedDate nvarchar(4000)
DECLARE @relationDataCreatedDate nvarchar(4000)
DECLARE @FriendlyCreatedDate nvarchar(4000)
DECLARE @j int
DECLARE @count_j int
DECLARE @operation nvarchar(4000)
DECLARE @targetType nvarchar(4000)
DECLARE @value nvarchar(4000)
DECLARE @v_expandableValue nvarchar(4000)
DECLARE @UserValue nvarchar(4000)
DECLARE @GroupValue nvarchar(4000)
DECLARE @Operation nvarchar(4000)
DECLARE @TargetType nvarchar(4000)
DECLARE @anonymousAccess int
DECLARE @unlicensedAccess int
DECLARE @start int
EXEC sp_OAMethod @jResp, 'IntOf', @start OUT, 'start'
DECLARE @limit int
EXEC sp_OAMethod @jResp, 'IntOf', @limit OUT, 'limit'
DECLARE @size int
EXEC sp_OAMethod @jResp, 'IntOf', @size OUT, 'size'
DECLARE @i int
SELECT @i = 0
DECLARE @count_i int
EXEC sp_OAMethod @jResp, 'SizeOfArray', @count_i OUT, 'results'
WHILE @i < @count_i
BEGIN
EXEC sp_OASetProperty @jResp, 'I', @i
EXEC sp_OAMethod @jResp, 'StringOf', @name OUT, 'results[i].name'
EXEC sp_OAMethod @jResp, 'StringOf', @RelationData OUT, 'results[i]._expandable.relationData'
EXEC sp_OAMethod @jResp, 'StringOf', @Source OUT, 'results[i]._expandable.source'
EXEC sp_OAMethod @jResp, 'StringOf', @Target OUT, 'results[i]._expandable.target'
EXEC sp_OAMethod @jResp, 'StringOf', @v_Type OUT, 'results[i].relationData.createdBy.type'
EXEC sp_OAMethod @jResp, 'StringOf', @AccountId OUT, 'results[i].relationData.createdBy.accountId'
EXEC sp_OAMethod @jResp, 'StringOf', @AccountType OUT, 'results[i].relationData.createdBy.accountType'
EXEC sp_OAMethod @jResp, 'StringOf', @v_Email OUT, 'results[i].relationData.createdBy.email'
EXEC sp_OAMethod @jResp, 'StringOf', @PublicName OUT, 'results[i].relationData.createdBy.publicName'
EXEC sp_OAMethod @jResp, 'StringOf', @Path OUT, 'results[i].relationData.createdBy.profilePicture.path'
EXEC sp_OAMethod @jResp, 'IntOf', @Width OUT, 'results[i].relationData.createdBy.profilePicture.width'
EXEC sp_OAMethod @jResp, 'IntOf', @Height OUT, 'results[i].relationData.createdBy.profilePicture.height'
EXEC sp_OAMethod @jResp, 'BoolOf', @IsDefault OUT, 'results[i].relationData.createdBy.profilePicture.isDefault'
EXEC sp_OAMethod @jResp, 'StringOf', @DisplayName OUT, 'results[i].relationData.createdBy.displayName'
EXEC sp_OAMethod @jResp, 'StringOf', @Operations OUT, 'results[i].relationData.createdBy._expandable.operations'
EXEC sp_OAMethod @jResp, 'StringOf', @Details OUT, 'results[i].relationData.createdBy._expandable.details'
EXEC sp_OAMethod @jResp, 'StringOf', @PersonalSpace OUT, 'results[i].relationData.createdBy._expandable.personalSpace'
EXEC sp_OAMethod @jResp, 'StringOf', @Username OUT, 'results[i].relationData.createdBy.username'
EXEC sp_OAMethod @jResp, 'StringOf', @UserKey OUT, 'results[i].relationData.createdBy.userKey'
EXEC sp_OAMethod @jResp, 'StringOf', @Value OUT, 'results[i].relationData.createdBy.details.business.value'
EXEC sp_OAMethod @jResp, 'StringOf', @PersonalValue OUT, 'results[i].relationData.createdBy.details.personal.value'
EXEC sp_OAMethod @jResp, 'IntOf', @Id OUT, 'results[i].relationData.createdBy.personalSpace.id'
EXEC sp_OAMethod @jResp, 'StringOf', @Key OUT, 'results[i].relationData.createdBy.personalSpace.key'
EXEC sp_OAMethod @jResp, 'StringOf', @Name OUT, 'results[i].relationData.createdBy.personalSpace.name'
EXEC sp_OAMethod @jResp, 'StringOf', @PersonalSpaceType OUT, 'results[i].relationData.createdBy.personalSpace.type'
EXEC sp_OAMethod @jResp, 'StringOf', @Status OUT, 'results[i].relationData.createdBy.personalSpace.status'
EXEC sp_OAMethod @jResp, 'StringOf', @Settings OUT, 'results[i].relationData.createdBy.personalSpace._expandable.settings'
EXEC sp_OAMethod @jResp, 'StringOf', @Metadata OUT, 'results[i].relationData.createdBy.personalSpace._expandable.metadata'
EXEC sp_OAMethod @jResp, 'StringOf', @v_expandableOperations OUT, 'results[i].relationData.createdBy.personalSpace._expandable.operations'
EXEC sp_OAMethod @jResp, 'StringOf', @LookAndFeel OUT, 'results[i].relationData.createdBy.personalSpace._expandable.lookAndFeel'
EXEC sp_OAMethod @jResp, 'StringOf', @Permissions OUT, 'results[i].relationData.createdBy.personalSpace._expandable.permissions'
EXEC sp_OAMethod @jResp, 'StringOf', @Icon OUT, 'results[i].relationData.createdBy.personalSpace._expandable.icon'
EXEC sp_OAMethod @jResp, 'StringOf', @Description OUT, 'results[i].relationData.createdBy.personalSpace._expandable.description'
EXEC sp_OAMethod @jResp, 'StringOf', @Theme OUT, 'results[i].relationData.createdBy.personalSpace._expandable.theme'
EXEC sp_OAMethod @jResp, 'StringOf', @History OUT, 'results[i].relationData.createdBy.personalSpace._expandable.history'
EXEC sp_OAMethod @jResp, 'StringOf', @Homepage OUT, 'results[i].relationData.createdBy.personalSpace._expandable.homepage'
EXEC sp_OAMethod @jResp, 'StringOf', @IconPath OUT, 'results[i].relationData.createdBy.personalSpace.icon.path'
EXEC sp_OAMethod @jResp, 'IntOf', @IconWidth OUT, 'results[i].relationData.createdBy.personalSpace.icon.width'
EXEC sp_OAMethod @jResp, 'IntOf', @IconHeight OUT, 'results[i].relationData.createdBy.personalSpace.icon.height'
EXEC sp_OAMethod @jResp, 'BoolOf', @IconIsDefault OUT, 'results[i].relationData.createdBy.personalSpace.icon.isDefault'
EXEC sp_OAMethod @jResp, 'StringOf', @PlainValue OUT, 'results[i].relationData.createdBy.personalSpace.description.plain.value'
EXEC sp_OAMethod @jResp, 'StringOf', @Representation OUT, 'results[i].relationData.createdBy.personalSpace.description.plain.representation'
EXEC sp_OAMethod @jResp, 'StringOf', @ViewValue OUT, 'results[i].relationData.createdBy.personalSpace.description.view.value'
EXEC sp_OAMethod @jResp, 'StringOf', @ViewRepresentation OUT, 'results[i].relationData.createdBy.personalSpace.description.view.representation'
EXEC sp_OAMethod @jResp, 'StringOf', @HomepageValue OUT, 'results[i].relationData.createdBy.personalSpace.homepage.value'
EXEC sp_OAMethod @jResp, 'IntOf', @Start OUT, 'results[i].relationData.createdBy.personalSpace.metadata.labels.start'
EXEC sp_OAMethod @jResp, 'IntOf', @Limit OUT, 'results[i].relationData.createdBy.personalSpace.metadata.labels.limit'
EXEC sp_OAMethod @jResp, 'IntOf', @Size OUT, 'results[i].relationData.createdBy.personalSpace.metadata.labels.size'
EXEC sp_OAMethod @jResp, 'BoolOf', @RouteOverrideEnabled OUT, 'results[i].relationData.createdBy.personalSpace.settings.routeOverrideEnabled'
EXEC sp_OAMethod @jResp, 'StringOf', @Color OUT, 'results[i].relationData.createdBy.personalSpace.lookAndFeel.headings.color'
EXEC sp_OAMethod @jResp, 'StringOf', @LinksColor OUT, 'results[i].relationData.createdBy.personalSpace.lookAndFeel.links.color'
EXEC sp_OAMethod @jResp, 'StringOf', @HoverOrFocusValue OUT, 'results[i].relationData.createdBy.personalSpace.lookAndFeel.menus.hoverOrFocus.value'
EXEC sp_OAMethod @jResp, 'StringOf', @ColorValue OUT, 'results[i].relationData.createdBy.personalSpace.lookAndFeel.menus.color.value'
EXEC sp_OAMethod @jResp, 'StringOf', @BackgroundColorValue OUT, 'results[i].relationData.createdBy.personalSpace.lookAndFeel.header.backgroundColor.value'
EXEC sp_OAMethod @jResp, 'StringOf', @ButtonValue OUT, 'results[i].relationData.createdBy.personalSpace.lookAndFeel.header.button.value'
EXEC sp_OAMethod @jResp, 'StringOf', @PrimaryNavigationValue OUT, 'results[i].relationData.createdBy.personalSpace.lookAndFeel.header.primaryNavigation.value'
EXEC sp_OAMethod @jResp, 'StringOf', @SecondaryNavigationValue OUT, 'results[i].relationData.createdBy.personalSpace.lookAndFeel.header.secondaryNavigation.value'
EXEC sp_OAMethod @jResp, 'StringOf', @SearchValue OUT, 'results[i].relationData.createdBy.personalSpace.lookAndFeel.header.search.value'
EXEC sp_OAMethod @jResp, 'StringOf', @ScreenValue OUT, 'results[i].relationData.createdBy.personalSpace.lookAndFeel.content.screen.value'
EXEC sp_OAMethod @jResp, 'StringOf', @ContainerValue OUT, 'results[i].relationData.createdBy.personalSpace.lookAndFeel.content.container.value'
EXEC sp_OAMethod @jResp, 'StringOf', @HeaderValue OUT, 'results[i].relationData.createdBy.personalSpace.lookAndFeel.content.header.value'
EXEC sp_OAMethod @jResp, 'StringOf', @BodyValue OUT, 'results[i].relationData.createdBy.personalSpace.lookAndFeel.content.body.value'
EXEC sp_OAMethod @jResp, 'StringOf', @BordersAndDividersColor OUT, 'results[i].relationData.createdBy.personalSpace.lookAndFeel.bordersAndDividers.color'
EXEC sp_OAMethod @jResp, 'StringOf', @CreatedDate OUT, 'results[i].relationData.createdBy.personalSpace.history.createdDate'
EXEC sp_OAMethod @jResp, 'StringOf', @relationDataCreatedDate OUT, 'results[i].relationData.createdDate'
EXEC sp_OAMethod @jResp, 'StringOf', @FriendlyCreatedDate OUT, 'results[i].relationData.friendlyCreatedDate'
SELECT @j = 0
EXEC sp_OAMethod @jResp, 'SizeOfArray', @count_j OUT, 'results[i].relationData.createdBy.operations'
WHILE @j < @count_j
BEGIN
EXEC sp_OASetProperty @jResp, 'J', @j
EXEC sp_OAMethod @jResp, 'StringOf', @operation OUT, 'results[i].relationData.createdBy.operations[j].operation'
EXEC sp_OAMethod @jResp, 'StringOf', @targetType OUT, 'results[i].relationData.createdBy.operations[j].targetType'
SELECT @j = @j + 1
END
SELECT @j = 0
EXEC sp_OAMethod @jResp, 'SizeOfArray', @count_j OUT, 'results[i].relationData.createdBy.personalSpace.description.plain.embeddedContent'
WHILE @j < @count_j
BEGIN
EXEC sp_OASetProperty @jResp, 'J', @j
EXEC sp_OAMethod @jResp, 'StringOf', @value OUT, 'results[i].relationData.createdBy.personalSpace.description.plain.embeddedContent[j].value'
SELECT @j = @j + 1
END
SELECT @j = 0
EXEC sp_OAMethod @jResp, 'SizeOfArray', @count_j OUT, 'results[i].relationData.createdBy.personalSpace.description.view.embeddedContent'
WHILE @j < @count_j
BEGIN
EXEC sp_OASetProperty @jResp, 'J', @j
EXEC sp_OAMethod @jResp, 'StringOf', @value OUT, 'results[i].relationData.createdBy.personalSpace.description.view.embeddedContent[j].value'
SELECT @j = @j + 1
END
SELECT @j = 0
EXEC sp_OAMethod @jResp, 'SizeOfArray', @count_j OUT, 'results[i].relationData.createdBy.personalSpace.metadata.labels.results'
WHILE @j < @count_j
BEGIN
EXEC sp_OASetProperty @jResp, 'J', @j
EXEC sp_OAMethod @jResp, 'StringOf', @value OUT, 'results[i].relationData.createdBy.personalSpace.metadata.labels.results[j].value'
SELECT @j = @j + 1
END
SELECT @j = 0
EXEC sp_OAMethod @jResp, 'SizeOfArray', @count_j OUT, 'results[i].relationData.createdBy.personalSpace.operations'
WHILE @j < @count_j
BEGIN
EXEC sp_OASetProperty @jResp, 'J', @j
EXEC sp_OAMethod @jResp, 'StringOf', @operation OUT, 'results[i].relationData.createdBy.personalSpace.operations[j].operation'
EXEC sp_OAMethod @jResp, 'StringOf', @targetType OUT, 'results[i].relationData.createdBy.personalSpace.operations[j].targetType'
SELECT @j = @j + 1
END
SELECT @j = 0
EXEC sp_OAMethod @jResp, 'SizeOfArray', @count_j OUT, 'results[i].relationData.createdBy.personalSpace.permissions'
WHILE @j < @count_j
BEGIN
EXEC sp_OASetProperty @jResp, 'J', @j
EXEC sp_OAMethod @jResp, 'StringOf', @v_expandableValue OUT, 'results[i].relationData.createdBy.personalSpace.permissions[j].subjects._expandable.value'
EXEC sp_OAMethod @jResp, 'StringOf', @UserValue OUT, 'results[i].relationData.createdBy.personalSpace.permissions[j].subjects.user.value'
EXEC sp_OAMethod @jResp, 'StringOf', @GroupValue OUT, 'results[i].relationData.createdBy.personalSpace.permissions[j].subjects.group.value'
EXEC sp_OAMethod @jResp, 'StringOf', @Operation OUT, 'results[i].relationData.createdBy.personalSpace.permissions[j].operation.operation'
EXEC sp_OAMethod @jResp, 'StringOf', @TargetType OUT, 'results[i].relationData.createdBy.personalSpace.permissions[j].operation.targetType'
EXEC sp_OAMethod @jResp, 'BoolOf', @anonymousAccess OUT, 'results[i].relationData.createdBy.personalSpace.permissions[j].anonymousAccess'
EXEC sp_OAMethod @jResp, 'BoolOf', @unlicensedAccess OUT, 'results[i].relationData.createdBy.personalSpace.permissions[j].unlicensedAccess'
SELECT @j = @j + 1
END
SELECT @i = @i + 1
END
EXEC @hr = sp_OADestroy @http
EXEC @hr = sp_OADestroy @queryParams
EXEC @hr = sp_OADestroy @sbResponseBody
EXEC @hr = sp_OADestroy @jResp
END
GO
Curl Command
curl -G -d "sourceStatus=%3Cstring%3E"
-d "targetStatus=%3Cstring%3E"
-d "sourceVersion=%3Cinteger%3E"
-d "targetVersion=%3Cinteger%3E"
-d "expand=%3Cstring%3E"
-d "expand=%3Cstring%3E"
-d "start=0"
-d "limit=25"
-H "Authorization: Bearer <access_token>"
https://your-domain.atlassian.net/wiki/rest/api/relation/:relationName/to/:targetType/:targetKey/from/:sourceType
Postman Collection Item JSON
{
"name": "Find source entities related to a target entity",
"request": {
"auth": {
"type": "oauth2"
},
"method": "GET",
"header": [
],
"url": {
"raw": "{{baseUrl}}/api/relation/:relationName/to/:targetType/:targetKey/from/:sourceType?sourceStatus=<string>&targetStatus=<string>&sourceVersion=<integer>&targetVersion=<integer>&expand=<string>&expand=<string>&start=0&limit=25",
"host": [
"{{baseUrl}}"
],
"path": [
"api",
"relation",
":relationName",
"to",
":targetType",
":targetKey",
"from",
":sourceType"
],
"query": [
{
"key": "sourceStatus",
"value": "<string>",
"description": "The status of the source. This parameter is only used when the\n`sourceType` is 'content'."
},
{
"key": "targetStatus",
"value": "<string>",
"description": "The status of the target. This parameter is only used when the\n`targetType` is 'content'."
},
{
"key": "sourceVersion",
"value": "<integer>",
"description": "The version of the source. This parameter is only used when the\n`sourceType` is 'content' and the `sourceStatus` is 'historical'."
},
{
"key": "targetVersion",
"value": "<integer>",
"description": "The version of the target. This parameter is only used when the\n`targetType` is 'content' and the `targetStatus` is 'historical'."
},
{
"key": "expand",
"value": "<string>",
"description": "A multi-value parameter indicating which properties of the response\nobject to expand.\n\n- `relationData` returns information about the relationship, such as\nwho created it and when it was created.\n- `source` returns the source entity.\n- `target` returns the target entity."
},
{
"key": "expand",
"value": "<string>",
"description": "A multi-value parameter indicating which properties of the response\nobject to expand.\n\n- `relationData` returns information about the relationship, such as\nwho created it and when it was created.\n- `source` returns the source entity.\n- `target` returns the target entity."
},
{
"key": "start",
"value": "0",
"description": "The starting index of the returned relationships."
},
{
"key": "limit",
"value": "25",
"description": "The maximum number of relationships to return per page.\nNote, this may be restricted by fixed system limits."
}
],
"variable": [
{
"key": "relationName",
"value": "<string>",
"type": "string",
"description": "(Required) The name of the relationship. This method supports relationships created via\n[Create relationship](#api-relation-relationName-from-sourceType-sourceKey-to-targetType-targetKey-put).\nNote, this method does not support 'favourite' relationships."
},
{
"key": "sourceType",
"value": "<string>",
"type": "string",
"description": "(Required) The source entity type of the relationship."
},
{
"key": "targetType",
"value": "<string>",
"type": "string",
"description": "(Required) The target entity type of the relationship."
},
{
"key": "targetKey",
"value": "<string>",
"type": "string",
"description": "(Required) The identifier for the target entity:\n\n- If `targetType` is `user`, then specify either `current` (logged-in user), the user key of the user, or\nthe account ID of the user. Note that the user key has been deprecated in favor of the account ID for this parameter. See the\n[migration guide](https://developer.atlassian.com/cloud/confluence/deprecation-notice-user-privacy-api-migration-guide/)\nfor details.\n- If `targetType` is 'content', then specify the content ID.\n- If `targetType` is 'space', then specify the space key."
}
]
},
"description": "Returns all target entities that have a particular relationship to the\nsource entity. Note, relationships are one way.\n\nFor example, the following method finds all users that have a 'collaborator'\nrelationship to a piece of content with an ID of '1234':\n`GET https://your-domain.atlassian.net/wiki/rest/api/relation/collaborator/to/content/1234/from/user`\nNote, 'collaborator' is an example custom relationship type.\n\n**[Permissions](https://confluence.atlassian.com/x/_AozKw) required**:\nPermission to view both the target entity and source entity."
},
"response": [
{
"name": "Returned if the requested relationships 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/relation/:relationName/to/:targetType/:targetKey/from/:sourceType?sourceStatus=<string>&targetStatus=<string>&sourceVersion=<integer>&targetVersion=<integer>&expand=<string>&expand=<string>&start=0&limit=25",
"host": [
"{{baseUrl}}"
],
"path": [
"api",
"relation",
":relationName",
"to",
":targetType",
":targetKey",
"from",
":sourceType"
],
"query": [
{
"key": "sourceStatus",
"value": "<string>"
},
{
"key": "targetStatus",
"value": "<string>"
},
{
"key": "sourceVersion",
"value": "<integer>"
},
{
"key": "targetVersion",
"value": "<integer>"
},
{
"key": "expand",
"value": "<string>"
},
{
"key": "expand",
"value": "<string>"
},
{
"key": "start",
"value": "0"
},
{
"key": "limit",
"value": "25"
}
],
"variable": [
{
"key": "relationName"
},
{
"key": "targetType"
},
{
"key": "targetKey"
},
{
"key": "sourceType"
}
]
}
},
"status": "OK",
"code": 200,
"_postman_previewlanguage": "json",
"header": [
{
"key": "Content-Type",
"value": "application/json"
}
],
"cookie": [
],
"body": "{\n \"results\": [\n {\n \"name\": \"eiusmod sunt laboris\",\n \"_expandable\": {\n \"relationData\": \"velit veniam\",\n \"source\": \"eiusmod\",\n \"target\": \"ea consectetur cupidatat ad adipisicing\"\n },\n \"_links\": {},\n \"relationData\": {\n \"createdBy\": {\n \"type\": \"user\",\n \"accountId\": \"velit in exercitation laboris\",\n \"accountType\": \"atlassian\",\n \"email\": \"id voluptate\",\n \"publicName\": \"deserunt\",\n \"profilePicture\": {\n \"path\": \"ut fugiat\",\n \"width\": -38683687,\n \"height\": 65248683,\n \"isDefault\": true\n },\n \"displayName\": \"velit commodo ullamco ipsum\",\n \"_expandable\": {\n \"operations\": \"id veniam\",\n \"details\": \"pariatur\",\n \"personalSpace\": \"enim nostrud exercitation consequat\"\n },\n \"_links\": {},\n \"username\": \"sed ullamco\",\n \"userKey\": \"esse quis elit\",\n \"operations\": [\n {\n \"operation\": \"read\",\n \"targetType\": \"attachment\"\n },\n {\n \"operation\": \"read\",\n \"targetType\": \"page\"\n }\n ],\n \"details\": {\n \"business\": {\n \"value\": \"<Error: Too many levels of nesting to fake this schema>\"\n },\n \"personal\": {\n \"value\": \"<Error: Too many levels of nesting to fake this schema>\"\n }\n },\n \"personalSpace\": {\n \"id\": -57606158,\n \"key\": \"sunt cillum aute\",\n \"name\": \"dolore elit ea in\",\n \"type\": \"non in\",\n \"status\": \"aliquip et anim\",\n \"_expandable\": {\n \"settings\": \"ex dolor deserunt anim\",\n \"metadata\": \"dolore qui officia Duis\",\n \"operations\": \"sed laboris\",\n \"lookAndFeel\": \"Duis elit dolore veniam\",\n \"permissions\": \"dolor dolore in\",\n \"icon\": \"reprehenderit pariatur magna labore irure\",\n \"description\": \"Duis aute est fugiat laborum\",\n \"theme\": \"qui nulla est\",\n \"history\": \"non fugiat do\",\n \"homepage\": \"nisi\"\n },\n \"_links\": {},\n \"icon\": {\n \"path\": \"est labore\",\n \"width\": -327281,\n \"height\": -79671930,\n \"isDefault\": false\n },\n \"description\": {\n \"plain\": {\n \"value\": \"esse dolore\",\n \"representation\": \"view\",\n \"embeddedContent\": [\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 },\n \"view\": {\n \"value\": \"commodo\",\n \"representation\": \"view\",\n \"embeddedContent\": [\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 }\n },\n \"homepage\": {\n \"value\": \"<Circular reference to #/components/schemas/Content detected>\"\n },\n \"metadata\": {\n \"labels\": {\n \"results\": [\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 \"start\": -56637757,\n \"limit\": 1062771,\n \"size\": 37957067,\n \"_links\": {}\n }\n },\n \"operations\": [\n {\n \"operation\": \"update\",\n \"targetType\": \"page\"\n },\n {\n \"operation\": \"move\",\n \"targetType\": \"attachment\"\n }\n ],\n \"permissions\": [\n {\n \"subjects\": {\n \"_expandable\": {\n \"value\": \"<Error: Too many levels of nesting to fake this schema>\"\n },\n \"user\": {\n \"value\": \"<Error: Too many levels of nesting to fake this schema>\"\n },\n \"group\": {\n \"value\": \"<Error: Too many levels of nesting to fake this schema>\"\n }\n },\n \"operation\": {\n \"operation\": \"purge_version\",\n \"targetType\": \"page\"\n },\n \"anonymousAccess\": false,\n \"unlicensedAccess\": false\n },\n {\n \"subjects\": {\n \"_expandable\": {\n \"value\": \"<Error: Too many levels of nesting to fake this schema>\"\n },\n \"user\": {\n \"value\": \"<Error: Too many levels of nesting to fake this schema>\"\n },\n \"group\": {\n \"value\": \"<Error: Too many levels of nesting to fake this schema>\"\n }\n },\n \"operation\": {\n \"operation\": \"purge\",\n \"targetType\": \"page\"\n },\n \"anonymousAccess\": false,\n \"unlicensedAccess\": false\n }\n ],\n \"settings\": {\n \"routeOverrideEnabled\": true,\n \"_links\": {}\n },\n \"theme\": {},\n \"lookAndFeel\": {\n \"headings\": {\n \"color\": \"se\"\n },\n \"links\": {\n \"color\": \"sit\"\n },\n \"menus\": {\n \"hoverOrFocus\": {\n \"value\": \"<Error: Too many levels of nesting to fake this schema>\"\n },\n \"color\": {\n \"value\": \"<Error: Too many levels of nesting to fake this schema>\"\n }\n },\n \"header\": {\n \"backgroundColor\": {\n \"value\": \"<Error: Too many levels of nesting to fake this schema>\"\n },\n \"button\": {\n \"value\": \"<Error: Too many levels of nesting to fake this schema>\"\n },\n \"primaryNavigation\": {\n \"value\": \"<Error: Too many levels of nesting to fake this schema>\"\n },\n \"secondaryNavigation\": {\n \"value\": \"<Error: Too many levels of nesting to fake this schema>\"\n },\n \"search\": {\n \"value\": \"<Error: Too many levels of nesting to fake this schema>\"\n }\n },\n \"content\": {\n \"screen\": {\n \"value\": \"<Error: Too many levels of nesting to fake this schema>\"\n },\n \"container\": {\n \"value\": \"<Error: Too many levels of nesting to fake this schema>\"\n },\n \"header\": {\n \"value\": \"<Error: Too many levels of nesting to fake this schema>\"\n },\n \"body\": {\n \"value\": \"<Error: Too many levels of nesting to fake this schema>\"\n }\n },\n \"bordersAndDividers\": {\n \"color\": \"magna consequat\"\n }\n },\n \"history\": {\n \"createdDate\": \"1951-04-28T13:26:19.420Z\"\n }\n }\n },\n \"createdDate\": \"1945-06-14T04:34:24.316Z\",\n \"friendlyCreatedDate\": \"reprehenderit \"\n },\n \"source\": {},\n \"target\": {}\n },\n {\n \"name\": \"consectetur Ut enim occaec\",\n \"_expandable\": {\n \"relationData\": \"in est qui\",\n \"source\": \"incididunt\",\n \"target\": \"laborum magna proident amet aliquip\"\n },\n \"_links\": {},\n \"relationData\": {\n \"createdBy\": {\n \"type\": \"user\",\n \"accountId\": \"cillu\",\n \"accountType\": \"app (if this user is a bot user created on behalf of an Atlassian app)\",\n \"email\": \"enim eu\",\n \"publicName\": \"eu aute in\",\n \"profilePicture\": {\n \"path\": \"non\",\n \"width\": -48499479,\n \"height\": 87770702,\n \"isDefault\": true\n },\n \"displayName\": \"dolore ut\",\n \"_expandable\": {\n \"operations\": \"magna pariatur eiusmod nisi\",\n \"details\": \"non consectetur\",\n \"personalSpace\": \"nostrud\"\n },\n \"_links\": {},\n \"username\": \"anim aliquip eu amet\",\n \"userKey\": \"dolore ullamco nostrud laboris\",\n \"operations\": [\n {\n \"operation\": \"administer\",\n \"targetType\": \"comment\"\n },\n {\n \"operation\": \"export\",\n \"targetType\": \"space\"\n }\n ],\n \"details\": {\n \"business\": {\n \"value\": \"<Error: Too many levels of nesting to fake this schema>\"\n },\n \"personal\": {\n \"value\": \"<Error: Too many levels of nesting to fake this schema>\"\n }\n },\n \"personalSpace\": {\n \"id\": 96005227,\n \"key\": \"elit eiusmod ad\",\n \"name\": \"in tempor ad\",\n \"type\": \"et elit officia\",\n \"status\": \"dolore\",\n \"_expandable\": {\n \"settings\": \"ad aliquip nisi sed\",\n \"metadata\": \"ut cupidatat\",\n \"operations\": \"veniam sit\",\n \"lookAndFeel\": \"anim ex\",\n \"permissions\": \"mollit qui Lorem nulla quis\",\n \"icon\": \"amet fugiat dolor cupidatat\",\n \"description\": \"consequat anim\",\n \"theme\": \"ipsum\",\n \"history\": \"aliqua Dui\",\n \"homepage\": \"voluptate consectetur do Ut ut\"\n },\n \"_links\": {},\n \"icon\": {\n \"path\": \"ex minim consectetur\",\n \"width\": -35571565,\n \"height\": -58278363,\n \"isDefault\": false\n },\n \"description\": {\n \"plain\": {\n \"value\": \"dolor exercitation\",\n \"representation\": \"plain\",\n \"embeddedContent\": [\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 },\n \"view\": {\n \"value\": \"velit irure laborum id nostrud\",\n \"representation\": \"view\",\n \"embeddedContent\": [\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 }\n },\n \"homepage\": {\n \"value\": \"<Circular reference to #/components/schemas/Content detected>\"\n },\n \"metadata\": {\n \"labels\": {\n \"results\": [\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 \"start\": 36294069,\n \"limit\": -28282967,\n \"size\": 56940014,\n \"_links\": {}\n }\n },\n \"operations\": [\n {\n \"operation\": \"administer\",\n \"targetType\": \"blogpost\"\n },\n {\n \"operation\": \"read\",\n \"targetType\": \"application\"\n }\n ],\n \"permissions\": [\n {\n \"subjects\": {\n \"_expandable\": {\n \"value\": \"<Error: Too many levels of nesting to fake this schema>\"\n },\n \"user\": {\n \"value\": \"<Error: Too many levels of nesting to fake this schema>\"\n },\n \"group\": {\n \"value\": \"<Error: Too many levels of nesting to fake this schema>\"\n }\n },\n \"operation\": {\n \"operation\": \"purge\",\n \"targetType\": \"attachment\"\n },\n \"anonymousAccess\": false,\n \"unlicensedAccess\": false\n },\n {\n \"subjects\": {\n \"_expandable\": {\n \"value\": \"<Error: Too many levels of nesting to fake this schema>\"\n },\n \"user\": {\n \"value\": \"<Error: Too many levels of nesting to fake this schema>\"\n },\n \"group\": {\n \"value\": \"<Error: Too many levels of nesting to fake this schema>\"\n }\n },\n \"operation\": {\n \"operation\": \"create\",\n \"targetType\": \"space\"\n },\n \"anonymousAccess\": false,\n \"unlicensedAccess\": false\n }\n ],\n \"settings\": {\n \"routeOverrideEnabled\": false,\n \"_links\": {}\n },\n \"theme\": {},\n \"lookAndFeel\": {\n \"headings\": {\n \"color\": \"dolore consequat occaeca\"\n },\n \"links\": {\n \"color\": \"occaecat ut sit\"\n },\n \"menus\": {\n \"hoverOrFocus\": {\n \"value\": \"<Error: Too many levels of nesting to fake this schema>\"\n },\n \"color\": {\n \"value\": \"<Error: Too many levels of nesting to fake this schema>\"\n }\n },\n \"header\": {\n \"backgroundColor\": {\n \"value\": \"<Error: Too many levels of nesting to fake this schema>\"\n },\n \"button\": {\n \"value\": \"<Error: Too many levels of nesting to fake this schema>\"\n },\n \"primaryNavigation\": {\n \"value\": \"<Error: Too many levels of nesting to fake this schema>\"\n },\n \"secondaryNavigation\": {\n \"value\": \"<Error: Too many levels of nesting to fake this schema>\"\n },\n \"search\": {\n \"value\": \"<Error: Too many levels of nesting to fake this schema>\"\n }\n },\n \"content\": {\n \"screen\": {\n \"value\": \"<Error: Too many levels of nesting to fake this schema>\"\n },\n \"container\": {\n \"value\": \"<Error: Too many levels of nesting to fake this schema>\"\n },\n \"header\": {\n \"value\": \"<Error: Too many levels of nesting to fake this schema>\"\n },\n \"body\": {\n \"value\": \"<Error: Too many levels of nesting to fake this schema>\"\n }\n },\n \"bordersAndDividers\": {\n \"color\": \"deserunt Duis laborum ad\"\n }\n },\n \"history\": {\n \"createdDate\": \"1977-01-29T01:15:06.769Z\"\n }\n }\n },\n \"createdDate\": \"2018-11-14T12:56:13.456Z\",\n \"friendlyCreatedDate\": \"reprehenderit laborum\"\n },\n \"source\": {},\n \"target\": {}\n }\n ],\n \"start\": -48357202,\n \"limit\": 5335291,\n \"size\": 43833338,\n \"_links\": {}\n}"
},
{
"name": "Returned if the user does not have permission to view the\nrelationship",
"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/relation/:relationName/to/:targetType/:targetKey/from/:sourceType?sourceStatus=<string>&targetStatus=<string>&sourceVersion=<integer>&targetVersion=<integer>&expand=<string>&expand=<string>&start=0&limit=25",
"host": [
"{{baseUrl}}"
],
"path": [
"api",
"relation",
":relationName",
"to",
":targetType",
":targetKey",
"from",
":sourceType"
],
"query": [
{
"key": "sourceStatus",
"value": "<string>"
},
{
"key": "targetStatus",
"value": "<string>"
},
{
"key": "sourceVersion",
"value": "<integer>"
},
{
"key": "targetVersion",
"value": "<integer>"
},
{
"key": "expand",
"value": "<string>"
},
{
"key": "expand",
"value": "<string>"
},
{
"key": "start",
"value": "0"
},
{
"key": "limit",
"value": "25"
}
],
"variable": [
{
"key": "relationName"
},
{
"key": "targetType"
},
{
"key": "targetKey"
},
{
"key": "sourceType"
}
]
}
},
"status": "Forbidden",
"code": 403,
"_postman_previewlanguage": "text",
"header": [
{
"key": "Content-Type",
"value": "text/plain"
}
],
"cookie": [
],
"body": ""
},
{
"name": "Returned if the target entity does not exist.",
"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/relation/:relationName/to/:targetType/:targetKey/from/:sourceType?sourceStatus=<string>&targetStatus=<string>&sourceVersion=<integer>&targetVersion=<integer>&expand=<string>&expand=<string>&start=0&limit=25",
"host": [
"{{baseUrl}}"
],
"path": [
"api",
"relation",
":relationName",
"to",
":targetType",
":targetKey",
"from",
":sourceType"
],
"query": [
{
"key": "sourceStatus",
"value": "<string>"
},
{
"key": "targetStatus",
"value": "<string>"
},
{
"key": "sourceVersion",
"value": "<integer>"
},
{
"key": "targetVersion",
"value": "<integer>"
},
{
"key": "expand",
"value": "<string>"
},
{
"key": "expand",
"value": "<string>"
},
{
"key": "start",
"value": "0"
},
{
"key": "limit",
"value": "25"
}
],
"variable": [
{
"key": "relationName"
},
{
"key": "targetType"
},
{
"key": "targetKey"
},
{
"key": "sourceType"
}
]
}
},
"status": "Not Found",
"code": 404,
"_postman_previewlanguage": "text",
"header": [
{
"key": "Content-Type",
"value": "text/plain"
}
],
"cookie": [
],
"body": ""
}
]
}
