Forum Discussion

rsantos1's avatar
rsantos1
New Member
7 years ago

Power query extract value of a json record

Hi,   Hi have a nested json file imported to excel, power query, they successfully tranforme to a table the values, but in the third column for example, there is a [Record] value, I want to write i...
Show and Tell
rsantos1's avatar
rsantos1
New Member
7 years ago

I don't want to expand the json value in collumns, I want the raw json value like {"option", ...} and insert in each row, that's the clhallenge..

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    rsantos1,

    I am not very clear about your requirment. Could you please share sample data and expected result here?

    Regards,
    Lydia

    • rsantos1's avatar
      rsantos1
      New Member
      7 years ago

      Hi,

      Source json:
      [{"name" : "teste", "request_type": "POST", "url": "www.example.com", "body": {"test1": { "log": { "lang": "", "log2": "", "device": "", "state": "Unknown" }, "form": "simple", "gui": "221307"}, "id222": "341735", "size": "302x170"}}]

       

      In the collumn body, I want all the content of the json text, not split into collumns, just all the value

       

      Thank you

      • Anonymous's avatar
        Anonymous
        Not applicable
        7 years ago

        rsantos1,

        I notice your column contains nested Record. Please add a custom column using code below, and check if you can expand values from List column.

        Record.FieldValues([Column1.body])



        Regards,
        Lydia