EndPoint Get List of Queries
Name
get_queries
Description
Gets a list of predefined queries within the organization. [API reference]
Parameters
| Parameter | Label | Required | Options | Description |
|---|---|---|---|---|
| Project | Project Name | YES | The Name of the project. | |
| Depth | Max Depth (items inside nested folders) | NO |
Output Columns
| Label | Data Type (SSIS) | Data Type (SQL) | Length | Raw | Description |
|---|---|---|---|---|---|
| Id |
DT_WSTR
|
nvarchar(200)
|
200 | False |
|
| Name |
DT_WSTR
|
nvarchar(200)
|
200 | False |
|
| Path |
DT_WSTR
|
nvarchar(200)
|
200 | False |
|
| Url |
DT_WSTR
|
nvarchar(2048)
|
2048 | False |
|
| CreatedDate |
DT_DBTIMESTAMP
|
datetime
|
False |
||
| LastModifiedDate |
DT_DBTIMESTAMP
|
datetime
|
False |
||
| IsFolder |
DT_BOOL
|
bit
|
False |
||
| HasChildren |
DT_BOOL
|
bit
|
False |
||
| CreatedByName |
DT_WSTR
|
nvarchar(255)
|
255 | False |
|
| CreatedByUniqueName |
DT_WSTR
|
nvarchar(255)
|
255 | False |
|
| CreatedById |
DT_WSTR
|
nvarchar(200)
|
200 | False |
|
| LastModifiedByName |
DT_WSTR
|
nvarchar(255)
|
255 | False |
|
| LastModifiedByUniqueName |
DT_WSTR
|
nvarchar(255)
|
255 | False |
|
| LastModifiedById |
DT_WSTR
|
nvarchar(200)
|
200 | False |
Input Columns
| Label | Data Type (SSIS) | Data Type (SQL) | Length | Raw | Description | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| There are no Static columns defined for this endpoint. This endpoint detects columns dynamically at runtime. | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Examples
SSIS
Use Azure DevOps Connector in API Source component to read data or in API Destination component to read/write data:
Get List of Queries using API Source
Azure DevOps
Get List of Queries
Get List of Queries using API Destination
Azure DevOps
Get List of Queries
ODBC application
Use these SQL queries in your ODBC application data source:
Get a list of predefined queries
SELECT * FROM get_queries
WITH(
Project='Odbc'
)SQL Server
Use these SQL queries in SQL Server after you create a data source in Data Gateway:
Get a list of predefined queries
DECLARE @MyQuery NVARCHAR(MAX) = 'SELECT * FROM get_queries
WITH(
Project=''Odbc''
)';
EXEC (@MyQuery) AT [LINKED_SERVER_TO_AZURE_DEVOPS_IN_DATA_GATEWAY];