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
;