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
- 6 Cloud Amplifier
- 9 Federated
- 3.8K Transform
- 657 Datasets
- 115 SQL DataFlows
- 2.2K Magic ETL
- 815 Beast Mode
- 3.3K Visualize
- 2.5K Charting
- 81 App Studio
- 45 Variables
- 775 Automate
- 190 Apps
- 481 APIs & Domo Developer
- 81 Workflows
- 23 Code Engine
- 40 AI and Machine Learning
- 20 AI Chat
- 1 AI Playground
- 1 AI Projects and Models
- 18 Jupyter Workspaces
- 410 Distribute
- 120 Domo Everywhere
- 280 Scheduled Reports
- 10 Software Integrations
- 144 Manage
- 140 Governance & Security
- 8 Domo Community Gallery
- 48 Product Releases
- 12 Domo University
- 5.4K Community Forums
- 41 Getting Started
- 31 Community Member Introductions
- 114 Community Announcements
- 4.8K Archive