NetSuite: Use SuiteQL to Get Company Contacts

Published on November 13, 2024.

This SuiteQL query returns all of the contacts associated with a specified company. The contact's name, and their role in the company, are included in the results.

SELECT
	Company.ID AS Company,
	Company.EntityTitle AS CompanyName,
	CompanyContactRelationship.Contact,
	BUILTIN.DF( CompanyContactRelationship.Contact ) AS ContactName,
	CompanyContactRelationship.Role,
	BUILTIN.DF( CompanyContactRelationship.Role ) AS RoleName
FROM
	Entity AS Company
	INNER JOIN CompanyContactRelationship ON
		( CompanyContactRelationship.Company = Company.ID )
WHERE
	( Company.ID = 2707 )
About Me

Hello, I'm Tim Dietrich. I develop custom software for businesses that are running on NetSuite, including mobile apps, Web portals, Web APIs, and more.

I'm the developer of several popular NetSuite open source solutions, including the SuiteQL Query Tool, SuiteAPI, and more.

I founded SuiteStep, a NetSuite development studio, to provide custom software and AI solutions - and continue pushing the boundaries of what's possible on the NetSuite platform.

Copyright © 2025 Tim Dietrich.