行程動態饋給

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

重要元件

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

其中包含下列必填欄位:

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

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

  • itinerary_desc:行程說明。

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

  • departure_dt:航班的出發日期和時間,以港口所在地的世界標準時間 (UTC) 為準。

  • 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 標記法指定。這項資訊可用於精確找出呼叫實體的連接埠。舉例來說,義大利的里雅斯特 (Trieste) 經度座標為 45.64665541364354。以下項目不支援:
  • TOKYO
  • GCJ-02
longitude Optional decimal 這個呼叫端口的經度。應使用 WGS84 標記法指定。這項資訊可用於精確找出呼叫實體的連接埠。舉例來說,義大利 Trieste 的經度座標為 13.76188003458354。以下項目不支援:
  • TOKYO
  • 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

範例

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

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