parsing JSON formatted data in python

Question

Hey I am trying to import data that is already formatted as JSON data. I am trying to get it to be read in Python so I can use it for a http post request. I have tried saving it as .JSON and .txt and using json.dumps on both files but I'm still getting it in the wrong format. The code is below. I am guessing it is reading in the wrong format as the response from the post is getting an error. However when I use postman for the job, no error.

workingFile = 'D:\\test.json'

file = open(workingFile, 'r')

read = [file.read()]

data = json.dumps(read)
url = 'http://webaddress'
username = 'username'
password = 'password'

requestpost = requests.post(url, data, auth=(username, password))

Post your code and all relevant information...your question is not complete.. — Iron Fist
– Iron Fist, Commented Dec 23, 2015 at 14:03
If you don't actually need to modify the JSON before sending it and you know that you're only dealing with valid JSON, then there no reason to parse and dump it. Just send the text as is. — Lie Ryan
– Lie Ryan, Commented Dec 24, 2015 at 0:44

Mukund M K · Accepted Answer · 2015-12-23 14:23:06Z

1

workingFile = 'D:\\test.json'

with open(workingFile, 'r') as fh:
    data = json.load(fh)

url = 'http://webaddress'
username = 'username'
password = 'password'

requestpost = requests.post(url, json=data, auth=(username, password))

By specifying json=data, requests encodes the payload as json instead of form data

answered Dec 23, 2015 at 14:23

Mukund M K

814 bronze badges

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

Comments

Community · Accepted Answer · 2017-05-23 12:07:25Z

0

To read json data from file Parsing values from a JSON file using Python?
To read json data from string Convert string to JSON using Python

edited May 23, 2017 at 12:07

CommunityBot

11 silver badge

answered Dec 23, 2015 at 14:06

Netro

7,3077 gold badges45 silver badges58 bronze badges

1 Comment

tosh Over a year ago

It looks as if the JSON is wrong in the first link. I am guessing mine cannot be wrong if it works in postman

Collectives™ on Stack Overflow

parsing JSON formatted data in python

2 Answers 2

Comments

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related