I'm trying to see what is the best method of converting a CURL output of tabular data as seen below into JSON.
I'm running:
curl -d "sql query here" -X POST https://xxx/database_query
Currently the output has | as the separator and I need to slice off the first line because its displaying the query string. I was thinking to pass this data through sed to clean it up a bit first?