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
- 2K Product Ideas
- 2K Ideas Exchange
- 1.6K Connect
- 1.3K Connectors
- 311 Workbench
- 7 Cloud Amplifier
- 9 Federated
- 3K Transform
- 114 SQL DataFlows
- 654 Datasets
- 2.2K Magic ETL
- 4.1K Visualize
- 2.5K Charting
- 803 Beast Mode
- 79 App Studio
- 44 Variables
- 758 Automate
- 188 Apps
- 480 APIs & Domo Developer
- 73 Workflows
- 17 DomoAI
- 40 Predict
- 17 Jupyter Workspaces
- 23 R & Python Tiles
- 408 Distribute
- 119 Domo Everywhere
- 279 Scheduled Reports
- 10 Software Integrations
- 141 Manage
- 137 Governance & Security
- 8 Domo Community Gallery
- 47 Product Releases
- 12 Domo University
- 5.4K Community Forums
- 41 Getting Started
- 31 Community Member Introductions
- 114 Community Announcements
- 4.8K Archive