0
votes

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?

enter image description here

Paste as text not as screenshot. - Markus Zeller