行程 Feed

行程 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 行程中特定行程的唯一航行标识符,包含开始日期和结束日期。

例如,对于 5 晚 3 个停靠点的行程,sail_id 是唯一的,并且对于所有 3 个停靠点都保持不变。sail_id 的一个示例为 ABC12345

注意sail_idstop_index 会串联起来形成复合主键,并且必须是唯一的。

stop_index Required integer 邮轮行程中每个经停点的唯一编号标识符。第一个经停点的索引为零,以此类推。零代表第一个出发港。例如,stop_index 表示为 0

注意sail_idstop_index 会串联起来形成复合主键,并且必须是唯一的。

port_of_call Required string 包含邮轮停靠城市名称和国家/地区的位置。 例如,port_of_call 可以表示为 Venice,Italy

明确指出不需要英文引号 (")。

itinerary_desc Required string 行程说明。以“X 晚”开头,其中 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 相同。它表示为 XYZ12345

latitude Optional decimal 此停靠港的纬度。应采用 WGS84 表示法指定。这些信息对于精确定位调用实体的端口非常有用。例如,意大利特里斯特的纬度坐标为 45.64665541364354。不支持以下内容:
  • 东京
  • GCJ-02
longitude Optional decimal 此停靠港的经度。应采用 WGS84 表示法指定。这些信息对于精确定位调用实体的端口非常有用。例如,意大利的里雅斯特的 longitude 坐标为 13.76188003458354。不支持以下内容:
  • 东京
  • GCJ-02
image_url Optional URL 表示停靠港的图片的网址。例如 https://partner.com/images/XXXXX.jpg
updated_at Optional datetime 此条目上次更新的日期和时间(采用世界协调时间 [UTC])。这些信息有助于识别过时数据。应采用 ISO 8601 格式。例如,updated_at2025-01-22T00:00:00+00:00

示例

以下是两个航程的行程 Feed 的基本示例,其中一个航程是单程,另一个航程是往返。

示例同时显示了 CSVJSON 格式。sail_idstop_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"
  }
]