Solved

Using CDATA Rest Task to call Azure DevOps Rest API - Error

  • 17 July 2023
  • 3 replies
  • 51 views

Badge

Hello,

 

I am trying to use CData Rest Task to call a Rest API from Azure DevOps.  The goal will be to pull the capacity information from the call.  

https://dev.azure.com/AIZ-Global/_apis/projects/2ef0bfbb-5826-423d-a8e7-c970f2268f59/teams/64155638-69bf-4173-b301-2022f7bb356c/members?api-version=5.1

When I enter the URI into the into URI field  under the connection section and select test connection I get the following error message.  

 I am sure that I am doing something wrong here but not being a developer I am a little lost here. 

Any help would be appreciate.  If you need additional information I would be happy to provide it. 

John Flood

icon

Best answer by Ankit Singh 19 July 2023, 13:24

View original

3 replies

Userlevel 5
Badge +1

Hey @John Flood 

You could use CData Azure DevOps SSIS Components for this as well: https://www.cdata.com/drivers/azuredevops/ssis/, which should make it easier for you to connect to the Azure DevOps instance without going through the trouble of creating the URI yourself.

Is there any specific reason you are using the REST connector for this?

Badge

The Capacity extract is only available via the Rest API.  

 

https://learn.microsoft.com/en-us/rest/api/azure/devops/work/capacities/list?view=azure-devops-rest-6.0&tabs=HTTP

 

 

Userlevel 5
Badge +1

Hi @John Flood 

CData Azure DevOps SSIS Connectors should support connecting to the REST APIs along with Analytics API. If you don’t see an object like Capacities being exposed in the REST data model using Azure DevOps SSIS Components, you can raise a request with our Tech support team for this: CData - Support Form.

What you tested with the REST connector, requires further investigation and would be best directed to our Tech support team at  CData - Support Form.

Reply