You can work with the following types of NetSuite RESTlet V2 objects in Data Integration:
Standard objects
The standard object type for NetSuite. Standard objects, such as Accounts and Customer, are packaged within NetSuite.
You can read data from and write data to standard objects.
The following image shows how a standard object for a NetSuite RESTlet V2 source is displayed in Data Integration:
The label specifies the parent record and the name specifies the metadata that the record holds.
For example, the name customer_child_contact with label customer is a standard record with customer as the parent and contact as the child.
Custom objects
A standard object that you can create to hold data in the structure that you want. NetSuite system administrators and users with required permissions can define custom fields for standard and custom records.
You can read data from and write data to custom objects. You can use a custom NetSuite RESTlet V2 object as a single source.
The following image shows how a custom object for a NetSuite RESTlet V2 source is displayed in Data Integration:
A record whose label starts with the term customrecord is a custom record. The name represents the name that you specified at the time of creating the custom records in the NetSuite account.
Saved searches
A reusable search definition that can include one or more advanced search criteria and search results. You can use a standard join to combine two or more standard objects in saved searches. You can use a custom join to combine standard objects with custom objects in saved searches.
You can use a saved search NetSuite RESTlet V2 object as a single source. You cannot write data to saved search objects.
The following image shows how a saved search object for a NetSuite RESTlet V2 source is displayed in Data Integration:
A record that has a numeric label is a saved search. The name of the record is the title of the saved search that you specified while saving the saved search in the Netsuite account. The name is appended with the id of the saved search.
Search record objects
A search object to search records based on the specified search criteria.
You cannot write data to search record objects.
The following image shows how a search record object for a NetSuite RESTlet V2 source is displayed in Data Integration:
A record that has the same name and label, both ending with _SR, is a search record.
Sibling objects
Sibling objects can be loaded as separate records for an SR object. You can see all the search joins for an SR object listed in the record browser.
You cannot write data to sibling objects.
The following image shows how a sibling object for a NetSuite RESTlet V2 source is displayed in Data Integration:
A sibling record has the parent name followed by the search join ID. The search join ID is received from the record browser.
For example, the object parent_employee_sibling_location is a sibling object with employee as the parent name and location as the search join ID.
