Feature #2676
openJSON import
Description
Feature
A data import option of data that has a more complex structure than a csv would be a great addition, maybe something JSON?
Use case
We will have to import data that come with a lot of 1:n relations, e.g. a site with multiple objects, objects with multiple samples... While items can have more than one subordninate item, there won't be the other way round (an item with more than one super-ordinate items). Achieving this with a csv is very difficult. In contrast to csv, a JSON-(like) format would allow to include the relations between the items rather easily in a structured way.
Alternative
We thought about adding POST endpoints to the API to directly write to the database. However, we are aware that this would require authentification for the API and probably additional efforts to make the databse safe from malicious attemps through the API.