Describe the bug
Only on option is allowed while using CSV Files as source:
- Either providing lookup field with already filled Ids
- Or defining External Id lookups.
Both on the same CSV is not possible.
To Reproduce
For example a ServiceContract import via CSV File:
Status,Term,EndDate,StartDate,AccountId,Name,Pricebook2.Name Active,12,2026-03-26,2021-03-26,0019Z00000fmA3tQAE,test,Pricebook Standard
Whihc contains ac account.Id already filled. And an externalId lookup via Pricebook2.Name. Both in the same file are not possible.
Expected behavior
Ids for lookups are used as they are and externalId lookups are resolved
export.json
{ "allOrNone": true, "excludeIdsFromCSVFiles": true, "objects": [ { "query": "SELECT Id FROM Pricebook2", "operation": "Readonly", "externalId": "Id", "master": false },{ "query": "SELECT Id FROM Account", "operation": "Readonly", "externalId": "Id", "master": false },{ "query": "SELECT Status,Term,EndDate,StartDate,AccountId,Name,Pricebook2Id FROM ServiceContract", "operation": "Upsert", "useValuesMapping": true, "useSourceCSVFile": true, "master": true } ] }
_target.csv file.
does not get created
Describe the bug
Only on option is allowed while using CSV Files as source:
Both on the same CSV is not possible.
To Reproduce
For example a ServiceContract import via CSV File:
Status,Term,EndDate,StartDate,AccountId,Name,Pricebook2.Name Active,12,2026-03-26,2021-03-26,0019Z00000fmA3tQAE,test,Pricebook StandardWhihc contains ac account.Id already filled. And an externalId lookup via Pricebook2.Name. Both in the same file are not possible.
Expected behavior
Ids for lookups are used as they are and externalId lookups are resolved
export.json
{ "allOrNone": true, "excludeIdsFromCSVFiles": true, "objects": [ { "query": "SELECT Id FROM Pricebook2", "operation": "Readonly", "externalId": "Id", "master": false },{ "query": "SELECT Id FROM Account", "operation": "Readonly", "externalId": "Id", "master": false },{ "query": "SELECT Status,Term,EndDate,StartDate,AccountId,Name,Pricebook2Id FROM ServiceContract", "operation": "Upsert", "useValuesMapping": true, "useSourceCSVFile": true, "master": true } ] }_target.csv file.
does not get created