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 Jan 11 '16 at 09:14 — Daniel Roseman, Jan 11 '16 at 09:14
@DanielRoseman I am running flask framework – Nuru Salihu Jan 11 '16 at 09:16 — Nuru Salihu, Jan 11 '16 at 09:16

score 3 · Answer 1 · answered Jan 11 '16 at 09:19

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']

score 2 · Accepted Answer · answered Jan 11 '16 at 09:18

2

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

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

answered Jan 11 '16 at 09:18

Daniel Roseman

588,541
66
880
895

receive and loop through json data in python

2 Answers2