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

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?
Answers
-
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.0 -
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?
0
Categories
- All Categories
- 1.9K Product Ideas
- 1.9K Ideas Exchange
- 1.6K Connect
- 1.3K Connectors
- 307 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 3K Transform
- 112 SQL DataFlows
- 649 Datasets
- 2.2K Magic ETL
- 4K Visualize
- 2.5K Charting
- 790 Beast Mode
- 78 App Studio
- 43 Variables
- 745 Automate
- 187 Apps
- 475 APIs & Domo Developer
- 67 Workflows
- 16 DomoAI
- 40 Predict
- 17 Jupyter Workspaces
- 23 R & Python Tiles
- 406 Distribute
- 117 Domo Everywhere
- 279 Scheduled Reports
- 10 Software Integrations
- 139 Manage
- 136 Governance & Security
- 8 Domo Community Gallery
- 47 Product Releases
- 12 Domo University
- 5.4K Community Forums
- 41 Getting Started
- 31 Community Member Introductions
- 113 Community Announcements
- 4.8K Archive