Forum Discussion
Dynamic Dataset refresh error
- 3 years ago
No worries. I have done it. Sharing the steps below. Initially I was doing below steps to get REST API Output in Json Records:-->
#"Pull Request API" = Table.AddColumn(#"Changed Type2", "Pull Request API", each "https://*************.com/******/_apis/git/pullrequests/"&[Pull Request Id]&"?api-version=7.0", Text.Type),
#"Transformed to Binary" = Table.TransformColumns(#"Pull Request API", {{"Pull Request API", VSTS.Contents}}),
#"Transformed to Json" = Table.TransformColumns(#"Transformed to Binary", {{"Pull Request API", Json.Document}}),.
But instead I did this:-->
#"Pull Request API" = Table.AddColumn(#"Changed Type2", "Pull Request API",each
Json.Document(
VSTS.Contents("https://************.com/**********/_apis/git/pullrequests/",
[RelativePath = [Pull Request Id]&"?api-version=7.0"]
)
)
),.
This solved my problem. I watched a youtube video which explains very easily how to do it, sharing the link below.
No worries. I have done it. Sharing the steps below. Initially I was doing below steps to get REST API Output in Json Records:-->
#"Pull Request API" = Table.AddColumn(#"Changed Type2", "Pull Request API", each "https://*************.com/******/_apis/git/pullrequests/"&[Pull Request Id]&"?api-version=7.0", Text.Type),
#"Transformed to Binary" = Table.TransformColumns(#"Pull Request API", {{"Pull Request API", VSTS.Contents}}),
#"Transformed to Json" = Table.TransformColumns(#"Transformed to Binary", {{"Pull Request API", Json.Document}}),
.
But instead I did this:-->
#"Pull Request API" = Table.AddColumn(#"Changed Type2", "Pull Request API",each
Json.Document(
VSTS.Contents(
"https://************.com/**********/_apis/git/pullrequests/",
[RelativePath = [Pull Request Id]&"?api-version=7.0"]
)
)
),
.
This solved my problem. I watched a youtube video which explains very easily how to do it, sharing the link below.