POST api/reportserver/v3/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, application/*+json

json

{
  "PreviewDataInfo": {
    "MaxRows": 620,
    "SelectCommandType": "Text",
    "SelectCommand": "SELECT * FROM Orders",
    "CommandTimeout": 622,
    "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": "DateTime"
    },
    {
      "Name": "Region",
      "Value": "North America",
      "DbType": "String"
    }
  ]
}

Response Information

Resource Description

None.