JDBC Driver for Google Directory

Build 22.0.8462

UserLocations

Query the locations for a user.

Table Specific Information

Select

To get a list of locations for a user, the UserId column is required. It can be set in the connection string or in the WHERE clause condition. Otherwise, the driver will automatically use the Id of the first user from the Users table. The driver processes other queries client-side in memory.

For example, the following query is processed server side by the Google Directory APIs:

SELECT * FROM UserLocations

Columns

Name Type Description
Area String Textual location of the user.
UserId String The unique identifier for the user.
BuildingId String The building identifier.
DeskCode String The desk location.
FloorName String The floor name/number
FloorSection String The floor section.
CustomType String The custom type of the location.
Type String The type of the location.

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462