行程動態饋給

行程動態饋給包含郵輪航行資訊。每個行程都有一組行程。每趟行程都包含詳細資料,例如港口、抵達和出發時間與日期、旅程各階段的航行時間,以及每趟行程的說明。你可以上傳 CSV 格式的行程動態饋給。

重要元件

行程動態饋給含有不區分大小寫的必填欄位。部分欄位為選填,可以留空。傳送選用資料可提升資料品質。

其中包含下列必填欄位:

  • sail_id:特定行程的專屬航行 ID。
  • stop_index:每個出發港口的專屬停靠站 ID。

  • port_of_call:停靠港或郵輪停靠地點。

  • itinerary_desc:行程說明。

  • arrival_dt:抵達港口的日期和時間(世界標準時間)。

  • departure_dt:港口的起航日期和時間 (世界標準時間)。

  • ship_name:船隻名稱。

  • sail_duration:航行天數或時長。

欄位

下表說明行程動態饋給中所有可用的欄位:

欄位名稱 是否必要? 類型 說明
sail_id Required string 行程中特定行程的專屬航行 ID,包含開始和結束日期。

舉例來說,如果行程為 5 晚,且有 3 個停靠點,則 sail_id 是不重複的,且 3 個停靠點都相同。sail_id 的範例為 ABC12345

注意: sail_idstop_index 會串連形成複合主鍵,且必須是唯一值。

stop_index Required integer 郵輪行程中每個停靠站的專屬索引 ID。第一個停靠站的索引為零。零代表第一個出發港口。舉例來說,stop_index 會以 0 表示。

注意: sail_idstop_index 會串連形成複合主鍵,且必須是唯一值。

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 相同。以 XYZ12345 表示。

latitude Optional decimal 這個停靠港的緯度。應以 WGS84 標記法指定。這項資訊有助於精確找出攜碼實體的號碼。舉例來說,義大利的里雅斯特的緯度座標為 45.64665541364354。以下是不支援的項目:
  • 東京
  • GCJ-02
longitude Optional decimal 這個停靠港的經度。應以 WGS84 標記法指定。這項資訊有助於精確找出攜碼實體的號碼。舉例來說,義大利的里雅斯特的經度座標為 13.76188003458354。以下是不支援的項目:
  • 東京
  • GCJ-02
image_url Optional URL 代表停靠港的圖片網址。例如:https://partner.com/images/XXXXX.jpg
updated_at Optional datetime 這個項目上次更新的日期和時間(世界標準時間)。這項資訊有助於識別過時資料。請遵守 ISO 8601 格式。例如,updated_at2025-01-22T00:00:00+00:00

範例

以下是兩個航程的行程動態饋給基本範例,其中一個航程是單程,另一個是來回行程。

範例會顯示 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"
  }
]