Extract UUID value from JSON returned from HTTP reply

Question

I am trying to make a little script in shellscript that takes one serviceUuid from a response and use it. I just print the server response on a file called final.txt Now i need to extract the value after "serviceUuid":"

This is the script:

uuid=$(curl   -X POST -H "ACCEPT-LANGUAGE:en"   -H "Content-Type: application/json"   -H "Accept: application/json" -d  {"username":"HereThereIsTheUsername"}  Here there is the url )

echo $uuid >> final.txt

this is the response:

{"status":{"code":"STATUS_OK","message":"ServiceUUID sent successfully via..."},"body":{"data":{"userApps":{},"username":"HereTheUsername","fullName":"NameOfTheAccountPossessor","lang":"sq","blocked":false,"lastLogin":"2016-10-10T17:19:22","passwordResetUuid":"6147dc32-b72e-450a-8084-2fdb5319a931","userAccessLevel":5,"countDownSeconds":0,"serviceUuid":"7260276c-5c3f-41d3-9329-3603acecb7e5","userAttributes":{},"labelMap":{},"id":"APPUSER00000012","someLabel":"NameOfTheOrganisation"}}}

So can someone help me to extract the value?

Answer 1

jq is a JSON parsing tool. You can do this:

uuid=$(curl ...)
service_uuid=$(jq -r '.body.data.serviceUuid' <<<"$uuid")
echo "$service_uuid"

7260276c-5c3f-41d3-9329-3603acecb7e5

Answer 2

Now i need to extract the value after "serviceUuid"

So, if the variable $uuid contains this:

echo "$uuid"
{"status":{"code":"STATUS_OK","message":"ServiceUUID sent successfully via..."},"body":{"data":{"userApps":{},"username":"HereTheUsername","fullName":"NameOfTheAccountPossessor","lang":"sq","blocked":false,"lastLogin":"2016-10-10T17:19:22","passwordResetUuid":"6147dc32-b72e-450a-8084-2fdb5319a931","userAccessLevel":5,"countDownSeconds":0,"serviceUuid":"7260276c-5c3f-41d3-9329-3603acecb7e5","userAttributes":{},"labelMap":{},"id":"APPUSER00000012","someLabel":"NameOfTheOrganisation"}}}

...and you only want the serviceUuid value, I would do this:

echo "$uuid" | sed -nE 's/.*"serviceUuid":"(.*)","user.*/\1/p'
7260276c-5c3f-41d3-9329-3603acecb7e5

In your case, it would look like:

echo "$uuid" | sed -nE 's/.*"serviceUuid":"(.*)","user.*/\1/p' >> final.txt

...to append it to the file final.txt

---

sed --version
sed (GNU sed) 4.2.2

Answer 3

Don't have 'jq', and have no quote escape problems... Try this FAST and simple solution...

service_uuid=$( grep -oP '"serviceUuid":"\K[^"]+'  <<< "$uuid" )

• The <<< "$uuid feeds the string into "grep"
• The -oP options mean only the 'matching part' of the perl regex is to be returned.
• The '\K' in the perl-RE means find the part before, but only match the part after.

The result is that it finds the key, and returns the value (up until the first quote).

Fast small simple, and works with a lot of key-value file types.