L'API Feedier vous permet d'importer un volume plus important (> 2 000 feedback) que le module d'importation du tableau de bord. Si vous souhaitez importer un volume inférieur à 2 000 commentaires, utilisez ce guide.
Étape 1 : Préparer le fichier
L'API Feedier fonctionne avec des fichiers CSV et prend en charge 3 types de données pour les données de feedback
created_at→ Heure de création de l'entrée de feedback. ⚠️ Le format doit être AAAA-MM-JJ HH:MM:SS. Dans Excel ou Google Spreadsheet, vous pouvez définir un format d'heure personnalisé comme dans l’exemple de tableau ci-dessous, mais il n'est pas obligatoire.question_answer:X→ Chaque réponse qui doit être importée dans Feedier doit avoir sa propre colonne avec l'en-tête question_answer:X où X est l'ID de la question de Feedier. Vous pouvez trouver l'ID de la question depuis la page des Questions.
All other columns will be treated and imported as Attributes in Feedier.
Here is an example of working file structure:
created_at | question_answer:121881 | question_answer:121882 | customer_id |
|---|---|---|---|
2022-12-25 00:00:00 | 5 | I love this company | 123 |
This will create in Feedier a feedback with a creation time 25rd of December 2022, with a rating score of 5, text answer and attribute customer_id with the value 123.
The file must be UTF-8 encoded and with “;” as seperator and not “,“.
Excel documentation here: https://support.microsoft.com/en-gb/office/import-or-export-text-txt-or-csv-files-5250ac4c-663c-47ce-937b-339e391393ba#:~:text=When%20you%20save%20a%20workbook,your%20computer%2C%20affecting%20all%20applications.
Step 2: Upload the file
Download the file from Step 1.
Now, Feedier’s API must be able to reach the file online. So import it to an online service that return the file as a readable CSV (not a page to download the CSV). When reached by URL the file must download automatically. Such servcies can be Hubspot files, AWS S3 or others.
Example: https://resources.feedier.com/hubfs/Import-Feedier-test.csv
For security reasons, we highly recommend you to delete the file when the import is completed.
Step 3: Prepare the API call
The start the import process, we need the following API call:
https://api.feedier.com/v1/feedback/bulk?url={csv_file_url}&api_key={private_api_key}
If you are using a private instance, replace the api.feedier.com with your instance’s API url.
The CSV file URL must be replaced with the URL you get from Step 2 and URL encoded (https%3A%2F%2Fresources.feedier.com%2Fhubfs%2FImport-Feedier-test.csv)
The Private API key, can be found on your Feedier Dashboard with an Admin role:
Organizations → Integrations → Private API key.
Step 4: Call the API
Open your browser and call the url with your CSV file and Private API key.
When it works, you will see the message:
A job has been triggered to import the feedback data