Import high feedback volume using the API
- Carlos Carasco
- Alexis Pinon
- François Forest
The Feedier API let you import a higher volume (> 2,000 feedback) than the dashboard Import module. If you arae looking to import a volume lower than 2,000 feedback, use this guide.
Step 1: Prepare the file
Feedier API works with CSV file, and support 3 type of data types for the feedback data
created_at→ Creation time of the feedback entry. The format must be YYYY-MM-DD HH:MM:SS. In Excel, or Google Spreadsheet, you can define the custom time format as seen in the below example table. The time is not mandatory.question_answer:X→ Every answer that needs to be imported in Feedier, must have its own column with the header question_answer:X where X is the Feedier’s Question ID. You can find the Question ID from the Questions page.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}
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)
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