[Deprecated]: v7.0
get
/ec-query-svc/rest/v7.0/studies/{studyId}/{mode}/queries/{queryId}
Deprecated: Use latest version instead. Compared to v6.0, this v7.0 endpoint preserves get-by-id behavior while aligning response semantics with the v7 contract. This benefits users by reducing client-side adaptation work during v7 adoption.
Request
Path Parameters
-
mode(required): string
Study mode. Allowed values: test (testing sandbox), training (training environment), and active (production).
-
queryId(required): string
Query ID.
-
studyId(required): string(uuid)
Clinical One study identifier formatted as a 32 to 36 character GUID.
There's no request body for this operation.
Back to TopResponse
Supported Media Types
- application/json
200 Response
Successful operation.
Root Schema : QueryDTOv7Resp
Type:
Show Source
object-
creatorStudyRoleId: string
(uuid)
-
dataElementId: string
(uuid)
Data element Unique GUID
-
discrepancyId: integer
(int64)
Discrepancy IdExample:
123456789 -
eventId(required): string
(uuid)
Event Unique GUID
-
eventInstanceNumber: number
Sequence number (0, 1, 2, ...) of repeating eventExample:
0 -
formId(required): string
(uuid)
Form Unique GUID
-
formInstanceNumber: number
Sequence number (0, 1, 2, ...) of repeating formExample:
0 -
id: string
(uuid)
Query Unique GUID
-
isQueryCreator: boolean
-
itemId: string
(uuid)
Item Unique GUID
-
objectVersionNumber: number
Sequence number (0, 1, 2, ...) of object Version NumberExample:
0 -
queryComment(required): string
Minimum Length:
1Maximum Length:2048Query commentsExample:Comment -
siteId: string
(uuid)
Site Unique GUID
-
state: string
Query stateExample:
Opened -
studyRoles: array
studyRoles
-
studyVersionStart: string
(date-time)
Data element Version Start
-
subjectId(required): string
(uuid)
Subject Unique GUID
Example:
{\n \"id\": \"AE33A9096BF548BBB29A96E399E9FBBB\",\n \"queryComment\": \"Visit date clarification required.\",\n \"state\": \"Opened\",\n \"subjectId\": \"762744769B0E4E40B6A74691179BC578\",\n \"dataElementId\": \"583A45DD0A1C46F88D7842D76CAF9A59\",\n \"dataElementVersionStart\": \"2026-01-15T10:05:30Z\",\n \"formId\": \"680E0FB01F1B4CCB990C333563FAEE80\",\n \"siteId\": \"CB9BBB0767114F599FE75616223D6665\",\n \"eventId\": \"3B95322B15144E4397B30305EB33E871\",\n \"eventInstanceNumber\": 0,\n \"formInstanceNumber\": 0,\n \"objectVersionNumber\": 4,\n \"itemId\": \"42738D18833E45C29D9CDEABBB2247FE\",\n \"studyRoles\": [{\"studyRoleId\": \"6AF54DB79B764662B685D68C52AB0B84\", \"studyRoleName\": \"CRA\"}],\n \"discrepancyId\": 123456789\n}Nested Schema : QueryStudyRoleDTOv6
Type:
Show Source
object-
studyRoleId: string
(uuid)
Study role of the user performing the query operation
-
studyRoleName: string
Study role name of the user performing the query operationExample:
CRA
Examples
400 Response
Request validation failed due to missing, invalid, or inconsistent request data.
Root Schema : Response DTO
Type:
objectBase envelope returned by Query APIs. Use the status field to determine whether result or errorData is populated.
Show Source
-
errorData: object
Error details DTO
Standard structure used to describe errors returned by Query APIs.
-
result: object
result
Result payload returned when status equals success.
-
status: string
Read Only:
trueAllowed Values:[ "success", "failed" ]Overall execution status. Value is success when result is populated and failed when errorData is returned.Example:success -
version: string
Read Only:
trueSemantic version of the response envelope.Example:1
Example:
{\n \"status\": \"success\",\n \"result\": {\n \"id\": \"AE33A9096BF548BBB29A96E399E9FBBB\",\n \"state\": \"Answered\"\n },\n \"errorData\": null,\n \"version\": \"1\"\n}Nested Schema : Error details DTO
Type:
objectStandard structure used to describe errors returned by Query APIs.
Show Source
-
details: object
QueryRestErrorDetail
Read Only:
trueContext object returned when additional error metadata is available. -
errorCode: string
Read Only:
trueMachine-readable error code that identifies the failure.Example:QRY-5000 -
errorMessage: string
Read Only:
trueHuman-readable explanation describing why the request failed.Example:Unexpected server error.
Example:
{
"errorCode":"QRY-5000",
"errorMessage":"Unexpected server error.",
"details":{
"requestId":"3b3b8f31-87a3-4dd2-8b9d-21d0c93ef27a",
"supportCode":"QRY-5000",
"hint":"Retry request after verifying the study mode."
}
}Nested Schema : result
Type:
objectResult payload returned when status equals success.
Example:
{
"opened":3,
"answered":1,
"closed":2
}Nested Schema : QueryRestErrorDetail
Type:
objectRead Only:
trueContext object returned when additional error metadata is available.
Show Source
-
hint: string
Client-facing guidance that clarifies how to resolve or retry the request.Example:
Retry request after verifying the study mode. -
requestId: string
Unique identifier that can be supplied to Oracle Support when troubleshooting.Example:
3b3b8f31-87a3-4dd2-8b9d-21d0c93ef27a -
supportCode: string
Support or incident code associated with the error source.Example:
QRY-5000
Example:
{
"requestId":"3b3b8f31-87a3-4dd2-8b9d-21d0c93ef27a",
"supportCode":"QRY-5000",
"hint":"Retry request"
}Examples
404 Response
The query could not be found.
Root Schema : Response DTO
Type:
objectBase envelope returned by Query APIs. Use the status field to determine whether result or errorData is populated.
Show Source
-
errorData: object
Error details DTO
Standard structure used to describe errors returned by Query APIs.
-
result: object
result
Result payload returned when status equals success.
-
status: string
Read Only:
trueAllowed Values:[ "success", "failed" ]Overall execution status. Value is success when result is populated and failed when errorData is returned.Example:success -
version: string
Read Only:
trueSemantic version of the response envelope.Example:1
Example:
{\n \"status\": \"success\",\n \"result\": {\n \"id\": \"AE33A9096BF548BBB29A96E399E9FBBB\",\n \"state\": \"Answered\"\n },\n \"errorData\": null,\n \"version\": \"1\"\n}Nested Schema : Error details DTO
Type:
objectStandard structure used to describe errors returned by Query APIs.
Show Source
-
details: object
QueryRestErrorDetail
Read Only:
trueContext object returned when additional error metadata is available. -
errorCode: string
Read Only:
trueMachine-readable error code that identifies the failure.Example:QRY-5000 -
errorMessage: string
Read Only:
trueHuman-readable explanation describing why the request failed.Example:Unexpected server error.
Example:
{
"errorCode":"QRY-5000",
"errorMessage":"Unexpected server error.",
"details":{
"requestId":"3b3b8f31-87a3-4dd2-8b9d-21d0c93ef27a",
"supportCode":"QRY-5000",
"hint":"Retry request after verifying the study mode."
}
}Nested Schema : result
Type:
objectResult payload returned when status equals success.
Example:
{
"opened":3,
"answered":1,
"closed":2
}Nested Schema : QueryRestErrorDetail
Type:
objectRead Only:
trueContext object returned when additional error metadata is available.
Show Source
-
hint: string
Client-facing guidance that clarifies how to resolve or retry the request.Example:
Retry request after verifying the study mode. -
requestId: string
Unique identifier that can be supplied to Oracle Support when troubleshooting.Example:
3b3b8f31-87a3-4dd2-8b9d-21d0c93ef27a -
supportCode: string
Support or incident code associated with the error source.Example:
QRY-5000
Example:
{
"requestId":"3b3b8f31-87a3-4dd2-8b9d-21d0c93ef27a",
"supportCode":"QRY-5000",
"hint":"Retry request"
}Examples