How to save data from a JSON consisting of arrays?

0

Hello. I have a JSON that has the following structure:

 {
"_id": {
    "$oid": "3432fa43242"
},
"posts": [{
    "thread": {
        "uuid": "2911da",
        "url": "http://www.google.com",
        "site_full": "opiniaoenoticia.com.br",
        "site": "opiniaoenoticia.com.br",
        "site_section": "http://opiniaoenoticia.com.br/feed/",
        "site_categories": [],
        "section_title": "Opinião e Notícia",
        "title": "Veto a protestos contra Temer na Rio 2016 gera polêmica",
        "title_full": "Veto a protestos contra Temer na Rio 2016 gera polêmica",
        "published": "2016-08-08T18:07:00.000+03:00",
        "replies_count": 0,
        "participants_count": 1,
        "site_type": "news",
        "country": "BR",
        "spam_score": 0.0,
        "main_image": "",
        "performance_score": 0,
        "domain_rank": null,
        "social": {
            "facebook": {
                "likes": 0,
                "comments": 0,
                "shares": 0
            },
            "gplus": {
                "shares": 0
            },
            "pinterest": {
                "shares": 0
            },
            "linkedin": {
                "shares": 0
            },
            "stumbledupon": {
                "shares": 0
            }
        }
    },
    "uuid": "2931da",
    "url": "http://3NXmoxXP9jWxZXABLjFrpB03",
    "ord_in_thread": 0,
    "author": "Melissa",
    "published": "2016-08-08T18:07:00.000+03:00",
    "title": "Veto a protestos contra Temer na Rio 2016 gera polêmica",
    "text": "Início » Brasil » Veto a protestos contra Temer na Rio 2016 gera polêmica.",
    "highlightText": "",
    "highlightTitle": "",
    "language": "portuguese",
    "external_links": [],
    "entities": {
        "persons": [],
        "organizations": [],
        "locations": []
    },
    "crawled": "2016-08-08T22:09:19.938+03:00"
}, {
"thread": {...

Does anyone know how to extract specific data from this array (for example, the data of all the title of each instance of the array) and save it to CSV? I've tried using MongoDB.

Thank you!

    
asked by anonymous 25.09.2016 / 22:51

1 answer

0

In the mongo you can extract the attributes from within the array like this: db.artigos.find({}, {'posts.thread.title': 1}) .

    
26.09.2016 / 17:27