Not able to get more than 10000 record when querying Oracle Fusion Cloud Financials REST API
When querying the General Ledger for balances via
https://docs.oracle.com/en/cloud/saas/financials/24b/farfa/api-ledger-balances.html
any results above 10000 records cannot be obtained. We would like advice from oracle on how to overcome this.
It should be possible to somehow query 0-9999, 10000-19999,20000-29999
for example using offset and limit values for instance, but it's not
working.
/fscmRestApi/resources/11.13.18.05/ledgerBalances?onlyData=true&fields=LedgerName,PeriodName,Currency,DetailAccountCombination,Scenario,BeginningBalance,PeriodActivity,EndingBalance,AmountType,CurrencyType&totalResults=true&limit=1000&q=EndingBalance
!=0.00&finder=AccountBalanceFinder;accountCombination=%-%-%-000-%-0000-00-00000-00000-0000,scenario=Actual,accountingPeriod=Jul-23,amountType=YTD,currency=AUD,currencyType=Total,ledgerName=AULedger,mode=Detail&offset=0