How do you find tables in the new NetSuite2.com connector?

Shana · 2025-03-07T21:12:20+00:00

There was an error rendering this rich post.

I am having trouble finding some basic tables in the new NetSuite2.com connection. Things like Product_Line and PRODUCT_TYPE, basic smaller tables that you need just to pull in the description of something. I've tried looking into NetSuite resources and their connection reference table looks like it probably only has a quarter of the available tables. Are there any other resources out there that have mapped NetSuite.com to NetSuite2.com?

Find more posts tagged with

Accepted answers

All comments

chapman

Setup a new NetSuite2.com ODBC dataset in Domo and use this query:SELECT * FROM OA_TABLES

This will give you a list of all the tables in your instance. You can also use SELECT * FROM OA_COLUMNS which will give you all the columns in all the tables.

Shana

Hi Chapman!

I do have these but I'm missing A LOT of tables and fields within tables that I have found. Is there an a accurate listing of table/field name conversions someone for the NetSuite to NetSuite2 conversion?