Hello-
I would like to understand if anyone faced similar situation and if there is any workaround available in cast iron. As per requirement, cast iron is suppose to do data upsert in sfdc cloud by reading a flat file from on premise and transferring the information using external ID column.The flat file can have duplicate external id's, when utilized sfdc bulk api will throw exception. I would like to understand if cast iron can accomodate this situation and avoid error. the duplicate records are necessary for creation of records in subsequent objects in the flow.

Thanks,
Sam

Hi Sam,

You can filter the input to the SFDC Upsert to eliminate any duplicate external ids.  I normally use an XSLT stlye sheet in an Apply XSLT activity.  You need to upload the XSLT file into Cast Iron Studio before you can use it to configure the Apply XSLT activity.