search

OpenEnergyPlatform / oedatamodel

A common open energy data model (oedatamodel) and datapackage format for energy and scenario data
Creative Commons Zero v1.0 Universal
7 stars 3 forks source link

No column "id" in tables of oedatamodel #26

Closed henhuy closed 3 years ago

henhuy commented 3 years ago

Just wanted to post data into our oeddatamodel but upload fails with following response: reason": "column \"id\" does not exist"

From https://oep-data-interface.readthedocs.io/en/latest/api/how_to.html#create-table it states, that tables have to have a primary key called "id". Thus, we have to change "scenario_id" in table "oed_scenario" to "id" (and all other tables). Unfortunately, there is no error message when creating the table without column "id" - maybe there should be one?!

jh-RLI commented 3 years ago

That is unfortunate. I usually only uploaded data with pandas. That way it works without an ID column, if I'm not mistaken. I did not notice this issue.