How to send your flight content to CitizenPlane using our SFTP server.
Your tech contact will give you credentials to connect to our SFTP server. General information are:
Host: airdrop.citizenplane.com
Protocol: sftp
Port: 22
Path: /flight-ingest
If you're using your own file format, please send us an example of a cache file you're currently using in production.
Our team will then develop a custom parsing function to process your file.
If you don't currently have a file format used in production, we recommend that you follow our own format, so we won't have to add a new custom parsing function to process your file.
CitizenPlane's file format uses csv. There are no naming convention regarding the name of the file you upload. However, do not use filenames with spaces.
The format of the csv should follow the example below:
segment_1_origin_airport,segment_1_origin_terminal_airport,segment_1_date_local_takeoff,segment_1_hours_local_takeoff,segment_1_destination_airport,segment_1_destination_terminal_airport,segment_1_date_local_landing,segment_1_hours_local_landing,segment_1_via_airport,segment_1_airline,segment_1_flight_number,segment_2_origin_airport,segment_2_origin_terminal_airport,segment_2_date_local_takeoff,segment_2_hours_local_takeoff,segment_2_destination_airport,segment_2_destination_terminal_airport,segment_2_date_local_landing,segment_2_hours_local_landing,segment_2_via_airport,segment_2_airline,segment_2_flight_number,segment_3_origin_airport,segment_3_origin_terminal_airport,segment_3_date_local_takeoff,segment_3_hours_local_takeoff,segment_3_destination_airport,segment_3_destination_terminal_airport,segment_3_date_local_landing,segment_3_hours_local_landing,segment_3_via_airport,segment_3_airline,segment_3_flight_number,luggage_options,available_seats,price,outward_price,return_price,infant_price,need_apis,end_selling_date
CDG,,2032-04-27,18:40,PMI,,2032-04-27,21:55,,AF,775,,,,,,,,,,,,,,,,,,,,,,,1-20-0,9,75.88,70,70,TRUE,48
CDG,,2032-04-27,17:15,AMS,,2032-04-27,18:15,,AF,783,AMS,,2032-04-27,19:30,BER,,2032-04-27,22:00,,AF,784,,,,,,,,,,,,1-20-0,9,105,100,100,TRUE,48