jq filtering - Cannot index array with string "Score"

I am trying to find person name who has a subject and it score. But i am getting index arrary.

jq -r '.[] | select(.result."*value*".Score.English) | {Name: .result."*value*".name, Subject: .result."*value*".Score.English} | @text' test.txt | sed 's/^{\|}$//g; s/,/\n/'

INPUT JSON FILE

[{ "host": "testserver", "hostclass": "Unknown", "result": { "*value*": [ { "sessionId": "000001", "name": "ABC", "Age": "21", "Score": { "English": "A+", "Mathematics": "B-", "String Theory": "C+" } }, { "sessionId": "000001", "name": "CDE", "Age": "21", "Score": { "English": "A-", "German": "B-", "French": "C+" } }, { "sessionId": "000001", "name": "EFG", "Age": "21", "Score": { } }, { "sessionId": "000001", "name": "XYZ", "Age": "21" }] }
}]

OUTPUT :

Name: ABC
Subject : A+
Name: CDE
Subject : A-

ERROR :

jq: error (at test.txt:39): Cannot index array with string "Score"

how can i fix this error

2 Answers

You need to iterate through the "*value*" children with "*value*"[]. Here is a solution that I tested and it produces the output you want:

cat test.txt | jq -r '.[].result."*value*"[] | select(.Score.English) | "Name: "+.name+"\nSubject: "+.Score.English'

I'm surprised no one gave you a jq solution on this one so far. Then, instead, let me give you an alternative one - based on unix walk-path utility jtc:

bash $ <input.json jtc -w'<English>l:[-2][name]' -w'<English>l:' -l
"name": "ABC"
"English": "A+"
"name": "CDE"
"English": "A-"
bash $ 

And if you really meant to replace "English" with "Subject", then add template per each walk, like this:

bash $ <input.json jtc -w'<English>l:[-2][name]' -w'<English>l:' -TT -T'{"Subject":"{}"}' -ll
"name": "ABC"
"Subject": "A+"
"name": "CDE"
"Subject": "A-"
bash $ 

• first template (-TT) is a dummy one, meant to fail (because first walk does not require altering)

btw, there's a bit more succinct way of writing the same query:
<input.json jtc -x'<English>l' -y:[-2][name] -y: -TT -T'{"Subject":"{}"}' -ll

PS> Disclosure: I'm the creator of the jtc - shell cli tool for JSON operations

EDIT: another way to achieve the same query:

bash $ <input.json jtc -w'<English>l:<N>v[-2][name]' -llT'{"Name":{{}},"Subject":{{N}}}'
"Name": "ABC"
"Subject": "A+"
"Name": "CDE"
"Subject": "A-"
bash $