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
QueryResultName | 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>