Checking whether a JSON dictionary is empty or not and storing in a list



I have an Instagram API which I load into a JSON. The response is coming properly and I am even able to fetch the id from the data received. Then I save it in a python list and put it in an Excel sheet using openpyxl.

Here is the catch. While loading the values, If there is no response from API in case of a deleted instagram account,where the JSON will be empty, I want to store "ACC deleted" in the list.

(NOTE :- I also referred similar questions but didnt get my answer which works.)

Here is the code:

for r in range(1,51):
    var=r,test.cell(row=r,column=1).value
    xy=var[1]
    myopener=Myopener()
   
url=myopener.open('https://api.instagram.com/v1/users/search?q='+xy+'&count=1&access_token=641567093.1fb234f.a0ffbe574e844e1c818145097050cf33')

    **beta=json.load(url)
    for item in beta['data']:
        list.append(item['id'])** //*HERE I WANT THE CHANGE*


    for j in range(len(list)):
        for row in sheet.iter_rows(min_row=j+1, max_row=j+1):
            for cell in row:
                cell.value=list[j]
                wb.save('sample.xlsx')

The json Response is this:

{
"meta":  {
"code": 200
},
"data":  [
 {
  "username": "rawhawk_sk",
  "profile_picture":
"https://scontent.cdninstagram.com/t51.2885-19/s150x150/12724928_109384759877664_1105313598_a.jpg",
  "id": "670907103",
  "full_name": "shwan mcswan"
}
]
}

If the json response is empty like below, how to store "ACC deleted" in the list?

{
"meta":  {
"code": 200
},
"data":  []
} 

Related to : Checking whether a JSON dictionary is empty or not and storing in a list

HD Wallpapers
3D
3D Abstract
City
Celebrities
Indian Celebrities
Cars
Travel
Girls
Animals Birds
Movies
Sports
Black White
Nature
Planes
Anime
Food Drink
Dreamy Fantasy
Architecture
Games
Space
Holidays
Flowers
Love
Artistic
Baby
Beach
Bikes Motorcycles
Macro
Computers
Vector
Funny
Army
Textures
Brands
Misc
Music
Other
Privacy Policy - Copyrights Notice - Feedback - Report Violation - RSS 2017 © bighow.org All Rights Reserved .