| Table of Contents |
|---|
Summary:
DataBlend uses NetSuite RESTlet functionality to run a saved search and collect the results. For this to work, a NetSuite administrator must create the saved search and RESTlet, and then a DataBlend user can configure the collector.
These instructions assume the saved search has already been configured.
Configure the RESTlet
| Attachments | ||||||
|---|---|---|---|---|---|---|
|
Download the DataBlend saved search RESTlet from the link above.
From the Customization menu, create a new script.
Mouse over the downward chevrons and then click the '+' button.
Enter a file name, select the script file downloaded earlier and save the record.
Create the script record.
Select RESTlet as the script type.
Enter a name for the script.
Enter GetSavedSearch in the Get Function field.
Save and Deploy the script.
Set the deployment status to Released and set the security access as appropriate, then save to deploy the script.
Note the External URL for the DataBlend collector configuration.
Find the ID of the Saved Search
Use the Report → Saved Searches menu option to open the list of NetSuite saved searches.
Identify the internal id of the search results to be collected by DataBlend.
Configuring the Collector in DataBlend
Add a new collector.
Complete the configuration fields and save the collector.
...
3. Use the Collect Now button to run the collection and initialize the schema.
...
Flattening Results
Some columns from a NetSuite Saved Search will be returned as embedded objects; a single column may itself include several related fields. In the example below, the collector’s Flatten Results value is “false”; in the collected data account and department are embedded objects while amount is a simple value.
...