Get Business Object by Top and Skip

Fetches business object records and displays the defined number of records after skipping the defined number of records. For example, you can define to skip the first 10 records and fetch the next top 10 records.

The latest created/modified business objects will be on top of the list.

Base URL:

https://{tenant url}/api/odata/businessobject/{business object name}?$top={number of records to display}&$skip={number of records to skip}

Ensure the business object name is suffixed with an "s".

Here is an example to fetch incidents by skipping top 2 records and then returning the next top 2 records.

URL

https://{tenant url}/api/odata/businessobject/Incidents?$top=2&$skip=2

Method

GET
Header Name Authorization: JTW Token/Session Key/REST API Key

Status Code

200

Response Payload

{

"@odata.context": "{tenant url}/odata/$metadata#incidents",

"@odata.count": 44,

"value": [

{

"ActualCategory_Valid": "14348C1FFA044D8AB1E93005B4A0A287",

"ActualCategory": "Missing Item",

"Category_Valid": "14348C1FFA044D8AB1E93005B4A0A287",

"Category": "Missing Item",

"CauseCode_Valid": "E2489F3F7DA34B898CCD9569CA5541F2",

"CauseCode": "Other",

"ClosedBy": "JClerk",

"CreatedBy": "JClerk",

"RecId": "003B58C0B4554E4BAA30DFD88876582A",

"Subject": "Remote control for projector in Boardroom is are missing ",

"Symptom": "This is an issue as it is roof mounted and cannot be switched on/off without the remote",

"Urgency_Valid": "44021B6CC6E44E598868C4B3306053AE",

"Urgency": "Medium",

"LoginId": "KDavidson",

},

{

"ActualCategory_Valid": "B30A0BC3F3174B22B328D742C24B59C4",

"ActualCategory": "Account Lockout",

"Category_Valid": "B30A0BC3F3174B22B328D742C24B59C4",

"Category": "Account Lockout",

"CauseCode_Valid": "E2489F3F7DA34B898CCD9569CA5541F2",

"CauseCode": "Other",

"ClosedBy": "JClerk",

"CreatedBy": "Service Desk Analyst",

"RecId": "019A1ED9C77C4210B7054F47D214C004",

"Subject": "Cannot get into email - says invalid credentials have been supplied",

"Symptom": "Will not logon via windows authentication",

"Urgency_Valid": "44021B6CC6E44E598868C4B3306053AE",

"Urgency": "Medium",

"LoginId": "MHendric",

}

]

}

Unsuccessful Responses

Scenario: Trying to fetch records without providing the Top/Skip values.

https://{tenant url}/api/odata/businessobject/Incidents?$top= & $skip =

Header Name:

Authorization: Sessionkey

Code ISM_5000
Description Invalid Request
Message

[

"The Top and Skip values cannot be empty.

Provide a valid value and try again."

]

HTTP STATUS CODE

500

Scenario: Trying to fetch more than 100 records.

https://{tenant url}/api/odata/businessobject/Incidents?$top=120 & $skip =10

Header Name:

Authorization: Sessionkey

Code ISM_5000
Description Invalid Request
Message

[

"You cannot query more than 100 records."

]

HTTP STATUS CODE

500