app_consent_app_consent_requests_user_consent_requests

Creates, updates, deletes, gets or lists an app_consent_app_consent_requests_user_consent_requests resource.

Overview

Name	app_consent_app_consent_requests_user_consent_requests
Type	Resource
Id	entra_id.identity_governance.app_consent_app_consent_requests_user_consent_requests

Fields

The following fields are returned by SELECT queries:

get

Retrieved navigation property

Name	Datatype	Description
id	string	The unique identifier for an entity. Read-only.
approval		Approval decisions associated with a request.
approvalId	string	The identifier of the approval of the request.
completedDateTime	string (date-time)	The request completion date time. (pattern: ^[0-9]{4,}-(0[1-9]|1[012])-(0[1-9]|[12][0-9]|3[01])T([01][0-9]|2[0-3]):[0-5][0-9]:[0-5][0-9]([.][0-9]{1,12})?(Z|[+-][0-9][0-9]:[0-9][0-9])$)
createdBy		The principal that created the request.
createdDateTime	string (date-time)	The request creation date time. (pattern: ^[0-9]{4,}-(0[1-9]|1[012])-(0[1-9]|[12][0-9]|3[01])T([01][0-9]|2[0-3]):[0-5][0-9]:[0-5][0-9]([.][0-9]{1,12})?(Z|[+-][0-9][0-9]:[0-9][0-9])$)
customData	string	Free text field to define any custom data for the request. Not used.
reason	string	The user's justification for requiring access to the app. Supports $filter (eq only) and $orderby.
status	string	The status of the request. Not nullable. The possible values are: Canceled, Denied, Failed, Granted, PendingAdminDecision, PendingApproval, PendingProvisioning, PendingScheduleCreation, Provisioned, Revoked, and ScheduleCreated. Not nullable.

list

Retrieved collection

Name	Datatype	Description
id	string	The unique identifier for an entity. Read-only.
approval		Approval decisions associated with a request.
approvalId	string	The identifier of the approval of the request.
completedDateTime	string (date-time)	The request completion date time. (pattern: ^[0-9]{4,}-(0[1-9]|1[012])-(0[1-9]|[12][0-9]|3[01])T([01][0-9]|2[0-3]):[0-5][0-9]:[0-5][0-9]([.][0-9]{1,12})?(Z|[+-][0-9][0-9]:[0-9][0-9])$)
createdBy		The principal that created the request.
createdDateTime	string (date-time)	The request creation date time. (pattern: ^[0-9]{4,}-(0[1-9]|1[012])-(0[1-9]|[12][0-9]|3[01])T([01][0-9]|2[0-3]):[0-5][0-9]:[0-5][0-9]([.][0-9]{1,12})?(Z|[+-][0-9][0-9]:[0-9][0-9])$)
customData	string	Free text field to define any custom data for the request. Not used.
reason	string	The user's justification for requiring access to the app. Supports $filter (eq only) and $orderby.
status	string	The status of the request. Not nullable. The possible values are: Canceled, Denied, Failed, Granted, PendingAdminDecision, PendingApproval, PendingProvisioning, PendingScheduleCreation, Provisioned, Revoked, and ScheduleCreated. Not nullable.

Methods

The following methods are available for this resource:

Name	Accessible by	Required Params	Optional Params	Description
get	select	app_consent_request_id, user_consent_request_id		Read the properties and relationships of a userConsentRequest object.
list	select	app_consent_request_id		Retrieve a collection of userConsentRequest objects and their properties.
insert	insert	app_consent_request_id
update	update	app_consent_request_id, user_consent_request_id
delete	delete	app_consent_request_id, user_consent_request_id	If-Match

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
app_consent_request_id	string	The unique identifier of appConsentRequest
user_consent_request_id	string	The unique identifier of userConsentRequest
If-Match	string	ETag

SELECT examples

get

Read the properties and relationships of a userConsentRequest object.

