行程 Feed 包含邮轮航程信息。每个行程都包含一组旅程。每次行程都包含行程的详细信息,例如港口、到达和出发时间及日期、行程每个阶段的航行时长以及每次行程的说明。您可以上传 CSV 格式的行程 Feed。
关键组件
行程 Feed 包含不区分大小写的必填字段。有些字段是选填字段,可以留空。发送可选数据有助于提高数据质量。
它包含以下必填字段:
sail_id:特定行程的唯一航行标识符。stop_index:每个出发港口的唯一停靠站标识符。port_of_call:邮轮停靠的港口或地点。itinerary_desc:行程的说明。arrival_dt:港口的到达日期和时间(采用世界协调时间 [UTC])。departure_dt:港口的出发日期和时间(世界协调时间 [UTC])。ship_name:船只的名称。sail_duration:航行天数或时长。
字段
下表介绍了行程 Feed 中的所有可用字段:
| 字段名称 | 是否必需? | 类型 | 说明 |
|---|---|---|---|
| sail_id | Required | string | 行程中特定旅程的唯一航程标识符,包含开始日期和结束日期。
例如,对于包含 3 个停靠站的 5 晚行程, 注意: |
| stop_index | Required | integer | 邮轮行程中每个停靠站的唯一索引标识符。第一个停靠站的索引从零开始。0 表示第一个出发港口。例如,stop_index 表示为 0。
注意: |
| port_of_call | Required | string | 邮轮停靠的城市名称和国家/地区。
例如,port_of_call 可以表示为 Venice,Italy。
明确不需要使用英文引号 ( |
| itinerary_desc | Required | string | 行程的说明。它以“X-night”开头,其中 X 是行程中的晚数。不区分大小写。
例如,itinerary_desc 可以是 7-night greek isles & eastern med。 |
| arrival_dt | Required | datetime | 港口的到达日期和时间(以世界协调时间 [UTC] 表示)。第一个端口的 arrival_dt 必须为空,并且 stop_index 必须为零。
例如,arrival_dt 表示为 2025-01-22T06:00:00+01:00。 |
| departure_dt | Required | datetime | 港口的出发日期和时间(以世界协调时间 [UTC] 为准)。最后一个端口的 departure_dt 必须为空。stop_index 必须是行程的最后一晚。
例如,departure_dt 表示为 2025-01-23T18:00:00+01:00。 |
| ship_name | Required | string | 船只的名称。不区分大小写。
例如,ship_name 可以表示为 NORWEGIAN Escape。 |
| sail_duration | Required | integer | 航程时长或航行夜数。
例如,对于 5 个航行之夜,sail_duration 表示为 5。 |
| itinerary_id | Required | string | 标识行程。itinerary_id 用于区分不同的行程。访问相同停靠港的所有行程都具有相同的 itinerary_id,从而可以对行程进行分组和整理。
例如,如果两个不同行程的停靠港都是旧金山,则这两个行程的行程 ID 相同。它表示为 |
| latitude | Optional | decimal | 此停靠港的纬度。应以
WGS84 表示法指定。此信息有助于精确定位港口实体。例如,意大利的里雅斯特的纬度坐标为 45.64665541364354。以下内容不受支持:
|
| longitude | Optional | decimal | 此停靠港的经度。应采用
WGS84 表示法指定。此信息有助于精确定位港口实体。例如,意大利的里雅斯特的经度坐标为 13.76188003458354。以下内容不受支持:
|
| image_url | Optional | URL | 代表停靠港口的图片的网址。例如 https://partner.com/images/XXXXX.jpg |
| updated_at | Optional | datetime | 相应条目上次更新的日期和时间(世界协调时间 [UTC])。此信息有助于识别过时的数据。该值应遵循
ISO 8601 格式。例如,updated_at 为 2025-01-22T00:00:00+00:00。 |
示例
以下是一个行程 Feed 的基本示例,其中包含两次航程,一次是单程,另一次是往返。
示例中同时显示了 CSV 和 JSON 格式。sail_id、stop_index 字段会串联起来以形成复合主键,并且对于每一行都必须是唯一的。
CSV
单程(必需)
第一个航程或行程是从旧金山到加拿大的单程 4 晚行程。以下示例仅展示了必填字段:
sail_id; stop_index; port_of_call; itinerary_desc; arrival_dt; departure_dt;ship_name;sail_duration;itinerary_id
54321; 0; Seattle, Washington; 4 Night Alaska Cruise Trip; NULL;2025-05-23 15:00:00; Floating Home; 04; 888888
54321; 1; Ketchikan, Alaska; 4 Night Alaska Cruise Trip;2025-05-25 18:00:00; 2025-05-25 7:00:00; Floating Home; 04; 888888
54321; 2; Vancouver (Canada Place), British Columbia;4 Night Alaska Cruise Trip; 2025-05-27 7:30:00; NULL; Floating Home; 04; 888888
单程(全部)
以下示例展示了单程旅行的所有可用字段:
sail_id; stop_index; port_of_call; itinerary_desc; arrival_dt; departure_dt; ship_name;sail_duration; itinerary_id; latitude; longitude; image_url; updated_at
54321; 0; Seattle, Washington; 4 Night Alaska Cruise Trip; NULL; 2025-05-23 15:00:00; Floating Home;04; 888888; 47.608013; -122.335167; https://partner.com/images/XXXXX.jpg; 2025-05-23T00:00:00+00:00
54321; 1; Ketchikan, Alaska; 4 Night Alaska Cruise Trip; 2025-05-25 18:00:00; 2025-05-25 7:00:00;Floating Home; 04; 888888; 55.341808; -131.647507; https://partner.com/images/XXXXX.jpg; 2025-05-25T00:00:00+00:00
54321; 2; Vancouver (Canada Place), British Columbia; 4 Night Alaska Cruise Trip; 2025-05-27 7:30:00; NULL; Floating Home; 04; 888888; 49.246292; -123.116226; https://partner.com/images/XXXXX.jpg; 2025-05-27T00:00:00+00:00
往返(必需)
第二趟航程是从旧金山出发的往返航程,为期 14 晚,途经阿拉斯加和加拿大。以下示例仅展示了必填字段:
sail_id; stop_index; port_of_call; itinerary_desc; arrival_dt; departure_dt; ship_name;sail_duration; itinerary_id
12345; 0; San Francisco, California; 14 Night Alaska Cruise with Glacier Bay National Park; NULL;2025-06-06 16:00:00; Beautiful Ship; 14; 888888
12345; 1; Ketchikan, Alaska; 14 Night Alaska Cruise with Glacier Bay National Park; 2025-06-09 21:00:00; 2025-06-10 5:00:00; Beautiful Ship; 14; 888888
12345; 2; Vancouver (Canada Place), British Columbia; 14 Night Alaska Cruise with Glacier Bay National Park; 2025-06-13 14:00:00; 2025-06-14 20:00:00; Beautiful Ship; 14; 888888
12345; 3; Victoria, British Columbia; 14 Night Alaska Cruise with Glacier Bay National Park 2025-06-15 21:00:00; 2025-06-16 6:00:00; Beautiful Ship; 14; 888888
12345; 4; San Francisco, California; 14 Night Alaska Cruise with Glacier Bay National Park 2025-06-20 7:00:00; NULL; Beautiful Ship; 14; 888888
往返(全部)
以下示例展示了往返行程的所有可用字段:
sail_id; stop_index; port_of_call; itinerary_desc; arrival_dt; departure_dt; ship_name; sail_duration; itinerary_id; latitude; longitude; image_url; updated_at
12345; 0; San Francisco, California; 14 Night Alaska Cruise with Glacier Bay National Park; NULL; 2025-06-06 16:00:00; Beautiful Ship; 14; 888888; 37.773972; -122.431297; https://partner.com/images/XXXXX.jpg; 2025-06-06T00:00:00+00:00
12345; 1; Ketchikan, Alaska; 14 Night Alaska Cruise with Glacier Bay National Park; 2025-06-09 21:00:00; 2025-06-10 5:00:00; Beautiful Ship; 14; 888888; 55.341808; -131.647507; https://partner.com/images/XXXXX.jpg; 2025-06-09T00:00:00+00:00
12345; 2; Vancouver (Canada Place), British Columbia; 14 Night Alaska Cruise with Glacier Bay National Park; 2025-06-13 14:00:00; 2025-06-14 20:00:00; Beautiful Ship; 14; 888888; 49.246292; -123.116226; https://partner.com/images/XXXXX.jpg; 2025-06-13T00:00:00+00:00
12345; 3; Victoria, British Columbia; 14 Night Alaska Cruise with Glacier Bay National Park; 2025-06-15 21:00:00; 2025-06-16 6:00:00; Beautiful Ship; 14; 888888; 48.407326; -123.329773; https://partner.com/images/XXXXX.jpg; 2025-06-15T00:00:00+00:00
12345; 4; San Francisco, California; 14 Night Alaska Cruise with Glacier Bay National Park;2025-06-20 7:00:00; NULL; Beautiful Ship; 14; 888888; 37.773972; -122.431297; https://partner.com/images/XXXXX.jpg; 2025-06-20T00:00:00+00:00
JSON(仅供参考)
单程(必需)
第一个航程或行程是从旧金山到加拿大的单程 4 晚行程。以下示例仅展示了必填字段:
[
{
"sail_id": "54321",
"stop_index": "0",
"port_of_call": "Seattle, Washington",
"itinerary_desc": "4 Night Alaska Cruise Trip",
"arrival_dt": null,
"departure_dt": "2025-05-23 15:00:00",
"ship_name": "Floating Home",
"sail_duration": 4,
"itinerary_id": "888888"
},
---
{
"sail_id": "54321",
"stop_index": "2",
"port_of_call": "Vancouver (Canada Place), British Columbia",
"itinerary_desc": "4 Night Alaska Cruise Trip",
"arrival_dt": "2025-05-27 7:30:00",
"departure_dt": null,
"ship_name": "Floating Home",
"sail_duration": 4,
"itinerary_id": "888888"
}
]
单程(全部)
以下示例展示了单程旅行的所有可用字段:
[
{
"sail_id": "54321",
"stop_index": "0",
"port_of_call": "Seattle, Washington",
"itinerary_desc": "4 Night Alaska Cruise Trip",
"arrival_dt": "2025-05-23 15:00:00",
"departure_dt": null,
"ship_name": "Floating Home",
"sail_duration": 4,
"itinerary_id": "888888",
"latitude": "47.608013",
"longitude": "-122.335167",
"image_url": "https://partner.com/images/XXXXX.jpg",
"updated_at": "2025-05-23T00:00:00+00:00"
},
---
{
"sail_id": "54321",
"stop_index": "2",
"port_of_call": "Vancouver (Canada Place), British Columbia",
"itinerary_desc": "4 Night Alaska Cruise Trip",
"arrival_dt": null,
"departure_dt": "2025-05-27 7:30:00",
"ship_name": "Floating Home",
"sail_duration": 4,
"itinerary_id": "888888",
"latitude": "49.246292",
"longitude": "-123.116226",
"image_url": "https://partner.com/images/XXXXX.jpg",
"updated_at": "2025-05-27T00:00:00+00:00"
}
]
往返(必需)
第二趟航程是从旧金山出发的往返航程,为期 14 晚,途经阿拉斯加和加拿大。以下示例仅展示了必填字段:
[
{
"sail_id": "12345",
"stop_index": "0",
"port_of_call": "San Francisco, California",
"itinerary_desc": "14 Night Alaska Cruise with Glacier Bay National Park",
"arrival_dt": null,
"departure_dt": "2025-06-06 16:00:00",
"ship_name": "Beautiful Ship",
"sail_duration": 14,
"itinerary_id": "888888"
},
{
"sail_id": "12345",
"stop_index": "1",
"port_of_call": "Ketchikan, Alaska",
"itinerary_desc": "14 Night Alaska Cruise with Glacier Bay National Park",
"arrival_dt": "2025-06-09 21:00:00",
"departure_dt": "2025-06-10 5:00:00",
"ship_name": "Beautiful Ship",
"sail_duration": 14,
"itinerary_id": "888888"
},
---
{
"sail_id": "12345",
"stop_index": "4",
"port_of_call": "San Francisco, California",
"itinerary_desc": "14 Night Alaska Cruise with Glacier Bay National Park",
"arrival_dt": "2025-06-20 7:00:00",
"departure_dt": null,
"ship_name": "Beautiful Ship",
"sail_duration": 14,
"itinerary_id": "888888"
}
]
往返(全部)
以下示例展示了往返行程的所有可用字段:
[
{
"sail_id": "12345",
"stop_index": "0",
"port_of_call": "San Francisco, California",
"itinerary_desc": "14 Night Alaska Cruise with Glacier Bay National Park",
"arrival_dt": null,
"departure_dt": "2025-06-06 16:00:00",
"ship_name": "Beautiful Ship",
"sail_duration": 14,
"itinerary_id": "888888",
"latitude": "37.773972",
"longitude": "-122.335167",
"image_url": "https://partner.com/images/XXXXX.jpg",
"updated_at": "2025-06-06T00:00:00+00:00"
},
{
"sail_id": "12345",
"stop_index": "1",
"port_of_call": "Ketchikan, Alaska",
"itinerary_desc": "14 Night Alaska Cruise with Glacier Bay National Park",
"arrival_dt": "2025-06-09 21:00:00",
"departure_dt": "2025-06-10 5:00:00",
"ship_name": "Beautiful Ship",
"sail_duration": 14,
"itinerary_id": "888888",
"latitude": "55.341808",
"longitude": "-131.647507",
"image_url": "https://partner.com/images/XXXXX.jpg",
"updated_at": "2025-06-09T00:00:00+00:00"
},
---
{
"sail_id": "12345",
"stop_index": "4",
"port_of_call": "San Francisco, California",
"itinerary_desc": "14 Night Alaska Cruise with Glacier Bay National Park",
"arrival_dt": "2025-06-20 7:00:00",
"departure_dt": null,
"ship_name": "Beautiful Ship",
"sail_duration": 14,
"itinerary_id": "888888",
"latitude": "37.773972",
"longitude": "-122.431297",
"image_url": "https://partner.com/images/XXXXX.jpg",
"updated_at": "2025-06-20T00:00:00+00:00"
}
]