-hidden- asked

Extract InfoCapture data via API or SQL

Hi, I've been trying to extract the data that is collected via InfoCapture forms for our Data Warehouse. I've been able to access the SQL Server back-end, but "selections" are quite tricky to transform into something more tabular. For instance the ordinal number is stored rather than the text, multiple selections are stored as comma-separated lists and user selections store the user id rather than the name.

As the SQL I've written to get the data into the required shape is not ideal, it would be nice to know if there are alternatives such as an API for InfoCapture data (I can't see this mentioned in the wiki) or code\solutions that would make this easier and more efficient?

Thanks. Dan.

Asked on: 12 August 2016

api, database, infocapture, intranet

1 Like


{{ comment.user.is_me ? cc.translations.my_comment : comment.user.name }} {{ comment.user.is_me ? cc.translations.my_comment : comment.user.name }} {{comment.user.name}} [wrote]...
[Reply] [Like] [Unlike]  {{comment.like_count}} [person] [people] [liked this] [Edit] [Delete] {{ comment.timestamp.date_str }}