Discussions
Read on for the latest updates including:
• Agenda Builder launch
• SuiteWorld On Air registration
• New NetSuite Prompt Studio Contest
• And more!
Check out this thread to learn more!
REST API and SQL Join Tables.
Hi,
I could use some help with SQL Join tables.
I am trying to figure out the proper Fields to use when joining tables with the rest API.
i am mainly working with the following tables - and would like to know which fields to use for the join when matching Records with various tables.
Transaction
Transaction line
Transaction accounting line
Customers
Vendors
Account
Subsidiary
Entity
etc.
Q: Is there a URL that provides the information for the fields to be used when we join these types of tables together with SQL and RestAPI?
like ... where transaction.id = transactionline.transaction - and more like that?