Skip to content
background-image background-image

Oracle Netsuite

Get Contact

NetSuite - Contact

  • Version

    3.0

  • Agent restriction

    None

  • Processing type

    Row by row

  • Multi-input step

    Not Supported

The Get Contact action retrieves detailed information about a specific contact in Oracle NetSuite. It is designed to access a single contact record using unique identifiers, providing users with precise and comprehensive details for further processing or review.

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 - 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 - ID (ver. 1.2.0)

Column Data type Allow null Description
ID String Yes The unique identifier

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
Email 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