Post-Response Script Error

[ecotechie]

Given in the API Response:

{
  "sites": [
    {
      "id": "100",
      "title": "Site",
      "url": "https://www.site.com",
      "updated_at": "2025-05-08T00:59:37Z",
      "created_at": "2025-05-07T17:32:59Z",
      "connection": {
        "status": "CONNECTED"
      },
      "is_paused": false,
      "next_sync_at": "2025-05-08T14:17:15Z"
    },
    {
      "id": "101",
      "title": "Domain",
      "url": "https://domain.com",
      "updated_at": "2025-05-08T00:51:39Z",
      "created_at": "2025-05-06T18:10:10Z",
      "connection": {
        "status": "CONNECTED"
      },
      "is_paused": false,
      "next_sync_at": "2025-05-09T00:20:13Z"
    }
  ]
}

I'm getting an error:
Post-Response Script Error
Error: missing function for sites

When using:
res("sites[?].id");

Just trying to get a list of the IDs.

res("..id"); gives me this error:
Error: Cannot read properties of null (reading 'id')

I am under the impression that this would parse, and output the IDs.
https://docs.usebruno.com/testing/script/response/response-query

[anusree-bruno]

Can you try this? res("...sites.id")

[ecotechie]

That doesn't give me an error, but it also doesn't alter the Response.

I'm assuming that the "output" is supposed to show on the Response window... to only show IDs.

Something like:
[100, 101]

[anusree-bruno]

If you want to alter the response view you can do this via script like this
res.setBody(res("...sites.id"))

Or else you can just filter in the response view itself

[ecotechie]

Super late reply, but I'm really struggling with getting the id and host to show in a nested array.
So it would be something like:

    {
      "id": "100",
      "url": "https://www.site.com"
    },
    {
      "id": "101",
      "url": "https://domain.com"
    }

The closest I get is having them show on separate arrays using this...

res.setBody(
  {
    url: res("...sites.url"),
    id: res("...sites.id")
  }
)

[anusree-bruno]

Are you looking for a solution using JSONPath only, or are you okay with using a bit of JavaScript? If you're fine with JavaScript, you can achieve the nested structure like this:

const ids = res("...sites.id");
const urls = res("...sites.url");

const combined = ids.map((id, index) => ({
  id,
  url: urls[index]
}));

res.setBody(combined);

[ecotechie]

Thanks! That is EXACTLY what I was looking for. Should have reached for JS sooner.