GET api/GetQueryResult/{queryID}/{loggedInUserId}
Request Information
URI Parameters
| Name | Description | Type | Additional information |
|---|---|---|---|
| queryID | integer |
Required |
|
| loggedInUserId | integer |
Required |
Body Parameters
None.
Response Information
Resource Description
QueryResult| Name | Description | Type | Additional information |
|---|---|---|---|
| Columns | string |
None. |
|
| ResultTable | DataTable |
None. |
|
| Schema | Collection of QueryResultSchema |
None. |
|
| DecimalFields | Collection of string |
None. |
|
| ErrorMessage | string |
None. |
Response Formats
application/json, text/json
Sample:
{
"Columns": "sample string 1",
"ResultTable": null,
"Schema": [
{
"ColumnName": "sample string 1",
"DataType": "sample string 2"
},
{
"ColumnName": "sample string 1",
"DataType": "sample string 2"
}
],
"DecimalFields": [
"sample string 1",
"sample string 2"
],
"ErrorMessage": "sample string 2"
}
application/xml, text/xml
Sample:
<QueryResult xmlns:i="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://schemas.datacontract.org/2004/07/Goaa.iPro.Data.Admin.CustomClasses">
<Columns>sample string 1</Columns>
<DecimalFields xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
<d2p1:string>sample string 1</d2p1:string>
<d2p1:string>sample string 2</d2p1:string>
</DecimalFields>
<ErrorMessage>sample string 2</ErrorMessage>
<ResultTable i:nil="true" />
<Schema>
<QueryResultSchema>
<ColumnName>sample string 1</ColumnName>
<DataType>sample string 2</DataType>
</QueryResultSchema>
<QueryResultSchema>
<ColumnName>sample string 1</ColumnName>
<DataType>sample string 2</DataType>
</QueryResultSchema>
</Schema>
</QueryResult>