NetSuite Connector

Back Next

Configuring the NetSuiteCustomFields.ini file

You can specify custom NetSuite fields in the

Record Custom Fields

connection property when you configure a NetSuite connection so that the fields are available in

Data Integration

. Alternatively, if the NetSuite connection uses a Secure Agent group as the runtime environment, you can specify the custom NetSuite fields in the

NetSuiteCustomFields.ini

file.

If you choose to configure the

NetSuiteCustomFields.ini

file, perform the following steps:

Make a copy of the

NetSuiteCustomFields.ini

file, located in the following directory:

<Secure Agent installation directory>\downloads\packageNetsuiteConnector.<version>\package\rdtm\javalib

Use the following guidelines to change the file to include custom NetSuite fields:

Create a separate section for each NetSuite record for which you want to add custom fields.

Add the custom fields using the following format, where the value of scriptId is the ID field in the NetSuite user interface for each custom field:

[<Object Name>]
scriptIds = <custom field name1>,<custom field name2>,<custom field name3>

For example:

[Sales]
scriptIds = discountPrice,salesDescription,salesEvent

Add the custom fields for NetSuite advanced search using the following format, where the value of scriptId is the ID field in the NetSuite user interface for each custom field:

[<Object Name>]
scriptIds = <custom field name1>,<custom field name2>,<custom field name3>

For example:

[EmployeeSearchAdvanced]
scriptIds = custentity74,custentity66

If you want to read

or write

custom segment data, use the following format to add the custom segment fields:

[<Object Name>]
custSegScriptIds=custseg1:select,custseg2:multiselect,custseg3:select....

where the value of scriptId is the ID field in the NetSuite user interface for each custom segment field.

For example:

[Employee]
custSegScriptIds=custbody18:select,custbody19:multiselect,custbody20:select....

If you want to read data from

or write data to

child record custom segments, use the following format to add the child custom segment fields:

[<Object Name>]
custSegScriptIds=custseg1:select,custseg2:multiselect,custseg3:select....

For example:

[JournalEntry]
custSegScriptIds=custbody_cseg1:select,custbody_cseg2:select,custbody_cseg3:select

[JournalEntryLineList]
custSegScriptIds=custcol_cseg1:select,custcol_cseg2:select,custcol_cseg3:select

Save the

NetSuiteCustomFields.ini

in the following location:

<Secure Agent installation directory>\apps\Data_Integration_Server\ext\deploy_to_main\bin\rdtm-extra\reserved\userfiles\netsuite

The custom segment fields, which you add either in

NetSuiteCustomFields.ini

or connection properties, are not validated. For example, the metadata and duplicate field names.

Rename Saved Search

Table of Contents

NetSuite Connector

NetSuite Connector

Configuring the NetSuiteCustomFields.ini file

Configuring the NetSuiteCustomFields.ini file