receive and loop through json data in python

Question

I have a JSON data that I sent to my server using AJAX. The data comes here and I see it.

def add_collection(self):
        form = AccountForm.LoginForm(request.form)
        if self.request.method == 'GET' :
            return render_template('add_collection.html',user=current_user,formLogin = form)
        elif self.request.method == 'POST' :
            for data in self.request.data :
                print "The data is %s" %data

When I print self.request.data I get my JSON like

    [{"image":"https://mybucket.s3.amazonaws.com/asma.jpg","Description":"Photo Descriptiong"},
{"image":"https://mybucket.s3.amazonaws.com/NCg3G.png","Description":"Photo Description"}]'

The above is exactly what my JSONfile looks like and what I am expecting. However, I want to break it into the two rows and insert into the database. Please how do i loop through JSON. I have seen similar questions here and many more. However, none works for me. When i tried

 for data in self.request.data :
                print data['image']

TypeError: string indices must be integers, not str

Please how do i achieve this ?Any help would be appreciated.

Below is my ajax request .

$.ajax({
                url: "/user/add_collection",
                type: 'POST',
                contentType:'application/json',
                data: JSON.stringify(arr),
                dataType:'json',
                success : function(data,status){
                    console.log("The image upload data returns", data);
                    console.log("the image upload status is", status);
                },
                error : function(xhr, ajaxOptions, thrownError){
                    //$.mobile.loading('hide');
                    if (xhr.status == 200) {
                        alert(ajaxOptions);
                    }
                    else {
                        alert(xhr.status);
                        alert(thrownError);
                    }
                }
            });

I am using python running flask framework .

What is this "server"? What framework are you using?

Daniel Roseman
– Daniel Roseman

2016-01-11 09:14:32 +00:00
Commented Jan 11, 2016 at 9:14 — Daniel Roseman
– Daniel Roseman, Commented Jan 11, 2016 at 9:14
@DanielRoseman I am running flask framework

Nuru Salihu
– Nuru Salihu

2016-01-11 09:16:30 +00:00
Commented Jan 11, 2016 at 9:16 — Nuru Salihu
– Nuru Salihu, Commented Jan 11, 2016 at 9:16

Mirec Miskuf · Accepted Answer · 2016-01-11 09:19:38Z

3

I think you are getting the response as a string (self.request.data). To treat it as objects, you need to convert it (from string to python representation) first:

    elif self.request.method == 'POST' :
        parsed_json = json.loads(self.request.data)
        for data in parsed_json:
            print data['image']

answered Jan 11, 2016 at 9:19

Mirec Miskuf

1,6951 gold badge14 silver badges13 bronze badges

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

Comments

Daniel Roseman · Accepted Answer · 2016-01-11 09:18:22Z

2

JSON data is received as a string. You need to parse it first.

data = json.loads(self.request.data)

answered Jan 11, 2016 at 9:18

Daniel Roseman

602k68 gold badges910 silver badges923 bronze badges

Collectives™ on Stack Overflow

receive and loop through json data in python

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related