staging.inyokaproject.org

   # print('#' * 10, p, '#' * 10)

{
    "id": "$f",
    "request.created_by.department.name": null,
    "request.created_by.department.site.name": null,
    "request.created_by.email_id": null,
    "request.created_by.name": "System",
    "request.created_time.display_value": "Feb 2, 2020 11:56 AM",
    "request.description": null,
    "request.group.name": null,
    "request.id": "71472",
    "request.requester.email_id": "hkn@css.de",
    "request.requester.name": "hkn",
    "request.status.name": "Open",
    "request.subject": "FEHLER:  TransferBelege",
    "request.technician.email_id": null,
    "request.technician.name": null
}

"{\"content\": \"$content\"}" >

#!/usr/bin/env python3
from argparse import ArgumentParser
from collections.abc import MutableMapping
import json
import sys

import requests

parser = ArgumentParser(description="flatten json object and add additional values")
parser.add_argument("json", metavar="JSON", nargs="+", help="json file(s) to process")
parser.add_argument("-a", "--add-json", metavar="ADD_JSON", action="append", default=[], help="add json objects to output")
parser.add_argument("-c", "--content-url", metavar="CONTENT_URL", help="add content key with text content of given url")
parser.add_argument("-k", "--filter-key", metavar="FILTER_KEY", action="append", default=[], help="add key to select from the flattened result")
args = parser.parse_args()

# add all keys you want to use to the following list:
keys = [
    'request.subject',
    'request.id',
    'request.requester.email_id',
    'request.requester.name',
    'request.created_time.display_value',
]
keys.extend(args.filter_key)


def flatten(d, parent_key='', sep='_'):
    items = []
    for k, v in d.items():
        new_key = parent_key + sep + k if parent_key else k
        if isinstance(v, MutableMapping):
            items.extend(flatten(v, new_key, sep=sep).items())
        else:
            items.append((new_key, v))
    return dict(items)

addition_dict = {}

for addition in args.add_json:
    try:
        addition_dict.update(json.loads(addition))
    except json.JSONDecodeError:
       print("invalid json:", addition, file=sys.stderr)

for p in args.json:
    print('#' * 10, p, '#' * 10, file=sys.stderr)
    with open(p) as f:
        content = json.load(f)
    flattened = flatten(content, sep='.')
    result = {k: flattened.get(k) for k in keys}
    if args.content_url:
        r = requests.get(args.content_url)
        try:
            r.raise_for_status()
        except Exception as e:
            print("Could not retrieve url", args.content_url, e, file=sys.stderr)
        else:
            result['content'] = r.text
    result.update(addition_dict)
    print(json.dumps(result, sort_keys=True, indent=4, separators=(',', ': ')))

{
    "operation": {
        "result": {
            "message": "Notes retreived properly",
            "status": "Success"
        },
        "Details": [
            {
                "notesid": 176702,
                "NOTESUSERID": "118802",
                "NOTESTEXT": "<div>Sweethome 3d installiert<br /></div><div><br /></div><div>Log Datei kopiert<br /></div>",
                "ISPUBLIC": "false",
                "USERNAME": "dgge, Jghmdgmhg",
                "NOTESDATE": "1580111062477"
            },
            {
                "notesid": 176516,
                "NOTESUSERID": "13805",
                "NOTESTEXT": "<div>Programm runtergeladen und Jörg zur Verfügung gestellt; Installation durch Jörg, da er am Montag das NB von Hr. Kolvenbach bekommt<br /></div>",
                "ISPUBLIC": "false",
                "USERNAME": "Ho, Sha",
                "NOTESDATE": "1579875705490"
            }
        ]
    }
}