DX CLI force:data:tree:export Query returned no results

Question

Records are returned when I execute this

sfdx force:data:soql:query -u Dev --json --query "SELECT Id, Name, (SELECT Id, Name, AccountId FROM Contacts) FROM Account WHERE Id IN ('0010z00001T1uXSAAZ','0010z00001T1SbXAAV')"

No records are returned when I execute this

sfdx force:data:tree:export -u Dev --json --query "SELECT Id, Name, (SELECT Id, Name, AccountId FROM Contacts) FROM Account WHERE Id IN ('0010z00001T1uXSAAZ','0010z00001T1SbXAAV')" --prefix export --outputdir sfdx-out --plan 

In the commands above Dev is the alias of a sandbox, not a scratch org. The result is the same whether I use 15 or 18 digit record Ids in my export: {"status":0,"result":{"records":[]}}

1. Why doesn't this data:tree:export command return the same records as this data:soql:query command given that the same query is used in each against the same sandbox?
2. How can I troubleshoot this issue?

Answer 1

I've had a look at reproducing this. I got the same result when the data:tree:export included any specific ID's in the where clause. As soon as I took the where clause out of the SOQL query that data started exporting as expected. It even included the data for the Account I was trying to specify by ID.

I'm not certain at the moment, but I suspect it is related to how the export removes all specific record Id's from the result.

E.g. The ID on my Account of interest gets removed and replaced with:

"attributes": {
    "type": "Account",
    "referenceId": "AccountRef1"
},

---

From the data:tree:export docs:

The query for export can return a maximum of 2,000 records. For more information, see the REST API Developer Guide: https://developer.salesforce.com/docs/atlas.en-us.api_rest.meta/api_rest/resources_composite_sobject_tree.htm

I captured the SFDX CLI logging at trace level by appending a --loglevel trace, it didn't provide any more clues. I suspect I'd need to capture the underlying API requests to get to the root cause.

---

I think the actual answer lies in this file (on Windows at least):

%LocalAppData%\sfdx\plugins\node_modules\salesforce-alm\dist\lib\data\dataExportApi.js