SQ on sandbox

indexed_contact.json

{
    "_id": "4172840",
    "_index": "contacts_v1",
    "_routing": "60635",
    "_source": {
        "account_id": 60635,
        "actionable_per_type": [],
        "billing_address": null,
        "billing_address_city_suggest": {},
        "billing_address_country_suggest": {},
        "billing_address_region_suggest": {},
        "billing_address_street_suggest": {},
        "billing_address_zip_code_suggest": {},
        "calls_to_action": [
            {
                "actionable_count": 0,
                "user_id": 79094
            }
        ],
        "city": "New Barrett",
        "city_suggest": {
            "context": {
                "account_id": 60635,
                "owner_context": "c:79094"
            },
            "input": "New Barrett",
            "output": "New Barrett"
        },
        "collaborators": [],
        "company_id": null,
        "company_name": null,
        "company_name_suggest": {
            "context": {
                "account_id": 60635,
                "owner_context": "c:79094"
            },
            "input": null,
            "output": null
        },
        "country": "United States",
        "country_suggest": {
            "context": {
                "account_id": 60635,
                "owner_context": "c:79094"
            },
            "input": "United States",
            "output": "United States"
        },
        "created_at": "2016-02-25T09:33:40Z",
        "custom_fields": {
            "booleans": [],
            "dates": [],
            "lists": [],
            "multi_select_lists": [],
            "numbers": [],
            "strings": []
        },
        "customer_status": "non",
        "description": "implement collaborative bandwidth",
        "display_name": "Tomas Gulgowski",
        "email": "moses_runolfsdottir@jaskolski.name",
        "facebook": "http://facebook.com/pouros",
        "fax": null,
        "first_name": "Tomas",
        "hxp_attributes": {
            "open_cases_count": 0
        },
        "id": 4172840,
        "industry": "Nicolas LLC",
        "industry_suggest": {
            "context": {
                "account_id": 60635,
                "owner_context": "c:79094"
            },
            "input": "Nicolas LLC",
            "output": "Nicolas LLC"
        },
        "is_organisation": false,
        "is_sales_account": false,
        "last_activity_date": "2016-02-25T09:33:40Z",
        "last_name": "Gulgowski",
        "linkedin": "http://linkedin.com/douglasemard",
        "name": "Tomas Gulgowski",
        "owner": {
            "id": 79094,
            "name": "Willa"
        },
        "phone_numbers": {
            "mobile": "17608485452608",
            "phone": "1-235-491-6151 x06073"
        },
        "prospect_status": "non",
        "region": "Massachusetts",
        "region_suggest": {
            "context": {
                "account_id": 60635,
                "owner_context": "c:79094"
            },
            "input": "Massachusetts",
            "output": "Massachusetts"
        },
        "sales_account_custom_fields": {
            "booleans": [],
            "dates": [],
            "lists": [],
            "numbers": [],
            "strings": []
        },
        "shipping_address": null,
        "shipping_address_city_suggest": {},
        "shipping_address_country_suggest": {},
        "shipping_address_region_suggest": {},
        "shipping_address_street_suggest": {},
        "shipping_address_zip_code_suggest": {},
        "skype": "schuppe",
        "smart_attributes": {
            "booleans": [],
            "dates": [],
            "integers": [],
            "strings": []
        },
        "street": "1511 Casimir Burgs",
        "street_suggest": {
            "context": {
                "account_id": 60635,
                "owner_context": "c:79094"
            },
            "input": "1511 Casimir Burgs",
            "output": "1511 Casimir Burgs"
        },
        "tag_ids": [
            504719,
            504720,
            504721
        ],
        "tags": [
            "c",
            "d",
            "e"
        ],
        "title": "Mr.",
        "title_suggest": {
            "context": {
                "account_id": 60635,
                "owner_context": "c:79094"
            },
            "input": "Mr.",
            "output": "Mr."
        },
        "twitter": "torphy",
        "website": "http://cruickshank.biz/1456392820",
        "zip_code": "74586",
        "zip_code_suggest": {
            "context": {
                "account_id": 60635,
                "owner_context": "c:79094"
            },
            "input": "74586",
            "output": "74586"
        }
    },
    "_timestamp": 1456392826151,
    "_type": "document",
    "_version": 1,
    "found": true
}

request.json

{
    "aggregations": {
        "filtered": false,
        "global": false
    },
    "hits": true,
    "offset": 0,
    "per_page": 25,
    "query": {
        "filter": {
            "and": [
                {
                    "filter": {
                        "attribute": {
                            "data_type": "string",
                            "name": "tags",
                            "type": "field"
                        },
                        "parameter": {
                            "all": [
                                "b",
                                "c"
                            ]
                        
                    }
                }
            ]
        },
        "projection": [
            {
                "data_type": "string",
                "name": "display_name",
                "type": "field"
            },
            {
                "data_type": "string",
                "name": "tags",
                "type": "field"
            },
            {
                "data_type": "integer",
                "name": "owner",
                "type": "field"
            },
            {
                "data_type": "boolean",
                "name": "is_organisation",
                "type": "field"
            },
            {
                "data_type": "string",
                "name": "is_sales_account",
                "type": "field"
            }
        ],
        "sort": []
    },
    "requester": {
        "id": 125377,
        "type": "smart-list"
    },
    "timezone_offset": "+01:00"
}

response.json

{
    "items": [
        {
            "contact": {
                "id": "4172838",
                "display_name": "Leslie Collier",
                "tags": [
                    "a",
                    "b",
                    "c"
                ],
                "owner": {
                    "id": 79094,
                    "name": "Willa"
                },
                "is_organisation": false,
                "is_sales_account": false
            },
            "success": true,
            "metadata": {}
        },
        {
            "contact": {
                "id": "4172839",
                "display_name": "Louie Brakus",
                "tags": [
                    "b",
                    "c",
                    "d"
                ],
                "owner": {
                    "id": 79094,
                    "name": "Willa"
                },
                "is_organisation": false,
                "is_sales_account": false
            },
            "success": true,
            "metadata": {}
        },
        {
            "contact": {
                "id": "4172840",
                "display_name": "Tomas Gulgowski",
                "tags": [
                    "c",
                    "d",
                    "e"
                ],
                "owner": {
                    "id": 79094,
                    "name": "Willa"
                },
                "is_organisation": false,
                "is_sales_account": false
            },
            "success": true,
            "metadata": {}
        }
    ],
    "success": true,
    "metadata": {
        "count": 3,
        "total_count": 3,
        "suggestions": null,
        "aggregations": {
            "filtered": null,
            "global": null
        }
    }
}