CSPro Users Forum

Hi CSPro Community,

I am currently using a CSWeb server (hosted via CVPS) to manage survey data and would like to automate the transfer of data from CSWeb to Google Sheets for creating a real-time dashboard in Looker Studio.

Specifically, I am looking for guidance on:
1. Whether CSWeb provides an API or similar feature to access data programmatically.
2. How I can connect CSWeb with Google Sheets to fetch data automatically at regular intervals.
3. Any best practices for ensuring data synchronization between CSWeb and Google Sheets.

If this is possible, I would greatly appreciate any documentation, sample scripts, or advice on setting up the process.

Thank you!

Best regards,
Waqar

Hello,

You can use blob breakout in CSWeb, break out the cases stored on CSWeb into relational tables using Data Settings - CSWeb User's Guide and then use Google Data Studio or Power BI to create reports. The automation process cases can be done using a cron job on the server.

Hope this helps,
Justin