topic Netsuite Component Help in Talend Studio

Netsuite Component Help

Anonymous — Wed, 26 Aug 2015 18:56:39 GMT

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

Re: Netsuite Component Help

Anonymous — Fri, 28 Aug 2015 03:32:29 GMT

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

Re: Netsuite Component Help

Anonymous — Tue, 01 Sep 2015 17:52:39 GMT

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.

Re: Netsuite Component Help

_AnonymousUser — Thu, 11 Feb 2016 13:13:18 GMT

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!

Re: Netsuite Component Help

Anonymous — Sun, 06 Nov 2016 08:45:35 GMT

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

Re: Netsuite Component Help

Anonymous — Mon, 20 Feb 2017 20:05:37 GMT

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

Re: Netsuite Component Help

Anonymous — Sat, 11 Mar 2017 16:12:01 GMT

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,