When using SQL Stored Procedure (v2) Is it possible to fill out the databasename using a variable ?
I keep getting
Just because all those dropdowns give you that option. For some things it works for others it doesn't.
It doesnt even work for a single one.
Say my database is called test.
If i select that database from the dropdown it works
If i select that database using a variable it doesnt work.
Why give me the option to use a custom variable if the functionality doesnt work ?
I think the problem is that the stored procedure itself is different for each database. Yes it can have the same name and the same definition, but in the SQL master table its a different object. So if you use a custom string to connect to the database it can't pre-load the stored procedure schema. I thought it might still work, but evidently it won't.
- Datatype is string
- If I use the dataname from connection it works.
(I would like a variable since i have to connect to different databases)
What is the data type of the SQL parameter? Does it work if you pick the database name from the dropdown without using a variable?
That is what i did. I initialized a variable contaning the database name.
Then used: Enter custom value in which i supplied the variable.
Then added the 1 parameteri have (also by using a variable)
Then i got the error: "message": "The request entity's media type 'text/plain' is not supported for this resource."
Are you just typing the name in the blank, or are you using Enter Custom Value from the dropdown. You should be able to do it if you use the dropdown.