Sample Output for Database Connectors

The output format depends on the setting you choose for output_params.format for the connector you use.

If you have not used JSON before, take a look at Understanding JSON first.

Basic interactions (CouchDB, ElasticSearch, MongoDB)

Each payload contains only basic interaction JSON document. Available in CouchDB, ElasticSearch, and MongoDB connectors.

{
    "interactionId": "f35ace79b903eedfe5198f386d6fda0c",
    "subscriptionId": "ABC123456a891e3406789123216789",
    "hash": null,
    "hashType": null,
    "interaction": {
        "schema": {
            "version": 3
        },
        "source": "Twitter for Android",
        "type": "twitter",
        "created_at": "Thu, 09 May 2013 08:59:46 +0000",
        "content": "RT @Real_Liam_Payne: Thank you denmarkkkk :) love youuuu :)",
        "id": "f35ace79b903eedf75198f386d6fd40b",
        "author": {
            "hash_id": "c6add0a675830a785598a513d586203c"
        },
        "tags": [
            "type.share",
            "demo.tag",
            "another.one",
            "foobar"
        ]
    }
}

Basic interactions with Augmentations (CouchDB, ElasticSearch, MongoDB)

The payload is a full interaction with augmentations. Available in CouchDB, ElasticSearch, and MongoDB connectors.

{
    "interactionId": "f35ace79b903eedfe5198f386d6fda0c",
    "subscriptionId": "ABC123456a891e3406789123216789",
    "hash": null,
    "hashType": null,
    "interaction": {
        "demographic": {
            "first_language": "English",
            "main_street": {
                "eat_and_drink_at": [
                    "Starbucks"
                ],
                "dressed_by": [
                    "Burberry"
                ]
            },
            "sex": "Female",
            "twitter": {
                "activity": "1-5 tweets/day",
                "accounts.large": [
                    "Mayo Clinic",
                    "Debby Ryan",
                    "Creative Commons",
                    "Rebecca Black",
                    "Nick Jonas",
                    "Jessie J",
                    "Wynn Resorts",
                    "Rihanna",
                    "Politico",
                    "Ariana Grande",
                    "Cody Simpson",
                    "Lord_Voldemort7",
                    "Jordin Sparks",
                    "Selena Gomez",
                    "Demi Lovato",
                    "Ashley Tisdale",
                    "Emily Osment",
                    "Psy"
                ]
            },
            "type": "People"
        },
        "interaction": {
            "schema": {
                "version": 3
            },
            "source": "Twitter for Android",
            "type": "twitter",
            "created_at": "Thu, 09 May 2013 08:59:46 +0000",
            "content": "RT @Real_Liam_Payne: Thank you denmarkkkk :) love youuuu :)",
            "id": "f35ace79b903eedf75198f386d6fd40b",
            "author": {
                "hash_id": "c6add0a675830a785598a513d586203c"
            },
            "tags": [
                "type.share",
                "demo.tag",
                "another.one",
                "foobar"
            ]
        },
        "klout": {
            "amplification": 2,
            "network": 1.47,
            "score": 41,
            "true_reach": 10
        },
        "language": {
            "tag": "en",
            "confidence": 63
        },
        "salience": {
            "content": {
                "sentiment": 4
            }
        },
        "twitter": {
            "id": "231419612755326460",
            "retweet": {
                "text": "Thank you denmarkkkk :) love youuuu :)",
                "id": "231419612755326460",
                "user": {
                    "description": "♥One Direction ♥ 1D is my life ♥ DIRECTIONER ♥' 0/5 D':♥ BFF Annissa ♥ Single ♥ Life is a wonderfull thing, and only wonderfull people can get it  ♥",
                    "statuses_count": 4711,
                    "followers_count": 329,
                    "friends_count": 1257,
                    "profile_image_url": "http://a0.twimg.com/profile_images/3632046312/c0d75d140a02775761b8d9ecffe13a7b_normal.jpeg",
                    "lang": "nl",
                    "time_zone": "Amsterdam",
                    "utc_offset": 3600,
                    "geo_enabled": true,
                    "favourites_count": 123,
                    "created_at": "Sat, 15 Oct 2011 08:04:25 +0000",
                    "hash_id": "c6cdd4a675830a795598e513d586203b"
                },
                "source": "Twitter for Android",
                "count": 32166,
                "created_at": "Thu, 09 May 2013 08:59:46 +0000",
                "lang": "en"
            },
            "retweeted": {
                "id": "312189094049411043",
                "user": {
                    "description": "its on like donkey kong",
                    "location": "UK",
                    "statuses_count": 7254,
                    "followers_count": 10365944,
                    "friends_count": 13981,
                    "profile_image_url": "http://a0.twimg.com/profile_images/a566362915/de1b239ca19b01ef71994c57ef46e92e_normal.jpeg",
                    "lang": "en",
                    "listed_count": 57226,
                    "geo_enabled": true,
                    "verified": true,
                    "favourites_count": 29,
                    "created_at": "Tue, 22 Jun 2010 10:19:08 +0000",
                    "hash_id": "e74afc43e08a7b3969846ea4b1b8c83f"
                },
                "source": "Twitter for iPhone",
                "created_at": "Sun, 05 May 2013 23:30:08 +0000"
            }
        }
    }
}

