Discussions
Stay up-to-date with the latest news from NetSuite. You’ll be in the know about how to connect with peers and take your business to new heights at our virtual, in-person, on demand events, and much more.
New AI Community Guidelines. Please review and follow them to ensure AI use stays safe, accurate, and compliant.
Please note that on Saturday, April 11, 2026, at 8:00 PM Pacific time, our Case Management System will undergo a scheduled maintenance for approximately 30 minutes. During this time, case creation via SuiteAnswers will be unavailable and inbound calls will be routed to Customer Service.
Where can we find SuiteQL schema documentation?
We are trying to make a single SuiteQL query (through the REST API) to get multiple Customer records with their relevant Contacts and Addresses. If we made this query in the REST API directly, we would have to make an individual request to get every Customer record - which would be a very slow way to sync potentially thousands of records!
We have figured out - more-or-less by guessing - the table names to get Contacts with the customers with a JOIN like this:
SELECT c.id,c.companyName,c.phone,cn.firstName,cn.lastName,cn.title FROM customer as c JOIN contact as cn ON c.id = cn.company ORDER BY c.id ASC
Tagged:
1