Selecting/filtering with JSON Query in Thunder Client

Question

I am trying to test HTTP responses with Thunder Client in VS Code. The HTTP response I get is:

{
    "currencies": [
        {
            "name": "Btc",
            "count": 17
        },
        {
            "name": "Ltc",
            "count": 0
        }
    ]
}

My goal is to test count field in each of the item in the array bases on some condition/filter. The test option I want to use is JSON Query. I tried with json.currencies[name='Btc'].count query, but the response is:

Query: json.currencies[name='Btc'].count > 0 => Actual: undefined

How can I check some property with specific conditions inside of the array?

score 0 · Answer 1 · answered May 18 '22 at 17:32

0

In Thunder Client you can access response array element using index.

so use json.currencies[0].count

answered May 18 '22 at 17:32

Ranga Vadhineni

349
2
13

1

I know this feature, but I can not use it because order is not defined. – Rok May 19 '22 at 07:40

score 0 · Answer 2 · answered Aug 25 '22 at 07:56

0

With the version 1.18.3 filtering by property content was introduced.

answered Aug 25 '22 at 07:56

Rok

451
3
21

score 0 · Answer 3 · answered Sep 21 '22 at 05:14

0

No need of quotes around Btc

json.currencies[name=Btc].count

answered Sep 21 '22 at 05:14

Ranga Vadhineni

349
2
13

note, this is not working if a value has a dot character (potentially some other chars) e.g. json.domain[name=google.com].ip – Marko Vranjkovic Sep 22 '22 at 13:53
Please report on our thunder client GitHub page, will fix it asap. – Ranga Vadhineni Sep 23 '22 at 19:37
done: https://github.com/rangav/thunder-client-support/issues/798 – Marko Vranjkovic Sep 26 '22 at 08:16

Selecting/filtering with JSON Query in Thunder Client

3 Answers3

Linked