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-1488890104-234-000000c5",
"Status":"1",
"TempoChamada":"00:04:41",
"TempoAtendimento":"00:04:31",
"HangupCause":"16"
}


And need to make a table out of it and have no idea how to nor can i find anything online to help me

Need Help

1 Reply

  • 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".