Due to scheduled maintenance, some areas of our Shop and Manage Plan pages are currently inaccessible. Thank you for your patience.

Please reach out to sales@eonesolutions.com with any questions.

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 > Query
  2. On the Query Data Sources page click Create Bulk Query button
  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

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