Have you double checked the permissions for the role that you’re using to run the query?
@abbott, I am running these queries as administrator, am I doing something wrong? Were you able to get the above data using the REST API using suiteql or SOAP requests. Kindly let me know if there are any specific permissions I need to give to get this data. Thanks.