Visits Feed

File format ­ version 1

The TrustYou feed file format is a CSV without header line. The columns are separated by semicolon (;). The values don’t have quotation marks. The file encoding is UTF­8. There are following columns expected:

Column Name Column Description Required
HOTEL_ID Identifier of a hotel; It can be customer specific or TY cluster id; for customer specific identifiers we will have a mapping implemented; the identifier has to be unique within a group of hotels assigned to a single customer. Yes
EMAIL Hotel guest email Yes
FIRST_NAME Hotel guest first name No
LAST_NAME Hotel guest last name No
ARRIVAL_DATE Arrival date in ISO 8601 format No
DEPARTURE_DATE Departure date in ISO 8601 format No
LANG Language for the survey form in ISO 639­1 format.; Customer default language will be used if not specified No
PROFILE_ID An external identifier of the guest that can be used to query TrustYou Survey API and associate submitted reviews with the guest No
VISIT_ID An external identifier of the visit that can be used to query TrustYou Survey API and associate submitted review with the visit No

File format ­ version 2

The TrustYou visits feed file format version 2.0 is a CSV with the following header line: TRUSTYOU VISITS FEED V2.0

Immediately after the header line comes content. The content columns are separated by semicolon (;). The values don’t have quotation marks. The file encoding is UTF­8. There are following columns expected:

Column Name Column Description Required
HOTEL_ID Identifier of a hotel; It can be customer specific or TY cluster id; for customer specific identifiers we will have a mapping implemented; the identifier has to be unique within a group of hotels assigned to a single customer. Yes
SURVEY_ID Identifier of a survey we want to assign the visits to. If not specified, default hotel survey of a hotel will be used. No
EMAIL Hotel guest email Yes
FIRST_NAME Hotel guest first name No
LAST_NAME Hotel guest last name No
ARRIVAL_DATE Arrival date in ISO 8601 format No
DEPARTURE_DATE Departure date in ISO 8601 format No
LANG Language for the survey form in ISO 639­1 format.; Customer default language will be used if not specified No
PROFILE_ID An external identifier of the guest that can be used to query TrustYou Survey API and associate submitted reviews with the guest No
VISIT_ID An external identifier of the visit that can be used to query TrustYou Survey API and associate submitted review with the visit No