Fetching case data and photos into MySQL DB

Hi,

We have been fetching form data from Commcare into our MySQL DB. Is it possible to do the same for case data and also photos taken in Commcare forms? We are not able to locate the supporting literature for this. Thank you in advance.

Regards,
Nikhil

Hi Nikhil,

You can definitely configure a data feed for case data through the Data Export Tool. The DET will allow you to specify an attachment_url transform for form data which collects images, which will provide a static resource URL that can be used to fetch media data programmatically but to my knowledge the tool doesn’t currently have a mechanism for automating the retrieval of the raw files.

-Clayton