Collectors
      Back to home
      1. Knowledge Base
      2. Connect & Transform
      3. Collectors

      NetSuite OpenAir Collectors

      Overview

      DataBlend collects all Netsuite OpenAir data types; including but not limited to:

      • Accounting Periods

      • Agreements

      • Approval Processes

      • Attachments

      • Bookings

      • BookingTypes

      • Categories

      • Contacts

      • Cost Centers

      • Customer POs

      • Customers

      • Deals

      • Envelopes

      • Events

      • Invoices

      • Items

      • Job Codes

      • Newsfeeds

      • Payment Types

      • Payroll Types

      • Products

      • Projects

      • Purchase Items

      • Purchase Orders

      • Purchase Requests

      • Purchasers

      • Rate Cards

      • Request Items

      • Slip Stages

      • Slips

      • Tasks

      • Tax Locations

      • Tax Rates

      • Tickets

      • Time Types

      • Timesheets

      • User Locations

      • Users

      • Vendors

      • Workspaces

      Configuration

      Field

       

      Required/ Optional

       

      Comments

       

      Type

      Required

      NetSuite OpenAir

      Name

      Required

      Descriptive free-text name for the collector

      Data Source

      Required

      Select a pre-configured data source from the drop down or click Create New to create a new data source.

      Schema Name

      Required

      Enter a name for the schema where the collected data will be stored. This can be a pre-configured schema or a new schema which will be created the first time the collector is run.

      Credential

      Required

      Select a pre-configured NetSuite OpenAir credential from the drop-down.

      Use Custom Fields

      Optional

      Enable or Disable via the Use Custom Fields button.
      Collected Data

      The NetSuite OpenAir attribute metadata collection returns the complete set of all custom attributes (excluding the trading partner system attribute for consolidation instances), including member values. DataBlend makes these available in a tabular format with the following columns:

       

      Column Name

      Description

      rowtype

      Value will be either Attribute or AttributeValue.

      Indicates whether the row represents a custom attribute or the value of a custom attribute.

      parentid

      Populated for attribute values only.

      Indicates this value's parent attribute or attribute value.

      id

      OpenAir internal id number. This value is required when making updates to the attribute or attribute value.

      name

      Name of the attribute or attribute value.

      type

      Populated for attributes only.
      Value will be either account, level, or dimension.

      Indicates whether the attribute can be applied to a OpenAir account, level or dimension.

      autocreate

      Populated for attributes only.
      Value will be either 0 or 1.

      Indicates whether an attribute value can be created automatically for this attribute when data is loaded. If 0, attribute values will not be created. If 1, attribute values will be created.

      keepsorted

      DataBlend is aware of an issue where no values for keepsorted are returned.

      dimensionid

      Populated for attributes of type dimension only.

      Indicates the custom dimension the attribute is associated with.

      seqno

      Per OpenAir API docs:

      Added in API v17 but reserved for future use.