I am trying to run an upsert from a batch script.
I can't seem to track down any documentation on the actual mapping file when using an external id from a .csv file. How do I tell my upsert which column to use for the lookup?
Purpose: I am trying to obtain the sales_force_id from table account by using the value my_ext_id in my file. So my_ext_ID should join to account on my_ext_id = account.account_ID and retrieve a salesforce_ID that I will be mapping to a column called my_Sf_id.
I have the id here:
<entry key="sfdc.externalIdField" value="my_ext_ID"/>
what should my mapping file look like to match my_ext_ID -> account.account_ID? I tried :
which gives: Field mapping is invalid
edit: Thank you for the alternative but it needs to be done this way.