Flask load local json

Question

I am struggling with how to load a local json in flask.

from flask import Flask, render_template, json, url_for

def taiwan():
    json_data = open(url_for('static', filename="data/taiwan.json"))
    data = json.load(json_data)
    return render_template('taiwan.jade', data=data)

This raises an IOError: No such file or directory: '/static/css/taiwan.json'. But it still exists.

Any suggestions

Answer 1

I ended up with this:

import os
from flask import Flask, render_template, url_for, json

def showjson():
    SITE_ROOT = os.path.realpath(os.path.dirname(__file__))
    json_url = os.path.join(SITE_ROOT, "static/data", "taiwan.json")
    data = json.load(open(json_url))
    return render_template('showjson.jade', data=data)

Answer 2

Dynamically get your static directory and includes a data sub-dir which contains the .json file to load.

import os
from flask import Flask, render_template, json, current_app as app

# static/data/test_data.json
filename = os.path.join(app.static_folder, 'data', 'test_data.json')

with open(filename) as test_file:
    data = json.load(test_file)

return render_template('index.html', data=data)