topic Re: Not getting look up field (Id) on rejected updates in Talend Studio

Not getting look up field (Id) on rejected updates

Anonymous — Fri, 05 Oct 2018 11:44:58 GMT

Hi people,

How can i get the Id (look up field) of the row that was rejected during the update? I've tried doing different things like adding a t-map but nothing, guess it has something to do with the join that is made on the update. See attached files.

Thnx!

Re: Not getting look up field (Id) on rejected updates

manodwhb — Fri, 05 Oct 2018 11:52:39 GMT

@JoseQ,you will not get the Id for the rejected record from tSaleforce components. since you need to verify the records based on source that i believe that reference Key is missing to update.

Re: Not getting look up field (Id) on rejected updates

Anonymous — Fri, 05 Oct 2018 11:59:31 GMT

Thnx for your quick answer @manodwhb. But how can i associate the error message to especific Id?

My input file only contains a list of Salesforce ids, how can i get the ones that wasn´t updated?

img3.JPG

Re: Not getting look up field (Id) on rejected updates

TRF — Fri, 05 Oct 2018 12:26:38 GMT

Maybe I misunderstoo your question.

Any way, are you sure the Ids you provide for the lookup match with the object type you want to join?

Re: Not getting look up field (Id) on rejected updates

Anonymous — Fri, 05 Oct 2018 12:44:53 GMT

Yes, actually if you see i only have a few rejections. The thing is:

-Input file only contains a few Salesforce ID that i need to update.

-T-map and all componets are working as espected.

-Tfile for updated records are showing rows and info perfectly.

* Issue, the rejected tfile contains all the rows that were rejected but only showing message error, is not linked to the Id that generates the error, Id column is null. Ej.:

Id Error

FIELD_CUSTOM_VALIDATION_EXCEPTION::--

INVALID_CROSS_REFERENCE_KEY:invalid cross reference id:--

How can i get these 2 ids? i only have an error description on the file.