Advanced JSON datasource?

Hi,

Now I’m running a cloud SQL Server instance, right now there’s no direct way to import the performance data to grafana,So I use ‘Simple JSON datasource’ to proxy the data.

the /query is suggested to return metics,it works good when I just have one instance.
my api route are like:
/mssql/query return like [‘space_usage’,‘cpu rate’]
/mssql/search return performance data list

What should I do when there’re more than one instance?
implements other route like /mssql1/query?

Any good suggestion?

thx!