![]() ![]() ![]() Go to Setup -> Company -> Enable Features. To use the stored procedure, deploy a RESTlet in NetSuite, note the Deployment & Script IDs and the ID of the Saved Search you want to process, and call the stored procedure.įollow the steps below to deploy the included script and execute the RESTlet by executing a SELECT query: To view the results of a saved search, users can leverage the CreateRESTletSchema stored procedure to create views (read-only tables) of RESTlets. The screenshot below showcases a saved search in the NetSuite UI (left) and the same results in Visual Studio Server Explorer using the CData ADO.NET Provider (right). Users can quickly and easily see the results of saved searches, regardless of any complexities in the report, whether those are JOINs with other tables, formulas on fields, summaries, and more. With the added support for RESTlets in the CData Drivers, users get SQL access to their NetSuite saved searches, exactly as they appear within the NetSuite UI. ![]() NetSuite RESTlets are server-side scripts that interact with NetSuite data following RESTful principles. This article shows how to query a RESTlet in NetSuite. You can use CData Drivers to create reports on NetSuite data, and you can also access existing reports. The CData Drivers (JDBC, ODBC, API Server, ADO.NET, SSIS, BizTalk, and Excel) implement standards-based SQL access to various data sources, enabling third-party tools to interoperate.
0 Comments
Leave a Reply. |