Convert json to tuple (to be used in CSV generation for example)

json2tuple.py

import json

def json_titles_tuple(payload_json, prefix=''):
    jsonobj = json.loads(payload_json)
    titles = ()
    for key, value in jsonobj.items():
        if isinstance(value, dict):
            titles += json_titles_tuple(json.dumps(value), prefix + key + '_')
        else:
            titles += (prefix + key,)
    return titles

def json_values_tuple(payload_json):
    jsonobj = json.loads(payload_json)
    values = ()
    for _, value in jsonobj.items():
        if isinstance(value, dict):
            values += json_values_tuple(json.dumps(value))
        else:
            values += (value,)
    return values