Invoke a JavaScript API virtual export with paging

From the Resources menu, select Scripts.

At the right, click + Create script.

Name your new script (ex. exportVirtualPaging_Script).

Write the JavaScript code in the Edit content field.

1. The script must have at least one entry-point function – handleRequest(options) below.

2. It must handle any errors.

3. In this case, it calls exports.runVirtualWithPaging( options ).

4. Update pageSize values based on the business need, such that the response size limit is well below the 5 MB max limit per page. Note that Celigo currently supports a maximum of 1000 pages.

5. Define the export with the options object definition, as shown below in the NSObject JSON structure:

   Note

   The export object definition in the example below is for NetSuite. For other applications, you must use the export API endpoint (https://api.integrator.io/v1/exports/<exportId>) endpoint to get the object definition.

   import { exports } from 'integrator-api';
   
   function handleRequest(options) {
     
     let success = true;
     let invokeExportResponse;
     let nsObject;
     let response = {};
     
     nsObject = return_NetSuite_Export_Obj(options);
   
     try {
       const pagingObj = {
         export:nsObject
       }
       if (options.body && options.body.pagedExportState) {
           pagingObj.pagedExportState = options.body.pagedExportState
         }
       invokeExportResponse = exports.runVirtualWithPaging(pagingObj);
       response.statusCode = 200;
     } 
     
     catch (e) {
       invokeExportResponse = JSON.stringify(e);
       console.log(JSON.stringify(e), e.code, e.message)
       response.statusCode = 400;
     }
   
     response.body = invokeExportResponse;
   
     function return_NetSuite_Export_Obj(options) {
     
       let netSuiteObject = {
         "_connectionId": '6363916275366d48c0f1521d',
         "asynchronous": true,
         "pageSize": 5,
         "netsuite": {
             "type": "restlet",
             "skipGrouping": true,
             "statsOnly": false,
             "restlet": {
                 "recordType": "item",
                 "searchId": "69",
                 "restletVersion": "suiteapp2.0",
                 "markExportedBatchSize": 100
             },
             "distributed": {}
         },
         "adaptorType": "NetSuiteExport"
       };
       return netSuiteObject;
     }
   
     return {
       statusCode: response.statusCode,
       headers: {},
       body: response.body,
     };
   }
   
   

Save the script.

Navigate to Resources → API token.

Click + Create API token at the upper right.

Enter a name (ex. Run virtual export paging).

In the Token permissions section, select Custom scopes.

From the JavaScript API(s) list, select the JavaScript API you created in step B, (ex. Demo – exports.runVirtualPaging(options)).

Click Save & close.