Skip to main content

files_no_subscriptions

Creates, updates, deletes, gets or lists a files_no_subscriptions resource.

Overview

Namefiles_no_subscriptions
TypeResource
Idazure.support.files_no_subscriptions

Fields

The following fields are returned by SELECT queries:

Successfully retrieved file details.

NameDatatypeDescription
propertiesobjectProperties of the resource

Methods

The following methods are available for this resource:

NameAccessible byRequired ParamsOptional ParamsDescription
getselectfileWorkspaceName, fileNameReturns details of a specific file in a work space.
listselectfileWorkspaceNameLists all the Files information under a workspace for an Azure subscription.
createinsertfileWorkspaceName, fileNameCreates a new file under a workspace.
uploadexecfileWorkspaceName, fileNameThis API allows you to upload content to a file

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
fileNamestringFile Name
fileWorkspaceNamestringFile WorkspaceName

SELECT examples

Returns details of a specific file in a work space.

SELECT
properties
FROM azure.support.files_no_subscriptions
WHERE fileWorkspaceName = '{{ fileWorkspaceName }}' -- required
AND fileName = '{{ fileName }}' -- required
;

INSERT examples

Creates a new file under a workspace.

INSERT INTO azure.support.files_no_subscriptions (
data__properties,
fileWorkspaceName,
fileName
)
SELECT
'{{ properties }}',
'{{ fileWorkspaceName }}',
'{{ fileName }}'
RETURNING
properties
;

Lifecycle Methods

This API allows you to upload content to a file

EXEC azure.support.files_no_subscriptions.upload 
@fileWorkspaceName='{{ fileWorkspaceName }}' --required,
@fileName='{{ fileName }}' --required
@@json=
'{
"content": "{{ content }}",
"chunkIndex": {{ chunkIndex }}
}'
;