DUPLICATE_VALUE in upsert call - Salesforce

Question

我正在尝试通过Salesforce中的REST API进行批量更新，但我得到了以下错误：

<results xmlns="http://www.force.com/2009/06/asyncapi/dataload">
    <result>
        <errors>
            <message>duplicate value found: ID_Externo__c duplica o valor no registro com ID: 0014B00000RKZkR
</message>
            <statusCode>DUPLICATE_VALUE</statusCode>
        </errors>
        <success>false</success>
        <created>true</created>
    </result>
    <result>
        <errors>
            <message>duplicate value found: ID_Externo__c duplica o valor no registro com ID: 0014B00000RKZkP
</message>
            <statusCode>DUPLICATE_VALUE</statusCode>
        </errors>
        <success>false</success>
        <created>true</created>
    </result>
    <result>
        <errors>
            <message>duplicate value found: ID_Externo__c duplica o valor no registro com ID: 0014B00000RKZkS
</message>
            <statusCode>DUPLICATE_VALUE</statusCode>
        </errors>
        <success>false</success>
        <created>true</created>
    </result>
    <result>
        <errors>
            <fields>ID_Externo__c</fields>
            <message>Duplicate external id specified: 062.203.686-6501237000000RgoCAAS
</message>
            <statusCode>DUPLICATE_VALUE</statusCode>
        </errors>
        <success>false</success>
        <created>false</created>
    </result>
    <result>
        <errors>
            <message>duplicate value found: ID_Externo__c duplica o valor no registro com ID: 0014B00000RKZkT
</message>
            <statusCode>DUPLICATE_VALUE</statusCode>
        </errors>
        <success>false</success>
        <created>true</created>
    </result>
    <result>
        <errors>
            <message>duplicate value found: ID_Externo__c duplica o valor no registro com ID: 0014B00000RKZkU
</message>
            <statusCode>DUPLICATE_VALUE</statusCode>
        </errors>
        <success>false</success>
        <created>true</created>
    </result>
    <result>
        <errors>
            <fields>ID_Externo__c</fields>
            <message>Duplicate external id specified: 062.203.686-6501237000000RgoCAAS
</message>
            <statusCode>DUPLICATE_VALUE</statusCode>
        </errors>
        <success>false</success>
        <created>false</created>
    </result>
    <result>
        <errors>
            <message>duplicate value found: ID_Externo__c duplica o valor no registro com ID: 0014B00000RKZkV
</message>
            <statusCode>DUPLICATE_VALUE</statusCode>
        </errors>
        <success>false</success>
        <created>true</created>
    </result>
    <result>
        <errors>
            <message>duplicate value found: ID_Externo__c duplica o valor no registro com ID: 0014B00000RKZkW
</message>
            <statusCode>DUPLICATE_VALUE</statusCode>
        </errors>
        <success>false</success>
        <created>true</created>
    </result>
    <result>
        <errors>
            <message>duplicate value found: ID_Externo__c duplica o valor no registro com ID: 0014B00000RKZkX
</message>
            <statusCode>DUPLICATE_VALUE</statusCode>
        </errors>
        <success>false</success>
        <created>true</created>
    </result>
</results>

在我的请求中，我没有发送重复的值(除了我为test创建的值，并获得了指定的正确的error - duplicate外部id )。

以下是我的请求：

