buildings

Creates, updates, deletes, gets or lists a buildings resource.

Overview

Name	buildings
Type	Resource
Id	googleadmin.directory.buildings

Fields

The following fields are returned by SELECT queries:

get

Name	Datatype	Description
address	object	The postal address of the building. See PostalAddress for details. Note that only a single address line and region code are required. (id: BuildingAddress)
buildingId	string	Unique identifier for the building. The maximum length is 100 characters.
buildingName	string	The building name as seen by users in Calendar. Must be unique for the customer. For example, "NYC-CHEL". The maximum length is 100 characters.
coordinates	object	The geographic coordinates of the center of the building, expressed as latitude and longitude in decimal degrees. (id: BuildingCoordinates)
description	string	A brief description of the building. For example, "Chelsea Market".
etags	string	ETag of the resource.
floorNames	array	The display names for all floors in this building. The floors are expected to be sorted in ascending order, from lowest floor to highest floor. For example, ["B2", "B1", "L", "1", "2", "2M", "3", "PH"] Must contain at least one entry.
kind	string	Kind of resource this is. (default: admin#directory#resources#buildings#Building)

list

Name	Datatype	Description
address	object	The postal address of the building. See PostalAddress for details. Note that only a single address line and region code are required. (id: BuildingAddress)
buildingId	string	Unique identifier for the building. The maximum length is 100 characters.
buildingName	string	The building name as seen by users in Calendar. Must be unique for the customer. For example, "NYC-CHEL". The maximum length is 100 characters.
coordinates	object	The geographic coordinates of the center of the building, expressed as latitude and longitude in decimal degrees. (id: BuildingCoordinates)
description	string	A brief description of the building. For example, "Chelsea Market".
etags	string	ETag of the resource.
floorNames	array	The display names for all floors in this building. The floors are expected to be sorted in ascending order, from lowest floor to highest floor. For example, ["B2", "B1", "L", "1", "2", "2M", "3", "PH"] Must contain at least one entry.
kind	string	Kind of resource this is. (default: admin#directory#resources#buildings#Building)

Methods

The following methods are available for this resource:

Name	Accessible by	Required Params	Optional Params	Description
get	select	customer, buildingId		Retrieves a building.
list	select	customer	maxResults, pageToken	Retrieves a list of buildings for an account.
insert	insert	customer	coordinatesSource	Inserts a building.
patch	update	customer, buildingId	coordinatesSource	Patches a building.
update	replace	customer, buildingId	coordinatesSource	Updates a building.
delete	delete	customer, buildingId		Deletes a building.

Parameters

Parameters can be passed in the WHERE clause of a query. Check the Methods section to see which parameters are required or optional for each operation.

Name	Datatype	Description
buildingId	string
customer	string
coordinatesSource	string
maxResults	integer (int32)
pageToken	string

SELECT examples

get

Retrieves a building.

SELECT
address,
buildingId,
buildingName,
coordinates,
description,
etags,
floorNames,
kind
FROM googleadmin.directory.buildings
WHERE customer = '{{ customer }}' -- required
AND buildingId = '{{ buildingId }}' -- required
;

list

Retrieves a list of buildings for an account.

SELECT
address,
buildingId,
buildingName,
coordinates,
description,
etags,
floorNames,
kind
FROM googleadmin.directory.buildings
WHERE customer = '{{ customer }}' -- required
AND maxResults = '{{ maxResults }}'
AND pageToken = '{{ pageToken }}'
;

INSERT examples

insert

Inserts a building.

INSERT INTO googleadmin.directory.buildings (
data__description,
data__buildingId,
data__floorNames,
data__address,
data__etags,
data__buildingName,
data__coordinates,
data__kind,
customer,
coordinatesSource
)
SELECT 
'{{ description }}',
'{{ buildingId }}',
'{{ floorNames }}',
'{{ address }}',
'{{ etags }}',
'{{ buildingName }}',
'{{ coordinates }}',
'{{ kind }}',
'{{ customer }}',
'{{ coordinatesSource }}'
RETURNING
address,
buildingId,
buildingName,
coordinates,
description,
etags,
floorNames,
kind
;

Manifest

# Description fields are for documentation purposes
- name: buildings
props:
  - name: customer
    value: "{{ customer }}"
    description: Required parameter for the buildings resource.
  - name: description
    value: "{{ description }}"
    description: |
      A brief description of the building. For example, "Chelsea Market".
  - name: buildingId
    value: "{{ buildingId }}"
    description: |
      Unique identifier for the building. The maximum length is 100 characters.
  - name: floorNames
    value:
      - "{{ floorNames }}"
    description: |
      The display names for all floors in this building. The floors are expected to be sorted in ascending order, from lowest floor to highest floor. For example, ["B2", "B1", "L", "1", "2", "2M", "3", "PH"] Must contain at least one entry.
  - name: address
    description: |
      The postal address of the building. See [`PostalAddress`](/my-business/reference/rest/v4/PostalAddress) for details. Note that only a single address line and region code are required.
    value:
      addressLines:
        - "{{ addressLines }}"
      administrativeArea: "{{ administrativeArea }}"
      sublocality: "{{ sublocality }}"
      locality: "{{ locality }}"
      languageCode: "{{ languageCode }}"
      postalCode: "{{ postalCode }}"
      regionCode: "{{ regionCode }}"
  - name: etags
    value: "{{ etags }}"
    description: |
      ETag of the resource.
  - name: buildingName
    value: "{{ buildingName }}"
    description: |
      The building name as seen by users in Calendar. Must be unique for the customer. For example, "NYC-CHEL". The maximum length is 100 characters.
  - name: coordinates
    description: |
      The geographic coordinates of the center of the building, expressed as latitude and longitude in decimal degrees.
    value:
      longitude: {{ longitude }}
      latitude: {{ latitude }}
  - name: kind
    value: "{{ kind }}"
    description: |
      Kind of resource this is.
    default: admin#directory#resources#buildings#Building
  - name: coordinatesSource
    value: "{{ coordinatesSource }}"

UPDATE examples

patch

Patches a building.

UPDATE googleadmin.directory.buildings
SET 
data__description = '{{ description }}',
data__buildingId = '{{ buildingId }}',
data__floorNames = '{{ floorNames }}',
data__address = '{{ address }}',
data__etags = '{{ etags }}',
data__buildingName = '{{ buildingName }}',
data__coordinates = '{{ coordinates }}',
data__kind = '{{ kind }}'
WHERE 
customer = '{{ customer }}' --required
AND buildingId = '{{ buildingId }}' --required
AND coordinatesSource = '{{ coordinatesSource}}'
RETURNING
address,
buildingId,
buildingName,
coordinates,
description,
etags,
floorNames,
kind;

REPLACE examples

update

Updates a building.

REPLACE googleadmin.directory.buildings
SET 
data__description = '{{ description }}',
data__buildingId = '{{ buildingId }}',
data__floorNames = '{{ floorNames }}',
data__address = '{{ address }}',
data__etags = '{{ etags }}',
data__buildingName = '{{ buildingName }}',
data__coordinates = '{{ coordinates }}',
data__kind = '{{ kind }}'
WHERE 
customer = '{{ customer }}' --required
AND buildingId = '{{ buildingId }}' --required
AND coordinatesSource = '{{ coordinatesSource}}'
RETURNING
address,
buildingId,
buildingName,
coordinates,
description,
etags,
floorNames,
kind;

DELETE examples

delete

Deletes a building.

DELETE FROM googleadmin.directory.buildings
WHERE customer = '{{ customer }}' --required
AND buildingId = '{{ buildingId }}' --required
;