在嵌套字典Python Odoo中获得价值

debugcn 发表于 Dev

理查德·安加|

我又有问题... 这与我先前在Cron中的问题有关。我有JSON值，我想在数据库中输入它。我需要帮助来获取此嵌套字典中的值。请帮忙！

JSON

{'folders': [{'id': 94, 'name': 'Retargeting January 2021', 'totalBlacklisted': 606, 'uniqueSubscribers': 19988, 'totalSubscribers': 19382}, 
{'id': 90, 'name': 'Leads', 'totalBlacklisted': 0, 'uniqueSubscribers': 0, 'totalSubscribers': 0},
{'id': 84, 'name': 'Retargeting Year End', 'totalBlacklisted': 1367, 'uniqueSubscribers': 18847, 'totalSubscribers': 17480}, 
{'id': 79, 'name': 'CRM Folder', 'totalBlacklisted': 0, 'uniqueSubscribers': 3, 'totalSubscribers': 3},
{'id': 56, 'name': 'Curioo P', 'totalBlacklisted': 282, 'uniqueSubscribers': 3279, 'totalSubscribers': 2997}]}

Python

res = simplejson.loads(response.text)
self.env['get.folders'].create({
            'id' : self.id,
            'name': res['name'],
            'email_blacklist': res['totalBlacklisted'],
            'email_subscribers': res['totalSubscribers'],
            'unique_subscribers': res['uniqueSubscribers'],
            'foldersId': res['id'],
            })

编辑最后它起作用了。我尝试拼写出这些值，但我不知道该怎么做，但是它可以这样工作。感谢@Jack Dane的帮助。

for folder in folders.get("folders"):
            names = folder['name']
            ids = folder['id']
            blacklist = folder['totalBlacklisted']
            subscribe = folder['totalSubscribers']
            unique = folder['uniqueSubscribers']
            self.env['sendinblue.get_folders'].create({
                    # 'id' : folder['id'],
                    'name_folder': names,
                    'email_blacklist': blacklist,
                    'email_subscribers': subscribe,
                    'unique_subscribers': unique,
                    'foldersId': ids,
                    })

杰克·丹恩

您可以使用foreach循环调用create函数来循环浏览文件夹：

folders = {'folders': [{'id': 94, 'name': 'Retargeting January 2021', 'totalBlacklisted': 606, 'uniqueSubscribers': 19988, 'totalSubscribers': 19382}, 
{'id': 90, 'name': 'Leads', 'totalBlacklisted': 0, 'uniqueSubscribers': 0, 'totalSubscribers': 0},
{'id': 84, 'name': 'Retargeting Year End', 'totalBlacklisted': 1367, 'uniqueSubscribers': 18847, 'totalSubscribers': 17480}, 
{'id': 79, 'name': 'CRM Folder', 'totalBlacklisted': 0, 'uniqueSubscribers': 3, 'totalSubscribers': 3},
{'id': 56, 'name': 'Curioo P', 'totalBlacklisted': 282, 'uniqueSubscribers': 3279, 'totalSubscribers': 2997}]}

for folder in folders.get("folders"):
    self.env['get.folders'].create({
            'id' : self.id,
            'name': folder['name'],
            'email_blacklist': folder['totalBlacklisted'],
            'email_subscribers': folder['totalSubscribers'],
            'unique_subscribers': folder['uniqueSubscribers'],
            'foldersId': folder['id'],
            })

就我而言，我已经使用文件夹作为变量，它将作为JSON返回。

如果您需要任何澄清，请告诉我，

谢谢，

本文收集自互联网，转载请注明来源。

如有侵权，请联系[email protected] 删除。