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


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

    Comment actions Permalink

Please sign in to leave a comment.