TestCasesExport

Export excel¶

Attempt to export test cases' data in an Excel format

Request¶

post /export/test_cases/xlsx?detailed=yes

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¶

jsoncurlpythonkotlin

{
  "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¶

200400404406412500

Successful response of export test cases in excel format has the status 200 with no response body

400 Bad Request

{
    "timestamp": "2022-02-16T17:11:34.422+00:00",
    "status": 400,
    "error": "Bad Request",
    "message": "The request is missing detailed parameter",
    "path": "/export/test_cases/xlsx?detailed=yes"
}

404 Not found

{
    "timestamp": "2022-02-16T17:11:34.422+00:00",
    "status": 404,
    "error": "Not Found",
    "message": "Test case was not found.",
    "path": "/export/test_cases/xlsx?detailed=yes"
}

406 Insufficient permision

{
    "timestamp": "2022-02-16T17:11:34.422+00:00",
    "status": 406,
    "error": "Missing permission for action",
    "message": "You do not have a permission for this action",
    "path": "/export/test_cases/xlsx?detailed=yes"
}

412 Precondition failed

{
    "timestamp": "2022-02-16T17:11:34.422+00:00",
    "status": 412,
    "error": "Precondition failed",
    "message": "You do not have permission for this action",
    "path" : "/export/test_cases/xlsx?detailed=yes"
}

500 Unknown error

{
    "timestamp": "2022-02-16T17:11:34.422+00:00",
    "status": 500,
    "error": "Unknown",
    "message": "There was a problem with your request. Please contact your administrator.",
    "path" : "/export/test_cases/xlsx?detailed=yes"
}

Export in csv¶

Attempt to export test cases' data in a CSV format