List Contacts is a powerful action that simplifies your contact management by seamlessly retrieving a list of contacts from the NetSuite API. This functionality enhances your ability to access and organize vital contact information, enabling you to maintain strong relationships and improve communication within your organization. By integrating this action into your workflows, you can streamline data retrieval processes, ensuring that you have the most up-to-date contact details at your fingertips. Whether you're a small business or a large enterprise, List Contacts helps you optimize your operations and make informed decisions based on accurate and accessible data.
Configuration
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 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 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.
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.
Input & Output Schema
Input
This connector does not require a schema.
Output
NetSuite - Contact Response (ver. 1.5.0)
| Column | Data type | Allow null | Description |
|---|---|---|---|
| StatusCode | Integer | No | Indicates the status of the operation |
| IsError | Bool | No | Specifies whether an error occurred during the operation |
| Message | String | Yes | Provides additional information about the operation result |
| Contact | NetSuite - Contact v1.7.0 |
Yes | Contains the details of the contact retrieved from NetSuite |
NetSuite - ID (ver. 1.2.0)
| Column | Data type | Allow null | Description |
|---|---|---|---|
| ID | String | Yes | The unique identifier |
NetSuite - Contact (ver. 1.7.0)
| Column | Data type | Allow null | Description |
|---|---|---|---|
| IsInactive | Bool | Yes | Indicates if the contact is inactive or not |
| FirstName | String | Yes | The first name of the contact |
| HomePhone | String | Yes | The home phone number of the contact |
| ExternalID | String | Yes | A unique identifier for the contact in external systems |
| EntityID | String | Yes | The internal identifier for the contact in NetSuite |
| Title | String | Yes | The job title 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 of 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 identifier of the user who owns the contact record |
| IsPrivate | Bool | Yes | Indicates if the contact's information is private |
| Comments | String | Yes | Additional 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 v1.4.0 |
Yes | The global subscription status of the contact |
| LastName | String | Yes | The last name of the contact |
| AltEmail | String | Yes | An alternative email address for the contact |
| CustomForm | NetSuite - Custom Form v1.4.0 |
Yes | The custom form associated with the contact |
| Phone | String | Yes | The primary phone number of the contact |
| Salutation | String | Yes | The salutation used for the contact |
| 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 - Ns Link v1.1.0 |
Yes | Links related to the contact record |
| Image | NetSuite - Ns Resource v1.6.0 |
Yes | The image associated with the contact |
| ContactCampaignEvent | NetSuite - Ns Resource v1.6.0 |
Yes | The campaign events associated with the contact |
| Assistant | NetSuite - ID v1.2.0 |
Yes | The identifier for the contact's assistant |
| Company | NetSuite - ID v1.2.0 |
Yes | The identifier for the company associated with the contact |
| Supervisor | NetSuite - ID v1.2.0 |
Yes | The identifier for the contact's supervisor |
| ContactSourceCampaignCategory | NetSuite - Ns Resource v1.6.0 |
Yes | The campaign category source for the contact |
| ContactSource | NetSuite - Ns Resource v1.6.0 |
Yes | The source of the contact information |
| Subsidiary | NetSuite - ID v1.2.0 |
Yes | The identifier for the subsidiary associated with the contact |
| Category | NetSuite - Contact Category Collection v1.0.0 |
Yes | The category assigned to the contact |
| CustomFields | JSON | Yes | Custom fields associated with the contact record |
NetSuite - Global Subscription Status (ver. 1.4.0)
| Column | Data type | Allow null | Description |
|---|---|---|---|
| ID | String | No | Unique identifier for the contact in NetSuite |
| RefName | String | Yes | Display name of the contact used for reference |
| CustomFields | JSON | Yes | Additional user-defined fields for the contact |
NetSuite - Custom Form (ver. 1.4.0)
| Column | Data type | Allow null | Description |
|---|---|---|---|
| ID | String | No | Unique identifier for the contact in NetSuite |
| RefName | String | Yes | Display name of the contact used for reference |
| CustomFields | JSON | Yes | Additional user-defined fields for the contact |
NetSuite - Ns Link (ver. 1.1.0)
| Column | Data type | Allow null | Description |
|---|---|---|---|
| Rel | String | Yes | Represents the relationship identifier for the Netsuite account |
| Href | String | Yes | Contains the URL link to access the Netsuite account |
| CustomFields | JSON | Yes | Holds additional custom field data specific to the Netsuite account |
NetSuite - Ns Resource (ver. 1.6.0)
| Column | Data type | Allow null | Description |
|---|---|---|---|
| ID | String | No | Unique identifier for the Netsuite account |
| RefName | String | Yes | User-friendly name for the Netsuite account |
| ExternalID | String | Yes | Identifier used for external references to the account |
| Links | NetSuite - Ns Link v1.1.0 |
Yes | Links to related resources or entities in Netsuite |
| CustomFields | JSON | Yes | Additional custom attributes specific to the Netsuite account |
NetSuite - Contact Category Collection (ver. 1.0.0)
| Column | Data type | Allow null | Description |
|---|---|---|---|
| TotalResults | Integer | Yes | Represents the total number of contacts retrieved from NetSuite |
| Items | NetSuite - ID v1.2.0 |
Yes | Contains the details of individual contacts from NetSuite |
| Links | NetSuite - Ns Link v1.1.0 |
Yes | Provides links to related resources for the contacts |
| Count | Integer | Yes | Indicates the number of contacts returned in the current response |
| HasMore | Bool | Yes | Indicates whether there are more contacts available for retrieval |
| Offset | Integer | Yes | Specifies the starting point for the next set of contacts to retrieve |
| CustomFields | JSON | Yes | Holds additional custom field data associated with the contacts |