Using the SSRS REST API, how do you get values of a report parameter when ValidValuesQueryBased=true?

Question

Hello,

I have a report with two parameters. The second parameter is filtered based on the user selection of the first. All works well in the stock ReportViewer UI but we are building a web page for users without direct access to that UI. The request to /Reports({Id})/ParameterDefinitions returns both parameters and the list of values for the first but I can't find a way to get the second parameter list when the user has selected the first value.

{
"Name":"Range"
,"ParameterType":"String"
,"ParameterVisibility":"Visible"
,"ParameterState":"HasOutstandingDependencies"
,"ValidValues":[]
,"ValidValuesIsNull":true
,"Nullable":false
,"AllowBlank":false
,"MultiValue":false
,"Prompt":"Range"
,"PromptUser":true
,"QueryParameter":false
,"DefaultValuesQueryBased":false
,"ValidValuesQueryBased":true
,"Dependencies":["Township"]
,"DefaultValues":[]
,"DefaultValuesIsNull":true
,"ErrorMessage":null
}

Answer 1

Hi @Fred Spataro

Sorry I don't know REST API very well. In the official documentation of SSRS, there are the following two documents about rest api, which provide some examples.

Develop with the REST APIs for Reporting Services

REST API samples >>

Hope these can help you.

Best regards,

Aniya