Skip to main content
waffle.svg
Domo Knowledge Base

NetSuite OpenAir Connector

Intro

NetSuite OpenAir gives professional services organizations the ability to run their core business operations including project management, resource optimization, project accounting, time and expense management, and billing and revenue recognition. Use the Domo NetSuite OpenAir connector to pull data about customers, projects, profile types, slips, time cards, and users. To learn more about the NetSuite OpenAir API, visit their page (https://www.openair.com/download/Net...MLAPIGuide.pdf).

You connect to your NetSuite OpenAir account in the Data Center. This topic discusses the fields and menus that are specific to the NetSuite OpenAir connector user interface. General information for adding DataSets, setting update schedules, and editing DataSet information is discussed in Adding a DataSet Using a Data Connector.

Prerequisites

To connect to your NetSuite OpenAir account and create a DataSet, you must have the following:

  • The username and password for your company's NetSuite OpenAir account.

  • The company name for the account.

  • The URL for the account's OpenAir instance.

  • The account's API namespace.

  • The account's API key.

To obtain the API namespace and key, reach out to your NetSuite OpenAir account representative.

Connecting to Your NetSuite OpenAir Account

This section enumerates the options in the Credentials and Details panes in the NetSuite OpenAir Connector page. The components of the other panes in this page, Scheduling and Name & Describe Your DataSet, are universal across most connector types and are discussed in greater length in Adding a DataSet Using a Data Connector.

Credentials Pane

This pane contains fields for entering credentials to connect to your NetSuite OpenAir account. The following table describes what is needed for each field:  

Field

Description

Username

Enter the username for your company's NetSuite OpenAir account.

Password

Enter the password for your company's NetSuite OpenAir account.

Company

Enter the company name associated with the account.

URL

Enter the URL for the account's NetSuite OpenAir instance.

Namespace

Enter the account's API namespace as received from NetSuite.

API Key

Enter the account's API key as received from NetSuite.

Once you have entered valid NetSuite OpenAir credentials, you can use the same account any time you go to create a new NetSuite OpenAir DataSet. You can manage connector accounts in the Accounts tab in the Data Center. For more information about this tab, see Managing User Accounts for Connectors.

Details Pane

This pane contains a single menu from which you select a report.

Menu

Description

Report

Select the NetSuite OpenAir report you want to run. The following reports are available:

Customers Returns data about customers for your account.
Projects Returns data about projects for your account.
Resource Profile Type Returns data about resource profile types for your account.
Slips Returns data about slips for your account.
Task Time Cards Returns data about task time cards for your account.
Users Returns data about users for your account.

Other Panes

For information about the remaining sections of the connector interface, including how to configure scheduling, retry, and update options, see Adding a DataSet Using a Data Connector.