Rest API hits a limit of 2000 and not importing all the records

[Manju Shree]

Hi Team,

I have an integration to get data from Main instance to my sub instance through REST API. I have used GET method to fetch all the records. In GET method when I use query as "Active = TRUE" then 75000 records are being fetched but when I used query as "updated after Jan 1, 2025, and active is false", I only get 999 records. But the main instance has more than 1 lac records for the same query.

Kindly provide your inputs.

Thanks in advance

Best regards,

Manjushree

[Maik Skoddow]

Hi @Manju Shree 

have you impersonated with your integration user on your main instance to check how many records you will get with second query? That user might not have the full rights to retrieve inactive records.

Maik