Hello,
Need help with a request that I am trying to create. I would like to get all the stream audio from Teams using specific filter, dimension and measurements.
I have an error: Sorry, can't convert a null value in list type
Details:
Value =
Type=[Type]
let
//form the CQD API query body in JSON format
CQDQueryRequestBody = "
{
""Filters"":[
{
""DataModelName"":""[AllStreams].[Is Server Pair]"",
""Value"":""[Client : Server]"",
""Operand"":0
},
{
""DataModelName"":""[SecondTenantDataEndpoint].[Second Reflexive Local IP Network]"",
""Value"": ""[194.119.127.0],[194.119.126.0]"",
""Operand"":1
},
{
""DataModelName"":""[AllStreams].[Second Tenant Id]"",
""Value"": ""[c9a7d621-4bc4-4407-b730-f428e656aa9e]"",
""Operand"":0
},
{
""DataModelName"":""[AllStreams].[Jitter Max]"",
""Value"": ""082"",
""Operand"":7
}
],
""Dimensions"":[
{""DataModelName"":""[AllStreams].[Date]""},
{""DataModelName"":""[AllStreams].[Second Network Connection Detail]""},
{""DataModelName"":""[AllStreams].[AllStreams].[Stream Direction]""}
],
""Measurements"":[
{""DataModelName"":""[Measures].[Audio Stream Count]""}
]
"
& CommonQueryParametersString &
"
}",
CQDQueryUrlEncoded = Binary.ToText(Binary.Compress(Text.ToBinary(CQDQueryRequestBody), Compression.GZip), BinaryEncoding.Base64),
//make the CQD API http request
CQDcontents = Json.Document(Web.Contents(https://&DataSource&"/RunQuery",
[
Headers = [#"content-type" = "application/json;charset=UTF-8"],
Query = [#"query" = CQDQueryUrlEncoded]
])),
//convert the CQD API JSON into a PBI/PowerQuery Table and supply the column names
DataResultTable = Table.FromRows(CQDcontents[DataResult], {
"Date",
"Second Network Connection Detail",
"Stream Direction",
"Audio Stream Count"
})
in
DataResultTable
