Hi! I have a query regarding SuiteQL. Here' the Dataset exported SuiteQL text for fetching customer's data. Upon running the same query in postman, I am not getting the City, and State fields populated. What could possibly be wrong? SELECT Customer.entityid AS entityid /*{entityid#RAW}*/, Customer.companyname AS companyname /*{companyname#RAW}*/, Customer.phone AS phone /*{phone#RAW}*/, Customer.salesrep AS salesrep /*{salesrep#RAW}*/, EntityAddress.city AS city /*{defaultshippingaddress.city#RAW}*/, EntityAddress.state AS state /*{defaultshippingaddress.state#RAW}*/, Customer.searchstage AS searchstage /*{searchstage#RAW}*/, Customer.custentity27 AS custentity27 /*{custentity27#RAW}*/, Customer.lastsaledate AS lastsaledate /*{lastsaledate#RAW}*/ FROM Customer, EntityAddress WHERE Customer.defaultshippingaddress = EntityAddress.nkey(+) AND Customer.phone IN

I would guess you would need to join to entity address based on defaultBillingAddress or defaultShippingAddress whichever you are interested in.

If the query is working properly in NetSuite and not working properly via Postman the odds are that you have a role/permissions issue somewhere.

It was indeed the permission issue with the integration role. Thanks a ton