cancel
Showing results for 
Search instead for 
Did you mean: 

accounts.search REST queries and pagination

kstamou
Explorer
0 Kudos
312

Hi there, 

do you know if there is any limitation with account.search api on authorisation level when we run 2 queries on acounts and emailAccounts objects? 

We are running those 2 queries in databricks so that we get all CDC records in the datalake. We noticed that query shows that toal count is 7M for example, but the response is only 2 pages of 300 records each. So, we assume that because we use 2 queries with one application key, this could have some limitations. Do you have any input or similar experience? 

Thank you!

 

Accepted Solutions (0)

Answers (2)

Answers (2)

olehi941
Active Participant
0 Kudos

Hello @kstamou,
Yes, you are right. The reason is in a LIMIT keyword in your queries.
If you skip it - the default value is 300 records per query(LIMIT 300).
If you explicitly include LIMIT in your query, you may get up to 10000 records per query(LIMIT 10000).
But please don't forget to follow SAP's recommendations.
Hope it helped.

kstamou
Explorer
0 Kudos

Hello @adamreisberg , 

we are using the cursor ID yes. Maybe is the LIMIT keyword the reason. We are trying that now.