NS ODBC - Item based tables

NS ODBC - Item based tables

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

Re: NS ODBC - Item based tables

Postby 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/en_US/srbrowser/Browser2016_2/schema/record/task.html
MaximG
Devart Team
 
Posts: 738
Joined: Mon 06 Jul 2015 11:34

Re: NS ODBC - Item based tables

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

Re: NS ODBC - Item based tables

Postby 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.
MaximG
Devart Team
 
Posts: 738
Joined: Mon 06 Jul 2015 11:34


Return to ODBC Drivers