POST api/reportserver/v2/data/sql/model

Returns the fields data model 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": 1487,
    "Name": "Northwind Oracle Connection",
    "Provider": "System.Data.OracleClient",
    "ConnectionString": "Data Source=Northwind;User Id=sa;Password=P@ssw0rd!;"
  },
  "Parameters": [
    {
      "Name": "Region",
      "Value": "North America",
      "DbType": 16
    },
    {
      "Name": "CustomerId",
      "Value": 12345,
      "DbType": 11
    }
  ]
}

Response Information

Resource Description

SimpleDataModel

Name	Description	Type	Additional information
Expression	No documentation available.	string	None.
Measures	No documentation available.	Collection of Object	None.
DataSource	No documentation available.	IDataSource	None.
Name	No documentation available.	string	None.
Description	No documentation available.	string	None.
Parent	No documentation available.	IDataModelElement	None.

Response Formats

application/json, text/json

Sample not available.