Usage of OpenEnergyPlatform API (HTTP requests)¶

Repository: https://github.com/openego/oedialect
Documentation: http://oep-data-interface.readthedocs.io/en/latest/api/how_to.html

Please report bugs and improvements here: https://github.com/OpenEnergyPlatform/oedialect/issues

In [ ]:

__copyright__ = "Reiner Lemoine Institut"
__license__   = "GNU Affero General Public License Version 3 (AGPL-3.0)"
__url__       = "https://github.com/openego/data_processing/blob/master/LICENSE"
__author__    = "Ludee, oakca"

__copyright__ = "Reiner Lemoine Institut" __license__ = "GNU Affero General Public License Version 3 (AGPL-3.0)" __url__ = "https://github.com/openego/data_processing/blob/master/LICENSE" __author__ = "Ludee, oakca"

In [ ]:

import requests
import pandas as pd
from IPython.core.display import HTML

from token_config import oep_url, get_oep_token

# token
your_token = get_oep_token()

import requests import pandas as pd from IPython.core.display import HTML from token_config import oep_url, get_oep_token # token your_token = get_oep_token()

In [ ]:

# select data
schema = 'demand'
table = 'ego_dp_loadarea'
column = 'column=id&column=version'
orderby = 'order_by=version'

result = requests.get(oep_url+'/api/v0/schema/'+schema+'/tables/'+table+'/rows/?'+column+'&'+orderby, )
result.status_code

# select data schema = 'demand' table = 'ego_dp_loadarea' column = 'column=id&column=version' orderby = 'order_by=version' result = requests.get(oep_url+'/api/v0/schema/'+schema+'/tables/'+table+'/rows/?'+column+'&'+orderby, ) result.status_code

In [ ]:

df = pd.DataFrame(result.json())
df

df = pd.DataFrame(result.json()) df

In [ ]: