The List Contacts action retrieves a list of contact records from Oracle NetSuite. The retrieved contact list can be used for further processing or integration with other systems.
Configuration
NetSuite - Connection (ver. 1.0.0)
URL
URL of your NetSuite instance.
Account ID
Account ID for NetSuite API.
Consumer Key
Consumer key for NetSuite API.
Consumer Secret
Consumer secret for NetSuite API.
Token ID
Token ID for NetSuite API.
Token Secret
Token secret for NetSuite API.
NetSuite - List Resources (ver. 1.0.0)
Error behavior
The available values are:
-
Fail and return response: The connector fails at the specified line but generates output with error details.
-
Fail without response: The connector fails - the error will be displayed only in the log.
-
Do not fail and return response: The connector does not fail but generates output records that may be marked with an error and detailed information.
Limit
Specifies the maximum number of contact records to retrieve in a single query. This setting helps manage data load and ensures efficient processing.
Query
Allows for the input of a specific search query or filter to refine which contact records are retrieved.
Load All Records
When checked, this option overrides the limit and attempts to load all available records that meet the query criteria.
Input & Output Schema
Input
This connector does not require a schema.
Output
NetSuite - Contact Response (ver. 1.1.0)
| Column | Data type | Allow null | Description |
|---|---|---|---|
| StatusCode | Integer | No | HTTP status code returned by the NetSuite API indicating the result of the operation |
| IsError | Bool | No | Indicates whether the operation resulted in an error |
| Message | String | Yes | Error or status message providing additional information |
| Contact | NetSuite - Contact 1.3.0 |
Yes | The contact record returned as a result of the operation |
Status Code
- 200 Success
- 400 Bad request
- 404 Not found
- 500 Server error
NetSuite - Contact (ver. 1.3.0)
| Column | Data type | Allow null | Description |
|---|---|---|---|
| IsInactive | Bool | Yes | Indicates whether the contact is inactive |
| FirstName | String | Yes | The first name of the contact |
| HomePhone | String | Yes | The home phone number of the contact |
| ExternalId | String | Yes | The external identifier for the contact |
| EntityId | String | Yes | The internal identifier for the contact |
| Title | String | Yes | The title or position of the contact |
| MobilePhone | String | Yes | The mobile phone number of the contact |
| Id | String | Yes | The unique identifier for the contact record |
| Fax | String | Yes | The fax number associated with the contact |
| AssistantPhone | String | Yes | The phone number of the contact's assistant |
| String | Yes | The email address of the contact | |
| Owner | Integer | Yes | The internal ID of the owner associated with the contact |
| IsPrivate | Bool | Yes | Indicates whether the contact is private |
| Comments | String | Yes | Comments or notes about the contact |
| LastModifiedDate | DateTime | Yes | The date and time when the contact was last modified |
| MiddleName | String | Yes | The middle name of the contact |
| DateCreated | DateTime | Yes | The date and time when the contact was created |
| GlobalSubscriptionStatus | NetSuite - Global Subscription Status 1.2.0 |
Yes | The global subscription status of the contact |
| LastName | String | Yes | The last name of the contact |
| AltEmail | String | Yes | The alternate email address for the contact |
| CustomForm | NetSuite - Custom Form 1.2.0 |
Yes | The custom form associated with the contact |
| Phone | String | Yes | The primary phone number of the contact |
| Salutation | String | Yes | The salutation for the contact (e.g., Mr., Ms.) |
| OfficePhone | String | Yes | The office phone number of the contact |
| SupervisorPhone | String | Yes | The phone number of the contact's supervisor |
| RefName | String | Yes | The reference name for the contact |
| Links | NetSuite - ID 1.2.0 |
Yes | A list of links associated with the contact |
| Image | NetSuite - ID 1.2.0 |
Yes | The image associated with the contact |
| ContactCampaignEvent | NetSuite - ID 1.2.0 |
Yes | Campaign events linked to the contact |
| Assistant | NetSuite - ID 1.2.0 |
Yes | The assistant associated with the contact |
| Company | NetSuite - Company One Of 1.2.0 |
Yes | The company associated with the contact |
| Supervisor | NetSuite - ID 1.2.0 |
Yes | The supervisor of the contact |
| ContactSourceCampaignCategory | NetSuite - ID 1.2.0 |
Yes | The campaign category source of the contact |
| ContactSource | NetSuite - ID 1.2.0 |
Yes | The source associated with the contact |
| Subsidiary | NetSuite - ID 1.2.0 |
Yes | The subsidiary associated with the contact |
| Category | NetSuite - ID 1.2.0 |
Yes | The category associated with the contact |
| NetSuite - Custom Fields | NetSuite - Custom Fields 1.2.0 |
Yes | Custom fields associated with the contact |
NetSuite - Global Subscription Status (ver. 1.2.0)
| Column | Data type | Allow null | Description |
|---|---|---|---|
| Id | String | No | The unique identifier for the global subscription status |
| RefName | String | Yes | The reference name for the global subscription status |
| NetSuite - Custom Fields | NetSuite - Custom Fields 1.2.0 |
Yes | Custom fields associated with this subscription status |
NetSuite - Custom Fields (ver. 1.2.0)
| Column | Data type | Allow null | Description |
|---|---|---|---|
| Key | String | Yes | The identifier for the custom field |
| Value | String | Yes | The value associated with the custom field |
NetSuite - Custom Form (ver. 1.2.0)
| Column | Data type | Allow null | Description |
|---|---|---|---|
| Id | String | No | The unique identifier for the custom form |
| RefName | String | Yes | The reference name for the custom form |
| NetSuite - Custom Fields | NetSuite - Custom Fields 1.2.0 |
Yes | Custom fields associated with this custom form |
NetSuite - ID (ver. 1.2.0)
| Column | Data type | Allow null | Description |
|---|---|---|---|
| ID | String | Yes | The unique identifier |
NetSuite - Company One Of (ver. 1.2.0)
| Column | Data type | Allow null | Description |
|---|---|---|---|
| NetSuiteCustomer | NetSuite - ID 1.2.0 |
Yes | The unique identifier for a customer record in NetSuite |
| NetSuitePartner | NetSuite - ID 1.2.0 |
Yes | The unique identifier for a partner record in NetSuite |
| NetSuiteVendor | NetSuite - ID 1.2.0 |
Yes | The unique identifier for a vendor record in NetSuite |
| NetSuiteNsResource | NetSuite - ID 1.2.0 |
Yes | The unique identifier for an NS resource record in NetSuite |
| NetSuiteEmployee | NetSuite - ID 1.2.0 |
Yes | The unique identifier for an employee record in NetSuite |
| NetSuiteContact | NetSuite - ID 1.2.0 |
Yes | The unique identifier for a contact record in NetSuite |
| NetSuite - Custom Fields | NetSuite - Custom Fields 1.2.0 |
Yes | Custom fields associated with the company record |