Data types

  • The provided content outlines the specific data structure and formatting requirements for integrating cruise itineraries and prices into Google's Cruises search.

  • It details the required data types for field names in the CSV, including currency (ISO 4217), date (ISO 8601 YYYY-MM-DD), and datetime (ISO 8601 with UTC offset).

  • Other specified data types include decimal (dot-separated fractional part), integer, location (comma-separated City, State, Country), string (with handling for semicolons and escaped double quotes), and url (RFC 3986 format).

The section specifies the data structure and formatting requirements for integrating cruise itineraries and prices into Google's Cruises search. The field names in the CSV should have the following data types for each fields as needed:

Type name Description
currency A three-letter currency code in ISO 4217.

Example: USD, AUD, CAD
date Date in ISO 8601 format specified as YYYY-MM-DD.

Example: 2025-01-22
datetime Date and time in ISO 8601 format. Time format is in the Coordinated Universal time (UTC) specified as YYYY-MM-DDTHH:mm[:ss.SSS]+|-HH:mm[Z].

Example: Time format for 6AM in Venice should be formatted as follows: 2025-01-22T06:00:00+01:00

decimal A decimal value with a fractional part separated by a dot (.)

Example: 100.30
integer An integral decimal number.

Example: 123
location Comma separated list describing the location like City, State, Country.

Example: "San Francisco,California,USA" or "Venice,Italy"
string

It can be the following types:

  • A basic string of characters.

    Example: Abc123

  • Strings with Semicolon must be quoted. ";".

    Example: "strings with ; semicolon"

  • Strings with double quotes must be escaped. \".

    Example: "String with escaped double quotes\"
url An absolute URL in the RFC 3986 format.

Example: https://partner.com/path.html?param=1