SalesForce adding external Id to output

[Anonymous]

Hi,
I've a simple question, on a SalesForce connection (but it's not important).
Let's suppose I've the following csv to import (AccountImport):
- External_Id
- Name
I've to write in an object who have a lookup on account (MyObj):
- Account__c
- Name
Before I do the mapping, I made a lookup to retrive the record Id instead of External_Id to correct write in destination Object (MyObj).
When I have the waste record to write the log, I would to obtain the reference to external Id and not to the original Id.
The chain is:
tSalesForceInput (Account)/ tFileInputDelimited --> tMap --> tSalesForceOutput --> tFileOutputDelimited (error record)
How I can do?
Thank you.

[Anonymous]

Hi,
The "NB_LINK" global variables is used to count the total number of records have been proceed. Not the detailed info about which record is inserted successfully or not.
The "ERROR_MESSAGE" global variables is used to log the error in this component. If there is no error in current component, it will show "null".
For your requirement, it seems that you need the rejected record by tSaleforceOutput. If so, please uncheck the "Extend Output" option in Advanced Setting and you will get the "Reject" row from tSaleforceOutput.
See my screenshot
Best regards
Sabrina

[_AnonymousUser]

_anthony_ : Have you considered simply making a lookup table for the id's? You just store the external and internal id's somewhere and look up the one you need when you get it.
Not sure exactly how you can do that most efficiently in Talend, but it's possible in many ways.

[Anonymous]

Hi _anthony_,
Is there any update for your issue? Feel free post your issue on forum.
Best regards
Sabrina

[Anonymous]

Hi,
now I've partially solved my issue using the bulk output apex.
But I can't obtain the external Id.
Thnak you.

[Anonymous]

Hi,
Could you give us your new design workflow screenshot? Did you add the External_Id into output?
Best regards
Sabrina