System views are pre-defined query filters for objects. Each time you get a view, the response includes all data that matches the filtering and sorting options set up in the view.
Returns all system views for an object or a specified system view.
name required | string The name of a system view, in the form Example: name=accounts-payable/vendor::systemVendorFW1 |
OK
Bad Request
{- "ia::result": {
- "key": "string",
- "id": "string",
- "name": "string",
- "href": "string",
- "description": "string",
- "object": "string",
- "query": {
- "object": "accounts-payable/vendor",
- "fields": [
- "key",
- "id",
- "max:vendor.creditLimit"
], - "filters": [
- {
- "$eq": {
- "status": "active"
}
}, - {
- "$gt": {
- "totalDue": "1000"
}
}, - {
- "$contains": {
- "name": "Acme"
}
}
], - "filterExpression": "(1 and 2) or 3",
- "filterParameters": {
- "asOfDate": "2022-04-01",
- "includeHierarchyFields": false,
- "caseSensitiveComparison": true,
- "includePrivate": false
}, - "orderBy": [
- {
- "totalDue": "asc"
}, - {
- "lastPaymentMadeDate": "desc"
}
], - "start": 1,
- "size": 100
}, - "contexts": [
- "string"
]
}, - "ia::meta": {
- "totalCount": 3,
- "totalSuccess": 2,
- "totalError": 1
}
}
Use the query service to find system views that meet certain criteria and to specify the properties that are returned.
OK
Bad Request
{- "ia::result": {
- "ia::error": {
- "code": "invalidRequest",
- "message": "A POST request requires a payload",
- "errorId": "REST-1028",
- "additionalInfo": {
- "messageId": "IA.REQUEST_REQUIRES_A_PAYLOAD",
- "placeholders": {
- "OPERATION": "POST"
}, - "propertySet": { }
}, - "supportId": "Kxi78%7EZuyXBDEGVHD2UmO1phYXDQAAAAo"
}
}, - "ia::meta": {
- "totalCount": 1,
- "totalSuccess": 0,
- "totalError": 1
}
}