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

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

Vishu1 — Sat, 16 Nov 2024 08:26:35 GMT

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!

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

TRF — Sun, 08 Apr 2018 09:12:41 GMT

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

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

manodwhb — Mon, 09 Apr 2018 08:01:19 GMT

@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.

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

Vishu1 — Mon, 09 Apr 2018 12:01:56 GMT

It works after passing salesforce Id to component.

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

Thanks

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

TRF — Mon, 09 Apr 2018 12:44:58 GMT

Hi,

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

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

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

Vishu1 — Mon, 09 Apr 2018 12:48:23 GMT

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.