Our platform enables you to quickly and easily connect your data sources to NetSuite Objects.

This enables a one-way synchronization to occur – where any changes in the NetSuite Objects are downloaded into your data source on a regular basis.

Your data source will be automatically updated in this way until you remove the connector or an error occurs (such as losing authorization to access the database).

Adding

Data Source Settings

• Navigate the side menu to Data Hub > Data Sources
• Hover over a data source and click the “Settings” icon link ()
• In Settings, hit the “Add Connector” button
• Select the relevant option to add the connector

This will refresh the page with the newly added connector ready for configuration.

Nothing has been saved at this stage, so save your connector after making any changes to enable or update it.

Alternatively, if you’re viewing the rows of a data source, you can navigate to the Settings page using the option under the page’s title.

Configuring

Refresh Frequency

The time interval during which data is pulled and refreshed by this connector.

NetSuite Object

The name of the NetSuite Object that will be queried.

e.g, Company, PurchaseOrder, SalesOrder
For a comprehensive list of all of the NetSuite Objects please go to the Finding Record Types and Field Names and SuiteScript Records Browser pages.

Fields

Specify all of the fields that will be returned from the query, comma-separated.
e.g ID, Name, Lastname

For more info, please visit the Finding Record Types and Field Names and SuiteScript Records Browser pages.

If FUNCTIONS / CASE Statements are used, please ensure you give the column an alias using the ‘AS’ keyword.
e.g SUBSTR(…) AS ID, Name, Lastname

Filter

Add an optional filter clause to the query that will only return desired records.
e.g WHERE Lastname = ‘Good’.

When you save your changes, the connector will fire for the first time and run at the scheduled interval. Please wait a minute, or click the three-dot menu (  ) and select Run Now to trigger it manually. Then, check the Rows in your data source.

If rows are not downloaded, there may be an error with the FTP connection. To troubleshoot the issue, click the three-dot menu (  ) and select View Logs to review

When you save your changes, the connector will be fired for the first time, and after that, it will run at the refresh frequency you specified in the connector settings.

This connector allows large data sets to be pulled from NetSuite due to paging implemented when fetching rows, thereby reducing single request API limits.