NetSuite Search Record

You can use the NetSuite Search Record activity to search records based on the specified search criteria.

This activity supports paging search. It also supports custom fields, custom records, and custom lists, see Customization for more information.

General

On the General tab, you can specify a NetSuite connection and record category. The General tab contains the following fields:

Field Module Property? Description
Name No (Required) Specify a name for the activity in the process definition.
NetSuite Connection Yes (Required) Select a shared connection resource.

Click the icon to select a space connection. If no matching NetSuite connections are found, click Create Shared Resource in the Select NetSuiteConnectionResource Resource Template dialog to create one. See Creating a NetSuite Connection Shared Resource for more details.

Record Category No (Required) Select the top-level category of the record type.
Record Subcategory No (Required) Select the subcategory of the search record type.
Search Record No (Required) Select the search record type.
Record Type No (Required) Select the record type.

Note: This field is only displayed in one of the following two conditions:
  • If you select Lists from the Record Category list, select Accounting from the Record Subcategory list, and select ItemSearch from the Search Record list.
  • If you select Transactions from the Record Category list, select Sales from the Record Subcategory list, and select TransactionSearch from the Search Record list.

Page Size Yes (Required) Specify the maximum number of records that are to be returned on each page.

The value must be an integer that is greater than or equal to 5. The default value is 100. The recommended value is in the range 100 - 5000.

Description

On the Description tab, you can enter a short description for the activity.

Input

On the Input tab, you can specify the fields that you require. The Input tab contains the following fields:

Field Data Type Description
searchRecord
basic N/A The attributes of the specified search record type. For more information about the attributes, see NetSuite related documentation.

Note: On the General tab, if you select Lists from the Record Category list, Accounting from the Record Subcategory list, and SubsidiarySearch from the Search Record list, any input in the state element does not take effect.

Output

On the Output tab, you can check the response information. The Output tab contains the following fields:

Output Item Data Type Description
Success Boolean This property indicates the status of all the operations. If no error occurs when searching records, the status true is returned.
Message String The error messages or warning messages returned from the NetSuite system.
SearchResult   The SearchResult element contains the following elements:
  • totalRecords (A String value): The total number of searched records.
  • pageSize (A String value): The maximum number of records that are to be returned on each page. It is the same as the value specified on the General tab.
  • totalPages (A String value): The number of pages.
  • pageIndex (A String value): The index of the current page.
  • searchId (A String value): The search ID of this operation. The value in this field was allocated by the NetSuite system.
  • RecordList: This element contains the following subelement:
    • record: The attributes of a searched record. For more information about the attributes, see NetSuite related documents.

Fault

The Fault tab lists exceptions that might occur when you use this activity. For more detailed information, see Error Codes.

Error Schema Element Data Type Description
NetSuitePluginException
msg string The TIBCO ActiveMatrix BusinessWorks Plug-in for NetSuite error message.
msgCode string The TIBCO ActiveMatrix BusinessWorks Plug-in for NetSuite error code.
NetSuiteServerException
msg string The NetSuite system error message when processing a request from the plug-in.
msgCode string The NetSuite system error code when processing a request from the plug-in.
NetSuiteMSG String The NetSuite server error message when processing a request from the plug-in.