Netsuite Component Help

One Star

Netsuite Component Help

I'm using the tNetsuiteInput component and having someone issues receiving some data from it. I configured the component to retrieve data from the Employee Record Type. I can pull data like FirstName, LastName, etc., but some data I cannot pull. One example is the Department Field where I try to pull the data, but since it is a RecordRef object type Talend returns it as an object and returns an address to the value, but not the value: "com.netsuite.webservices.platform.core.RecordRef@######". Now I have read on the Netsuite site that in order to get the actual value for this field I need to make an API call called "getSelectValue" with the RecordRef object as a parameter. I could make a work around this issue, but I was wondering if there is a way using the Talend component to get the actual value instead of the RecordRef object.
Thanks,
Michael
Moderator

Re: Netsuite Component Help

Hi Michael,
Could you select a type of record you want to retrieve?
Feel free to create a workitem jira issue of DI project on Talend Bug Tracker.
https://jira.talendforge.org/secure/Dashboard.jspa
Best regards
Sabrina
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
One Star

Re: Netsuite Component Help

I selected the Employee Record Type and got data for all the employees in my company. The issue I was running into was that for some of the fields such as Department and Supervisor the values that were returning were "com.netsuite.webservices.platform.core.RecordRef@######" which is a RecordRef object. Now I don't want the RecordRef object, but the actually value for an employee's department. 
One Star

Re: Netsuite Component Help

I selected the Employee Record Type and got data for all the employees in my company. The issue I was running into was that for some of the fields such as Department and Supervisor the values that were returning were "com.netsuite.webservices.platform.core.RecordRef@######" which is a RecordRef object. Now I don't want the RecordRef object, but the actually value for an employee's department. 

I have the exact same problem. Have you found any solution to this?
Thank you very much!
One Star

Re: Netsuite Component Help

Is anyone has an answer for this? Please advise. Thanks.
One Star

Re: Netsuite Component Help

CPFung, 
Were you able to resolve this. If so could you advise on the solution.  
I am seeing the same thing. 
One Star

Re: Netsuite Component Help

The way I recently dealt with 'RecordRef' objects coming out from Netsuite input component is using a library to serialize them to XML. So I got an XML string with a couple of elements: 'name' and 'internalId'
Resulting XML string can then be converted to Document type in Talend or simply parsed to extract values from each child node.
Check out these pages too:
http://x-stream.github.io/index.html
https://dzone.com/articles/convert-java-object-xml-and
Regards,