NetSuite Sales Order component not returning customFieldList (enabling customisations returns custcol instead of custbody)

One Star

NetSuite Sales Order component not returning customFieldList (enabling customisations returns custcol instead of custbody)

Hi all,
When trying to use the NetSuite components to integrate data, we can successfully connect and set fields, but on the SalesOrder object, when getting the definition of the object, customFieldList is NOT returned and if enabling customisations, the custom records that are returned are the custcol items which relate to the SalesOrderItems rather than the custbody records which relate to the SalesOrder itself - these are within the SalesOrder.itemList, so we tried ensuring customFieldList was returned first in case it only took the first instance, but that didn't work.  This appears to be isolated to SalesOrder, Customer correctly returns the custom fields prefixed with custentity.
Even if you specifically add the fields to the tNetSuiteOutput component, the data is NOT pushed to the NetSuite request, meaning these items cannot be set.
We can see that NetSuite is correctly returning the list, but Talend is not adding the correct records to the schema and it seems if the fields are not in the schema, they will not be passed to NetSuite even if you manually add them.

The Soap body being sent is this, even though we have explicitly added custbody values into the list, they are not sent to NetSuite.

<soap:Body><ns2:updateList xmlns:ns20="urn:employees_2016_2.transactions.webservices.netsuite.com" xmlns:ns10="urn:accounting_2016_2.lists.webservices.netsuite.com" xmlns:ns21="urn:purchases_2016_2.transactions.webservices.netsuite.com" xmlns:ns11="urn:sales_2016_2.transactions.webservices.netsuite.com" xmlns:ns22="urn:employees_2016_2.lists.webservices.netsuite.com" xmlns:ns12="urn:demandplanning_2016_2.transactions.webservices.netsuite.com" xmlns:ns23="urn:bank_2016_2.transactions.webservices.netsuite.com" xmlns:ns13="urn:financial_2016_2.transactions.webservices.netsuite.com" xmlns:ns14="urn:supplychain_2016_2.lists.webservices.netsuite.com" xmlns:ns15="urn:scheduling_2016_2.activities.webservices.netsuite.com" xmlns:ns16="urn:support_2016_2.lists.webservices.netsuite.com" xmlns:ns17="urn:website_2016_2.lists.webservices.netsuite.com" xmlns:ns2="urn:messages_2016_2.platform.webservices.netsuite.com" xmlns:ns18="urn:customers_2016_2.transactions.webservices.netsuite.com" xmlns:ns19="urn:general_2016_2.transactions.webservices.netsuite.com" xmlns="urn:core_2016_2.platform.webservices.netsuite.com" xmlns:ns8="urn:customization_2016_2.setup.webservices.netsuite.com" xmlns:ns7="urn:filecabinet_2016_2.documents.webservices.netsuite.com" xmlns:ns9="urn:marketing_2016_2.lists.webservices.netsuite.com" xmlns:ns4="urn:relationships_2016_2.lists.webservices.netsuite.com" xmlns:ns3="urn:faults_2016_2.platform.webservices.netsuite.com" xmlns:ns6="urn:communication_2016_2.general.webservices.netsuite.com" xmlns:ns5="urn:common_2016_2.platform.webservices.netsuite.com" xmlns:ns24="urn:inventory_2016_2.transactions.webservices.netsuite.com"><ns2:record xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:type="ns11:SalesOrder" externalId="61:37c7402c-1dd4-4d79-b4f0-c171e2cb1e9a"><ns11:entity type="customer" externalId="61:0581fa83-d10a-40f6-9798-0b6243e84c4c"/><ns11:tranDate>2016-03-01T00:00:00.000+11:00</ns11:tranDate><ns11:otherRefNum>PO HERE</ns11:otherRefNum><ns11:memo>Memo</ns11:memo><ns11:terms type="term" internalId="2"/></ns2:record></ns2:updateList></soap:Body>

Has anyone come across this?
Talend schema for SalesOrder: https://www.netsuite.com/help/helpcenter/en_US/srbrowser/Browser2016_2/schema/record/salesorder.html
TalendPic1.PNGTalendPic2.PNG
Thanks in advance!!

Tags (1)

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Best Practices for Using Context Variables with Talend – Part 2

Part 2 of a series on Context Variables

Blog

Best Practices for Using Context Variables with Talend – Part 1

Learn how to do cool things with Context Variables

Blog

Best Practices for Using Context Variables with Talend – Part 3

Read about some useful Context Variable ideas

Blog