NS ODBC - Item based tables

Discussion of open issues, suggestions and bugs regarding usage of ODBC Drivers
Post Reply
lconnor
Posts: 2
Joined: Thu 16 Mar 2017 13:25

NS ODBC - Item based tables

Post by lconnor » Thu 16 Mar 2017 13:36

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
Devart Team
Posts: 1030
Joined: Mon 06 Jul 2015 11:34

Re: NS ODBC - Item based tables

Post by MaximG » Fri 17 Mar 2017 14:50

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
Posts: 2
Joined: Thu 16 Mar 2017 13:25

Re: NS ODBC - Item based tables

Post by lconnor » Fri 17 Mar 2017 15:25

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
Devart Team
Posts: 1030
Joined: Mon 06 Jul 2015 11:34

Re: NS ODBC - Item based tables

Post by MaximG » Tue 21 Mar 2017 14:59

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.

Post Reply