Endpoint

https://analyticsadmin.googleapis.com/v1/properties

Columns

The PROPERTIESLIST table contains the following columns. Columns marked with an asterisk comprise the primary key.
Note: When querying the PROPERTIESLIST table, you must filter by the PROPERTYID to return results; otherwise, the service returns a 400 Bad Request error. For example: 
SELECT * FROM PROPERTIESLIST WHERE FILTER = 'parent:properties/12345679' LIMIT 10
Column Name Data Type
NAME* VarChar(64)
ACCOUNT VarChar(64)
CREATETIME VarChar(64)
CURRENCYCODE VarChar(64)
DELETETIME VarChar(64)
DISPLAYNAME VarChar(64)
EXPIRETIME VarChar(64)
FILTER VarChar(64)
INDUSTRYCATEGORY VarChar(35)
PARENT VarChar(64)
PROPERTYID VarChar(64)
PROPERTYTYPE VarChar(23)
SERVICELEVEL VarChar(25)
SHOWDELETED Boolean
TIMEZONE VarChar(64)
UPDATETIME VarChar(64)