Web service and parameter pass

Hi Guys,

I have a Web Service that returns the MSSQL user info. And i want to send Web service parameter to grafana as you can see at below and grafana has to send to Stored Procedure in MSSQL. How can i get this? Web service returns the info in red box.
ressssssssssss
The original grafana is:
orgg
How can i send the red box info from web service to grafana without typing in grafana manually and then send this info to MSSQL?
Can you help me as soon as possible?

Regards,

You’ll need to create a datasource in Grafana which can communicate with your web service and then you can receive the value in red box as a template variable.