Start Mapping by SFTP Folder

Triggers the hotel mapping process for provider content files uploaded to the SFTP server. Follow the steps below to prepare, upload, and initiate mapping.

Step 1: Prepare Hotel Content Files

Download content template

Requirements:

File extension must be .csv

Create a separate file for each provider

Column names must match the template exactly (case-sensitive)

Do not include invalid values such as NULL, null, or whitespace

Template columns:

| Column | Required | Description | |--------|----------|-------------| | SupplierName | Yes | Provider name from the master list | | SupplierHotelId | Yes | Property ID from the provider | | HotelName | Yes | Property name | | Line1 | Yes | Address line 1 | | Line2 | No | Address line 2 | | CityName | Yes | City name | | CityCode | No | City/location code | | StateName | No | State name | | StateCode | No | State code | | ZipCode | Yes | Postal/zip code | | CountryName | Conditional | Country name (either CountryName or CountryCode is required) | | CountryCode | Conditional | ISO country code (either CountryName or CountryCode is required) | | StarRating | Yes | Star rating | | Lat | Yes | Latitude | | Long | Yes | Longitude | | ChainCode | No | Hotel chain code | | Phones | No | Phone numbers | | Fax | No | Fax number | | Email | No | Email address | | Website | No | Official website URL | | PropertyType | No | Property type (e.g., Hotel, Motel, Resort, Villa) |

Step 2: Upload Files to SFTP

2.1 Connect to the SFTP server using any SFTP client. Retrieve credentials from the Vervotech client portal under Load Provider Content.

2.2 Create the directory structure at the SFTP root:

[FTP Root]/[DATE]/[ProviderName]/[ProviderKey]

| Component | Format | Description | |-----------|--------|-------------| | DATE | DDMMYYYY | Upload date | | ProviderName | String | Provider name from the master list. Contact Vervotech Support if not listed. | | ProviderKey | String | Provider key from the Vervotech client portal under Manage Your Providers. |

2.3 Upload one CSV file per folder (recommended). Example paths:

18122022/HotelBeds/accountId__accountId__HotelBeds/HotelBedsProperties.csv 18122022/Priceline/accountId__accountId__Priceline/PricelineProperties.csv 18122022/EAN/accountId__accountId__EAN/EANProperties.csv

Step 3: Trigger Mapping via Client Portal

Navigate to Load Provider Content.

Enter the full SFTP folder path and click Start Mapping.

A unique RunId is generated for each file. Wait for processing to complete before uploading new files.

Step 4: Monitor Progress

Check mapping progress under Providers Content Processing in the client portal using the RunId.

Step 5: Trigger Mapping via API

Automate the workflow programmatically:

Upload files using an SFTP client.

Call this API with the SFTP folder path as input.

The response includes a RunId for tracking progress.

curl --location --request GET 'https://hotelmapping.vervotech.com/api/3.0/mappings/StartMappingByFtpFolder?templateType=Vervotech_Template&folderName=18122019/HotelBeds/johndoe__johndoe__HotelBeds' \ --header 'apikey: 056ec4c3-be6b-4c36-a4cc-a403ce9592a1' \ --header 'accountId: DemoAccount'

{ "Status": true, "Message": "Success", "RunId": "rc1234-3232-5657", "MappingStats": [ { "RunId": "f676e8a6-00b4-4231-8a1a-5a19d290837d", "MissingCountryCodes": 0, "MissingGeoCodes": 0, "MissingHotelChains": 0, "MissingPhones": 0, "MissingStarRatings": 0, "MissingZipCodes": 0, "MissingCity": 0, "MissingFax": 0, "MissingName": 0, "MissingState": 0, "MissingAddress": 0, "PublishCount": 0, "TotalProviderCount": 0, "StorageFilePath": "11092022/MGHoliday/via__via__MGHoliday/MGHoliday.csv", "ValidationMessage": "File format is Valid. Hotel count 269076.", "StartDate": "2022-09-12T10:03:57.134Z", "EndDate": "2022-09-12T11:30:07.219Z", "WorkFlowType": "FTPDownloader", "DownloadStats": [ { "status": "None", "runId": "string", "language": "string", "clientCode": "string", "originalFileName": "string", "fileType": "string", "fileUploadUrl": "string", "resultDownloadUrl": "string", "estimatedCompletionTime": "string", "workFlowType": "string", "totalProviderCount": 0, "disabledCount": 0, "recycledCount": 0, "newCount": 0, "downloadedHotelsCount": 0, "newlyMappedCount": 0, "matchCount": 0, "updateCount": 0, "suspectCount": 0, "recycleSuspectCount": 0, "recycleMappedCount": 0, "preSuspectCount": null, "publishCount": 0, "startDate": "2019-08-24T14:15:22.123Z", "endDate": "2019-08-24T14:15:22.123Z", "lastUpdatedDateTime": "2019-08-24T14:15:22.123Z", "contentDownloadFinishedOn": "2019-08-24T14:15:22.123Z", "propertiesCreditsUsed": 0, "missingAddress": 0, "missingZipCodes": 0, "missingPhones": 0, "missingGeoCodes": 0, "missingCountryCodes": 0, "missingHotelChains": 0, "missingChainCodes": 0, "missingChainNames": 0, "missingStarRatings": 0, "missingCity": 0, "missingFax": 0, "missingName": 0, "missingState": 0, "missingPropertyType": 0, "missingLat": 0, "missingLong": 0, "uniqueProperties": 0, "isHotelDisablerCompleted": true, "hotelDisablerStatus": "string", "invalidHotels": 0, "testProperties": 0, "inValidHotelNamesFormat": 0, "inValidAddressFormat": 0, "key": "string", "providerFamily": "string", "isExclusiveDownloader": true, "isScheduledDownloader": true } ], "Status": "None" } ], "StatusCode": 2000 }

Start Mapping by SFTP Folder

Step 1: Prepare Hotel Content Files

Step 2: Upload Files to SFTP

Step 3: Trigger Mapping via Client Portal

Step 4: Monitor Progress

Step 5: Trigger Mapping via API

Request

Responses

Start Mapping by SFTP Folder

Step 1: Prepare Hotel Content Files#

Step 2: Upload Files to SFTP#

Step 3: Trigger Mapping via Client Portal#

Step 4: Monitor Progress#

Step 5: Trigger Mapping via API#

Request

Responses

Step 1: Prepare Hotel Content Files

Step 2: Upload Files to SFTP

Step 3: Trigger Mapping via Client Portal

Step 4: Monitor Progress

Step 5: Trigger Mapping via API