Id cannot be resolved or is not a field in tSalesforceOutput while updating "Opportunity"

Six Stars

Id cannot be resolved or is not a field in tSalesforceOutput while updating "Opportunity"

Hello guys,

 

I am trying to update a field in Opportunity module using tSalesforceOutput but I am getting error,

Id cannot be resolved or is not a field

 

But I am not using any Id field in tSalesforceOutput while updating Opportunity.

Need help!

 

 


Accepted Solutions
Forteen Stars

Re: Id cannot be resolved or is not a field in tSalesforceOutput while updating "Opportunity"

@Vishu,since you need to update based on the key filed in Salesforce,Id is field,you can update,since you need to do lookup with Opportunity and to get the Id and ,need to be updated based on Id in Opportunity.

Manohar B
Don't forget to give kudos/accept the solution when a replay is helpful.

All Replies
Fifteen Stars TRF
Fifteen Stars

Re: Id cannot be resolved or is not a field in tSalesforceOutput while updating "Opportunity"

Hi,
Share your tSalesforceOutput Settings, Advanced Settings and Schema definition.

TRF
Forteen Stars

Re: Id cannot be resolved or is not a field in tSalesforceOutput while updating "Opportunity"

@Vishu,since you need to update based on the key filed in Salesforce,Id is field,you can update,since you need to do lookup with Opportunity and to get the Id and ,need to be updated based on Id in Opportunity.

Manohar B
Don't forget to give kudos/accept the solution when a replay is helpful.
Six Stars

Re: Id cannot be resolved or is not a field in tSalesforceOutput while updating "Opportunity"

It works after passing salesforce Id to component.

Initially I was not using Id field to update the record.

Thanks

Fifteen Stars TRF
Fifteen Stars

Re: Id cannot be resolved or is not a field in tSalesforceOutput while updating "Opportunity"

Hi,

Don't know what you refer by "Initially"?

Salesforce Id object has always been required as it identify the record to be updated.


TRF
Six Stars

Re: Id cannot be resolved or is not a field in tSalesforceOutput while updating "Opportunity"

Actually I am new to Salesforce and I was in impression that we can update records same like traditional SQL.

So I just used those fields based on which I need to update the record, was unaware that salesforce Id is sufficient.

 

 

What’s New for Talend Spring ’19

Watch the recorded webinar!

Watch Now

Definitive Guide to Data Quality

Create systems and workflow to manage clean data ingestion and data transformation.

Download

Tutorial

Introduction to Talend Open Studio for Data Integration.

Watch

Downloads and Trials

Test drive Talend's enterprise products.

Downloads