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
NS ODBC - Item based tables
Re: NS ODBC - Item based tables
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
http://www.netsuite.com/help/helpcenter ... /task.html
Re: NS ODBC - Item based tables
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
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
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.