A SuiteQL data source can retrieve up to 100,000 records from NetSuite based on a custom query.

Create a SuiteQL Data Source

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

8. Click Preview and make sure the expected data is returned

9. Click Save and close the data source

Using SuiteQL Schema

By default, a SuiteQL data source will only return fields that contain data. So it may be necessary to define your fields in the data source schema to ensure they are always available when previewing and running integrations even if the returned data does not contain all expected fields.

Load initial Schema

1. Build your query and ensure the preview data is the expected response
2. Click the Schema tab
3. Click Load Schema – this will run a sample query and add all returned columns
4. Optionally – edit the data type of fields to enable sorting in the integration

5. Click Validate
6. Click Save

Modify Schema

If small changes are made to the query, it may be required to edit the schema using these steps.

1. Open an existing SuiteQL query data source
2. Click Validate
3. Click the Schema tab
4. Click Refresh Schema to add any new fields – this will not remove existing fields
5. Add Column allows you to manually add a column if it is not being returned in the sample query
6. Click Validate
7. Click Save

Recreate Schema

If large changes are made to the query, it may be required to rebuild the schema using these steps.

1. Open an existing SuiteQL query data source
2. Click Validate
3. Click the Schema tab
4. Click Clear Schema -will remove all schema columns from the source
5. Click Load Schema – this will run a sample query and add all returned columns
6. Click Validate
7. Click Save