Page 1 of 1

NS ODBC - Item based tables

Posted: Thu 16 Mar 2017 13:36
by lconnor

I have been playing the Netsuite ODBC adapter and consuming this in Qlik BI tool.
Connecting to main tables this is not a problem, for example

SELECT * FROM Opportunity is working great, but I want to now get hold of the opportunity items and this does not seem to be in the list of objects along with other items such as order items etc...

I know in Netsuite everything is placed in into the 'transaction' table so the Opportunities must be 'parsed' out from the meta data or the via the web API.

How do I access these items tables / data?


Re: NS ODBC - Item based tables

Posted: Fri 17 Mar 2017 14:50
by MaximG
Unfortunately in this matter we are limited by the used NetSuite API abilities which provides access only to the following tables : ... /task.html

Re: NS ODBC - Item based tables

Posted: Fri 17 Mar 2017 15:25
by lconnor

In which case this is a big problem as I cannot also get Sales Order details.
Without being able to get these the driver is pretty much useless as a reporting connection into Netsuite unless you just want high level info.

Shame... but understand you constrained by the Netsuite API

Re: NS ODBC - Item based tables

Posted: Tue 21 Mar 2017 14:59
by MaximG
We are really limited by Netsuite API in this matter. Perhaps the situation will change for the better in the future when this API developers will remove restrictions to access the required tables.