NetSuite

From Starfish ETL
Revision as of 20:15, 1 December 2015 by Ahoekstra (talk | contribs) (Created page with "= Connection String = ''AccountId'': '''Required''' (Number) The Account ID for your Netsuite organization. You can retrieve this number in NetSuite, in the Integration secti...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search

Connection String

AccountId: Required (Number) The Account ID for your Netsuite organization. You can retrieve this number in NetSuite, in the Integration section under Setup.

LogoutUnknownSessions: (Boolean) If you cannot log in because it's complaining there is already an active session, try using this session to force those other sessions to be invalidated.

MaximumConcurrentSessions: (Number) If you wish to use multithreading while writing to NetSuite, you must use this setting. By default, NetSuite does not support mutltithreading. This only becomes available if you have purchased and activated the SuiteCloud Plus license for NetSuite. This will give you the ability to use up to 10 concurrent sessions. If you wish to use 10 threads, then set this parameter to 10, and also use 10 as the value in the Thread Count property on the Run Job tab in Starfish. Using multithreading with NetSuite will greatly improve the speed of writing. If you have to move a large amount of data, we highly recommend acquiring this license.


Picklists

When writing to NetSuite Picklist fields, you cannot write the value of the picklist to the field. You must instead reference the Internal Id of the picklist value you wish to use. These can be obtained in the Customization section under Setup. Using a hand-built Xref list for large lists would be recommended practice.

Aggregate Fields (Addresses)

Function ScriptedField dim xml xml = "<Customer_AddressbookList>" xml = xml & "<Row>" xml = xml & "<AddressbookList_DefaultShipping>true</AddressbookList_DefaultShipping>" xml = xml & "<AddressbookList_DefaultBilling>true</AddressbookList_DefaultBilling>" xml = xml & "<AddressbookList_Label>Address</AddressbookList_Label>" xml = xml & "<AddressbookList_addressee>@@ORG:Name@@</AddressbookList_addressee>" xml = xml & "<AddressbookList_Addr1>@@ORG:ShippingStreet@@</AddressbookList_Addr1>" xml = xml & "<AddressbookList_City>@@ORG:ShippingCity@@</AddressbookList_City>" xml = xml & "<AddressbookList_Zip>@@ORG:ShippingPostalCode@@</AddressbookList_Zip>" xml = xml & "<AddressbookList_State>@@ORG:ShippingState@@</AddressbookList_State>" xml = xml & "<AddressbookList_Country>@@ORG:ShippingCountry@@</AddressbookList_Country>" xml = xml & "</Row></Customer_AddressbookList>" ScriptedField=xml End Function

Retrieved from "https://wiki.starfishetl.com/index.php?title=NetSuite&oldid=4988"