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
NameDescriptionTypeAdditional information
PreviewDataInfo

No documentation available.

PreviewDataInfo

Required

Parameters

No documentation available.

Collection of QueryInfoParameter

None.

Request body formats

application/json, text/json

Sample:
{
  "PreviewDataInfo": {
    "MaxRows": 1,
    "SelectCommandType": 0,
    "SelectCommand": "sample string 2",
    "CommandTimeout": 3,
    "Name": "sample string 4",
    "Provider": "sample string 5",
    "ConnectionString": "sample string 6"
  },
  "Parameters": [
    {
      "Name": "sample string 1",
      "Value": {},
      "DbType": 0
    },
    {
      "Name": "sample string 1",
      "Value": {},
      "DbType": 0
    }
  ]
}

Response Information

Resource Description

System.Data.DataTable
NameDescriptionTypeAdditional 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:

Sample not available.

In this article
Not finding the help you need?