• Knowledge Base
  • SmartConnect
  • Dedicated Connections
  • NetSuite
  • Creating a SuiteQL Query Data Source

Creating a SuiteQL Query Data Source

Published: Aug 19, 2024

Creating a SuiteQL Query Data Source

Published: Aug 19, 2024
  1. On the left side options column expand Data Sources > Bulk Sources > QueryQuerySourceLocation 4
  2. On the Query Data Sources page click Create Bulk Query buttonCreateBulkQueryButton 4
  3. Select NetSuite SuiteQL Query Data Source
  4. Name – A friendly name for the data source
  5. Connection – Select the NetSuite connection to be used from the dropdown list
  6. Click Validate – this will enable the Query section
  7. Query (SuiteQL) – In the Query editor create a SuiteQL query
  1. Click Preview and make sure the expected data is returned
SuiteQL Data Source

Use NVL() and an alias to make sure every column is available in Return Fields even if the first record doesn’t contain a value in that column

  1. Click Save and close the data source

Feeling stuck? Get the support and guidance you need to help you power through any data challenge

We're on your integration team. Connect with our people and let us know how we can help you.

Get support
Reset Filters