Excel Add-In for Azure Active Directory

Build 24.0.9062

Contracts

Retrieves all contracts for the authenticated user.

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 id of the contract.
deletedDateTime Datetime The datetime when the contract was deleted.
contractType String The contractType of the contract.
customerId String The customerId of the contract.
defaultDomainName String The defaultDomainName of the contract.
displayName String The displayName of the contract.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9062