{"id":9657,"date":"2022-05-23T21:18:19","date_gmt":"2022-05-23T21:18:19","guid":{"rendered":"https:\/\/zappysys.com\/blog\/?p=9657"},"modified":"2025-12-11T11:54:29","modified_gmt":"2025-12-11T11:54:29","slug":"call-netsuite-restlet-ssis-odbc","status":"publish","type":"post","link":"https:\/\/zappysys.com\/blog\/call-netsuite-restlet-ssis-odbc\/","title":{"rendered":"How to call NetSuite RESTlet API in SSIS \/ ODBC"},"content":{"rendered":"

Introduction<\/h2>\n

\"\"<\/a>In our previous post we saw how to read API data in SSIS<\/a>. This post we will cover how to call NetSuite RESTlet<\/a> to read \/ write data in SSIS or ODBC Apps. For demo purpose we will use SSIS PowerPack REST API Task<\/a> but concepts and many UI elements remain same for ODBC JSON Driver<\/a> too. This article assumes you know how to write Netsuite RESTlet and you have obtained Credentials to call RESTlet from extranal app.<\/p>\n

<\/h2>\n

<\/h2>\n

What is NetSuite RESTlets<\/h2>\n

NetSuite added a really nice feature to expose business data and workflows as API by writing Javascript functions which they call it RESTlets<\/strong>. You can secure and customize these restlets as per your need.<\/p>\n

You can automate CRUD (Create \/Read \/ Write \/ Delete) operations in NetSuite by writing special functions in JavaScript and expose those functions as API URL which can be called by any external Systems (i.e. SSIS Packages , ODBC Apps like Power BI, Informatica, SSRS).<\/p>\n

RESTlet can be secured few ways such as OAuth 1.0 and OAuth 2.0 authentication. We will cover both approach briefly in this article. You can choose any one as per your need<\/p>\n

Prerequisites<\/span><\/h2>\r\nBefore we perform the steps listed in this article, you will need to make sure the following prerequisites are met:\r\n
    \r\n \t
  1. SSIS<\/abbr> designer installed.\u00a0Sometimes it is referred to as BIDS<\/abbr> or SSDT<\/abbr> (download it from the Microsoft site<\/a>).<\/li>\r\n \t
  2. Basic knowledge of SSIS package\u00a0development using\u00a0Microsoft SQL Server Integration Services<\/em>.<\/li>\r\n \t
  3. Make sure\u00a0ZappySys SSIS PowerPack<\/a><\/span>\u00a0is installed (download it<\/a>, if you haven't already).<\/li>\r\n \t
  4. (Optional step<\/em>).<\/em>\u00a0Read this article<\/a>, if you are planning to deploy packages to a server and schedule their execution later.<\/li>\r\n<\/ol><\/div>\n

    Creating NetSuite RESTlet \/ Obtain OAuth Credentials (Client ID and Secret)<\/h2>\n

    Below video shows how to obtain necessary credentials to call Netsuites API (RESTlet).<\/p>\n

    At mark 4:30 seconds it will show you How to use OAuth 2.0\u00a0for calling RESTlet<\/p>\n

    <\/div><\/div>
    <\/div>
    <\/div>
    <\/div><\/div><\/div>