Print json output to single line with comma separated

Question

I am new to JQ, I have below json file

   [
   {
     "userId" : "jens",
     "firstName" : "jens",
     "lastName" : "jens",
     "emailAddress" : "[email protected]",
     "source" : "default",
     "status" : "active",
     "readOnly" : false,
     "roles" : [ "reader" ],
     "externalRoles" : [ ]
   }, {
     "userId" : "admin",
     "firstName" : "Administrator",
     "lastName" : "User",
     "emailAddress" : "[email protected]",
     "source" : "default",
     "status" : "changepassword",
     "readOnly" : false,
     "roles" : [ "app-admin" ],
     "externalRoles" : [ ]
   }]  

Now I want to print as below format

"userId" : "jens","roles" : [ "reader" ]
"userId" : "admin", "roles" : [ "app-admin" ],

How can I achieve this? I tried with this command

jq -r '.[].userId,.[].roles'

but it scatters the data like below

jens
admin
[]
[
  "reader",
  "app-admins",
]

Please guide me how can I have above output.

Answer 1

If you do

jq -c '.[] | {userid: .userId, roles: .roles}'

you'll get

{"userid":"jens","roles":["reader"]}
{"userid":"admin","roles":["app-admin"]}

The -c flag will put each object on its own line, so as long as you don't have nested objects, this should do what you want. Post process to e.g. get rid of the braces:

jq -c '.[] | {userid: .userId, roles: .roles}' | sed -e 's/^{//g' -e 's/}$//g'

produces

"userid":"jens","roles":["reader"]
"userid":"admin","roles":["app-admin"]