NetSuite Connector > Mappings and mapping tasks with NetSuite > NetSuite objects in mappings
  

NetSuite objects in mappings

When you create a mapping, you can configure a Source or Lookup transformation to represent a NetSuite object.

NetSuite sources in mappings

In a mapping, you can configure a Source transformation to represent a single NetSuite source or multiple NetSuite sources.
You can use multiple related NetSuite standard objects as a source. You can select a standard object as the primary source, then you add one or more sibling objects or a single child object. When you select a list/record type object, its related object appears in the sibling list. NetSuite does not support the use of child and sibling objects at the same time.
The following table describes the NetSuite source properties that you can configure in a Source transformation:
Property
Description
Connection
Name of the source connection.
Source type
Select Single Object or Multiple Objects.
Object
For a single source. Select the source object.
Add Source Object
For multiple sources. Select the primary object.
Add Child Object
For multiple sources. Select the desired child object.
Add Sibling Objects
For multiple sources. Select the desired sibling objects.
Filter
Filters value in a read operation. You can add conditions to filter records and reduce the number of rows that the Secure Agent reads from the source.
Sort
Not supported.
The following table describes the NetSuite source advanced properties that you can configure in a Source transformation:
Advanced Property
Description
Start Date
Start date and time to capture the changed data. Use the following format: YYYY-MM-DD'T'hh:mm:ss.SSSSZ.
To perform a full read, do not use the Start Date and End Date properties.
End Date
End date and time to capture the changed data. Use the following format: YYYY-MM-DD'T'hh:mm:ss.SSSSZ.
To perform a full read, do not use the Start Date and End Date properties.
Page Size
Number of rows that the Secure Agent fetches per page. Default is 100 rows. The maximum value is 1000.
Get Deleted
Includes records that were deleted between the start date and end date for changed data capture.
Concurrent Threads
Number of concurrent threads. Specify the number of concurrent threads allowed.
To use concurrent threads for mapping tasks, your NetSuite account must be concurrency-enabled.
To optimize performance results with concurrent threads, your administrator might need to adjust the heap size. For example, a heap size of 512 MB for 10 threads might optimize performance results.
Default value is 1.
You cannot use a saved search as a source object in a mapping task that uses concurrent threads.
Maximum Number of Records to Be Read
Maximum number of records read from the source. For example, a value of 100 means that the agent reads 100 records from the source. The default value is 0, which means the agent reads all records.
Number of Retry
Number of times the agent attempts to execute the request. Default value is 0.
Note: Retry mechanism works after the transaction starts.
Retry Delay
Number of seconds the agent waits before it executes the request again. Default value is 200.
The agent reconnects to the NetSuite port every time it executes the request and send the existing search ID to the NetSuite port.

Adding multiple source objects

To use multiple source objects in a Source transformation, you select the primary source object and the child or sibling objects on the Source tab of the Properties panel.
    1In the Objects and Relationships section, click the arrow to open the Action menu and then select Add Source Object.
    2Select the primary object.
    3Click the arrow in the primary object's row and from the Related Object Actions menu, select either Add Child Object or Add Sibling Objects.
    4Select the desired child object or one or more sibling objects.
    After you select the source objects, the Objects and Relationships section displays the source objects and the relationship between the objects, as shown in the following image:

NetSuite lookups in mappings

In a mapping, you can configure a Lookup transformation to represent a NetSuite object. You can use Netsuite standard objects and custom objects as lookups.
When you use a NetSuite object as a lookup, you do not need to configure specific NetSuite properties. You can use a custom field in a lookup condition if the field is filterable.