A oneliner if you're a linuxer 😉
curl -sSLo- https://gist.githubusercontent.com/jorinvo/7f19ce95a9a842956358/raw/e319340c2f6691f9cc8d8cc57ed532b5093e3619/data.json \ | jq -r '.[] | {name: .name, creditcard: .creditcard} | join(",")' \ > `date +%Y%m%d`.csv
However, there is something you have not mentioned in your post: Should the CSV file have the header line?
If yes, then use this:
echo 'name,creditcard' > `date +%Y%m%d`.csv && \ curl -sSLo- https://gist.githubusercontent.com/jorinvo/7f19ce95a9a842956358/raw/e319340c2f6691f9cc8d8cc57ed532b5093e3619/data.json \ | jq -r '.[] | {name: .name, creditcard: .creditcard} | join(",")' \ >> `date +%Y%m%d`.csv
This adds quotes.
"Dax Brekke II,1234-2121-1221-1211" "Brando Stanton Jr.,1228-1221-1221-1431" "Lacey McDermott PhD," "Elza Bauch,"
Maybe adding this sed command:
curl -sSLo- https://gist.githubusercontent.com/jorinvo/7f19ce95a9a842956358/raw/e319340c2f6691f9cc8d8cc57ed532b5093e3619/data.json \ | jq '.[] | {name: .name, creditcard: .creditcard} | join(",")' \ | sed -e 's/^"//' -e 's/"$//' -e 's/\\"/"/g' \ > "$(date +%Y%m%d).csv"
Doesn't the second solution need a >> in the last line, so the output is appended?
>>
Yes, it does. (Didn't copy the correct version)
Thanks ☺
Are you sure you want to hide this comment? It will become hidden in your post, but will still be visible via the comment's permalink.
Hide child comments as well
Confirm
For further actions, you may consider blocking this person and/or reporting abuse
We're a place where coders share, stay up-to-date and grow their careers.
A oneliner if you're a linuxer 😉
However, there is something you have not mentioned in your post: Should the CSV file have the header line?
If yes, then use this:
This adds quotes.
Maybe adding this sed command:
Doesn't the second solution need a
>>
in the last line, so the output is appended?Yes, it does. (Didn't copy the correct version)
Thanks ☺