parses flat json with db info