POST
/
vLatest
/
query
/
glasscore
/
orderitem

Body

application/json

Multiple query options are supported. You can build a complex query filling out the advancedFilter section. We also support "simple" queries which used by putting the key you want to filter by in the query section along with the value you want it to filter for. E.g., nameFirst=John will return all persons with a first name of John.

advancedFilter
object

Complex filter configuration allowing for multiple conditions with AND/OR operators.

isAdditionalData
boolean
default:
false

Set to true to merge requested fields with default response, or false/omit to return only requested fields plus ID.

page
number
default:
1

Page number for pagination.

pageSize
number
default:
500

Number of items per page. Defaults to 500.

return
string[]

Array of field names to return in the response.

sortBy
string

Field name to sort by.

sortDirection
enum<string>
default:
desc

Sort direction: ascending (asc) or descending (desc).

Available options:
asc,
desc
{key}
string

Additional key-value pairs for simple filtering. Any field from the entity can be used as a filter key. E.g., field=value will return all records where that field matches the specified value.

Response

200 - application/json
c_currentStatusCodeId
string
required

Represents the unique identifier for the current status of an order item.

c_currentStatusCodeName
string
required

Represents the current status of an order item such as 'pending', 'shipped', 'delivered', etc.

c_org
string
required

Represents the organization associated with a particular order item.

c_personNameFirst
string
required

Stores the first name of the person who placed the order.

c_personNameLast
string
required

Stores the last name of the individual who placed the order.

c_productName
string
required

Stores the name of the product associated with each order item.

CreationTimestamp
required

Timestamp of record creation.

CurrentStatusId
number | null
required

Represents the unique identifier of the current status of an item in an order.

id
number
required

Unique identifier.

isNotModifiable
boolean | null
required

Indicates whether the order item can be changed or not.

orderedBy
string
required

Indicates the customer who placed the order for the item.

OrgId
number | null
required

Represents the unique identifier for the organization associated with a specific order item.

Parent~OrderItemId
number | null
required

Represents the unique identifier of the parent order item in the OrderItem table.

Passport~OrderItemId
number | null
required

Represents the unique identifier of an order item associated with a passport.

PersonId
number
required

Unique identifier for the individual who placed the order.

ProductId
number
required

Unique identifier for the specific product associated with an order item.