topic Re: tNetSuiteInput obtain company data from recordref in Talend Studio

tNetSuiteInput obtain company data from recordref

Anonymous — Tue, 06 Oct 2015 15:09:28 GMT

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?

Re: tNetSuiteInput obtain company data from recordref

Anonymous — Mon, 12 Oct 2015 07:18:01 GMT

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

Re: tNetSuiteInput obtain company data from recordref

Anonymous — Mon, 02 Nov 2015 17:58:58 GMT

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.