TestCasesExport
Export excel¶
Attempt to export test cases' data in an Excel format
Request¶
Parameters¶
Parameter | Path/Query | Type | Required | Notes |
---|---|---|---|---|
order | query | string | yes | defines the sorting for filter (asc/desc ), the default value is desc |
by | query | string | yes | defines the sorting for filter, the default value is id |
detailed | query | boolean | yes | defines if the export is detailed |
Request body¶
Attribute | Type | Required | Notes |
---|---|---|---|
testAnalysisFilters | array | no | array of objects containing nameOfTheField , operator and value . nameOfTheField is a string (example= ownerId), operator defines if filter works with "=" or "!=" and value is an integer that defines what is being filtered |
labelFilters | array | no | array of objects containing operator and value . operator defines if filter works with "=" or "!=" and value is an integer that defines what is being filtered |
collaboratorFilters | array | no | array of objects containing operator and value . operator defines if filter works with "=" or "!=" and value is an integer that defines what is being filtered |
testerFilters | array | no | array of objects containing operator and value . operator defines if filter works with "=" or "!=" and value is an integer that defines what is being filtered |
priorityFilter | array | no | array of objects containing operator and value . operator defines if filter works with "=" or "!=" and value is an integer that defines what is being filtered |
statusFilter | array | no | array of objects containing operator and value . operator defines if filter works with "=" or "!=" and value is an integer that defines what is being filtered |
testPlanIds | array | no | array of objects containing operator and value . operator defines if filter works with "=" or "!=" and value is an integer that defines what is being filtered |
testAnalysisStatus | object | yes | contains projectId (required integer), closed (boolean), deleted (boolean), scheduleId (integer) and type (integer) |
navbar | object | object containing substring (type: string) | |
testExecutionFilter | array | no | array of objects containing operator and value . operator defines if filter works with "=" or "!=" and value is an integer that defines what is being filtered |
testSpaceFilter | array | no | array of objects containing operator and value . operator defines if filter works with "=" or "!=" and value is an integer that defines what is being filtered |
Request body example¶
{
"testAnalysisFilters": [
{
"nameOfTheField": "ownerId",
"operator": "=",
"value": 1
}
],
"labelFilters": [
{
"operator": "=",
"value": 1
}
],
"collaboratorFilters": [
{
"operator": "=",
"value": 1
}
],
"testerFilters": [
{
"operator": "=",
"value": 1
}
],
"priorityFilter": [
{
"operator": "=",
"value": 1
}
],
"statusFilter": [
{
"operator": "=",
"value": 1
}
],
"testPlanIds": [
{
"operator": "=",
"value": 1
}
],
"testAnalysisStatus": {
"deleted": true,
"closed": true,
"projectId": 2,
"type": 2,
"scheduleId": 2
},
"navbar": {
"substring": "string"
},
"testExecutionFilter": [
{
"operator": "=",
"value": 1
}
],
"testSpaceFilter": [
{
"operator": "=",
"value": 2
}
]
}
curl --location 'https://example.juno.one/export/test_cases/xlsx?detailed=yes' \
--header 'Authorization: Bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzUxMiJ9.eyJzdWIiOiJ0ZXN0QGp1bm8ub25lIiwidGVuYW50SUQiOiJkZXZlbG9wbWVudCIsImV4cCI6MTY4NDQ4MzYyNn0.cYdUo4oiHnkdAywSAb7EFus9PFg-2FYHZPj4gdMML-mKgUVZw9fewOo4QK6U3PqCzGWjFVksz8HULzyKMnV8AA' \
--header 'X-tenantID: example' \
--header 'Content-Type: application/json' \
--data '{
"testAnalysisFilters": [
{
"nameOfTheField": "ownerId",
"operator": "=",
"value": 1
}
],
"labelFilters": [
{
"operator": "=",
"value": 1
}
],
"collaboratorFilters": [
{
"operator": "=",
"value": 1
}
],
"testerFilters": [
{
"operator": "=",
"value": 1
}
],
"priorityFilter": [
{
"operator": "=",
"value": 1
}
],
"statusFilter": [
{
"operator": "=",
"value": 1
}
],
"testPlanIds": [
{
"operator": "=",
"value": 1
}
],
"testAnalysisStatus": {
"deleted": true,
"closed": true,
"projectId": 2,
"type": 2,
"scheduleId": 2
},
"navbar": {
"substring": "string"
},
"testExecutionFilter": [
{
"operator": "=",
"value": 1
}
],
"testSpaceFilter": [
{
"operator": "=",
"value": 2
}
]
}'
import requests
import json
url = "https://example.juno.one/export/test_cases/xlsx?detailed=yes"
payload = json.dumps({
"testAnalysisFilters": [
{
"nameOfTheField": "ownerId",
"operator": "=",
"value": 1
}
],
"labelFilters": [
{
"operator": "=",
"value": 1
}
],
"collaboratorFilters": [
{
"operator": "=",
"value": 1
}
],
"testerFilters": [
{
"operator": "=",
"value": 1
}
],
"priorityFilter": [
{
"operator": "=",
"value": 1
}
],
"statusFilter": [
{
"operator": "=",
"value": 1
}
],
"testPlanIds": [
{
"operator": "=",
"value": 1
}
],
"testAnalysisStatus": {
"deleted": True,
"closed": True,
"projectId": 2,
"type": 2,
"scheduleId": 2
},
"navbar": {
"substring": "string"
},
"testExecutionFilter": [
{
"operator": "=",
"value": 1
}
],
"testSpaceFilter": [
{
"operator": "=",
"value": 2
}
]
})
headers = {
'Authorization': 'Bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzUxMiJ9.eyJzdWIiOiJ0ZXN0QGp1bm8ub25lIiwidGVuYW50SUQiOiJkZXZlbG9wbWVudCIsImV4cCI6MTY4NDQ4MzYyNn0.cYdUo4oiHnkdAywSAb7EFus9PFg-2FYHZPj4gdMML-mKgUVZw9fewOo4QK6U3PqCzGWjFVksz8HULzyKMnV8AA',
'X-tenantID': 'example',
'Content-Type': 'application/json'
}
response = requests.request("POST", url, headers=headers, data=payload)
print(response.text)
val client = OkHttpClient()
val mediaType = "application/json".toMediaType()
val body = "{\n \"testAnalysisFilters\": [\n {\n \"nameOfTheField\": \"ownerId\",\n \"operator\": \"=\",\n \"value\": 1\n }\n ],\n \"labelFilters\": [\n {\n \"operator\": \"=\",\n \"value\": 1\n }\n ],\n \"collaboratorFilters\": [\n {\n \"operator\": \"=\",\n \"value\": 1\n }\n ],\n \"testerFilters\": [\n {\n \"operator\": \"=\",\n \"value\": 1\n }\n ],\n \"priorityFilter\": [\n {\n \"operator\": \"=\",\n \"value\": 1\n }\n ],\n \"statusFilter\": [\n {\n \"operator\": \"=\",\n \"value\": 1\n }\n ],\n \"testPlanIds\": [\n {\n \"operator\": \"=\",\n \"value\": 1\n }\n ],\n \"testAnalysisStatus\": {\n \"deleted\": true,\n \"closed\": true,\n \"projectId\": 2,\n \"type\": 2,\n \"scheduleId\": 2\n },\n \"navbar\": {\n \"substring\": \"string\"\n },\n \"testExecutionFilter\": [\n {\n \"operator\": \"=\",\n \"value\": 1\n }\n ],\n \"testSpaceFilter\": [\n {\n \"operator\": \"=\",\n \"value\": 2\n }\n ]\n}".toRequestBody(mediaType)
val request = Request.Builder()
.url("https://example.juno.one/export/test_cases/xlsx?detailed=yes")
.post(body)
.addHeader("Authorization", "Bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzUxMiJ9.eyJzdWIiOiJ0ZXN0QGp1bm8ub25lIiwidGVuYW50SUQiOiJkZXZlbG9wbWVudCIsImV4cCI6MTY4NDQ4MzYyNn0.cYdUo4oiHnkdAywSAb7EFus9PFg-2FYHZPj4gdMML-mKgUVZw9fewOo4QK6U3PqCzGWjFVksz8HULzyKMnV8AA")
.addHeader("X-tenantID", "example")
.addHeader("Content-Type", "application/json")
.build()
val response = client.newCall(request).execute()
Response¶
Successful response of export test cases in excel format has the status 200
with no response body
400
Bad Request
404
Not found
406
Insufficient permision
412
Precondition failed
Export in csv¶
Attempt to export test cases' data in a CSV format
Request¶
Parameters¶
Parameter | Path/Query | Type | Required | Notes |
---|---|---|---|---|
order | query | string | yes | defines the sorting for filter (asc/desc ), the default value is desc |
by | query | string | yes | defines the sorting for filter, the default value is id |
detailed | query | boolean | yes | defines if the export is detailed |
Request body¶
Attribute | Type | Required | Notes |
---|---|---|---|
testAnalysisFilters | array | no | array of objects containing nameOfTheField , operator and value . nameOfTheField is a string (example= ownerId), operator defines if filter works with "=" or "!=" and value is an integer that defines what is being filtered |
labelFilters | array | no | array of objects containing operator and value . operator defines if filter works with "=" or "!=" and value is an integer that defines what is being filtered |
collaboratorFilters | array | no | array of objects containing operator and value . operator defines if filter works with "=" or "!=" and value is an integer that defines what is being filtered |
testerFilters | array | no | array of objects containing operator and value . operator defines if filter works with "=" or "!=" and value is an integer that defines what is being filtered |
priorityFilter | array | no | array of objects containing operator and value . operator defines if filter works with "=" or "!=" and value is an integer that defines what is being filtered |
statusFilter | array | no | array of objects containing operator and value . operator defines if filter works with "=" or "!=" and value is an integer that defines what is being filtered |
testPlanIds | array | no | array of objects containing operator and value . operator defines if filter works with "=" or "!=" and value is an integer that defines what is being filtered |
testAnalysisStatus | object | yes | contains projectId (required integer), closed (boolean), deleted (boolean), scheduleId (integer) and type (integer) |
navbar | object | object containing substring (type: string) | |
testExecutionFilter | array | no | array of objects containing operator and value . operator defines if filter works with "=" or "!=" and value is an integer that defines what is being filtered |
testSpaceFilter | array | no | array of objects containing operator and value . operator defines if filter works with "=" or "!=" and value is an integer that defines what is being filtered |
Request body example¶
{
"testAnalysisFilters": [
{
"nameOfTheField": "ownerId",
"operator": "=",
"value": 1
}
],
"labelFilters": [
{
"operator": "=",
"value": 1
}
],
"collaboratorFilters": [
{
"operator": "=",
"value": 1
}
],
"testerFilters": [
{
"operator": "=",
"value": 1
}
],
"priorityFilter": [
{
"operator": "=",
"value": 1
}
],
"statusFilter": [
{
"operator": "=",
"value": 1
}
],
"testPlanIds": [
{
"operator": "=",
"value": 1
}
],
"testAnalysisStatus": {
"deleted": true,
"closed": true,
"projectId": 2,
"type": 2,
"scheduleId": 2
},
"navbar": {
"substring": "string"
},
"testExecutionFilter": [
{
"operator": "=",
"value": 1
}
],
"testSpaceFilter": [
{
"operator": "=",
"value": 2
}
]
}
curl --location 'https://example.juno.one/export/test_cases/csv?detailed=yes' \
--header 'Authorization: Bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzUxMiJ9.eyJzdWIiOiJ0ZXN0QGp1bm8ub25lIiwidGVuYW50SUQiOiJkZXZlbG9wbWVudCIsImV4cCI6MTY4NDQ4MzYyNn0.cYdUo4oiHnkdAywSAb7EFus9PFg-2FYHZPj4gdMML-mKgUVZw9fewOo4QK6U3PqCzGWjFVksz8HULzyKMnV8AA' \
--header 'X-tenantID: example' \
--header 'Content-Type: application/json' \
--data '{
"testAnalysisFilters": [
{
"nameOfTheField": "ownerId",
"operator": "=",
"value": 1
}
],
"labelFilters": [
{
"operator": "=",
"value": 1
}
],
"collaboratorFilters": [
{
"operator": "=",
"value": 1
}
],
"testerFilters": [
{
"operator": "=",
"value": 1
}
],
"priorityFilter": [
{
"operator": "=",
"value": 1
}
],
"statusFilter": [
{
"operator": "=",
"value": 1
}
],
"testPlanIds": [
{
"operator": "=",
"value": 1
}
],
"testAnalysisStatus": {
"deleted": true,
"closed": true,
"projectId": 2,
"type": 2,
"scheduleId": 2
},
"navbar": {
"substring": "string"
},
"testExecutionFilter": [
{
"operator": "=",
"value": 1
}
],
"testSpaceFilter": [
{
"operator": "=",
"value": 2
}
]
}'
import requests
import json
url = "https://example.juno.one/export/test_cases/csv?detailed=yes"
payload = json.dumps({
"testAnalysisFilters": [
{
"nameOfTheField": "ownerId",
"operator": "=",
"value": 1
}
],
"labelFilters": [
{
"operator": "=",
"value": 1
}
],
"collaboratorFilters": [
{
"operator": "=",
"value": 1
}
],
"testerFilters": [
{
"operator": "=",
"value": 1
}
],
"priorityFilter": [
{
"operator": "=",
"value": 1
}
],
"statusFilter": [
{
"operator": "=",
"value": 1
}
],
"testPlanIds": [
{
"operator": "=",
"value": 1
}
],
"testAnalysisStatus": {
"deleted": True,
"closed": True,
"projectId": 2,
"type": 2,
"scheduleId": 2
},
"navbar": {
"substring": "string"
},
"testExecutionFilter": [
{
"operator": "=",
"value": 1
}
],
"testSpaceFilter": [
{
"operator": "=",
"value": 2
}
]
})
headers = {
'Authorization': 'Bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzUxMiJ9.eyJzdWIiOiJ0ZXN0QGp1bm8ub25lIiwidGVuYW50SUQiOiJkZXZlbG9wbWVudCIsImV4cCI6MTY4NDQ4MzYyNn0.cYdUo4oiHnkdAywSAb7EFus9PFg-2FYHZPj4gdMML-mKgUVZw9fewOo4QK6U3PqCzGWjFVksz8HULzyKMnV8AA',
'X-tenantID': 'example',
'Content-Type': 'application/json'
}
response = requests.request("POST", url, headers=headers, data=payload)
print(response.text)
val client = OkHttpClient()
val mediaType = "application/json".toMediaType()
val body = "{\n \"testAnalysisFilters\": [\n {\n \"nameOfTheField\": \"ownerId\",\n \"operator\": \"=\",\n \"value\": 1\n }\n ],\n \"labelFilters\": [\n {\n \"operator\": \"=\",\n \"value\": 1\n }\n ],\n \"collaboratorFilters\": [\n {\n \"operator\": \"=\",\n \"value\": 1\n }\n ],\n \"testerFilters\": [\n {\n \"operator\": \"=\",\n \"value\": 1\n }\n ],\n \"priorityFilter\": [\n {\n \"operator\": \"=\",\n \"value\": 1\n }\n ],\n \"statusFilter\": [\n {\n \"operator\": \"=\",\n \"value\": 1\n }\n ],\n \"testPlanIds\": [\n {\n \"operator\": \"=\",\n \"value\": 1\n }\n ],\n \"testAnalysisStatus\": {\n \"deleted\": true,\n \"closed\": true,\n \"projectId\": 2,\n \"type\": 2,\n \"scheduleId\": 2\n },\n \"navbar\": {\n \"substring\": \"string\"\n },\n \"testExecutionFilter\": [\n {\n \"operator\": \"=\",\n \"value\": 1\n }\n ],\n \"testSpaceFilter\": [\n {\n \"operator\": \"=\",\n \"value\": 2\n }\n ]\n}".toRequestBody(mediaType)
val request = Request.Builder()
.url("https://example.juno.one/export/test_cases/csv?detailed=yes")
.post(body)
.addHeader("Authorization", "Bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzUxMiJ9.eyJzdWIiOiJ0ZXN0QGp1bm8ub25lIiwidGVuYW50SUQiOiJkZXZlbG9wbWVudCIsImV4cCI6MTY4NDQ4MzYyNn0.cYdUo4oiHnkdAywSAb7EFus9PFg-2FYHZPj4gdMML-mKgUVZw9fewOo4QK6U3PqCzGWjFVksz8HULzyKMnV8AA")
.addHeader("X-tenantID", "example")
.addHeader("Content-Type", "application/json")
.build()
val response = client.newCall(request).execute()
Response¶
Successful response of export test case in a csv format has the status 200
with no response body
400
Bad Request
404
Not found
406
Insufficient permision
412
Precondition failed