JDBC Driver for Azure Active Directory

Build 24.0.9175

Contracts

Presents all active contracts for the authenticated user, detailing subscription and agreement terms.

Table Specific Information

Select

Most filters are handled server side, but the specific field of Id will change the endpoint we use to retrieve the data. It must be specified with an '=' or IN condition. For example:

SELECT * FROM Contracts WHERE Id = '8b0a526e-178d-4494-a276-8819b74d7933'
SELECT * FROM Contracts WHERE Id IN ('8b0a526e-178d-4494-a276-8819b74d7933')
SELECT * FROM Contracts WHERE DisplayName LIKE '%Test%'

Columns

Name Type Description
id [KEY] String The unique identifier for the contract, used to distinguish it from other records.
deletedDateTime Datetime The date and time when the contract was marked as deleted, indicating it is no longer active.
contractType String Specifies the type or category of the contract, such as subscription or licensing agreement.
customerId String The unique identifier of the customer associated with the contract.
defaultDomainName String The default domain name linked to the contract, typically used for customer authentication or services.
displayName String The user-friendly name or title assigned to the contract for easy identification.

Copyright (c) 2025 CData Software, Inc. - All rights reserved.
Build 24.0.9175