upsert into salesforce

Highlighted
Four Stars

upsert into salesforce

Can you please explain how to upsert data from excel file to salesforce. The salesforce object has no lookup field. Just need to upsert on single object with an external custom/standard field. How to design talend job for this case?


Accepted Solutions
Highlighted
Sixteen Stars
Sixteen Stars

Re: upsert into salesforce

The minimalist design looks like tFileInputExcel-->tSalesforceOutput.
For this component you need a field declared as an External Id used by salesforce to decide the action (insert or update) for each record.

TRF

View solution in original post


All Replies
Highlighted
Sixteen Stars
Sixteen Stars

Re: upsert into salesforce

The minimalist design looks like tFileInputExcel-->tSalesforceOutput.
For this component you need a field declared as an External Id used by salesforce to decide the action (insert or update) for each record.

TRF

View solution in original post

Four Stars

Re: upsert into salesforce

I done it like TFileInputExcel ==> tMap ==> tSalesforceOutput(External Id).

It is upserting data correctly into salesforce. Thanks for reply.

But after executing talend job, giving exception:    java.io.IOException: Name not specified   - here Name is standard field (Upsert key column).

Highlighted
Sixteen Stars
Sixteen Stars

Re: upsert into salesforce

Can you share your tSalesforceOutput settings with schema?


TRF

2019 GARTNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

Talend Cloud Developer Series – Defining Metadata

This video focuses on different methods of adding metadata to a job in Talend Cloud

Watch Now

Talend Cloud Developer Series – Updating Context Variables

This video will show you how to add context parameters to a job in Talend Cloud

Watch Now

Talend Cloud Developer Series – Deploying First Job to Cloud

This video will show you how to run a job in Studio and then publish that job to Talend Cloud

Watch Now