Forum Discussion

giangemelli's avatar
giangemelli
New Member
3 years ago

cdr Web array to table

I have an cdr(Call detail record) web array that is exported through a link: { "Origem":"1031", "Destino":"984249909", "Data":"2017-03-07 09:35:04", "Audio":"2017/03/07/09-35-05-1031-984249909...
Need Help
lbendlin's avatar
lbendlin
Super User
3 years ago
let
    Source = "{
""Origem"":""1031"",
""Destino"":""984249909"",
""Data"":""2017-03-07 09:35:04"",
""Audio"":""2017/03/07/09-35-05-1031-984249909-1488890104-234-000000c5"",
""Status"":""1"",
""TempoChamada"":""00:04:41"",
""TempoAtendimento"":""00:04:31"",
""HangupCause"":""16""
}",
    #"Parsed JSON" = Json.Document(Source),
    #"Converted to Table" = Record.ToTable(#"Parsed JSON"),
    #"Pivoted Column" = Table.Pivot(#"Converted to Table", List.Distinct(#"Converted to Table"[Name]), "Name", "Value")
in
    #"Pivoted Column"

How to use this code: Create a new Blank Query. Click on "Advanced Editor". Replace the code in the window with the code provided here. Click "Done".