cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
thebigwhite
Helper I
Helper I

DevOps data

Good morning, 

we are trying to get data from DevOps but the standard connector doesn't provide all the information that you can get from the relative rest API: 

https://docs.microsoft.com/en-us/rest/api/azure/devops/?view=azure-devops-rest-6.1

 

Do you know if there is an alternative way instead of develope a connector to retrieve the same information that I can get from the DevOps API?

Thanks 

 

1 ACCEPTED SOLUTION
Eyelyn9
Community Support
Community Support

Hi @thebigwhite ,

 

Sorry for my late reply...

From my research , you could try to use VSTS.Contents("url") like this:

let
    Source = VSTS.Contents("https://xxx"),
    #"Imported JSON" = Table.FromRecords(Json.Document(Source,65001)[value])
in
    #"Imported JSON"

 

Check if these can help.

https://docs.microsoft.com/en-us/rest/api/azure/devops/git/items/get?view=azure-devops-rest-5.0

https://community.powerbi.com/t5/Power-Query/HowTo-import-data-from-devops-VSTS-git-repo/m-p/682572

 

Did I answer your question ? Please mark my reply as solution. Thank you very much.

 

Best Regards,
Eyelyn Qin

View solution in original post

2 REPLIES 2
Eyelyn9
Community Support
Community Support

Hi @thebigwhite ,

 

Sorry to disturb you...

Could you tell me if your problem has been solved? If it is, kindly Accept it as the solution. More people will benefit from it.

 

Best Regards,
Eyelyn Qin

Eyelyn9
Community Support
Community Support

Hi @thebigwhite ,

 

Sorry for my late reply...

From my research , you could try to use VSTS.Contents("url") like this:

let
    Source = VSTS.Contents("https://xxx"),
    #"Imported JSON" = Table.FromRecords(Json.Document(Source,65001)[value])
in
    #"Imported JSON"

 

Check if these can help.

https://docs.microsoft.com/en-us/rest/api/azure/devops/git/items/get?view=azure-devops-rest-5.0

https://community.powerbi.com/t5/Power-Query/HowTo-import-data-from-devops-VSTS-git-repo/m-p/682572

 

Did I answer your question ? Please mark my reply as solution. Thank you very much.

 

Best Regards,
Eyelyn Qin

View solution in original post

Helpful resources

Announcements
MBAS on Demand

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

July 2021 Update 768x460.png

Check it out!

Click here to read more about the July 2021 Updates

Power Query PA Forum 768x460.png

Check it out!

Did you know that you can visit the Power Query Forum in Power BI and now Power Apps

Urdu Hindi D365 Bootcamp 768x460.png

Urdu Hindi D365 Bootcamp

Dont miss our very own April Dunnam’s The Developer Guide to the Galaxy! Find out what the Power Platform has to offer for the traditional developer.