/ All posts
- Data feeds, which is better JSON or XML
I have a iFormBuilder account with a moderate amount of data on it. This data can be exported as JSON or XML. I have only just started with iFormBuilder but it seems to push data in little files to an address you provide, even dropbox. It also provides URLs for downloading data in either JSON or XML. There are some other formats such as html or pdf but after seeing a sample of these, they are definitely not a prospect.
I would like to clean up the data and put it in a relational database that can support reporting. One approach will be to pull out some key fields and shove the rest into a field of type XML or JSON. I have no experience with these data types and their searchability. Shoving a whole XML/JSON record into a field is likely to be required where users keep changing form design.
The users can design their own forms and I had attached a sample of the data collected. The places and names have been removed or degraded.