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

Hi All, Does anyone know how to retrieve customer and address information in a single query using SuiteQL? I can't seem to find the name of the address object and all the variations I tried lead to "Invalid search query Invalid search type"

have you tried making it in the ui first?

yeah, there's no field name for addressbook or addressbookaddress in the dataset designer.

I think I found it tho. it's customeraddressbookentityaddress

like so: SELECT c.entityid, c.custentity_ari_customer_legacy_id, c.companyname, c.defaultbillingaddress, ca.addr1, ca.city FROM customer c, customeraddressbookentityaddress ca WHERE c.defaultbillingaddress = ca.nkey

btw, I spent a ton of time looking for this today and found it 5 minutes after posting here :slightly_smiling_face: that's pretty much how it always works for me