Apex Code Development You need to sign in to do that
Don't have an account?
JP Nikko AM Systems INVALID_FIELD_FOR_INSERT_UPDATE in Data Loader Upsert
Everytime I do an upsert to a detail custom object which is related to Contact,
Contact - Object1(master)-->Object2 (Detaill)
I get INVALID_FIELD_FOR_INSERT_UPDATE error.
Seems like for custom object, it doesn't consider the ID of the parent and master objects.
Not sure how to resolve this but I think if I merge the IDs it will create a unique ID that will allow me to insert.
Is it possible to merge 2 columns and set as External ID in an Upsert?
For example :
csv:
ID1 ID2
11 22
mapping.sdl
ID1 + ID2=ExternalID__c
Is that possible?
Thanks,
Precious
Contact - Object1(master)-->Object2 (Detaill)
I get INVALID_FIELD_FOR_INSERT_UPDATE error.
Seems like for custom object, it doesn't consider the ID of the parent and master objects.
Not sure how to resolve this but I think if I merge the IDs it will create a unique ID that will allow me to insert.
Is it possible to merge 2 columns and set as External ID in an Upsert?
For example :
csv:
ID1 ID2
11 22
mapping.sdl
ID1 + ID2=ExternalID__c
Is that possible?
Thanks,
Precious
i dnt think so you can able to merge in SDL file .. you can do one think .. merge them in CSV using concatenation function and pass the concatenation colum to SDL file
What are the columns present in your csv.?