Currently what you can do with JSON Query in FME is very limited. It would be great to have more advanced support per https://docs.jsonata.org/simple, where for example once could extract the last item in array (json[-1]) or get objects in reverse oder (json[-2] etc.), get items in an array based on the value of an attribute (ex: json["columns"["type"='Data']]...maybe not exactly this syntax but you get the point...). This would avoid having to fragment a lot of useless data and then use Testers and TestFilters to weed out what you want.
Reply
Rich Text Editor, editor1
Editor toolbars
Press ALT 0 for help
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.