This feature is now available as part of the July 2025 SmartConnect Update.

SmartConnect can query data out of NetSuite via a custom NetSuite RESTlet. This can be used to leverage Saved Searches in a lookup.

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 in to 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 Lookup

1. On the Integration tab, click on the Additional Columns tab
2. Click the Add Additional Column button

3. Name – Enter a name for the column
4. Type – Select RESTlet Lookup
5. Endpoint – Read-only field showing the RESTlet URL
6. Add required parameters
   • Query – Added as URL parameters.
   • Body – Added to the body of the request

6. Return Fields – Select the field(s) that will be returned from the lookup
7. If No Data – Select the required option if no data is found

8. Late Bound Lookup – If the lookup should run after the calculations and restrictions
9. Include lookup result in scripting – If the result of the lookup should be available to use in Calculated Columns

Using a RESTlet Schema

The fields returned by the RESTlet can be formatted and persisted, if necessary, by defining them in the schema.

Load initial Schema

1. Build your lookup query
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 ensure correct data interpretation

5. 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 RESTlet Lookup
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 RESTlet Lookup
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