Is your FileMaker database hosted on FMServer?
If so you can set up a scheduled script to periodically poll the Qualtrics using the API.
It looks like you should be able to pull in data using the Insert from URL command and the QUaltrics REST API
Look here for how to call the API
Hope this helps!
Another option we've used previously is ODBC. If the Qualtrics db accepts an ODBC connection, you can connect directly with FileMaker and download the data directly and act on it directly. Actual Technologies is where you can buy the drivers. Again, check to see if Qualtrics supports one of the "approved" ODBC databases.
Yes, we actually use the Qualtrics API in the SAS code, and the FM database is hosted on a server. Our solution is deployed in webdirect.
Theoretically, what would be the best way to update the FM database with only the new responses from Qualtrics?
I was thinking of creating a virtual list with the Qualtrics data and then transferring new responses to the main FM table. Is that a reasonable solution?
Can you use the API to mark the records in Qualtrics? If not, I would keep track of the last time records were imported (create a field in FM) then query the Qualtrics DB for records created after that date. Import them and update the FileMaker field.
I don't quite get the reason for a virtual list. Would you like to explain?
I was thinking of using the virtual list to process ALL Qualtrics data. Then from the main FM table, I will do an import - update matching records in found set, then add remaining data as new records. Do you think that would work?
I will look into your suggestion about marking the records in Qualtrics. I believe that is possible.
Querying based on the date is also a good option.