SmartConnect can query data out of NetSuite via a custom NetSuite RESTlet as a data source.

Retrieve RESTlet Parameters

Before you can interact with the RESTlet, you must get the Script ID and Deployment ID from the NetSuite script record.

1. Log into NetSuite
2. Navigate to Customization > Scripting > Script Deployments
3. Open your RESTlet script deployment
4. Copy the Script Id and Deployment Id from the URL and save for later

Configure RESTlet Data Source

1. Log into SmartConnect
2. On the left side options column expand Data Sources > Bulk Sources > Query

3. On the Query Data Sources page click Create Bulk Query button
4. Select NetSuite RESTlet Query Data Source
5. Name – A friendly name for the data source
6. Connection – Select the NetSuite connection to be used from the dropdown list
7. Click Validate – this will enable the Parameter section
8. Add required parameters
   • Query – Added as URL parameters.
   • Body – Added to the body of the request

9. Click Save and close the data source