Proposal Summary
This proposal covers the the integration of Netsuite and Google Cloud Storage to send the report data from Netsuite to Google Cloud Storage.
Requirements
Client needs to fetch the NetSuite report data and sent it to the Google Cloud Storage.
Solution
The standard NetSuite report has limitations on customizations. So, we will create a custom report page using a script. On this custom page, the XSEED can filter Subsidiaries, Accounts, and Date period. According to the filter provided, the script will generate and display the report. The custom report will be the replica of the ‘XSEED General Ledger’ report in NetSuite with an additional column ‘Cost Center Grouped’.
We will add a custom Button ‘Send Report’ to this custom page to download and send the report to Google Cloud Storage. A copy will be stored in the file cabinet in NetSuite
We can integrate NetSuite with Google Cloud Storage using REST APIs. The XSEED needs to set up the Google Cloud Storage environment and provide the client credentials, bucket details, permissions for transferring NetSuite and Google Cloud Storage.
We will generate access tokens using the credentials provided by XSEED. By using the access token, we will connect and sent the report data generated from the custom report page to the Google Cloud Storage bucket.
For error handling, we will create a custom record. So, if any error occurred while sending the report data from NetSuite to Cloud storage, it will be stored in the custom record for future reference.
API References
Cloud Storage API reference: Cloud Storage JSON API overview | Google Cloud
Inserting object to bucket: Objects: insert | Cloud Storage | Google Cloud
Headers and query params: HTTP headers and common query string parameters for JSON | Cloud Storage | Google Cloud
Status and error Codes: HTTP status and error codes for JSON | Cloud Storage | Google Cloud
Deliverables
- XSEED need to set up Google Cloud Storage Environment
- Using Client Credentials, generate access tokens.
- Deploy a script to create a custom report page as like ‘XSEED General Ledger’
- Add ‘Send Report’ button to the custom report page
- Deploy script in NetSuite to connect and send report data to Google Cloud Storage when ‘Send Report’ is clicked
Assumptions
- Assuming XSEED will set up their Google Cloud Environment
- Assuming XSEED will provide the client credentials for generating access tokens
- Assuming we need to only consider ‘XSEED General Ledger’ report
- Assuming the report data need to be sent when ‘Send Report’ is clicked
- Assuming XSEED will provide the format of report data need to be in CSV raw format.
Limitations
- If the XSEED fails to provide the correct credentials, the data transfer between NetSuite and Google cloud storage will be failed
- There will be a performance issue in the custom report page as the script needs to create search and display them.
- If the report data needs to be sent other than mentioned scheduled basis, XSEED needs to manually execute the script.
Time and Effort
Total Hours: 46 Hours