This article aims to guide you through the setup of your review retrieval flow by providing clear instructions on the steps to follow.
It also explains in detail the technical terms you may encounter while managing this process, enabling you to better understand them.
Operation
Reviews collected are transferred every night at 3 am to the FTP/SFTP server of your choice in CSV or XML format.
You have the possibility to configure the retrieval flow at any time within your Back Office (Display reviews → Retrieve my reviews → Data feed management), the identifiers of which will remain confidential.
If necessary, we can also create an FTP/SFTP account on our servers, feel free to contact us.
Setting up a flow
Here are the values to fill in:
| Format | We offer two formats: CSV and XML: The rest of this article will detail each of these formats. |
| Transfer Method | We provide two file transfer methods: FTP and SFTP. Please note, adjust the Port according to your server. |
| Server | Specify the IP address or host to which we will connect. |
| Identifier | Connection identifier to your FTP/SFTP server (we must have writing rights). |
| Password | Access password to your FTP/SFTP account. |
| Port | Communication port of your FTP/SFTP server. |
| Directory Path | Path where we will deposit your files. |
By configuring this side, you need to choose the right type of data feed:
Is it a review site FTP flow, product review, deliverability, or an unsubscribed user.
Remember to activate the data feed :
You can then:
- Test the connection »: Immediately test whether we can connect to your FTP/SFTP account.
- «Test the reviews feed »: Immediately send a data feed to the FTP/SFTP (daily or full).
Interpreting an action NEW, DELETE, UPDATE
Each line of the FTP/SFTP file or XML node, of the retrieved review files, has a type indicating the action that was performed within the database of your Avis Vérifiés account:
|
NEW |
New review published, you must add this review to your database |
| UPDATE |
The review has been modified, all review data (buyer's personal data, review, responses to the review) must be updated, for example, a response has been provided to the review by the store or the customer ★ If the consumer requests the anonymization of his personal data, the information will be replaced by Anonymous |
| DELETE | The review has been definitively rejected, you must remove this review from your database |
- An example of a CSV file (converted to Excel):
The "Update" action is related to an update made to a review collected on the platform.
This could be due to a request from the author to hide their identity, or to anonymize a review, as we do not retain personal data beyond 18 months.
The "New" action means that a new review has been submitted on the platform and has been set to "published" status.
- An example of an XML file:
File Formats
- CSV
- Encoding: UTF8 without BOM
- Separator: ";" (semicolon separator)
- XML
- Encoding: UTF8 without BOM
Find examples of downloadable files below:
File Naming
Files are named following the following format:
- Brand review: reviews_type_<idWebsite>_<date>.<file_type>
- Product review: reviews_product_<idWebsite>_<date>.<file_type>
| Field | Value |
|---|---|
| Type |
Nature of content Example: site or product |
|
IdWebsite |
Technical identifier designated by an alphanumeric code |
| Date |
Date format Example: 2020-01-01 |
| File_type |
File format |