NS ODBC - Item based tables

[lconnor]

Hi,

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?

Thanks
Lee

[MaximG]

Unfortunately in this matter we are limited by the used NetSuite API abilities which provides access only to the following tables :
http://www.netsuite.com/help/helpcenter ... /task.html

[lconnor]

Hmm,

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

[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.