Salesforce Output - Dreaded INVALID_FIELD error

I experienced this error when attempting to output the results of my Alteryx data blend workflow to Salesforce using the 'Salesforce Output' connector tool for an Update operation:

Salesforce Output (27)	Record-level error from Salesforce API: 
"INVALID_FIELD:Number of fields in header is different from the row. header = 15 row = 10:--"

I checked 'header 15' and it is the 'Id' field/header in my output that maps back to the existing Salesforce record so an update can successfully be performed-- I even have a 'Unique' tool set to catch any duplicate Salesforce Record Ids, and the issue is persisting.

Of the 67 records, 38 were successfully updated and 29 were not- any idea how this error can help me triangulate what the issue is?

Workflow

Output

Accepted answers

All comments

Rohit_Bajaj

Do you see anything suspicious at data level. Please compare cell level data for sample records which got failed those which got inserted.

Thanks,

Rohit Bajaj

aMac

Hey Rohit, thanks for the reply and excellent suggestion. I did actually output the entire results batch to compare all the records, but I couldn't find any pattern for the records that failed to insert.

I was able to actually output the records and then "force" bulk upload them using Salesforce's own Dataloader desktop client which was completely successful.

Any idea if this was BULK API related or a bug in my workflow?

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15865

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703