How to parse the json payload and make it as a row?
["App-Services","YYY","ZZZZ","AAA","VBVB","Last-Login","Meters","Modules","Schemas","Security","Triggers"]
How to parse this and make it as row using the Search Query?
-
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
Please sign in to leave a comment.
Comments
1 comment