loading json from text file

Question

I am trying to run this code but it creates error.

import json
import requests
import pprint
data = []
with open('data.txt') as o1:
  for line in o1:
    data.append(json.loads(line))
    print(data)
    print(" \n")
print(data)
url = 'http://xyz.abcdfx.in/devicedata'
body_json=json.dumps(data)
headers = {'Content-Type':'application/json'}
d = requests.post(url, data = body_json, headers=headers)
pprint.pprint(d.json())

it shows

Value Error: No json object could be Decoded

I am new to programming and not able to figure out what is the problem.

Does it throw that error only when started from your crontab? — Aran-Fey
– Aran-Fey, Commented Jun 6, 2017 at 8:30

Shai · Accepted Answer · 2017-06-06 08:37:37Z

1

It seems like you are trying to parse the json file line by line, but the json objects may (and usually are) span more than one line. You need to have the entire file in order to parse it:

 with open('data.txt') as o1:
      data = json.loads(o1.read()) # read ALL the file and parse. no loops
 print(data)

answered Jun 6, 2017 at 8:37

Shai

115k39 gold badges259 silver badges398 bronze badges

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

4 Comments

Aaron.0 Over a year ago

i tried this code but it again throw a Error :Value Error: Extra Data:

Shai Over a year ago

@Aaron.0 can you open 'data.txt' in any external json reader? It seems like the file is "not purely" json(?)

Aaron.0 Over a year ago

its json alright it runs well when there is only single data in 'data.txt' but throws error when there are more than that

Shai Over a year ago

@Aaron.0 who writes data.txt? why are there several "json data" in there?

Aaron.0 · Accepted Answer · 2017-06-06 13:08:29Z

0

i solved my problem using this:

data =[]
with open('data.txt') as f:
   for line in f:
      data = json.loads(line)
      print(data)
      url = 'http://xyz.abcdfx.cn/devicedata'
      body_json=json.dumps(data)
      headers = {'Content-Type':'application/json'}
      d = requests.post(url, data = body_json, headers=headers)
      pprint.pprint(d.json())

answered Jun 6, 2017 at 13:08

Aaron.0

431 silver badge9 bronze badges

Collectives™ on Stack Overflow

loading json from text file

2 Answers 2

4 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

4 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related