Is it possible in a json query to use and order by or where clause?

You should use the API itself to filter and order the data. If that’s not possible then you can use QRDS to process the data with SQL syntax.