Basic interactions with Augmentations, MongoDB Date Format (MongoDB)

Each payload is a full interaction with augmentations and a MongoDB-specific date representation. Available in the MongoDB connector.

{
    "interactionId": "f35ace79b903eedfe5198f386d6fda0c",
    "subscriptionId": "ABC123456a891e3406789123216789",
    "hash": null,
    "hashType": null,
    "interaction": {
        "demographic": {
            "first_language": "English",
            "main_street": {
                "eat_and_drink_at": [
                    "Starbucks"
                ],
                "dressed_by": [
                    "Burberry"
                ]
            },
            "sex": "Female",
            "twitter": {
                "activity": "1-5 tweets/day",
                "accounts.large": [
                    "Mayo Clinic",
                    "Debby Ryan",
                    "Creative Commons",
                    "Rebecca Black",
                    "Nick Jonas",
                    "Jessie J",
                    "Wynn Resorts",
                    "Rihanna",
                    "Politico",
                    "Ariana Grande",
                    "Cody Simpson",
                    "Lord_Voldemort7",
                    "Jordin Sparks",
                    "Selena Gomez",
                    "Demi Lovato",
                    "Ashley Tisdale",
                    "Emily Osment",
                    "Psy"
                ]
            },
            "type": "People"
        },
        "interaction": {
            "schema": {
                "version": 3
            },
            "source": "Twitter for Android",
            "type": "twitter",
            "created_at": "Thu, 09 May 2013 08:59:46 +0000",
            "content": "RT @Real_Liam_Payne: Thank you denmarkkkk :) love youuuu :)",
            "id": "f35ace79b903eedf85198f386d6fd40b",
            "author": {
                "hash_id": "c6add0a675830a785598a513d586203c"
            },
            "tags": [
                "type.share",
                "demo.tag",
                "another.one",
                "foobar"
            ]
        },
        "klout": {
            "amplification": 2,
            "network": 1.47,
            "score": 41,
            "true_reach": 10
        },
        "language": {
            "tag": "en",
            "confidence": 63
        },
        "salience": {
            "content": {
                "sentiment": 4
            }
        },
        "twitter": {
            "id": "231419612755326460",
            "retweet": {
                "text": "Thank you denmarkkkk :) love youuuu :)",
                "id": "231419612755326460",
                "user": {
                    "description": "♥One Direction ♥ 1D is my life ♥ DIRECTIONER ♥' 0/5 D':♥ BFF Annissa ♥ Single ♥ Life is a wonderfull thing, and only wonderfull people can get it  ♥",
                    "statuses_count": 4711,
                    "followers_count": 329,
                    "friends_count": 1257,
                    "profile_image_url": "http://a0.twimg.com/profile_images/3632046312/c0d75d140a02775761b8d9ecffe13a7b_normal.jpeg",
                    "lang": "nl",
                    "time_zone": "Amsterdam",
                    "utc_offset": 3600,
                    "geo_enabled": true,
                    "favourites_count": 123,
                    "created_at": "Sat, 15 Oct 2011 08:04:25 +0000",
                    "hash_id": "c6cdd4a675830a795598e513d586203b"
                },
                "source": "Twitter for Android",
                "count": 32166,
                "created_at": "Thu, 09 May 2013 08:59:46 +0000",
                "lang": "en"
            },
            "retweeted": {
                "id": "312189094049411043",
                "user": {
                    "description": "its on like donkey kong",
                    "location": "FR",
                    "statuses_count": 7254,
                    "followers_count": 10365944,
                    "friends_count": 13981,
                    "profile_image_url": "http://a0.twimg.com/profile_images/a566362915/de1b239ca19b01ef71994c57ef46e92e_normal.jpeg",
                    "lang": "en",
                    "listed_count": 57226,
                    "geo_enabled": false,
                    "verified": true,
                    "favourites_count": 29,
                    "created_at": "Tue, 22 Jun 2010 10:19:08 +0000",
                    "hash_id": "e74afc43e08a7b3969846ea4b1b8c83f"
                },
                "source": "Twitter for iPhone",
                "created_at": "Sun, 05 May 2013 23:30:08 +0000"
            }
        }
    },
    "created_at": ISODate("2013-05-09T08:59:46Z")
}