The Insert or Update Contact action enables either the insertion of a new contact or the updating of an existing contact in Oracle NetSuite.
Configuration
NetSuite - Connection (ver. 1.0.0)
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 - Configuration (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.
Input & Output Schema
Input
NetSuite - Contact Update Request (ver. 1.1.0)
| Column | Data type | Allow null | Description |
|---|---|---|---|
| ID | String | No | The unique identifier for the contact to be updated |
| Contact | NetSuite - Contact 1.3.0 |
No | The updated contact details to be applied to the specified contact |
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 |
Output
NetSuite - Response (ver. 1.0.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 there was an error during the operation |
| Message | String | Yes | Error or status message providing additional information |
Status Code
- 200 Success
- 400 Bad request
- 404 Not found
- 500 Server error