...
| Code Block |
|---|
projectID=$(jq -r --arg EMAILID "$EMAILID" '
.resource[]
| select(.username==$EMAILID)
| .id' file.json) |
json to csv
https://e.printstacktrace.blog/how-to-convert-json-to-csv-from-the-command-line/
| Code Block |
|---|
$ cat jobs.json | jq '[.[0] | {id,title,url,company,location}]'
[
{
"id": "9ef799fa-5253-47bc-a101-82557c675e4d",
"title": "QA Automation Engineer (m/f/d)",
"url": "https://jobs.github.com/positions/9ef799fa-5253-47bc-a101-82557c675e4d",
"company": "Scanbot / doo GmbH",
"location": "Bonn"
}
]
$ jq -r 'map({id,title,url,company,location}) | (first | keys_unsorted) as $keys | map([to_entries[] | .value]) as $rows | $keys,$rows[] | @csv' jobs.json
"9ef799fa-5253-47bc-a101-82557c675e4d","QA Automation Engineer (m/f/d)","https://jobs.github.com/positions/9ef799fa-5253-47bc-a101-82557c675e4d","Scanbot / doo GmbH","Bonn"
"dec1d370-c5fa-4103-b3ca-ad5e24ce4fb6","Fullstack Entwickler (React & Kolin/Java) - azeti IoT platform","https://jobs.github.com/positions/dec1d370-c5fa-4103-b3ca-ad5e24ce4fb6","azeti GmbH","Berlin"
"85c06c71-e088-413c-9db2-a6709ecba809","Webentwickler Typescript / Angular (m/w/d)","https://jobs.github.com/positions/85c06c71-e088-413c-9db2-a6709ecba809","CompuGroup Medical SE & Co. KGaA","Nürnberg"
"712212cc-6214-4236-99d9-605cf35a82d3","Software Engineer","https://jobs.github.com/positions/712212cc-6214-4236-99d9-605cf35a82d3","Neonomics AS","Oslo, Norway"
"bb7b1579-105c-44f8-9d8a-d0c7d7160806","Full Stack Engineer","https://jobs.github.com/positions/bb7b1579-105c-44f8-9d8a-d0c7d7160806","SocialVenu","Remote (North America Only)"
"377e8e58-7bd1-45ca-8ccf-4d633381d4c8","Senior Enterprise Software Engineer (Kotlin)","https://jobs.github.com/positions/377e8e58-7bd1-45ca-8ccf-4d633381d4c8","Ikayzo","United States"
"7d20a54c-244b-4d92-9c6b-66c85cdbf876","Senior Backend Engineer (Kotlin/Spring boot)","https://jobs.github.com/positions/7d20a54c-244b-4d92-9c6b-66c85cdbf876","Superside","Remote/Europe"
"1f0bc6cd-6347-48a1-8754-98b09c264cf2","Frontend Engineer (React/NextJS)","https://jobs.github.com/positions/1f0bc6cd-6347-48a1-8754-98b09c264cf2","Superside","Remote"
|