POST api/reportserver/v2/data/sql/parameters

Returns the required parameters for the specified data connection.

Request Information

URI Parameters

None.

Body Parameters

Query with parameters model.

QueryInfoWithParameters

Name	Description	Type	Additional information
QueryInfo	No documentation available.	QueryInfo	Required
Parameters	No documentation available.	Collection of QueryInfoParameter	None.

Request body formats

application/json, text/json

json

{
  "QueryInfo": {
    "SelectCommandType": 0,
    "SelectCommand": "SELECT * FROM Orders",
    "CommandTimeout": 1469,
    "Name": "Northwind Oracle Connection",
    "Provider": "System.Data.OracleClient",
    "ConnectionString": "Data Source=Northwind;User Id=sa;Password=P@ssw0rd!;"
  },
  "Parameters": [
    {
      "Name": "IsActive",
      "Value": true,
      "DbType": 3
    },
    {
      "Name": "OrderDate",
      "Value": "2024-01-15",
      "DbType": 6
    }
  ]
}

Response Information

Resource Description

Collection of QueryParameter

Name	Description	Type	Additional information
Name	No documentation available.	string	None.
DbType	No documentation available.	System.Data.DbType	None.

Response Formats

application/json, text/json

Sample not available.