I am running the sample 'sql_request' from the docs which passes in a third @Paramjeet Dahiya to this plugin, but I am getting this error of only 2 params supported, both on KustoWebUi and in Kusto.Explorer. https://video2.skills-academy.com/en-us/azure/data-explorer/kusto/query/sqlrequestplugin?pivots=azuredataexplorer#examples The 2 argument variant does work fine for me.

Hi @Kovács, Ferenc , Thanks for using Microsoft Q&A !! I have tested this with 3 arguments and it works fine from Kusto Explorer. Can you please share sql_request you are using along with the exact error message. Note: For 3rd parameter (SqlParameters) you need to pass a constant value of type dynamic that holds key-value pairs to pass as parameters along with the query. Thanks Saurabh

The function 'sql_request' expects 2 arguments.

Accepted answer

Saurabh Sharma 23,816 Reputation points Microsoft Employee

2022-01-19T01:46:16.84+00:00

Hi @Kovács, Ferenc ,
Thanks for using Microsoft Q&A !!
I have tested this with 3 arguments and it works fine from Kusto Explorer.

Can you please share sql_request you are using along with the exact error message.

Note: For 3rd parameter (SqlParameters) you need to pass a constant value of type dynamic that holds key-value pairs to pass as parameters along with the query.

Thanks
Saurabh
Please sign in to rate this answer.

1 person found this answer helpful.
Kovács, Ferenc 61 Reputation points

2022-01-19T07:19:48.837+00:00

Hi @Saurabh Sharma ,

My bad, it actually "runs" but I usually do not run things with errors as a habit.
You see in your own screenshot, sql_request is underlined in RED. If you hover over it with the mouse you see the error.
The difference is you had the courage to run it ignoring errors, I did not :).

In the end it works, and the cosmetic bug is in the intellisense most probably.

Thanks a lot!
kf-

Saurabh Sharma 23,816 Reputation points Microsoft Employee

2022-01-19T12:11:37.53+00:00

Hi @Kovács, Ferenc ,

Great that it works, and I agree with you on this cosmetic issue. :).
I will however provide your findings internally to the products team to improve the product. Thanks for your feedback.

Thanks
Saurabh
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.

Share via

The function 'sql_request' expects 2 arguments.

0 additional answers

Your answer