How do I query the direct child of a JSON element?

[Stevoisiak]

I have JSON data from Pixiv I want to filter if it has a numeric object value, and a child with aiType=2.

Example JSON

{
  "body": {
    "illusts": {
      "109391399": {
        "id": "109391399",
        "aiType": 2
      },
      "109419499": {
        "id": "109419499",
        "aiType": 1
      }
    },
    "manga": {
      "146074135": {
        "id": "146074135",
        "aiType": 1
      }
    },
    "novels": {
      "28373726": {
        "id": "28373726",
        "aiType": 2
      }
    }
  }
}

Desired result:

{
  "body": {
    "illusts": {
      "109419499": {
        "id": "109419499",
        "aiType": 1
      }
    },
    "manga": {
      "146074135": {
        "id": "146074135",
        "aiType": 1
      }
    },
    "novels": {}
    }
  }
}

Attempts

I am able to select the numeric element value using regex.

Expression

v2:$../^\d+$/

Result

{
  "body": {
    "illusts": {},
    "manga": {},
    "novels": {}
  }
}

However, when I try to add my query for filtering I get no results. (Presumably because it's filtering one layer deeper than I would like)

v2:$../^\d+$/[?@.aiType==2]

If I repeat the numeric attribute expression, all of the values are filtered if any of the children match.

v2:$..[?./^\d+$/.aiType==2]./^\d+$/

{
  "body": {
    "illusts": {},
    "manga": {
      "146074135": {
        "id": "146074135",
        "aiType": 1
      }
    },
    "novels": {}
  }
}

I'm not able to use$..[?@.aiType==2] because other pages will break when filtered that way.

How can I query the direct child of the JSON element I am filtering on?

[gorhill]

I am not able to make it work with official JSONPath spec using https://jsonpath.com/, for example $..['28373726'][?@.aiType==2] also doesn't select. Unless I miss something, I don't see a way to test against a property name in official JSONPath spec, only against a property value.

Unless I missed something in the spec, will need to think of extending the syntax to allow for this sort of cases.

[Stevoisiak]

Appreciate the response. Can use illusts/manga/novels as my identifying elements for now as a workaround.

[gorhill]

Wait, this seems to work?

v2:$..[?@./^\d+$/][?@.aiType==2]

[Stevoisiak]

Huh. Will give that a try and report back.

[Stevoisiak]

Filter worked once I switched to the uBO dev build, presumably because of the null fix). Appreciated.