Skip to main content
waffle.svg
Domo Knowledge Base

NetSuite OpenAir Connector

Version 7

 

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 user ID and password for your company's NetSuite OpenAir account.

  • The company ID 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

User ID

Enter the user ID for your company's NetSuite OpenAir account.

Password

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

Company ID

Enter the company ID 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:

Attribute Receives data about NetSuite OpenAir Attribute reports.
Attribute Set Receives data about NetSuite OpenAir Attribute Set reports.
Booking Receives data about NetSuite OpenAir Booking reports.
Booking By Day Receives data about NetSuite OpenAir Booking By Day reports.
Booking Request Receives data about NetSuite OpenAir Booking Request reports.
Booking Type Receives data about NetSuite OpenAir Booking Type reports.
Budget Receives data about NetSuite OpenAir Budget reports.
Budget Allocation Receives data about NetSuite OpenAir Budget Allocation reports.
Category Receives data about NetSuite OpenAir Category reports.
Customers Receives data about NetSuite OpenAir Customers reports.
Department Receives data about NetSuite OpenAir Department reports.
Entity Tag Receives data about NetSuite OpenAir Entity Tag reports.
Hierarchy Receives data about NetSuite OpenAir Hierarchy reports.
Hierarchy Node Receives data about NetSuite OpenAir Hierarchy Node reports.
Invoice Receives data about NetSuite OpenAir Invoice reports.
Item Receives data about NetSuite OpenAir Item reports.
Job Code Receives data about NetSuite OpenAir Job Code reports.
Loaded Cost Receives data about NetSuite OpenAir Loaded Cost reports.
Product Receives data about NetSuite OpenAir Product reports.
Project Assign Receives data about NetSuite OpenAir Project Assign reports.
Project Assignment Profile Receives data about NetSuite OpenAir Project Assignment Profile reports.
Project Billing Rule Receives data about NetSuite OpenAir Project Billing Rule reports.
Project Billing Transaction Receives data about NetSuite OpenAir Project Billing Transaction reports.
Project Budget Group Receives data about NetSuite OpenAir Project Budget Group reports.
Project Budget Rule Receives data about NetSuite OpenAir Project Budget Rule reports.
Project Budget Transaction Receives data about NetSuite OpenAir Project Budget Transaction reports.
Project Location Receives data about NetSuite OpenAir Project Location reports.
Project Group Receives data about NetSuite OpenAir Project Group reports.
Project Stage Receives data about NetSuite OpenAir Project Stage reports.
Project Task Receives data about NetSuite OpenAir Project Task reports.
Project Task Assign Receives data about NetSuite OpenAir Project Task Assign reports.
Project Task Type Receives data about NetSuite OpenAir Project Task Type reports.
Projects Receives data about NetSuite OpenAir Projects reports.
Ratecard Receives data about NetSuite OpenAir Ratecard reports.
Ratecard Item Receives data about NetSuite OpenAir Ratecard Item reports.
Resource Profile Receives data about NetSuite OpenAir Resource Profile reports.
Resource Profile Type Receives data about NetSuite OpenAir Resource Profile Type reports.
Resource Request Receives data about NetSuite OpenAir Resource Request reports.
Revenue Container Receives data about NetSuite OpenAir Revenue Container reports.
Revenue Projection Receives data about NetSuite OpenAir Revenue Projection reports.
Revenue Recognition Rule Receives data about NetSuite OpenAir Revenue Recognition Rule reports.
Revenue Recognition Rule Amount Receives data about NetSuite OpenAir Revenue Recognition Rule Amount reports.
Revenue Recognition Transaction Receives data about NetSuite OpenAir Revenue Recognition Transaction reports.
Revenue Stage Receives data about NetSuite OpenAir Revenue Stage reports.
Role Receives data about NetSuite OpenAir Role reports.
Schedule By Day Receives data about NetSuite OpenAir Schedule By Day reports.
Schedule Exception Receives data about NetSuite OpenAir Schedule Exception reports.
Schedule Request Receives data about NetSuite OpenAir Schedule Request reports.
Schedule Request Item Receives data about NetSuite OpenAir Schedule Request Item reports.
Slips Receives data about NetSuite OpenAir Slips reports.
Slips Projection Receives data about NetSuite OpenAir Slips Projection reports.
Slips Stage Receives data about NetSuite OpenAir Slips Stage reports.
Tag Group Receives data about NetSuite OpenAir Tag Group reports.
Tag Group Attribute Receives data about NetSuite OpenAir Tag Group Attribute reports.
Target Utilization Receives data about NetSuite OpenAir Target Utilization reports.
Task Receives data about NetSuite OpenAir Task reports.
Task Time Cards Receives data about NetSuite OpenAir Task Time Cards reports.
Timecard Receives data about NetSuite OpenAir Timecard reports.
Timesheet Receives data about NetSuite OpenAir Timesheet reports.
Timetype Receives data about NetSuite OpenAir Timetype reports.
Uprate Receives data about NetSuite OpenAir Uprate reports.
Users Receives data about NetSuite OpenAir Users reports.
Users Location Receives data about NetSuite OpenAir Users Location reports.
Vendor Receives data about NetSuite OpenAir Vendor reports.
Include Custom Fields Select this option if you would like custom fields to be returned with the dataset you have selected.
Date Type Filter Select the required Date Type Filter to filter the records.

Note: Please select None, to return complete data
User IDs Enter the comma separated (,) values of User Ids for which the report should run. User Ids can be found in Users report.

Note: If User Id's are not provided, then report will run for the current user.
Duration Select the duration for the report (a Single Date, or a Date Range).
Single Date Select whether the report data is for a specific date or for a relative number of days back from today.
Specific Date Select the specific date using the date selector.
Relative Date Enter the number of days back that you would like to get data for in the Days Back field. Specify either today or 0, yesterday or 1, or today-7 or 7 to get data for 7 days into the past.
Date Range Select the specific or relative date range.
Start Date - Specific Select the first date in your date range using the date selector.
End Date - Specific Select the last date in your date range using the date selector.
Start Date - Relative

Enter the number of days back that you would like to get data from (start day). Combine with End Date to create a range of represented days.

For example, if you entered 10 for Start Date and 5 for End Date, the report would contain data for 10 days ago up until 5 days ago.

End Date - Relative

Enter the number of days back that you would like to get data to (end day). Combine with Start Date to create a range of represented days.

For example, if you entered 10 for Start Date and 5 for End Date, the report would contain data for 10 days ago up until 5 days ago.

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.