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 UTF8. 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 |
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 6391 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 UTF8. 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 |
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 6391 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 |