Retrieve other objects list via Relation's Navigation Property

Overview

Retrieve cell control object via Navigation Property

Required Privileges

• When acquire Role
  auth-read
• When acquire Relation
  social-read

Restrictions

• Accept in the request header is ignored
• Always handles Content-Type in the request header as application/json
• Only accepts the request body in the JSON format
• Only application/json is supported for Content-Type in the request header and the JSON format for the response body
• $formatQuery options ignored

Request

Request URL

NavigationProperty to Box

{CellURL}__ctl/Relation(Name='{RelationName}',_Box.Name='{BoxName}')/_Box

or

{CellURL}__ctl/Relation(Name='{RelationName}')/_Box

or

{CellURL}__ctl/Relation('{RelationName}')/_Box

NavigationProperty to ExCel

{CellURL}__ctl/Relation(Name='{RelationName}',_Box.Name='{BoxName}')/_ExtCell

or

{CellURL}__ctl/Relation(Name='{RelationName}')/_ExtCell

or

{CellURL}__ctl/Relation('{RelationName}')/_ExtCell

NavigationPropert to ExtRole

{CellURL}__ctl/Relation(Name='{RelationName}',_Box.Name='{BoxName}')/_ExtRole

or

{CellURL}__ctl/Relation(Name='{RelationName}')/_ExtRole

or

{CellURL}__ctl/Relation('{RelationName}')/_ExtRole

Navigation Property to Role

{CellURL}__ctl/Relation(Name='{RelationName}',_Box.Name='{BoxName}')/_Role

or

{CellURL}__ctl/Relation(Name='{RelationName}')/_Role

or

{CellURL}__ctl/Relation('{RelationName}')/_Role

If the _Box.Name parameter is omitted, it is assumed that null is specified

Request Method

GET

Request Query

The following query parameters are available

Query Name	Overview	Effective Value	Required	Notes
p_cookie_peer	Cookie Authentication Value	The cookie authentication value returned from the server during authentication	No	Valid only if no Authorization header specified Specify this when cookie authentication information is to be used

$select Query

$expand Query

$format Query

$filter Query

$inlinecount Query

$orderby Query

$top Query

$skip Query

Full-text Search (q) Query

Request Header

Header Name	Overview	Effective Value	Required	Notes
X-HTTP-Method-Override	Method override function	User-defined	No	If you specify this value when requesting with the POST method, the specified value will be used as a method.
X-Override	Header override function	${OverwrittenHeaderName}:${Value};override} $: $ {value}	No	Overwrite normal HTTP header value. To overwrite multiple headers, specify multiple X-Override headers.
X-Personium-RequestKey	RequestKey field value output in the event log	Single-byte alphanumeric characters, hyphens ("-"), and underscores ("_") Maximum of 128 characters	No	When not specified, default value given with ${4 digits}_${22 digits} Base64url characters format representing an UUID for each request
Authorization	Specifies authentication information in the OAuth 2.0 format	Bearer {AccessToken}	No	* Authentication tokens are the tokens acquired using the Authentication Token Acquisition API
Accept	Specifies the response body format	application/json	No	[application/json] by default

Request Body

None

Response

Response Code

200

Response Header

Header Name	Overview	Notes
X-Personium-Version	API version that the request is processed	Version of the API used to process the request
Access-Control-Allow-Origin	Cross domain communication permission header	Return value fixed to "*"
Content-Type	Format of data to be returned
DataServiceVersion	OData version

Response Body

Object	Item Name	Data Type	Notes
Root	d	object	Object{1}
{1}	results	array	Array object {2}
{2}	__published	string	Creation date (UNIX time)
{2}	__updated	string	Update date (UNIX time)
{2}	__metadata	object	Object{3}
{3}	etag	string	Etag value
{3}	uri	string	URL to the resource that was created
{1}	__count	string	Get number of results in $inlinecount query

When acquiring Relation

Relation specific response body

Object	Item Name	Data Type	Notes
{3}	type	string	CellCtl.Relation
{3}	Name	string	Relation Name
{2}	_Box.Name	string	Box name to be related

Error Messages

Refer to Error Message List

Response Sample

{
  "d": {
    "results": {
      "Name": "relation1",
      "_Box.Name": "box1",
      "__metadata": {  
        "uri": "https://cell1.unit1.example/__ctl/Relation(Name='relation1'
,_Box.Name='box1')",
        "type": "CellCtl.relation"  
      },  
      "__published" : "\/Date(1339128525502)\/",  
      "__updated"   : "\/Date(1339128525502)\/"  
    }
  }
}

cURL Command

None