Skip to main content

endpoints

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

Overview

Nameendpoints
TypeResource
Idazure.hybrid_connectivity.endpoints

Fields

The following fields are returned by SELECT queries:

NameDatatypeDescription
expiresOnintegerThe expiration time of short lived proxy name in unix epoch. Required.
proxystringThe short lived proxy name. Required.

Methods

The following methods are available for this resource:

NameAccessible byRequired ParamsOptional ParamsDescription
list_managed_proxy_detailsselectresource_uri, endpoint_nameFetches the managed proxy details.
getselectresource_uri, endpoint_nameGets the endpoint to the resource.
listselectresource_uriList of endpoints to the target resource.
create_or_updateinsertresource_uri, endpoint_nameCreate or update the endpoint to the target resource.
updateupdateresource_uri, endpoint_nameUpdate the endpoint to the target resource.
create_or_updatereplaceresource_uri, endpoint_nameCreate or update the endpoint to the target resource.
deletedeleteresource_uri, endpoint_nameDeletes the endpoint access to the target resource.
list_credentialsexecresource_uri, endpoint_nameexpiresinGets the endpoint access credentials to the resource.
list_ingress_gateway_credentialsexecresource_uri, endpoint_nameexpiresinGets the ingress gateway endpoint credentials.

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
endpoint_namestringThe endpoint name. Required.
resource_uristringThe fully qualified Azure Resource manager identifier of the resource. Required.
expiresinintegerThe is how long the endpoint access token is valid (in seconds). Default value is None.

SELECT examples

Fetches the managed proxy details.

SELECT
expiresOn,
proxy
FROM azure.hybrid_connectivity.endpoints
WHERE resource_uri = '{{ resource_uri }}' -- required
AND endpoint_name = '{{ endpoint_name }}' -- required
;

INSERT examples

Create or update the endpoint to the target resource.

INSERT INTO azure.hybrid_connectivity.endpoints (
properties,
resource_uri,
endpoint_name
)
SELECT
'{{ properties }}',
'{{ resource_uri }}',
'{{ endpoint_name }}'
RETURNING
id,
name,
properties,
systemData,
type
;

UPDATE examples

Update the endpoint to the target resource.

UPDATE azure.hybrid_connectivity.endpoints
SET
properties = '{{ properties }}'
WHERE
resource_uri = '{{ resource_uri }}' --required
AND endpoint_name = '{{ endpoint_name }}' --required
RETURNING
id,
name,
properties,
systemData,
type;

REPLACE examples

Create or update the endpoint to the target resource.

REPLACE azure.hybrid_connectivity.endpoints
SET
properties = '{{ properties }}'
WHERE
resource_uri = '{{ resource_uri }}' --required
AND endpoint_name = '{{ endpoint_name }}' --required
RETURNING
id,
name,
properties,
systemData,
type;

DELETE examples

Deletes the endpoint access to the target resource.

DELETE FROM azure.hybrid_connectivity.endpoints
WHERE resource_uri = '{{ resource_uri }}' --required
AND endpoint_name = '{{ endpoint_name }}' --required
;

Lifecycle Methods

Gets the endpoint access credentials to the resource.

EXEC azure.hybrid_connectivity.endpoints.list_credentials 
@resource_uri='{{ resource_uri }}' --required,
@endpoint_name='{{ endpoint_name }}' --required,
@expiresin='{{ expiresin }}'
@@json=
'{
"serviceName": "{{ serviceName }}"
}'
;