AnsweredAssumed Answered

Query on Netsuite custom field does not work

Question asked by Sjaak Overgaauw on Mar 9, 2017
Latest reply on Apr 26, 2017 by Sjaak Overgaauw

Hi all,

One of my favourite topics: Netsuite ;-)

 

Here's what I'm trying to do: QUERY an employee record on a custom field. However, the NS connector doesn't return an XML. When I "Query" or "Get" the same record on internalId, it works. So the record is there, including the custom field value. Any idea?

 

Request message in the Netsuite integration log

 

 

Response message of Query on internalId

<?xml version="1.0" encoding="utf-8"?>
<listEmp:Employee xmlns:listEmp="urn:employees_2016_1.lists.webservices.netsuite.com" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" internalId="123456789">
<listEmp:entityId>XXXX</listEmp:entityId>
<listEmp:firstName>XXXX</listEmp:firstName>
<listEmp:lastName>XXXX</listEmp:lastName>
<listEmp:isInactive>false</listEmp:isInactive>
<listEmp:lastModifiedDate>2017-02-20T23:25:20.000-08:00</listEmp:lastModifiedDate>
<listEmp:dateCreated>2015-12-03T01:25:35.000-08:00</listEmp:dateCreated>
.....
<listEmp:customFieldList>
<platformCore:Person_Number xmlns:platformCore="urn:core_2016_1.platform.webservices.netsuite.com" internalId="2936" scriptId="custentity_employee_personnumber" xsi:type="platformCore:LongCustomFieldRef">
<platformCore:value>12345</platformCore:value>
</platformCore:Person_Number>
</listEmp:customFieldList>
</listEmp:Employee>

Outcomes