Forum Discussion

ziyabikram96's avatar
ziyabikram96
Icon for Helper V rankHelper V
5 years ago
Solved

Web Api dataset Scheduled Refresh

Hi, I am working on Web Api dataset Scheduled Refresh with Chris Webb's blogs as guidance. In one of his blogs, he has suggested to use Relative Path and Query options to achieve the desired goal. I...
Need Help
Show and Tell
  • lbendlin's avatar
    lbendlin
    5 years ago

    let
    Contents = "{ ""recordsAfterDateTime"": ""2020-11-30T00:00:00"",""recordsBeforeDateTime"": ""2020-12-24T23:59:59.999"" }",
    Source = Json.Document(Web.Contents("https://api.trulinks.co.uk",[
    RelativePath = "analysis-reports/v1/api/driver-d14",
    Query = [q="date"],
    Headers=["TT-Api-Key"="abcd", "Ocp-Apim-Subscription-Key"="abcd","Content-Type" = "text/json"],
    Content = Text.ToBinary(Contents)

    ]
    ))
    in
    Source

lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
5 years ago

let
Contents = "{ ""recordsAfterDateTime"": ""2020-11-30T00:00:00"",""recordsBeforeDateTime"": ""2020-12-24T23:59:59.999"" }",
Source = Json.Document(Web.Contents("https://api.trulinks.co.uk",[
RelativePath = "analysis-reports/v1/api/driver-d14",
Query = [q="date"],
Headers=["TT-Api-Key"="abcd", "Ocp-Apim-Subscription-Key"="abcd","Content-Type" = "text/json"],
Content = Text.ToBinary(Contents)

]
))
in
Source