tNetSuiteInput obtain company data from recordref

One Star

tNetSuiteInput obtain company data from recordref

Greetings,
I am trying to join contacts to customers using the tNetSuiteInput component and noticed that the contact returns a recordref as opposed to an internal ID for the parent customer entity. 
Is there any way to obtain the internal ID for the parent customer in order to join contacts to their parent customer using the tNetSuite components?
Community Manager

Re: tNetSuiteInput obtain company data from recordref

Hi
Which version are you using? I see the schema of Contact type contains internalID and externalID columns on version 5.6.2. see

Best regards
Shong
----------------------------------------------------------
Talend | Data Agility for Modern Business
One Star

Re: tNetSuiteInput obtain company data from recordref

Shong,
I have tested on version 5.6.2 and 6.0 and each version has yielded the same result. The Internal and ExternalIDs are both visible for the record itself, but the parent record references (i.e. 'Company' on the contacts table return recordref strings that include neither the internal or external ID of the parent customer). 
In NetSuite's CSV import utility the user can select either the parent record name internal ID or external ID when importing contacts. In talend, none of the aforementioned fields work in the output component. 
Pulling a sample contact from the database will exemplify what I'm talking about. For any parent record reference, a strange string including an '@' symbol is returned as opposed to an internalID, externalID or parent record name.