SELECT
id,
approval,
approvalId,
completedDateTime,
createdBy,
createdDateTime,
customData,
reason,
status
FROM entra_id.identity_governance.app_consent_app_consent_requests_user_consent_requests
WHERE app_consent_request_id = '{{ app_consent_request_id }}' -- required
AND user_consent_request_id = '{{ user_consent_request_id }}' -- required
;

list

Retrieve a collection of userConsentRequest objects and their properties.

SELECT
id,
approval,
approvalId,
completedDateTime,
createdBy,
createdDateTime,
customData,
reason,
status
FROM entra_id.identity_governance.app_consent_app_consent_requests_user_consent_requests
WHERE app_consent_request_id = '{{ app_consent_request_id }}' -- required
;

INSERT examples

insert

No description available.

INSERT INTO entra_id.identity_governance.app_consent_app_consent_requests_user_consent_requests (
id,
approvalId,
completedDateTime,
createdBy,
createdDateTime,
customData,
status,
reason,
approval,
app_consent_request_id
)
SELECT 
'{{ id }}',
'{{ approvalId }}',
'{{ completedDateTime }}',
'{{ createdBy }}',
'{{ createdDateTime }}',
'{{ customData }}',
'{{ status }}',
'{{ reason }}',
'{{ approval }}',
'{{ app_consent_request_id }}'
RETURNING
id,
approval,
approvalId,
completedDateTime,
createdBy,
createdDateTime,
customData,
reason,
status
;

Manifest

# Description fields are for documentation purposes
- name: app_consent_app_consent_requests_user_consent_requests
props:
  - name: app_consent_request_id
    value: "{{ app_consent_request_id }}"
    description: Required parameter for the app_consent_app_consent_requests_user_consent_requests resource.
  - name: id
    value: "{{ id }}"
    description: |
      The unique identifier for an entity. Read-only.
  - name: approvalId
    value: "{{ approvalId }}"
    description: |
      The identifier of the approval of the request.
  - name: completedDateTime
    value: "{{ completedDateTime }}"
    description: |
      The request completion date time.
  - name: createdBy
    value: "{{ createdBy }}"
    description: |
      The principal that created the request.
  - name: createdDateTime
    value: "{{ createdDateTime }}"
    description: |
      The request creation date time.
  - name: customData
    value: "{{ customData }}"
    description: |
      Free text field to define any custom data for the request. Not used.
  - name: status
    value: "{{ status }}"
    description: |
      The status of the request. Not nullable. The possible values are: Canceled, Denied, Failed, Granted, PendingAdminDecision, PendingApproval, PendingProvisioning, PendingScheduleCreation, Provisioned, Revoked, and ScheduleCreated. Not nullable.
  - name: reason
    value: "{{ reason }}"
    description: |
      The user's justification for requiring access to the app. Supports $filter (eq only) and $orderby.
  - name: approval
    value: "{{ approval }}"
    description: |
      Approval decisions associated with a request.

UPDATE examples

update

No description available.

UPDATE entra_id.identity_governance.app_consent_app_consent_requests_user_consent_requests
SET 
id = '{{ id }}',
approvalId = '{{ approvalId }}',
completedDateTime = '{{ completedDateTime }}',
createdBy = '{{ createdBy }}',
createdDateTime = '{{ createdDateTime }}',
customData = '{{ customData }}',
status = '{{ status }}',
reason = '{{ reason }}',
approval = '{{ approval }}'
WHERE 
app_consent_request_id = '{{ app_consent_request_id }}' --required
AND user_consent_request_id = '{{ user_consent_request_id }}' --required
RETURNING
id,
approval,
approvalId,
completedDateTime,
createdBy,
createdDateTime,
customData,
reason,
status;

DELETE examples

delete

No description available.

DELETE FROM entra_id.identity_governance.app_consent_app_consent_requests_user_consent_requests
WHERE app_consent_request_id = '{{ app_consent_request_id }}' --required
AND user_consent_request_id = '{{ user_consent_request_id }}' --required
AND If-Match = '{{ If-Match }}'
;