What is the character limit for the WHERE clause in the export.json file?

Question:

I have an organization with thousands of records. Can I specify which ones to select by including all their IDs in the WHERE clause of my export.json? What are the limitations on the length of a SOQL statement in export.json?

Answer:

Yes, you can include a list of IDs in the WHERE clause using the IN operator.

  • Remember to set master = true for your sObject or omit this parameter.

  • The length of the WHERE clause is limited to 4000 characters, as per Salesforce documentation.

Last updated on 18th Apr 2024