iam-json-reformat.py

iam-json-reformat.py

#!/usr/bin/env python3
# Python script to reformat IAM json data
# Author: Rajathithan Rajasekar - 03/03/2020
import json,ast,sys

data = []

project = ""

def hello(jdata, project):
    nicedata = ast.literal_eval(json.dumps(jdata, indent=4, sort_keys=True))
    for i in range(len(nicedata)):
        indrow = nicedata[i]
        usersandservice = indrow['members']
        for j in range(len(usersandservice)):
            print("{},{},{}".format(project, indrow['role'], usersandservice[j]))


project = sys.argv[1]
data = sys.stdin.read()
data = data.replace("u\'", "\"")
data = data.replace("\'", "\"")
jdata = json.loads(data)
hello(jdata, project)