Talend Connect
Virtual Summit
JOIN US!
And visit the Customer
& Community Lounge.
May 27-28, wherever you are.

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

Highlighted
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)
Highlighted
Community Manager

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

Hi
It seems like a bug, can you please open a jira issue on bugtracker? Our developers will investigate it, and you can discuss it with developers directly.
https://jira.talendforge.org/secure/Dashboard.jspa

Regards
Shong
----------------------------------------------------------
Talend | Data Agility for Modern Business

2019 GARTNER 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

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