on 2024 Feb 07 1:06 PM
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!
Request clarification before answering.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello @adamreisberg ,
we are using the cursor ID yes. Maybe is the LIMIT keyword the reason. We are trying that now.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
18 | |
3 | |
2 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.