You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Pagination capped at 500 for many resources. Paginating using the key column also not possible.

[REST APIs]

There are quite a few resources like Expenses (https://docs.oracle.com/en/cloud/saas/financials/26d/farfa/op-expenses-get.html), TaxTransactionBusinessCategories (https://docs.oracle.com/en/cloud/saas/financials/26d/farfa/op-taxtransactionbusinesscategories-get.html) etc. which stop returning items after fetching first 500 items (offset=500). Even though more items exist, the hasMore attribute is returned as false.

A workaround is to paginate using the key attribute. For example, we can fetch more results for Expenses using q=ExpenseId>{last_id_in_the_response}&limit=100&orderBy=ExpenseId:asc.

But the fix is not possible for resources which do not have a key attribute defined or more than one attribute is a key. For example: TaxTransactionBusinessCategories does not list any finder variable for its PrimaryKey Finder (https://docs.oracle.com/en/cloud/saas/financials/26d/farfa/op-taxtransactionbusinesscategories-get.html). Also neither

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!