"apiVersion": "51.0",
"bulkApiVersion": "2.0",
"bulkThreshold": 200,
"queryBulkApiThreshold": 10000,
"fileLog": true,
"promptOnMissingParentObjects": false,
"objects": [
{ "source": "csvfile",
"master": false,
"excluded": false,
"alwaysUseBulkApiToUpdateRecords": true,
"query": "SELECT legacy_Id__c, BillingCountry, BillingCountryCode, CreatedDate, CurrencyIsoCode, IsActive, IsDeleted, IsPersonAccount, IsPriorityRecord, LastModifiedDate, LastReferencedDate, LastViewedDate, Name, RecordTypeId, ShippingCountry, ShippingCountryCode, SystemModstamp FROM Account_Source_1 WHERE RecordTypeId = '123' AND ParentId = null",
"operation": "Upsert",
"externalId": "legacy_Id__c",
"useFieldMapping": true,
"useValuesMapping": true,
"targetRecordsFilter": "RecordTypeId = '123' AND NOT ParentId",
"fieldMapping": [
{
"targetObject": "Account"
}
],
"updateWithMockData": true,
"mockFields": [
{
"name": "Name",
"pattern": "company_name"
}
],
"useValuesMapping": true
}
]
Issue title
Where Clause is not working when CSV as a Source.
-- Add your title here --
Issue summary
We want records to be filter before insert the records to target we have CSV file is source , we have 67k records in CSV file but out of those we have to filter rows on the basis of record type but filter is not working it is trying to insert all 67k records .
Steps to reproduce
we have 67k records in CSV file but out of those we have to filter rows on the basis of record type but filter is not working it is trying to insert all 67k records .
-- Add steps to reproduce here --
Expected behavior
we have 67k records in CSV file but out of those we have to filter 10k rows on the basis of record type so 10K records need to be insert
Actual behavior
Describe what actually happened.
we have 67k records in CSV file but out of those we have to filter rows on the basis of record type but filter is not working it is trying to insert all 67k records .
Log file (required)
Log file attached
_target.csv file (if relevant)
** Json like -
{
}