Data download from formstack into excel (could use API)
£20-250 GBP
진행 중
게시됨 12년 이상 전
£20-250 GBP
제출할때 지불됩니다
Data from around 40 forms on a formstack ([login to view URL]) website require downloaded regularly
- example of a typical form is [login to view URL]
I am looking for an automated solution, which will be easily repeatable as the data set grows;
and would like the solution to work on a Mac; and to be able to autorun eg. every 24 hours; and to have the new file have a new name or number ie. not just overwrite older file
Possible solutions:
1. Use the formstack API to get XML data (see formstack developer guide on [login to view URL]) note the downloaded data needs converted into an excel file (preferably combining all data from the 40 forms into a multi-worksheet single file).
2. Web scrape data with the same result - an excel file of data
3. Any other solution is fine, as long as it works consistently
Please ask for any clarification, happy to explain further as needed