Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

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?
Labels (2)
2 Replies
Anonymous
Not applicable
Author

Hi
Which version are you using? I see the schema of Contact type contains internalID and externalID columns on version 5.6.2. see
0683p000009MBod.png
Best regards
Shong
Anonymous
Not applicable
Author

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.