How to parse the json payload and make it as a row?

Comments

1 comment

  • Avatar
    Kevin Keech

    Looks like the string is a comma-separated list so what you could do is first parse the list between the brackets and then use the CSV operator to parse the fields you want from that list. 

    | parse "[*]" as values
    | csv values extract 1 as fieldA, 2 as fieldB, 3 as fieldC

    Help on CSV operator

    0
    Comment actions Permalink

Please sign in to leave a comment.