This site was built to compliment the existing NetSuite Professionals Slack Community by adding a means for members to easily find answers to common questions and to create a searchable database of those questions and answers.

NetSuite Professionals

Anyone used AnalyticsConnect JDBC to get a list of Contacts?

There is this table <http://netsuite.com/help/helpcenter/en_US/srbrowser/Browser2021_2/odbc/record/contact.html|netsuite.com/help/helpcenter/en_US/srbrowser/Browser2021_2/odbc/record/contact.html> but that isn't peope, more like contain-points/interactions.

The CUSTOMER table has TYPE= CONTACT which gives some data, but not all the native field ont he contact record are there, and there are no custom fields.   I just cannot find the correct Table for Contacts!

Are you using Data Source <http://NetSuite2.com|NetSuite2.com> if this is the case then contact is the right table, you can add a filter so the company field is not null.

Yeah, <http://netsuite2.com|netsuite2.com>

image.png

pretty sure the table you want is contact

side note you should use the records catalog not the connect browser if you are using <http://netsuite2.com|netsuite2.com>

Thanks <@U0262UG4YMC> <@UHU4PSNTA> - I setup my own JDBC connection and can see the data.  Turns out our middleware was not syncing data correctly!