Forum Discussion

sujeesh's avatar
sujeesh
Helper I
6 years ago
Solved

How to connect Azure DevOps REST API in to power bi

Hi, I am new to this power bi. Can someone please tell me how to connect the Azure Devops REST API into the power bi. The API I am trying to connect is "https://vsrm.dev.azure.com/****/_apis/releas...
Tutorial Requests
  • artemus's avatar
    artemus
    6 years ago

    = VSTS.Contents(<your url>)

  • artemus's avatar
    artemus
    6 years ago

    Oh, that isn't zip I think. It should be JSON. Just apply the line I gave in the previous post of the zip function. The zip function is useful if you want to download a bunch of files out of git. I did this myself once to do a git blame summary

     

    This is what your query should look like:

     

     

    let
    Source = VSTS.Contents("https://vsrm.dev.azure.com/fe-tfs/_apis/release/definitions?api-version=5.1"),
    #"Imported JSON" = Table.FromRecords(Json.Document(Source,65001)[value])
in
    #"Imported JSON"

     

nsalvay's avatar
nsalvay
Frequent Visitor
2 years ago

Hello artemus , I have this case where I receive a zip file in json format via API. I have a column with the file name and another with the value (which is apparently in base64).
I tried to follow the steps I found on this forum to unzip it but I couldn't.
In summary:
1) I generated Unzip function with detailed code.
2) In the query that I get from the zip, I transformed the content to binary with the Text.ToBinary ([value]) function (I don't know if this step is correct)
3) I applied the ZIP function to the binary value and it gave me an error.

I'll take some screenshots to see if you can guide me, I would appreciate your help!

 

 

 

 

nsalvay's avatar
nsalvay
Frequent Visitor
2 years ago
Hi, just in case I notice that I have already solved it, the error was in the conversion of the zip file to binary, I used this formula: Binary.FromText([value], BinaryEncoding.Base64).
With this I now see the compressed files, although I still cannot see their values, it gives me the following error about one of the csv:
 

I would appreciate if you could help me with this error.

 

Greetings