search

FDA / openfda

openFDA is an FDA project to provide open APIs, raw data downloads, documentation and examples, and a developer community for an important collection of FDA public datasets.
https://open.fda.gov
Creative Commons Zero v1.0 Universal
572 stars 132 forks source link

Broken Json files #204

Open cwdgservices opened 2 months ago

cwdgservices commented 2 months ago

I ran into 13 entries in device registration listing that are broken. It appears that proprietary_name is being cut off due to the entry being too long. Each entry is cut off at above 65500 making me believe that the openfda data table is set to TEXT and should now be set to medium or large text to support the long entries.

dkrylovsb commented 2 months ago

@cwdgservices openFDA does not use a relational database. Would you be able to share an example here?