POST api/reportserver/v2/data/sql/preview

Returns the preview data for the specified data connection.

Request Information

URI Parameters

None.

Body Parameters

Data preview with parameters model.

PreviewDataInfoWithParameters

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

Request body formats

application/json, text/json

json

{
  "PreviewDataInfo": {
    "MaxRows": 1460,
    "SelectCommandType": 0,
    "SelectCommand": "SELECT * FROM Orders",
    "CommandTimeout": 1462,
    "Name": "Northwind Oracle Connection",
    "Provider": "System.Data.OracleClient",
    "ConnectionString": "Data Source=Northwind;User Id=sa;Password=P@ssw0rd!;"
  },
  "Parameters": [
    {
      "Name": "OrderDate",
      "Value": "2024-01-15",
      "DbType": 6
    },
    {
      "Name": "Region",
      "Value": "North America",
      "DbType": 16
    }
  ]
}

Response Information

Resource Description

System.Data.DataTable

Name	Description	Type	Additional information
CaseSensitive	No documentation available.	boolean	None.
IsInitialized	No documentation available.	boolean	None.
RemotingFormat	No documentation available.	System.Data.SerializationFormat	None.
ChildRelations	No documentation available.	Collection of Object	None.
Columns	No documentation available.	Collection of Object	None.
Constraints	No documentation available.	Collection of Object	None.
DataSet	No documentation available.	System.Data.DataSet	None.
DefaultView	No documentation available.	Collection of Object	None.
DisplayExpression	No documentation available.	string	None.
ExtendedProperties	No documentation available.	Dictionary of Object [key] and Object [value]	None.
HasErrors	No documentation available.	boolean	None.
Locale	No documentation available.	System.Globalization.CultureInfo	None.
MinimumCapacity	No documentation available.	integer	None.
ParentRelations	No documentation available.	Collection of Object	None.
PrimaryKey	No documentation available.	Collection of System.Data.DataColumn	None.
Rows	No documentation available.	Collection of Object	None.
TableName	No documentation available.	string	None.
Namespace	No documentation available.	string	None.
Prefix	No documentation available.	string	None.
Site	No documentation available.	System.ComponentModel.ISite	None.
Container	No documentation available.	System.ComponentModel.IContainer	None.
DesignMode	No documentation available.	boolean	None.

Response Formats

application/json, text/json

Sample not available.