Can't read from mysql json data in python

Question

I can't get variables in json format from mysql.

My code:

import mysql_db
import json

# Tüm kullanıcılar çekildi ve  kullanıcı sayısı kadar döndürüldü
tum_kullanicilar = mysql_db.mysql_get_all("select * from users")
for kullanici in tum_kullanicilar:
    print(kullanici['trendyol_api_bilgileri'])

Output:

{
    "api_key": "xxx",
    "api_secret": "xxx",
    "merchant_id": "xxx",
    "default_kargo_id": "2",
    "default_kargo_adi": "MNG Kargo",
    "entegrasyon_durumu": 1,
    "defaultinvoiceAddressId": 659331,
    "defaultshipmentAddressId": 5785842,
    "defaultreturningAddressId": 659321
}

I'm trying to do:

kullanici['trendyol_api_bilgileri']['entegrasyon_durumu']

TypeError: string indices must be integers

I didn't understand your issue in the code. What is your expected output? — Rahul K P
– Rahul K P, Commented Oct 15, 2022 at 2:03
So when I try this way, I get an error and when I enter an integer value, it returns values like { or ". kullanici['trendyol_api_bilgileri']['entegrasyon_durumu'] — kaann.gunerr
– kaann.gunerr, Commented Oct 15, 2022 at 2:07
Can you check the type of print(type(kullanici['trendyol_api_bilgileri'])) — Rahul K P
– Rahul K P, Commented Oct 15, 2022 at 2:09

Rahul K P · Accepted Answer · 2022-10-15 02:11:49Z

1

You need to parse the data with json,

import json

data = json.loads(kullanici['trendyol_api_bilgileri'])
print(data['entegrasyon_durumu'])

answered Oct 15, 2022 at 2:11

Rahul K P

16.2k4 gold badges40 silver badges56 bronze badges

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

Collectives™ on Stack Overflow

Can't read from mysql json data in python

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related