C
C#•2mo ago
VoidPointer

I need help using JSONPath to query two or more properties from each object in a JSON array.

{
    "name": "KYC Athena - V3",
    "timestamp": "2025-03-13T10:24:58.380Z",
    "startedAt": "2025-03-13T10:19:05.304Z",
    "totalFail": 0,
    "results": [
        {
            "name": "/Test1/post_Request",
            "url": "http://localhost:1234/api/Test1/post_request",
            "responseCode": {
                "code": 404,
                "name": "Not Found"
            }
        },
        {
            "name": "/Test1/post_requestPlus",
            "url": "http://localhost:1234/api/Test1/post_requestPlus",
            "responseCode": {
                "code": 200,
                "name": "OK"
            }
        },
        {
            "name": "/Test1/post_requestStandard",
            "url": "http://localhost:2234/api/Test1/post_requestStandard",
            "responseCode": {
                "code": 200,
                "name": "OK"
            }
        }
    ],
    "count": 1,
    "totalTime": 344664
}
{
    "name": "KYC Athena - V3",
    "timestamp": "2025-03-13T10:24:58.380Z",
    "startedAt": "2025-03-13T10:19:05.304Z",
    "totalFail": 0,
    "results": [
        {
            "name": "/Test1/post_Request",
            "url": "http://localhost:1234/api/Test1/post_request",
            "responseCode": {
                "code": 404,
                "name": "Not Found"
            }
        },
        {
            "name": "/Test1/post_requestPlus",
            "url": "http://localhost:1234/api/Test1/post_requestPlus",
            "responseCode": {
                "code": 200,
                "name": "OK"
            }
        },
        {
            "name": "/Test1/post_requestStandard",
            "url": "http://localhost:2234/api/Test1/post_requestStandard",
            "responseCode": {
                "code": 200,
                "name": "OK"
            }
        }
    ],
    "count": 1,
    "totalTime": 344664
}
Now I would like to query name, url, and responseCode for each of the items in the results array. I'm stuck on querying for more than one value at a time. I have tried these patterns: 
$.results[*].url // I get a list of URLs, one for each `result` item
$.results[*].responseCode // I get a list of response codes with `code` and `name`
$.results[*].url // I get a list of URLs, one for each `result` item
$.results[*].responseCode // I get a list of response codes with `code` and `name`
Yet after lots of various query format attempts, I can't find a way to do the equivalent of this, to the these two properties for each result: 
$.results[*][name, url]
$.results[*][name, url]
I get no results, despite that query syntax coming from an example on this JSONPath repo. The example is $..book[category,author], which is supposed to give "The categories and authors of all books".
GitHub
GitHub - atifaziz/JSONPath: JSONPath (XPath-like syntax for JSON) C...
JSONPath (XPath-like syntax for JSON) C# implementation - atifaziz/JSONPath
1 Reply
Anton
Anton•2mo ago
It might just not be implemented in the library

Did you find this page helpful?