Is the WHERE clause in our export.json file limited to 4k characters like a normal SOQL statement?

Question.

I have an org that has thousands of records, and I want to only grab a specific set of those.
I will have all the ids that I can copy into my WHERE clause.
Just want to make sure this is possible.

Answer.

Yes it is possible.

You can put your ids into WHERE with IN operator, but be aware of the limitation of the permitted total length for SOQL query:
https://developer.salesforce.com/docs/atlas.en-us.salesforce_app_limits_cheatsheet.meta/salesforce_app_limits_cheatsheet/salesforce_app_limits_platform_soslsoql.htm

Also set master: true for your sObject (or omit this parameter)

Last updated on Sa Oct 2022