Theme switcher

Execute a query across unrelated entity sets

A Cross Join returns the Cartesian product of all the specified entity sets; use $filter to filter the result such that only related entities are returned. See Addressing the Cross Join of Entity Sets

Header Parameters

Content-Languagestring

A 5 character language tag, like en-US, de-DE, etc. Determines the LN system and data languages to use while executing the request. If not specified, the system and data language of the LN service user are used

X-Infor-LnCompanyinteger

A company number in the range 0-9999. Selects the LN company number in which the request is executed. If not specified, the company of the LN service user is used

Maximum
9999
X-Infor-LnIdentitystring

An identity tag. Selects the identity to assume while executing the request. If not specified, the LN service user identity is assumed

Query Parameters

$filterstring

Filter Cross Join items based on related properties between the entity sets

$expandstring

Expand Cross Join items; use the names of the selected entity sets as navigation property names; use nested $select and $filter options to select the properties and filter entities of the entity set to expand

$orderbystring

Order items by property values

$countboolean

Include count of items

$topinteger

Show only the first n items

$skipinteger

Skip the first n items

Path Parameters

EntitySetsstring Required

A comma separated list of entity sets to join

Response

200
Object
Retrieved Cross Join items

Response Attributes

@odata.countinteger

The number of entities in the collection. Available when using the $count query parameter.

valuearray

Show child attributes

200
Object
Error

Response Attributes

errorobject

Show child attributes

Was this section helpful?

What made this section unhelpful for you?

GET

/

Select
1

Response

Was this section helpful?

What made this section unhelpful for you?