Python flask parsing JSON content from output

Question

I have an output that contains system output information from a remote server, and at the very end of the output, it contains a JSON object. Like this:

output:

...
-Verification-
-Test1: PASS
-Test2: PASS
...
...
Result: PASS
...
#JSON Object below
{"path": "/my/path/file.log",  "name": "Roger", "year": 2018}

The output would only contain one set of {} and that is the JSON object I want to parse. So we don't have to worry about grabbing wrong information

I would like my flask app to parse this output to only return the JSON object (everything in the {} including the {}) and filter all the text above it. How can I do this?

Did you tried using regex ?

Chiheb Nexus
– Chiheb Nexus

2018-07-19 00:12:31 +00:00
Commented Jul 19, 2018 at 0:12 — Chiheb Nexus
– Chiheb Nexus, Commented Jul 19, 2018 at 0:12

U13-Forward · Accepted Answer · 2018-07-19 00:22:20Z

2

import re
jsonstr='''...
-Verification-
-Test1: PASS
-Test2: PASS
...
...
Result: PASS
...
#JSON Object below
{"path": "/my/path/file.log",  "name": "Roger", "year": 2018}'''
print(jsonstr.lstrip(re.sub('{.*}','',jsonstr)))

jsonstr='''...
-Verification-
-Test1: PASS
-Test2: PASS
...
...
Result: PASS
...
#JSON Object below
{"path": "/my/path/file.log",  "name": "Roger", "year": 2018}'''
print([i for i in jsonstr.splitlines() if i.startswith('{') and i.endswith('}')])

answered Jul 19, 2018 at 0:22

U13-Forward

71.8k15 gold badges100 silver badges125 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Mr.cysl · Accepted Answer · 2018-07-19 00:13:51Z

1

Use regex (re) with expression {.*}

answered Jul 19, 2018 at 0:13

Mr.cysl

1,6849 gold badges25 silver badges44 bronze badges

Comments

PaulMcG · Accepted Answer · 2018-07-19 10:33:22Z

0

To locate the JSON string, since you know there are no other '{'s in it, use str.find and string indexing:

json_loc = jsonstr.find('{')
if json_loc >= 0:
    jsonstr = jsonstr[json_loc:]
else:
    raise Exception("no JSON string found")

answered Jul 19, 2018 at 10:33

PaulMcG

64.1k16 gold badges98 silver badges135 bronze badges

Collectives™ on Stack Overflow

Python flask parsing JSON content from output

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related