Execute query and get data
post
/fscmRestApi/resources/11.13.18.05/dataGetterQueries/action/getQueryData
Accepts query ID, data format type, selection tool ID, query payload and returns a JSON string which contains the query result.
Request
Header Parameters
-
Metadata-Context:
If the REST API supports runtime customizations, the shape of the service may change during runtime. The REST client may isolate itself from these changes or choose to interact with the latest version of the API by specifying this header. For example: Metadata-Context:sandbox="TrackEmployeeFeature".
-
REST-Framework-Version:
The protocol version between a REST client and service. If the client does not specify this header in the request the server will pick a default version for the API.
Supported Media Types
- application/vnd.oracle.adf.action+json
Root Schema : schema
Type:
Show Source
object
-
dataFormatType: string
Query result format type such as HIERARCHICAL or FLAT.
-
queryId: number
ID of a query to be executed.
-
queryPayload: string
Query payload to be executed.
-
rowCount: number
Query row count.
-
selectionToolId: number
Selection tool ID of a query to be executed.
Response
Supported Media Types
- application/json
- application/vnd.oracle.adf.actionresult+json
Default Response
The following table describes the default response for this task.