Azure DevOps Connectors

ZappySys Azure DevOps Connector provide read / write capability inside your app (see list below), using these drag and drop , high performance connectors you can perform many Azure DevOps operations without any coding. You can use this connector to integrate Azure DevOps data inside apps like SSIS, SQL Server or popular ETL Platforms / BI Tools/ Reporting Apps / Programming languages (i.e. Informatica, Power BI, SSRS, Excel, C#, JAVA, Python)

Download for SSIS Download for Other Apps Documentation

Video Tutorial - Azure DevOps - Connectors REST API Integration

Click on your App below to get started with Azure DevOps Integration

Choose your App / Scenario for which you like to integrate Azure DevOps
Azure DevOps Connector for SSIS
SSIS
Azure DevOps Connector for SQL Server
SQL Server
Azure DevOps Connector for Power BI
Power BI
Azure DevOps Connector for SSRS
SSRS
Azure DevOps Connector for Informatica
Informatica
Azure DevOps Connector for MS Access
MS Access
Azure DevOps Connector for MS Excel
MS Excel
Azure DevOps Connector for SSAS
SSAS
Azure DevOps Connector for C#
C#
Azure DevOps Connector for Python
Python
Azure DevOps Connector for JAVA
JAVA
Azure DevOps Connector for Tableau
Tableau
Azure DevOps Connector for SAP Crystal Reports
SAP Crystal Reports
Azure DevOps Connector for Azure Data Factory (ADF)
Azure Data Factory (ADF)
Azure DevOps Connector for ODBC
ODBC

Actions supported by Azure DevOps Connector

Azure DevOps Connector support following actions for REST API integration. If some actions are not listed below then you can easily edit Connector file and enhance out of the box functionality.
 Get Query Fileds
Gets query fields for work items.
Parameter Description
Project Name The Name of the project.
Team Id or Name Id or name of the team associated with the query.
Use time precision Whether or not to use time precision.
Option Value
false false
true true
Wiql Query The WIQL query (refer Azure DevOps Help to learn Wiql syntax.
 Query Work Items
Get work items associated with the specified project and organization that are filtered by a Wiql query. (A team can optionally be specified as well.). Read more about this API here https://learn.microsoft.com/en-us/rest/api/azure/devops/wit/wiql/query-by-wiql?view=azure-devops-rest-7.0 and here https://learn.microsoft.com/en-us/azure/devops/boards/queries/query-operators-variables?view=azure-devops
Parameter Description
Project Name The Name of the project.
Team Id or Name Id or name of the team associated with the query.
Use time precision Whether or not to use time precision.
Option Value
false false
true true
Wiql Query The WIQL query (refer Azure DevOps Help to learn Wiql syntax.
 Query Work Item Comments
Get work item comments associated with the specified project and organization that are filtered by a Wiql query. (A team can optionally be specified as well.). Read more about this API here https://learn.microsoft.com/en-us/rest/api/azure/devops/wit/wiql/query-by-wiql?view=azure-devops-rest-7.0 and here https://learn.microsoft.com/en-us/azure/devops/boards/queries/query-operators-variables?view=azure-devops
Parameter Description
Project Name The Name of the project.
Team Id or Name Id or name of the team associated with the query.
Use time precision Whether or not to use time precision.
Option Value
false false
true true
Wiql Query The WIQL query (refer Azure DevOps Help to learn Wiql syntax.
 Query Work Item Comments by WorkItem Id
Get work item comments associated with WorkItsm Id
Parameter Description
WorkItemId WorkItem Id for which you like to get comments
Project Name The Name of the project.
api-version For this API you must set 7.0-preview for now
 Get Work Item Comment by Comment Id and Work Item Id
Get work item comment by its Comment Id (for specific WorkItem Id)
Parameter Description
Id Comment Id
WorkItemId WorkItem Id for which you like to get comments
Project Name The Name of the project.
api-version For this API you must set 7.0-preview for now
 Create Work Item Comment
Creates work item comment for a specific WorkItem Id
Parameter Description
Id Comment Id
WorkItemId WorkItem Id for which you like to get comments
Project Name The Name of the project.
Comment Text
api-version For this API you must set 7.0-preview for now
 Update Work Item Comment
Update work item comment for a specific Work Item Id and Comment Id
Parameter Description
Id Comment Id
WorkItemId WorkItem Id for which you like to get comments
Project Name The Name of the project.
Comment Text
api-version For this API you must set 7.0-preview for now
 Delete Work Item Comment
Delete work item comment for a specific Work Item Id and Comment Id
Parameter Description
Id Comment Id
WorkItemId WorkItem Id for which you like to get comments
Project Name The Name of the project.
api-version For this API you must set 7.0-preview for now
 Get Work Item Column Fields
Get work item column fields in the default project within the organization. Read more about description on each field here https://learn.microsoft.com/en-us/azure/devops/boards/work-items/guidance/work-item-field?view=azure-devops
Parameter Description
Project Name The Name of the project.
Expand Parameters The expand parameters for work item attributes. Possible options are 'None', 'Relations', 'Fields', 'Links', and 'All'.
Option Value
None None
Relations Relations
Fields Fields
Links Links
All All
 Get Work Items by Ids
Get work items in the default project within the organization by their work item Ids.
Parameter Description
Project Name The Name of the project.
Work Item Id List (comma separated) The comma-separated list of requested work item ids. (Maximum 200 ids allowed).
As-Of Date AsOf UTC date time string.
Expand Parameters The expand parameters for work item attributes. Possible options are 'None', 'Relations', 'Fields', 'Links', and 'All'.
Option Value
None None
Relations Relations
Fields Fields
Links Links
All All
Error Policy The flag to control error policy in a bulk get work items request. Possible options are 'Fail' and 'Omit'.
Option Value
Fail Fail
Omit Omit
Fields Comma-separated list of requested fields.
 Get Work Item Types
Get work item types in the default project within the organization.
Parameter Description
Project Name The Name of the project.
 Create Work Item
Creates a new work item in the default project within the organization.
Parameter Description
Project Name The Name of the project.
WorkItemType
ByPassRules Set this to true to allow setting values for some fields which otherwise wont work due to certain rules
Option Value
true true
false false
 Update Work Item
Updates an existing work item in the default project within the organization.
Parameter Description
Project Name The Name of the project.
Work Item Id
Operation Some operation requires you to supply 'add' rather than 'replace' (e.g. adding new tag)
Option Value
replace replace
add add
remove remove
copy copy
move move
test test
 Delete Work Item
Deletes an existing work item in the default project within the organization.
Parameter Description
Project Name The Name of the project.
Work Item Id
 Get List of Projects
Gets a list of projects within the organization.
 Get Project Details
Gets the details of the specified project within the organization by its project Id.
Parameter Description
Id
 Create Project
Create a new project within the organization.
 Update Project
Update an existing project within the organization.
Parameter Description
Project Id The ID of the project to update.
 Delete Project
Delete an existing project within the organization.
Parameter Description
Project Id The ID of the project to delete.
 Get List of Teams
Gets a list of teams in the default project within the organization.
Parameter Description
Project Name The Name of the project.
 Get Team Details
Gets the details of the specified team in the default project within the organization by its team Id or team name.
Parameter Description
API Version
Option Value
7.0-preview 7.0-preview
7.1-preview.2 7.1-preview.2
Team Id or Name
Project Name The Name of the project.
 Create Team
Creates a new team in the default project within the organization.
 Update Team
Updates the details of the specified team in the default project within the organization by its team Id.
Parameter Description
API Version
Option Value
7.0-preview 7.0-preview
7.1-preview.2 7.1-preview.2
Team Id
 Delete Team
Deletes the specified team in the default project within the organization by its team Id.
Parameter Description
API Version
Option Value
7.0-preview 7.0-preview
7.1-preview.2 7.1-preview.2
Team Id The ID of the team to delete.
 Search for Work Items by Text
Search for specific text within work items in the default project of the organization.
Parameter Description
Text to Search For
 Generic Request
This is generic endpoint. Use this endpoint when some actions are not implemented by connector. Just enter partial URL (Required), Body, Method, Header etc. Most parameters are optional except URL.
Parameter Description
Url API URL goes here. You can enter full URL or Partial URL relative to Base URL. If it is full URL then domain name must be part of ServiceURL or part of TrustedDomains
Body Request Body content goes here
IsMultiPart Check this option if you want to upload file(s) (i.e. POST RAW file data) or send data using Multi-Part encoding method (i.e. Content-Type: multipart/form-data). Multi-Part request allows you to mix key/value and upload files in same request. On the other hand raw upload allows only single file upload (without any key/value) ==== Raw Upload (Content-Type: application/octet-stream) ===== To upload single file in raw mode check this option and specify full file path starting with @ sign in the Body (e.g. @c:\data\myfile.zip ) ==== Form-Data / Multipart Upload (Content-Type: multipart/form-data) ===== To treat your Request data as multi part fields you must specify key/value pairs separated by new lines into RequestData field (i.e. Body). Each key value pair is entered on new-line and key/value are separated using equal sign (=). Preceding and trailing spaces are ignored also blank lines are ignored. If field value has some any special character(s) then use escape sequence (e.g. For NewLine: \r\n, For Tab: \t, For at (@): \@). When value of any field starts with at sign (@) its automatically treated as File you want to upload. By default file content type is determined based on extension however you can supply content type manually for any field using this way [ YourFileFieldName.Content-Type=some-content-type ]. By default File Upload Field always includes Content-Type in the request (non file fields do not have content-type by default unless you supply manually). For some reason if you dont want to use Content-Type header in your request then supply blank Content-Type to exclude this header altogather [e.g. SomeFieldName.Content-Type= ]. In below example we have supplied Content-Type for file2 and SomeField1, all other fields are using default content-type. See below Example of uploading multiple files along with additional fields. If some API requires you to pass Content-Type: multipart/form-data rather than multipart/form-data then manually set Request Header => Content-Type: multipart/mixed (it must starts with multipart/ else will be ignored). file1=@c:\data\Myfile1.txt file2=@c:\data\Myfile2.json file2.Content-Type=application/json SomeField1=aaaaaaa SomeField1.Content-Type=text/plain SomeField2=12345 SomeFieldWithNewLineAndTab=This is line1\r\nThis is line2\r\nThis is \ttab \ttab \ttab SomeFieldStartingWithAtSign=\@MyTwitterHandle
Filter Enter filter to extract array from response. Example: $.rows[*] --OR-- $.customers[*].orders[*]. Check your response document and find out hierarchy you like to extract
Headers Headers for Request. To enter multiple headers use double pipe or new line after each {header-name}:{value} pair