Skip to main content

oauth_providers

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

Overview

Nameoauth_providers
TypeResource
Idazure_extras.agrifood_farming.oauth_providers

Fields

The following fields are returned by SELECT queries:

SELECT not supported for this resource, use SHOW METHODS to view available operations for the resource.

Methods

The following methods are available for this resource:

NameAccessible byRequired ParamsOptional ParamsDescription
create_or_updateinsertoauth_provider_id, endpointCreates or updates an oauthProvider resource.
create_or_updatereplaceoauth_provider_id, endpointCreates or updates an oauthProvider resource.
deletedeleteoauth_provider_id, endpointDeletes an specified oauthProvider resource.
get_rawexecoauth_provider_id, endpointGet a specified oauthProvider resource.
list_rawexecendpointminCreatedDateTime, maxCreatedDateTime, minLastModifiedDateTime, maxLastModifiedDateTime, skipTokenReturns a paginated list of oauthProvider resources.
get_cascade_delete_job_detailsexecjob_id, endpointGet cascade delete job for oauthProvider resource.
create_cascade_delete_jobexecjob_id, oauthProviderId, endpointCreate cascade delete job for oauthProvider resource.

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.

NameDatatypeDescription
endpointstringThe service endpoint host (no scheme). (default: )
job_idstringJob Id supplied by end user. Required.
oauthProviderIdstringId of the application data. Required.
oauth_provider_idstringID of the oauthProvider resource. Required.
maxCreatedDateTimestring (date-time)Maximum creation date of resource (inclusive). Default value is None.
maxLastModifiedDateTimestring (date-time)Maximum last modified date of resource (inclusive). Default value is None.
minCreatedDateTimestring (date-time)Minimum creation date of resource (inclusive). Default value is None.
minLastModifiedDateTimestring (date-time)Minimum last modified date of resource (inclusive). Default value is None.
skipTokenstringSkip token for getting next set of results. Default value is None.

INSERT examples

Creates or updates an oauthProvider resource.

INSERT INTO azure_extras.agrifood_farming.oauth_providers (
oauth_provider_id,
endpoint
)
SELECT
'{{ oauth_provider_id }}',
'{{ endpoint }}'
;

REPLACE examples

Creates or updates an oauthProvider resource.

REPLACE azure_extras.agrifood_farming.oauth_providers
SET
-- No updatable properties
WHERE
oauth_provider_id = '{{ oauth_provider_id }}' --required
AND endpoint = '{{ endpoint }}' --required;

DELETE examples

Deletes an specified oauthProvider resource.

DELETE FROM azure_extras.agrifood_farming.oauth_providers
WHERE oauth_provider_id = '{{ oauth_provider_id }}' --required
AND endpoint = '{{ endpoint }}' --required
;

Lifecycle Methods

Get a specified oauthProvider resource.

EXEC azure_extras.agrifood_farming.oauth_providers.get_raw 
@oauth_provider_id='{{ oauth_provider_id }}' --required,
@endpoint='{{ endpoint }}' --required
;