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

Sanjib Bhowal

February 25, 2020 10:26

["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?

0

Comments

1 comment

Kevin Keech2

February 28, 2020 18:19
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.