Contents
Create RESTlet Script Records in NetSuite
Create DataBlend Bulk Import Data Target
Create RESTlet Script Records in NetSuite
1. Log into NetSuite to create a new script from the Customization menu > Scripting > Scripts > New.
2. If you have not added a Bulk Export script before or the script in NetSuite is outdated, download the according DataBlend script from the table in NetSuite Data Targets, then hover your mouse over the SCRIPT FILE box to click the ‘+ Add’ button.
Subrecord.js
Map-reduce-wrapper.js
Status-results.js
Bulk-import.js
3. If the script is the latest version but a new script record needs to be created, click the double-down arrows to click on List, search for the file, and select it.
4. Enter a file name with the date for versioning control, select the script file downloaded, and Save the record. Important! File name should have .js at the end of the name.
5. Select the created script and click Create Script Record.
6. Enter a name for the script and note the API version. Click on the down arrow next to Save to click the Save and Deploy button. Important! File name should have .js at the end of the name.
7. Set the deployment STATUS to Released, LOG LEVEL to Error, ensure DEPLOYED is checked, set the security access as appropriate, and Save to deploy the script.
8. Navigate back to Customization > Scripting > Scripts > New to repeat the steps for creating the other scripts: subrecord.js, map-reduce-wrapper.js, status-results.js, and bulk-import.js until all are in NetSuite.
Reminder: deactivate outdated scripts.
Create DataBlend Bulk Import Data Target
1. In DataBlend, create a Data Target with the Bulk Import object type and a selected Record Type. Refer to netsuite.com/help/helpcenter/en_US/srbrowser/Browser2022_2/script/record/account.html for required Query fields (click on the alphabetical buttons, such as C for the Customer fields).
2. In NetSuite, copy the EXTERNAL URL from the bulk-import script and paste into DataBlend’s Script URL. If “Use Map/Reduce Script” is toggled on, the Status URL field becomes required. In NetSuite, search to open the “SuiteScripts” page and click edit on the map-reduce script to copy the URL and paste into DataBlend.
3. Choose a Batch Size, Save and Run Data Target.
