---
title: Tickets
slug: tickets
createdAt: 2026-10-20T09:51:11.729Z
---

{
  "id": "k0ZbfD6nAYurWeSGO8byx",
  "type": "api-oas-v2",
  "data": {
    "method": "GET",
    "url": "https://tnapi.ticketpay.de/exports/tickets",
    "servers": [
      {
        "url": "https://tnapi.ticketpay.de/exports/tickets",
        "description": "The production API server"
      }
    ],
    "name": "Tickets",
    "description": "<p>With this endpoint you can get a list of your tickets. The default output is JSON.\nFor results in a CSV file please extend the url with .csv\nIf you use time filter please note that this is used by default to the 'updated_iso' field. If you wish to use it to the 'created_iso' field please use filter_by parameter.</p>",
    "contentType": "application/json",
    "request": {
      "pathParameters": [],
      "headerParameters": [
        {
          "kind": "required",
          "name": "Authorization",
          "type": "string",
          "description": "<p>To authentificate please use your API-KEY created here <a href=\"https://iam.ticketpay.de/api-keys\" target=\"_blank\">https://iam.ticketpay.de/api-keys</a>. Please give this API-KEY the role Export.</p>"
        }
      ],
      "queryParameters": [
        {
          "kind": "optional",
          "name": "from",
          "type": "string",
          "example": "2025-05-01T00:00:00.000",
          "description": "<p>A date or datetime parameter to select the data start with this date. In default this filter is used in the field updated_iso.</p>"
        },
        {
          "kind": "optional",
          "name": "to",
          "type": "string",
          "example": "2025-05-05",
          "description": "<p>A date or datetime parameter to select the data end with this date. In default this filter is used in the field updated_iso.</p>"
        },
        {
          "kind": "optional",
          "name": "filter_by",
          "type": "string",
          "example": "created_iso",
          "description": "<p>Datetime filter field. Default value is updated_iso. Possible values are created_iso and updated_iso</p>"
        },
        {
          "kind": "optional",
          "name": "time_period",
          "type": "string",
          "description": "<p>If you dont want to use from and to you can use a time period to select data with a special period. Possible values are months, days, hours, minutes, seconds</p>"
        },
        {
          "kind": "optional",
          "name": "time_range",
          "type": "integer",
          "description": "<p>A time range is needed if you use the time_period parameter to select data. For exapmle you want tho get the last two months - time_period is months and time_range is 2</p>"
        },
        {
          "kind": "optional",
          "name": "shop_order_id",
          "type": "integer",
          "description": "To filter the results you can pass here the id of your order. The results will put all tickets from this order."
        },
        {
          "kind": "optional",
          "name": "shop_id",
          "type": "integer",
          "description": "<p>To filter the results you can pass here the shop_id of your organizer shop</p>"
        },
        {
          "kind": "optional",
          "name": "event_id",
          "type": "integer",
          "description": "<p>To filter the results you can pass here the event_id of one out yours events</p>"
        },
        {
          "kind": "optional",
          "name": "sso_user_id",
          "type": "string",
          "description": "<p>To filter the results you can pass here a sso_user_id. The results will put all tickets with this sso_user_id.</p>"
        },
        {
          "kind": "optional",
          "name": "status",
          "type": "string",
          "description": "To filter the results you can pass here the status of tickets. The results will put all tickets with this status."
        },
        {
          "kind": "optional",
          "name": "ticketnumber",
          "type": "string",
          "description": "<p>To filter the results you can pass here the ticket number (QR Code). The results will put one ticket with this number.</p>"
        },
        {
          "kind": "optional",
          "name": "email",
          "type": "string",
          "description": "To filter the results you can pass here an email address. The results will put all tickets with this email address."
        },
        {
          "kind": "optional",
          "name": "per_page",
          "type": "integer",
          "description": "For pagination. Defines the number of data per page in the output."
        },
        {
          "kind": "optional",
          "name": "page",
          "type": "integer",
          "description": "For pagination. Defines the page number for the data output."
        }
      ],
      "bodyDataParameters": [],
      "formDataParameters": [],
      "oAuthParameters": [],
      "cookieParameters": []
    },
    "responses": [
      {
        "statusCode": "200",
        "description": "Response for get tickets.",
        "jsonExample": "",
        "isExpanded": true,
        "schema": [
          {
            "kind": "optional",
            "type": "object",
            "description": "",
            "customType": "get_tickets",
            "schema": [
              {
                "name": "total",
                "kind": "optional",
                "type": "integer",
                "description": "",
                "example": 157
              },
              {
                "name": "page",
                "kind": "optional",
                "type": "integer",
                "description": "",
                "example": 1
              },
              {
                "name": "size",
                "kind": "optional",
                "type": "integer",
                "description": "",
                "example": 157
              },
              {
                "name": "data",
                "kind": "optional",
                "type": "array",
                "description": "",
                "example": "",
                "itemType": "object",
                "customType": "object[]",
                "schema": [
                  {
                    "name": "id",
                    "kind": "optional",
                    "type": "integer",
                    "description": "",
                    "example": 6256520
                  },
                  {
                    "name": "valid_from",
                    "kind": "optional",
                    "type": "string",
                    "description": "",
                    "example": "2023-07-28T20:00:00+02:00"
                  },
                  {
                    "name": "valid_until",
                    "kind": "optional",
                    "type": "string",
                    "description": "",
                    "example": "2023-07-28T22:00:00+02:00"
                  },
                  {
                    "name": "status",
                    "kind": "optional",
                    "type": "string",
                    "description": "",
                    "example": "approved"
                  },
                  {
                    "name": "shop_id",
                    "kind": "optional",
                    "type": "integer",
                    "description": "",
                    "example": 14669
                  },
                  {
                    "name": "created_iso",
                    "kind": "optional",
                    "type": "string",
                    "description": "",
                    "example": "2022-02-26T19:29:42+01:00"
                  },
                  {
                    "name": "updated_iso",
                    "kind": "optional",
                    "type": "string",
                    "description": "",
                    "example": "2022-02-26T19:29:43+01:00"
                  },
                  {
                    "name": "event_id",
                    "kind": "optional",
                    "type": "integer",
                    "description": "",
                    "example": 78001
                  },
                  {
                    "name": "additional_fields",
                    "kind": "optional",
                    "type": "array",
                    "description": "",
                    "example": "",
                    "itemType": "object",
                    "customType": "object[]",
                    "schema": [
                      {
                        "name": "show1",
                        "kind": "optional",
                        "type": "boolean",
                        "description": "",
                        "example": true
                      },
                      {
                        "name": "field1",
                        "kind": "optional",
                        "type": "string",
                        "description": "",
                        "example": "Startzeit"
                      },
                      {
                        "name": "field1_val",
                        "kind": "optional",
                        "type": "string",
                        "description": "",
                        "example": "12:40"
                      },
                      {
                        "name": "show2",
                        "kind": "optional",
                        "type": "boolean",
                        "description": "",
                        "example": false
                      },
                      {
                        "name": "field2",
                        "kind": "optional",
                        "type": "string",
                        "description": "",
                        "example": ""
                      },
                      {
                        "name": "field2_val",
                        "kind": "optional",
                        "type": "string",
                        "description": "",
                        "example": ""
                      }
                    ]
                  },
                  {
                    "name": "age",
                    "kind": "optional",
                    "type": "integer",
                    "description": "",
                    "example": 29
                  },
                  {
                    "name": "barcode_value",
                    "kind": "optional",
                    "type": "string",
                    "description": "",
                    "example": "992LFU8HB"
                  },
                  {
                    "name": "birthday",
                    "kind": "optional",
                    "type": "string",
                    "description": "",
                    "example": "05.12.1999"
                  },
                  {
                    "name": "channel",
                    "kind": "optional",
                    "type": "string",
                    "description": "",
                    "example": "shop"
                  },
                  {
                    "name": "checked_in",
                    "kind": "optional",
                    "type": "boolean",
                    "description": "",
                    "example": false
                  },
                  {
                    "name": "checked_out",
                    "kind": "optional",
                    "type": "boolean",
                    "description": "",
                    "example": false
                  },
                  {
                    "name": "city",
                    "kind": "optional",
                    "type": "string",
                    "description": "",
                    "example": "Hamm"
                  },
                  {
                    "name": "country",
                    "kind": "optional",
                    "type": "string",
                    "description": "",
                    "example": "DE"
                  },
                  {
                    "name": "ds_confirmation",
                    "kind": "optional",
                    "type": "string",
                    "description": "<p>Digital signature. User can read and confirm separate provisions.\nPossible options:</p>\n<ul>\n<li>open - not signed yet</li>\n<li>closed - already signed</li>\n<li>not_necessary - no sign needed</li>\n</ul>",
                    "example": "open"
                  },
                  {
                    "name": "firstname",
                    "kind": "optional",
                    "type": "string",
                    "description": "",
                    "example": "Max"
                  },
                  {
                    "name": "lastname",
                    "kind": "optional",
                    "type": "string",
                    "description": "",
                    "example": "Mustermann"
                  },
                  {
                    "name": "gender",
                    "kind": "optional",
                    "type": "string",
                    "description": "",
                    "example": "m"
                  },
                  {
                    "name": "has_questions",
                    "kind": "optional",
                    "type": "boolean",
                    "description": "",
                    "example": true
                  },
                  {
                    "name": "mail",
                    "kind": "optional",
                    "type": "string",
                    "description": "",
                    "example": "example@ticketpay.de"
                  },
                  {
                    "name": "matching_id",
                    "kind": "optional",
                    "type": "integer",
                    "description": "",
                    "example": 1548851
                  },
                  {
                    "name": "matching_required",
                    "kind": "optional",
                    "type": "boolean",
                    "description": "",
                    "example": true
                  },
                  {
                    "name": "newsletter",
                    "kind": "optional",
                    "type": "boolean",
                    "description": "",
                    "example": true
                  },
                  {
                    "name": "order_information",
                    "kind": "optional",
                    "type": "string",
                    "description": "",
                    "example": "Max Mustrmann,Neue Bahnhofstr. 1-3,DE 59065 Hamm"
                  },
                  {
                    "name": "original_price",
                    "kind": "optional",
                    "type": "float",
                    "description": "",
                    "example": 119
                  },
                  {
                    "name": "paid",
                    "kind": "optional",
                    "type": "boolean",
                    "description": "",
                    "example": true
                  },
                  {
                    "name": "personalization_due",
                    "kind": "optional",
                    "type": "string",
                    "description": "",
                    "example": "2023-07-28T20:00:00+02:00"
                  },
                  {
                    "name": "personalize",
                    "kind": "optional",
                    "type": "boolean",
                    "description": "",
                    "example": true
                  },
                  {
                    "name": "personalize_status",
                    "kind": "optional",
                    "type": "string",
                    "description": "",
                    "example": "not_necessary"
                  },
                  {
                    "name": "price",
                    "kind": "optional",
                    "type": "float",
                    "description": "",
                    "example": 100
                  },
                  {
                    "name": "phone",
                    "kind": "optional",
                    "type": "string",
                    "description": "",
                    "example": 238112345678
                  },
                  {
                    "name": "qrcode_value",
                    "kind": "optional",
                    "type": "string",
                    "description": "",
                    "example": "992LFU8HB"
                  },
                  {
                    "name": "questions_answered",
                    "kind": "optional",
                    "type": "boolean",
                    "description": "",
                    "example": false
                  },
                  {
                    "name": "questions_answers",
                    "kind": "optional",
                    "type": "array",
                    "description": "",
                    "example": "[[\"Bist du ein Fan?\",\"yes\"],[\"Do you need entry support?\",\"Maybe\"]]",
                    "itemType": "object",
                    "customType": "object[]",
                    "itemExample": "",
                    "itemDefault": ""
                  },
                  {
                    "name": "questions_count",
                    "kind": "optional",
                    "type": "integer",
                    "description": "",
                    "example": 0
                  },
                  {
                    "name": "seat",
                    "kind": "optional",
                    "type": "string",
                    "description": "",
                    "example": "Reihe 2-Sitz 15"
                  },
                  {
                    "name": "source_item_id",
                    "kind": "optional",
                    "type": "integer",
                    "description": "",
                    "example": 11708
                  },
                  {
                    "name": "source_item_type",
                    "kind": "optional",
                    "type": "string",
                    "description": "",
                    "example": "EventTicket"
                  },
                  {
                    "name": "shop_order_id",
                    "kind": "optional",
                    "type": "integer",
                    "description": "",
                    "example": 322333
                  },
                  {
                    "name": "sso_user_id",
                    "kind": "optional",
                    "type": "string",
                    "description": "",
                    "example": "subject_21345rez113323"
                  },
                  {
                    "name": "start_number",
                    "kind": "optional",
                    "type": "string",
                    "description": "",
                    "example": 1250
                  },
                  {
                    "name": "street",
                    "kind": "optional",
                    "type": "string",
                    "description": "",
                    "example": "Neue Bahnhofstr. 1-3"
                  },
                  {
                    "name": "tags",
                    "kind": "optional",
                    "type": "string",
                    "description": "",
                    "example": "premium,early"
                  },
                  {
                    "name": "team_id",
                    "kind": "optional",
                    "type": "integer",
                    "description": "",
                    "example": "1324,"
                  },
                  {
                    "name": "team_name",
                    "kind": "optional",
                    "type": "string",
                    "description": "",
                    "example": "The one and only"
                  },
                  {
                    "name": "ticket_downloads",
                    "kind": "optional",
                    "type": "integer",
                    "description": "",
                    "example": 2
                  },
                  {
                    "name": "ticket_fee",
                    "kind": "optional",
                    "type": "float",
                    "description": "",
                    "example": 1.99
                  },
                  {
                    "name": "ticket_link",
                    "kind": "optional",
                    "type": "string",
                    "description": "",
                    "example": "https://my.ticketpay.de/ticket/d74932836fabe97fe83746bbad880833/"
                  },
                  {
                    "name": "ticket_name",
                    "kind": "optional",
                    "type": "string",
                    "description": "",
                    "example": "Early Bird Ticket"
                  },
                  {
                    "name": "ticket_type",
                    "kind": "optional",
                    "type": "string",
                    "description": "",
                    "example": "print"
                  },
                  {
                    "name": "ticketnumber",
                    "kind": "optional",
                    "type": "string",
                    "description": "",
                    "example": "992LFU8HB"
                  },
                  {
                    "name": "vat_percentage",
                    "kind": "optional",
                    "type": "float",
                    "description": "",
                    "example": 0.19
                  },
                  {
                    "name": "zip",
                    "kind": "optional",
                    "type": "string",
                    "description": "",
                    "example": 59065
                  }
                ]
              }
            ],
            "modelRef": "#/components/schemas/get_tickets",
            "isExpanded": true
          }
        ]
      },
      {
        "statusCode": "401",
        "description": "Response for a failed authentification.",
        "jsonExample": "",
        "isExpanded": true,
        "schema": [
          {
            "kind": "optional",
            "type": "object",
            "description": "",
            "customType": "not_authorized",
            "schema": [
              {
                "name": "message",
                "kind": "optional",
                "type": "string",
                "description": "",
                "example": "Unauthorized"
              }
            ],
            "modelRef": "#/components/schemas/not_authorized",
            "isExpanded": true
          }
        ]
      }
    ],
    "hasXCodeSamples": false,
    "examples": {
      "languages": [
        {
          "id": "example-0-curl",
          "language": "curl",
          "label": "cURL",
          "code": "curl --request GET \\\n     --url https://tnapi.ticketpay.de/exports/tickets \\\n     --header 'accept: application/json' \\\n     --header 'authorization: string'"
        },
        {
          "id": "example-1-javascript",
          "language": "javascript",
          "label": "javascript",
          "code": "var myHeaders = new Headers();\nmyHeaders.append(\"accept\", \"application/json\");\nmyHeaders.append(\"content-type\", \"application/json\");\nmyHeaders.append(\"authorization\", \"string\");\n\nvar requestOptions = {\n   method: 'GET',\n   headers: myHeaders,\n   redirect: 'follow'\n};\n\nfetch(\"https://tnapi.ticketpay.de/exports/tickets\", requestOptions)\n   .then(response => response.text())\n   .then(result => console.log(result))\n   .catch(error => console.log('error', error));"
        },
        {
          "id": "example-2-ruby",
          "language": "ruby",
          "label": "Ruby",
          "code": "require \"uri\"\nrequire \"json\"\nrequire \"net/http\"\n\nurl = URI(\"https://tnapi.ticketpay.de/exports/tickets\")\n\nhttps = Net::HTTP.new(url.host, url.port)\nhttps.use_ssl = true\n\nrequest = Net::HTTP::Get.new(url)\nrequest[\"accept\"] = \"application/json\"\nrequest[\"content-type\"] = \"application/json\"\nrequest[\"authorization\"] = \"string\"\n\nresponse = https.request(request)\nputs response.read_body\n"
        },
        {
          "id": "example-3-python",
          "language": "python",
          "label": "Python",
          "code": "import requests\nimport json\n\nurl = \"https://tnapi.ticketpay.de/exports/tickets\"\n\npayload = {}\nheaders = {\n   'accept': 'application/json',\n   'content-type': 'application/json',\n   'authorization': 'string'\n}\n\nresponse = requests.request(\"GET\", url, headers=headers, data=payload)\n\nprint(response.text)\n"
        }
      ],
      "selectedLanguageId": "example-0-curl"
    },
    "results": {
      "languages": [
        {
          "id": "response-0-200",
          "language": "200",
          "code": "// Response for get tickets.\n{\n  \"total\": 157,\n  \"page\": 1,\n  \"size\": 157,\n  \"data\": [\n    {\n      \"id\": 6256520,\n      \"valid_from\": \"2023-07-28T20:00:00+02:00\",\n      \"valid_until\": \"2023-07-28T22:00:00+02:00\",\n      \"status\": \"approved\",\n      \"shop_id\": 14669,\n      \"created_iso\": \"2022-02-26T19:29:42+01:00\",\n      \"updated_iso\": \"2022-02-26T19:29:43+01:00\",\n      \"event_id\": 78001,\n      \"additional_fields\": [\n        {\n          \"show1\": true,\n          \"field1\": \"Startzeit\",\n          \"field1_val\": \"12:40\",\n          \"show2\": false,\n          \"field2\": \"\",\n          \"field2_val\": \"\"\n        }\n      ],\n      \"age\": 29,\n      \"barcode_value\": \"992LFU8HB\",\n      \"birthday\": \"05.12.1999\",\n      \"channel\": \"shop\",\n      \"checked_in\": false,\n      \"checked_out\": false,\n      \"city\": \"Hamm\",\n      \"country\": \"DE\",\n      \"ds_confirmation\": \"open\",\n      \"firstname\": \"Max\",\n      \"lastname\": \"Mustermann\",\n      \"gender\": \"m\",\n      \"has_questions\": true,\n      \"mail\": \"example@ticketpay.de\",\n      \"matching_id\": 1548851,\n      \"matching_required\": true,\n      \"newsletter\": true,\n      \"order_information\": \"Max Mustrmann,Neue Bahnhofstr. 1-3,DE 59065 Hamm\",\n      \"original_price\": 119,\n      \"paid\": true,\n      \"personalization_due\": \"2023-07-28T20:00:00+02:00\",\n      \"personalize\": true,\n      \"personalize_status\": \"not_necessary\",\n      \"price\": 100,\n      \"phone\": 238112345678,\n      \"qrcode_value\": \"992LFU8HB\",\n      \"questions_answered\": false,\n      \"questions_answers\": [\n        {}\n      ],\n      \"questions_count\": 0,\n      \"seat\": \"Reihe 2-Sitz 15\",\n      \"source_item_id\": 11708,\n      \"source_item_type\": \"EventTicket\",\n      \"shop_order_id\": 322333,\n      \"sso_user_id\": \"subject_21345rez113323\",\n      \"start_number\": 1250,\n      \"street\": \"Neue Bahnhofstr. 1-3\",\n      \"tags\": \"premium,early\",\n      \"team_id\": \"1324,\",\n      \"team_name\": \"The one and only\",\n      \"ticket_downloads\": 2,\n      \"ticket_fee\": 1.99,\n      \"ticket_link\": \"https://my.ticketpay.de/ticket/d74932836fabe97fe83746bbad880833/\",\n      \"ticket_name\": \"Early Bird Ticket\",\n      \"ticket_type\": \"print\",\n      \"ticketnumber\": \"992LFU8HB\",\n      \"vat_percentage\": 0.19,\n      \"zip\": 59065\n    }\n  ]\n}"
        },
        {
          "id": "response-1-401",
          "language": "401",
          "code": "// Response for a failed authentification.\n{\n  \"message\": \"Unauthorized\"\n}"
        }
      ],
      "selectedLanguageId": "response-0-200"
    }
  },
  "children": [
    {
      "text": ""
    }
  ]
}