You are not logged in.

Unanswered posts



Important! This site has been replaced. All content here is read-only. Please visit our brand-new community at https://community.talend.com/. We look forward to hearing from you there!



#1 2015-08-26 18:56:39

mchiosi
Member
4 posts

mchiosi said:

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

Last edited by mchiosi (2015-08-26 18:57:25)

Offline

#2 2015-08-28 03:32:29

xdshi
Talend Team


xdshi said:

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


What we can do is to make sure that Talend will be your best choice!

Offline

#3 2015-09-01 17:52:39

mchiosi
Member
4 posts

mchiosi said:

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. 

Offline

#4 2016-02-11 14:13:18

talenda2z
Guest

talenda2z said:

Re: Netsuite Component Help

   mchiosi wrote:

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!

#5 2016-11-06 09:45:35

cpfung
Member
1 post

cpfung said:

Re: Netsuite Component Help

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

Offline

#6 2017-02-20 21:05:37

dtomczak
Member
2 posts

dtomczak said:

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. 

Offline

#7 2017-03-11 17:12:01

ybautista
Member
6 posts

ybautista said:

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,

Last edited by ybautista (2017-03-11 17:14:00)

Offline

Board footer

Talend Contributor Agreement - Talend Website Privacy Policy