Is the WHERE clause in my 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 of export.json.

Can I do that and is there any limitation regarding the maximal length of SOQL statement defined in export.json file ?


Answer.

Yes it is possible. SOQL queries used by SFDMU is the same query like a "normal" SOQL statement, so they have the same set of limitations.

  • Put list of your ids in WHERE with IN operator.

  • It's important to set master = true for your sObject (or omit this parameter)

Visit the below article regarding allowed total length of 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

Last updated on 13th Nov 2023