Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Thanks in advance!!