CODEWITHSUNDEEP
pythonjson
Aaron.0
Aaron.0

Reputation: 43

loading json from text file

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.

Upvotes: 0

Views: 1826

Answers (2)

Aaron.0
Aaron.0

Reputation: 43

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())

Upvotes: 0

Shai
Shai

Reputation: 114786

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)

Upvotes: 1

Related Questions