In my project I have a table created from a POST call to a REST service. The service populates the table just fine with fixed values passed to the service's paramenters. I then try adding my own paramenters to our function call in order to make it dynamic. The issue I have is that I want to pass values to the paramenters from marked record on the charts. So, for instance, say that I marked a record on a table or on a map, and that record has a key value in one of its columns. I want to call the function, pass the value of the key column in the record selected to the function and repopulate the table with the new payload coming back from the REST service. Below is the service call I use to populate the table:
()=>
let
body = Text.Combine({"{
""parameters"": {
""ItemId"" : ", inputIdParamenter, ",
""startDate"" : ", inputStartDateParameter, ",
""endDate"" : ", inputEndDateParameter, "
}
}"}),
Data=Json.Document(
Web.Contents(
"https://mydomain.com/",
[
RelativePath="path/to/my/service/execute",
Headers=[
#"Content-Type"="application/json",
Authorization=GetAccessToken()
],
Content=Text.ToBinary(body)
]
)
),
well_data = Data[value]
in
well_data
