Import Excel File

In the Passenger List Management section, users have the option to upload an Excel file to import passenger data directly into the system.

In the Passenger List Management section, users have the option to upload an Excel file to import passenger data directly into the system. This feature simplifies the process of entering passenger information by allowing bulk data import in a single step. To use this functionality, click on the "Upload Excel" button and select the Excel file containing your passenger list. Ensure that the file is properly formatted, with columns for passenger details such as name, surname, date of birth, country of birth, nationality, and other relevant information. For your convenience, an example Excel file is attached below, illustrating the required format. By following this template, you can ensure a smooth and accurate data import process.

Import from Excel File: To simplify the passenger entry process, the broker has the option to import the entire list by uploading a correctly formatted Excel file. The Excel file must contain passenger data with the required fields, such as name, surname, date of birth, country of birth, nationality, and other relevant data as described above. The flight detail page provides the broker with all the necessary information to effectively manage and monitor the flight and associated passengers, ensuring an efficient and secure experience during the booking and flight management process.

10KB

example.xlsx

Open

Below an CURL Example

// Some code
url --location --request POST 'https://broker.mydomain.belevensoftware.com/api/broker/v0/upload/29000' \
--header 'Authorization: Bearer <token> form 'paxlist=@"example.xlsx"'

Than, the server answere

[
    {
        "id": null,
        "idvolo": 30617,
        "surname": "ROSSI",
        "name": "MARIO",
        "luogonascita": "IT",
        "nazionalita": "IT",
        "typedoc": "P",
        "numberdoc": "CA1234567",
        "date_born": "1988-04-06",
        "scadenza": "2033-04-06",
        "issuingstate": "IT",
        "email": "[email protected]",
        "phone": "[phone]",
        "is_carring_infant": true,
        "gender": "M",
        "parent_id": null,
        "row_number_parent_id": null,
        "row_number": 1
    },
    {
        "id": null,
        "idvolo": 30617,
        "surname": "BIANCHI",
        "name": "MARIA",
        "luogonascita": "IT",
        "nazionalita": "IT",
        "typedoc": "P",
        "numberdoc": "YB1234567",
        "date_born": "1983-05-09",
        "scadenza": "2030-05-03",
        "issuingstate": "IT",
        "email": "[email protected]",
        "phone": "[phone]",
        "is_carring_infant": false,
        "gender": "F",
        "parent_id": null,
        "row_number_parent_id": null,
        "row_number": 2
    },
    {
        "id": null,
        "idvolo": 30617,
        "surname": "ROSSI",
        "name": "LUCA",
        "luogonascita": "IT",
        "nazionalita": "IT",
        "typedoc": "I",
        "numberdoc": "YA5009569",
        "date_born": "2024-01-01",
        "scadenza": "2023-09-28",
        "issuingstate": "IT",
        "email": null,
        "phone": null,
        "is_carring_infant": false,
        "gender": "I",
        "parent_id": null,
        "row_number_parent_id": 2,
        "row_number": 3
    }
]