<sObjects xmlns="http://www.force.com/2009/06/asyncapi/dataload" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
    <sObject>
        <CPF_CNPJ__c>672.334.062-00</CPF_CNPJ__c>
        <Name>672.334.062-00</Name>
        <RecordType>
            <sObject>
                <Name>Cliente Varejo</Name>
            </sObject>
        </RecordType>
        <Clear__c>true</Clear__c>
        <ID_Externo__c>672.334.062-0001237000000RgoCAAS</ID_Externo__c>
    </sObject>
    <sObject>
        <CPF_CNPJ__c>035.621.729-90</CPF_CNPJ__c>
        <Name>035.621.729-90</Name>
        <RecordType>
            <sObject>
                <Name>Cliente Varejo</Name>
            </sObject>
        </RecordType>
        <Clear__c>true</Clear__c>
        <ID_Externo__c>035.621.729-9001237000000RgoCAAS</ID_Externo__c>
    </sObject>
    <sObject>
        <CPF_CNPJ__c>303.292.018-32</CPF_CNPJ__c>
        <Name>303.292.018-32</Name>
        <RecordType>
            <sObject>
                <Name>Cliente Varejo</Name>
            </sObject>
        </RecordType>
        <Clear__c>true</Clear__c>
        <ID_Externo__c>303.292.018-3201237000000RgoCAAS</ID_Externo__c>
    </sObject>
    <sObject>
        <CPF_CNPJ__c>062.203.686-65</CPF_CNPJ__c>
        <Name>062.203.686-65</Name>
        <RecordType>
            <sObject>
                <Name>Cliente Varejo</Name>
            </sObject>
        </RecordType>
        <Clear__c>true</Clear__c>
        <ID_Externo__c>062.203.686-6501237000000RgoCAAS</ID_Externo__c>
    </sObject>
    <sObject>
        <CPF_CNPJ__c>054.454.224-02</CPF_CNPJ__c>
        <Name>054.454.224-02</Name>
        <RecordType>
            <sObject>
                <Name>Cliente Varejo</Name>
            </sObject>
        </RecordType>
        <Clear__c>true</Clear__c>
        <ID_Externo__c>054.454.224-0201237000000RgoCAAS</ID_Externo__c>
    </sObject>
    <sObject>
        <CPF_CNPJ__c>845.374.266-91</CPF_CNPJ__c>
        <Name>845.374.266-91</Name>
        <RecordType>
            <sObject>
                <Name>Cliente Varejo</Name>
            </sObject>
        </RecordType>
        <Clear__c>true</Clear__c>
        <ID_Externo__c>845.374.266-9101237000000RgoCAAS</ID_Externo__c>
    </sObject>
    <sObject>
        <CPF_CNPJ__c>062.203.686-65</CPF_CNPJ__c>
        <Name>062.203.686-65</Name>
        <RecordType>
            <sObject>
                <Name>Cliente Varejo</Name>
            </sObject>
        </RecordType>
        <Clear__c>true</Clear__c>
        <ID_Externo__c>062.203.686-6501237000000RgoCAAS</ID_Externo__c>
    </sObject>
    <sObject>
        <CPF_CNPJ__c>041.235.286-94</CPF_CNPJ__c>
        <Name>041.235.286-94</Name>
        <RecordType>
            <sObject>
                <Name>Cliente Varejo</Name>
            </sObject>
        </RecordType>
        <Clear__c>true</Clear__c>
        <ID_Externo__c>041.235.286-9401237000000RgoCAAS</ID_Externo__c>
    </sObject>
    <sObject>
        <CPF_CNPJ__c>258.419.948-32</CPF_CNPJ__c>
        <Name>258.419.948-32</Name>
        <RecordType>
            <sObject>
                <Name>Cliente Varejo</Name>
            </sObject>
        </RecordType>
        <Clear__c>true</Clear__c>
        <ID_Externo__c>258.419.948-3201237000000RgoCAAS</ID_Externo__c>
    </sObject>
    <sObject>
        <CPF_CNPJ__c>126.912.867-11</CPF_CNPJ__c>
        <Name>126.912.867-11</Name>
        <RecordType>
            <sObject>
                <Name>Cliente Varejo</Name>
            </sObject>
        </RecordType>
        <Clear__c>true</Clear__c>
        <ID_Externo__c>126.912.867-1101237000000RgoCAAS</ID_Externo__c>
    </sObject>
</sObjects>

字段ID_Externo__c是排他性的，区分大小写，外部Id。如果我禁用了exclusive标记，upsert调用就会复制注册表；如果我再次尝试将字段设为exclusive，显然，Salesforce会给我一个错误:找到重复的外部id。

谢谢

Answer 1

ID_Externo_c : 062.203.686-6501237000000RgoCAAS引用了两次:第4条和第7条记录。