| 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, choose 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.
Field | Required | Comments |
|---|---|---|
Type | Required | NetSuite |
Name | Required | Free-text. |
Data Source | Required | Select from list of configured data sources. Data sources are configured separately. |
Schema | Required | Free-text. Used when writing queries against the collected data. If a schema with this name does not already exist, one will be created under the selected data source. |
Credential | Required | Select from the list of configured NetSuite credentials. |
NetSuite Collector Type | Required | Select Saved Search. |
URL | Required | The URL of the deployed RESTlet. |
Search Id | Required | The Internal Id of the saved search. |
Flatten Results | Default is true. |
...
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.
...
Flattening the collected data places each field of each embedded object in its own column making it easier to query. In the example below, the collector’s Flatten Results value is “true”; the nested fields from each object are placed in their own columns.
...