Search Query

Query description

The Search Query is sent when searching in Datafari and pressing the “Enter” key or clicking on the magnifying glass:

GET https://datafariui.datafari.com/Datafari/rest/v2.0/search/select?parameters

Query parameters:

Parameter	Value	Description	Data Type
q	User input (default: :)	The user input from search bar. When the user does not enter any term in the search bar, use the default value “:” to retrieve all documents indexed in Datafari.	String
fl	List from ui-config.json	Used to display items on the search page about the document, like title, preview content, url, etc... The list of values from "queryParams": { "fields": [ ] } in the configuration file: ui-config.json. The default values in this file are: "queryParams": { "fields": [ "title", "url", "id", "extension", "preview_content", "last_modified", "crawl_date", "author", "original_file_size", "emptied", "repo_source" ] },	String
sort	score desc	Fixed value to sort the result list of documents.	String
q.op	AND	Fixed value that configure the type of search in Solr.	String
rows	10	Number of documents retrieved by the query. Fixed value.	number
start	Computed value	Is used to retrieve next page of result list. The search query must be sent with a value computed as follow: page_index * rows. Starts with 0. To have the first result page start=0, then second page is start=1*10, etc…	number
aggregator	From ui-config.json	The value of this parameter must be retrieved from this object in the ui-config.json file: “aggregator” value from searchBar.suggesters[x].type=”BASIC”.aggregator.	boolean
facet	true	Always true for filtering results with facet selections.	boolean
facet.field	{!ex=field_name}field_name made from ui-config.json	This parameter is used for result arrangement into categories (Solr functionality). It is made with all objects of type `FieldFacet` and the object of type `HierarchicalFacet` in ui-config.json: All objects `left[x].type="FieldFacet"` and `left[x].type="HierarchicalFacet"` are used to create parameters facet.field={!ex=field_name}field_name. field_name = `left[x].type="FieldFacet".field`. With the current ui-config.json content the parameters to generate are: &facet.field={!ex=author}author &facet.field={!ex=repo_source}repo_source &facet.field={!ex=extension}extension &facet.field={!ex=language}language &facet.field={!ex=urlHierarchy}urlHierarchy	String multiple
facet.query	{!key=id_index}query made from ui-config.json	This parameter is used for result arrangement into categories (Solr functionality). It is made with one object of type `QueryFacet` in ui-config.json: The object `left[x].id="date__lastmodified_facet"`is used to create multiple parameters: facet.query={!key=id_index}query. To do this, browse the `"queries"` table of the object. id: `date__lastmodified_facet` index: an index for making the “key” unique. Start with 0. query: is a query item in `"queries"` table.	String multiple

Header Parameters:

Nothing

Request Body Parameters:

Nothing

Path Parameters:

Nothing

Response description

A JSON response containing the list of documents found. All needed to display the result is in this response.

Here is the 5 main objects:

spellcheck: no use.

response: the documents and their information.

"response": {

"docs": [table of document objects
...
],
"numFound": (integer) number of documents in "docs". Used to display the total number of results (on top of result list), and to calculate the number of pages.,
"start": (integer)= start parameter of the request (position in the result list),
"maxScore": (integer) no use,
"numFoundExact": (boolean, no use) always true

}

"docs": [table of documents

    {
        "preview_content": [
            (string) The preview content of the document (2-preview content)
        ],
        "extension": (string, no use for now) The extension file (ex: "docx"),
        "author": [ (string, no use for now) table of authors name, ex:
            "Denis Dehenne", ...
        ],
        "original_file_size": (integer, no use for now) size of the file,
        "emptied": (boolean, no use for now) if the content of the file has been emptied,
        "crawl_date": (string, no use for now),
        "id": (string) the document id. Use it to find if highlight text exists for Preview content replacing (see more in "highlighting" description),
        "repo_source": (string) the source of the document (6-Source),
        "title": [(string) table of document titles. The 1-title is the first element of this table.
            "Contoso Company Goals Q1 - Q4.docx"
        ],
        "click_url": (string) the url link used to go on the document when clicking on 1-title,
        "last_modified": [(String, no use for now) last modified date of the document
            "2023-06-27T10:23:23Z"
        ],
        "url": (String) 4-url
    },
    {another document ...},
    {another document ...},
    {another document ...}

]

responseHeader: no use.

highlighting: used to display highlighted terms in the preview content.

"highlighting": {

    id of a document (ex: "id_1"): {
        "exactContent": [ (Table of String) a list of highlighted text to display in 3-highlighted text. The text is already html formatted to bold the corresponding search term(s). Example:
            "\n\n3 Check Short Term Budgeting: In Progress\nBudgets Q1-Q4: Over <span class=\"em\">Budget</span> by 12% Avg.\nCustomer Requests\n\nimage1.gif\n\n"
        ],
        "content_en": [ (Table of String) another list of highlighted text to display in 3-highlighted text. It's an english content. Example:
            "Reports Process\nInternational Sales Goals?\n\n3 Check Short Term <span class=\"em\">Budgeting</span>: In Progress\n<span class=\"em\">Budgets</span> Q1-Q4: Over <span class=\"em\">Budget</span> by 12% Avg.\nCustomer Requests\n\nimage1.gif\n\n"
        ]
    },
    id of a document (ex: "id_2"): {
        "exactContent": [
            "<span class=\"em\">BUDGET</span>\n\t      EUROPEAN BACKPACKING TRIP, SUMMER 2017\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\t\t\t\t\t<span class=\"em\">Budget</span> remaining\t\t\t\t\t\t\t\t\t<span class=\"em\">Budget</span> spent"
        ],
        "content_en": [
            "<span class=\"em\">BUDGET</span>\n\t      EUROPEAN BACKPACKING TRIP, SUMMER 2017\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\t\t\t\t\t<span class=\"em\">Budget</span> remaining\t\t\t\t\t\t\t\t\t<span class=\"em\">Budget</span> spent"
        ]
    },
    "id_3": {
        "exactContent": [
            "Fake text <span class=\"em\">search_term</span> Fake text... Another Fake text <span class=\"em\">search_term</span> Fake text..."
        ],
        "content_en": [
            "Fake text in english content <span class=\"em\">search_term</span> Fake text in english content..."
        ]
    },
    "id_4": {Another highlighting objet...}

}

facet_counts: used to fill the facets (7-Facets).

"facet_counts": {

    "facet_intervals": {description to come},
    "facet_queries": { description to come
        "date__lastmodified_facet_3": (number) more details to come
    },
    "facet_fields": {Facets field description (7-Facets)...},
    "facet_heatmaps": {description to come},
    "facet_ranges": {description to come}

}

facet_fields : This object is linked to "FieldFacet" objects in ui-config.json. It is used to fill the corresponding facets on the result page (7-Facets). Each item of this object is as follow:

“field”: [ (String,number) For the "field" Facet. A table with couples of [label,number].
“label1”, number_for_label1,
“label2”, number_for_label2,
etc...
],

“field” will have the value of “field” attribute of the "FieldFacet" object in ui-config.json (i.e. left[x].type="FieldFacet")). For example, it is "extension" with this defined in ui-config.json:
"left": [ ...
{
"type": "FieldFacet",
"title": "Extension",
"field": "extension",
"op": "OR",
"minShow": 3,
"maxShow": 15
}, ...
]

"facet_fields": { Example...

    "extension": [ For the Facet with the title "extension". In this example, there are 2 "docx" and 2 "xlsx" documents.
        "docx", 2,
        "xlsx", 2
    ],
    "language": [ For the Facet with title "Language". There are only english documents and they are 4.
        "en", 4
    ],
    "repo_source": [ For the Facet with the title "Source". There are documents only in "Simple O365" source and they are 4.
        "Simple O365", 4
    ]

}

Examples

Empty search

Here is the default request sent to the Datafari API for an empty input in the search bar:

https://datafariui.datafari.com/Datafari/rest/v2.0/search/select ?q=*:* &fl=title,url,id,extension,preview_content,last_modified,crawl_date,author,original_file_size,emptied,repo_source &sort=score desc &q.op=AND &rows=10 &start=0 &aggregator= &facet=true &facet.field={!ex=author}author &facet.field={!ex=repo_source}repo_source &facet.field={!ex=extension}extension &facet.field={!ex=language}language &facet.field={!ex=urlHierarchy}urlHierarchy &facet.query={!key=date__lastmodified_facet_0}last_modified:[NOW/DAY TO NOW] &facet.query={!key=date__lastmodified_facet_1}last_modified:[NOW/DAY-7DAY TO NOW/DAY] &facet.query={!key=date__lastmodified_facet_2}last_modified:[NOW/DAY-30DAY TO NOW/DAY-8DAY] &facet.query={!key=date__lastmodified_facet_3}last_modified:([1970-09-01T00:01:00Z TO NOW/DAY-31DAY] || [* TO 1970-08-31T23:59:59Z]) &facet.query={!key=date__lastmodified_facet_4}last_modified:[1970-09-01T00:00:00Z TO 1970-09-01T00:00:00Z]

Response:

In the detailed response below, you find the 10 documents in the response.docs objects with response.numFound=14. This last value is used to display the number of pages.

The “ids” in highlighting objects are empty, so the preview_content is displayed above.

{
    "spellcheck": {
        "collations": [],
        "suggestions": [],
        "correctlySpelled": true
    },
    "response": {
        "docs": [
            {
                "preview_content": [
                    "BUDGET\n\t      EUROPEAN BACKPACKING TRIP, SUMMER 2017\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\t\t\t\t\tBudget remaining\t\t\t\t\t\t\t\t\tBudget spent\n\t\t\t\t\tSpent:\t\t\t\t\t\t\t\t\t \tGear\tApparel\tMiscellaneous\tTravel/lodging\n\t\t\t\t\tGear\t\t$   913.00\t\t\t\t\t\t\tOctober\t$   233.00\t$   230.00\t$   240.00\t$   350.00\n\t\t\t\t\tApparel\t\t$   853.00\t\t\t\t\t\t\tNovember\t$   305.00\t$   500.00\t$   120.00\t$   450.00\n\t\t\t\t\tMiscellaneous\t\t$   650.00\t\tSUMMARY\t\t\t\t\tDecember\t$   75.00\t$   123.00\t$   260.00\t$   90.00\n\t\t\t\t\tTravel/lodging\t\t$   1,110.00\t\tTOTAL BUDGET\t\t\t\t\tJanuary\t$   300.00\t\t$   30.00\t$   220.00\n\t\t\t\t\tBUDGET REMAINING\t\t$   3,974.00\t\t$7,500\t\t\t\t\tTOTAL SPEND:\t$   913.00\t$   853.00\t$   650.00\t$   1,110.00\n\n\t\t\t\t\t\t\t\t\tBUDGET SPENT\n\t\t\t\t\t\t\t\t\t$3,500\n\n\n\t\t\t\t\t\t\t\t\tBUDGET REMAINING\n\t\t\t\t\t\t\t\t\t$4,173\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\nBUDGET SPENT TO DATE\n\nGear\tOctober\tNovember\tDecember\tJanuary\t233\t305\t75\t300\tApparel\tOctober\tNovember\tDecember\tJanuary\t230\t500\t123\tMiscellaneous\tOctober\tNovember\tDecember\tJanuary\t240\t120\t260\t30\tTravel/lodging\tOctober\tNovember\tDecember\tJanua"
                ],
                "extension": "xlsx",
                "author": [
                    "Microsoft Office User"
                ],
                "original_file_size": 41984,
                "emptied": false,
                "crawl_date": "2024-06-10T13:13:34.747Z",
                "id": "id_example_1",
                "repo_source": "Simple O365",
                "title": [
                    "European Backpacking Trip.xlsx"
                ],
                "click_url": "https://192.168.254.128/Datafari/rest/v2.0/url?url=https%3A%2F%2Fxzr8j.sharepoint.com%2Fsites%2Fwcontosoteam%2F_layouts%2F15%2FDoc.aspx%3Fsourcedoc%3D%7BE1CBF229-6BE9-4D54-B124-10BD8F3AB43B%7D%26file%3DEuropean+Backpacking+Trip.xlsx%26action%3Ddefault%26mobileredirect%3Dtrue&id=1bc853fc-297e-4f27-8e03-1c47519b01ac",
                "last_modified": [
                    "2023-06-27T10:23:32Z"
                ],
                "url": "https://xzr8j.sharepoint.com/sites/wcontosoteam/_layouts/15/Doc.aspx?sourcedoc=%7BE1CBF229-6BE9-4D54-B124-10BD8F3AB43B%7D&file=European%20Backpacking%20Trip.xlsx&action=default&mobileredirect=true"
            },
            {
                "preview_content": [
                    "Annual Report\n\n\nSALES\nOur Sales have breached previous years’ expectations and have allowed us to expand into two more regions this year: The Northwest and California.  Contoso today announced financial results for its most recent fiscal quarter. The Company posted quarterly revenue of $28.27 million and quarterly net profit of $6. 2 million, or $7.25 per diluted share. These results compare to revenue of $21.65 million and net quarterly profit of $4.45 million, or $4.74 per diluted share, in the year-ago quarter. Gross margin was 42.3 percent compared to 38.9 percent in the year-ago quarter. International sales accounted for 27 percent of the quarter’s revenue. \n\nWe are thrilled with the very strong finish of an outstanding second quarter, growing annual revenue to $108 million and growing earnings to $26 million. Customer response to our entertainment and video products has been fantastic, we have strong momentum going into the next quarter, and we remain really enthusiastic about ou"
                ],
                "extension": "docx",
                "author": [
                    "Denis Dehenne"
                ],
                "original_file_size": 74023,
                "emptied": false,
                "crawl_date": "2024-06-10T13:13:34.805Z",
                "id": "id_example_2",
                "repo_source": "Simple O365",
                "title": [
                    "Contoso Annual Report [Draft].docx"
                ],
                "click_url": "https://192.168.254.128/Datafari/rest/v2.0/url?url=https%3A%2F%2Fxzr8j.sharepoint.com%2Fsites%2Fwcontosoteam%2F_layouts%2F15%2FDoc.aspx%3Fsourcedoc%3D%7BAED29CFE-3078-4228-9C2D-AC93EA673F76%7D%26file%3DContoso+Annual+Report+%5BDraft%5D.docx%26action%3Ddefault%26mobileredirect%3Dtrue&id=1bc853fc-297e-4f27-8e03-1c47519b01ac",
                "last_modified": [
                    "2023-06-27T10:23:20Z"
                ],
                "url": "https://xzr8j.sharepoint.com/sites/wcontosoteam/_layouts/15/Doc.aspx?sourcedoc=%7BAED29CFE-3078-4228-9C2D-AC93EA673F76%7D&file=Contoso%20Annual%20Report%20[Draft].docx&action=default&mobileredirect=true"
            },
            {
                "preview_content": [
                    "Shipping Budget\n\tQT300 Accessories Specs\t\t\t\t\t\tCosts Chart\n\t\t\tContinue?\tWhich Regions?\t\t\tPackages\tCount of Package 4\n\t\t\t\t\t\t\tPackage 1\t19\n\t\t\t\t\t\t\tPackage 2\t40\n\t\t\t\t\t\t\tPackage 3\t10\n\t\t\t\t\t\t\tPackage 4\t16\n\t\t\t\t\t\t\tPackage 5\t14\n\t\t\t\t\t\t\tGrand Total\t99\n\n\n\n\nTotal\tPackage 1\tPackage 2\tPackage 3\tPackage 4\tPackage 5\t19\t40\t10\t16\t14\t\n\n\n\n\nData\n\tResults Data\n\tTest Group\tGender\tTest Option\t1\t2\t3\n\t18-25\tMale\tPackage 4\tColor\tCurious\tExcited\n\t36-45\tFemale\tPackage 2\tShape\tExcited\tExcited\n\t36-45\tFemale\tPackage 2\tShape\tInterested\tExcited\n\tOver 65\tMale\tPackage 2\tWords\tExcited\tCurious\n\t26-35\tFemale\tPackage 2\tShape\tNeutral\tExcited\n\t36-45\tFemale\tPackage 1\tShape\tConfused\tNeutral\n\t26-35\tFemale\tPackage 1\tShape\tFrustrated\tConfused\n\tOver 65\tFemale\tPackage 4\tOther\tNeutral\tFrustrated\n\t26-35\tMale\tPackage 4\tShape\tConfused\tConfused\n\t18-25\tFemale\tPackage 2\tShape\tNeutral\tInterested\n\t36-45\tMale\tPackage 2\tOther\tNeutral\tConfused\n\t46-55\tMale\tPackage 3\tWords\tNeutral\tFrustrated\n\t26-35\tMale\tPackage 1\tSymbols\tNeutral\tNeutral\n\t26-35\tMale\tPa"
                ],
                "extension": "xlsx",
                "author": [
                    "Denis Dehenne"
                ],
                "original_file_size": 34713,
                "emptied": false,
                "crawl_date": "2024-06-10T13:13:35.368Z",
                "id": "id_example_3",
                "repo_source": "Simple O365",
                "title": [
                    "QT300 Accessories Specs.xlsx"
                ],
                "click_url": "https://192.168.254.128/Datafari/rest/v2.0/url?url=https%3A%2F%2Fxzr8j.sharepoint.com%2Fsites%2Fwcontosoteam%2F_layouts%2F15%2FDoc.aspx%3Fsourcedoc%3D%7B15DCC143-2211-4D6E-B1EA-65651549C819%7D%26file%3DQT300+Accessories+Specs.xlsx%26action%3Ddefault%26mobileredirect%3Dtrue&id=1bc853fc-297e-4f27-8e03-1c47519b01ac",
                "last_modified": [
                    "2023-06-27T10:23:36Z"
                ],
                "url": "https://xzr8j.sharepoint.com/sites/wcontosoteam/_layouts/15/Doc.aspx?sourcedoc=%7B15DCC143-2211-4D6E-B1EA-65651549C819%7D&file=QT300%20Accessories%20Specs.xlsx&action=default&mobileredirect=true"
            },
            {
                "preview_content": [
                    "Contoso Annual Report\n\nAnne Wallace\nSales\nOur Sales have breached previous years’ expectations and have allowed us to expand into two more regions this year: The Northwest and California.  Contoso today announced financial results for its most recent fiscal quarter. The Company posted quarterly revenue of $28.27 million and quarterly net profit of $6. 2 million, or $7.25 per diluted share. These results compare to revenue of $21.65 million and net quarterly profit of $4.45 million, or $4.74 per diluted share, in the year-ago quarter. Gross margin was 42.3 percent compared to 38.9 percent in the year-ago quarter. International sales accounted for 27 percent of the quarter’s revenue. \n\n\nWe are thrilled with the very strong finish of an outstanding second quarter, growing annual revenue to $108 million and growing earnings to $26 million. Customer response to our entertainment and video products has been fantastic, we have strong momentum going into the next quarter, and we remain really "
                ],
                "extension": "docx",
                "author": [
                    "Denis Dehenne"
                ],
                "original_file_size": 31618,
                "emptied": false,
                "crawl_date": "2024-06-10T13:13:35.417Z",
                "id": "id_example_4",
                "repo_source": "Simple O365",
                "title": [
                    "Contoso Annual Report.docx"
                ],
                "click_url": "https://192.168.254.128/Datafari/rest/v2.0/url?url=https%3A%2F%2Fxzr8j.sharepoint.com%2Fsites%2Fwcontosoteam%2F_layouts%2F15%2FDoc.aspx%3Fsourcedoc%3D%7BC33F452E-98D7-4FCC-8E94-A75E65CB219B%7D%26file%3DContoso+Annual+Report.docx%26action%3Ddefault%26mobileredirect%3Dtrue&id=1bc853fc-297e-4f27-8e03-1c47519b01ac",
                "last_modified": [
                    "2023-06-27T10:23:21Z"
                ],
                "url": "https://xzr8j.sharepoint.com/sites/wcontosoteam/_layouts/15/Doc.aspx?sourcedoc=%7BC33F452E-98D7-4FCC-8E94-A75E65CB219B%7D&file=Contoso%20Annual%20Report.docx&action=default&mobileredirect=true"
            },
            {...},
            {...},
            {...},
            {...},
            {...},
            {...}
        ],
        "numFound": 14,
        "start": 0,
        "maxScore": 1.0,
        "numFoundExact": true
    },
    "responseHeader": {...},
    "highlighting": {
        "id_example_1": {},
        "id_example_2": {},
        "id_example_3": {},
        "id_example_4": {},
        "id_example_5": {},
        "id_example_6": {},
        "id_example_7": {},
        "id_example_8": {},
        "id_example_9": {},
        "id_example_10": {}
    },
    "facet_counts": {
        "facet_intervals": {},
        "facet_queries": {
            "date__lastmodified_facet_3": 13,
            "date__lastmodified_facet_1": 1
        },
        "facet_fields": {
            "extension": [
                "docx",
                6,
                "pptx",
                3,
                "xlsx",
                3,
                "txt",
                2
            ],
            "author": [
                "denis dehenne",
                5,
                "katie swanson (insight global, inc)",
                2,
                "garth fort",
                1,
                "microsoft office user",
                1,
                "tyler rasmussen",
                1
            ],
            "type_category": [
                "bureautique",
                1
            ],
            "language": [
                "en",
                11,
                "fr",
                2,
                "de",
                1
            ],
            "repo_source": [
                "Simple O365",
                12,
                "enron",
                2
            ],
            "urlHierarchy": [
                "0/",
                14,
                "1/xzr8j.sharepoint.com",
                12,
                "2/xzr8j.sharepoint.com/sites",
                12,
                "3/xzr8j.sharepoint.com/sites/wcontosoteam",
                12,
                "4/xzr8j.sharepoint.com/sites/wcontosoteam/_layouts",
                12,
                "5/xzr8j.sharepoint.com/sites/wcontosoteam/_layouts/15",
                12,
                "1/localhost",
                2,
                "2/localhost/enron",
                2
            ]
        },
        "facet_heatmaps": {},
        "facet_ranges": {}
    }
}

Term(s) search

Except for the “q” parameter, an empty search is not different from a search with terms. So we don’t repeat the full query here, but we specify the “q” parameter: q=budget.

Response:

In the detailed response below, you find the 4 documents in the response.docs objects with response.numFound=4

In the detailed response below, the “ids” in highlighting objects are filled with the texts displayed in the result above.

{
    "spellcheck": {
        "collations": [],
        "suggestions": [],
        "correctlySpelled": true
    },
    "response": {
        "docs": [
            {
                "preview_content": [
                    "Contoso Company Goals Q1-Q4\n\nAnne Wallace\n\nProduct Innovation\nWe will continue to provide high quality products that give consumers a reason ..."
                ],
                "extension": "docx",
                "author": [
                    "Denis Dehenne"
                ],
                "original_file_size": 528742,
                "emptied": false,
                "crawl_date": "2024-06-10T13:13:36.756Z",
                "id": "id_example_1",
                "repo_source": "Simple O365",
                "title": [
                    "Contoso Company Goals Q1 - Q4.docx"
                ],
                "click_url": "https://192.168.254.128/Datafari/rest/v2.0/url?url=https%3A%2F%2Fxzr8j.sharepoint.com%2Fsites%2Fwcontosoteam%2F_layouts%2F15%2FDoc.aspx%3Fsourcedoc%3D%7B22748EA1-9104-4104-A70F-DC90D8AA026D%7D%26file%3DContoso+Company+Goals+Q1+-+Q4.docx%26action%3Ddefault%26mobileredirect%3Dtrue&id=f8e9b996-67ba-4bf2-951c-fc4f89ad104a",
                "last_modified": [
                    "2023-06-27T10:23:23Z"
                ],
                "url": "https://xzr8j.sharepoint.com/sites/wcontosoteam/_layouts/15/Doc.aspx?sourcedoc=%7B22748EA1-9104-4104-A70F-DC90D8AA026D%7D&file=Contoso%20Company%20Goals%20Q1%20-%20Q4.docx&action=default&mobileredirect=true"
            },
            {
                "preview_content": [
                    "BUDGET\n\t      EUROPEAN BACKPACKING TRIP, SUMMER 2017\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\t\t\t\t\tBudget remaining\t\t\t\t\t\t\t\t\tBudget spent\n\t\t\t\t\tSpent:\t\t\t\t\t\t\t\t\t \tGear\tApparel\tMiscellaneous\tTravel/lodging\n\t\t\t\t\tGear\t\t$   913.00\t\t\t\t\t\t\tOctober\t$   233.00\t$   230.00\t$   240.00\t$   350.00\n\t\t\t\t\tApparel\t\t$   853.00\t\t\t\t\t\t\tNovember\t$   305.00\t$   500.00\t$   120.00\t$   450.00\n\t\t\t\t\tMiscellaneous\t\t$   650.00\t\tSUMMARY\t\t\t\t\tDecember\t$   75.00\t$   123.00\t$   260.00\t$   90.00\n\t\t\t\t\tTravel/lodging\t\t$   1,110.00\t\tTOTAL BUDGET\t\t\t\t\tJanuary\t$   300.00\t\t$   30.00\t$   220.00\n\t\t\t\t\tBUDGET REMAINING\t\t$   3,974.00\t\t$7,500\t\t\t\t\tTOTAL SPEND:\t$   913.00\t$   853.00\t$   650.00\t$   1,110.00\n\n\t\t\t\t\t\t\t\t\tBUDGET SPENT\n\t\t\t\t\t\t\t\t\t$3,500\n\n\n\t\t\t\t\t\t\t\t\tBUDGET REMAINING\n\t\t\t\t\t\t\t\t\t$4,173\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\nBUDGET SPENT TO DATE\n\nGear\tOctober\tNovember\tDecember\tJanuary\t233\t305\t75\t300\tApparel\tOctober\tNovember\tDecember\tJanuary\t230\t500\t123\tMiscellaneous\tOctober\tNovember\tDecember\tJanuary\t240\t120\t260\t30\tTravel/lodging\tOctober\tNovember\tDecember\tJanua"
                ],
                "extension": "xlsx",
                "author": [
                    "Microsoft Office User"
                ],
                "original_file_size": 41984,
                "emptied": false,
                "crawl_date": "2024-06-10T13:13:34.747Z",
                "id": "id_example_2",
                "repo_source": "Simple O365",
                "title": [
                    "European Backpacking Trip.xlsx"
                ],
                "click_url": "https://192.168.254.128/Datafari/rest/v2.0/url?url=https%3A%2F%2Fxzr8j.sharepoint.com%2Fsites%2Fwcontosoteam%2F_layouts%2F15%2FDoc.aspx%3Fsourcedoc%3D%7BE1CBF229-6BE9-4D54-B124-10BD8F3AB43B%7D%26file%3DEuropean+Backpacking+Trip.xlsx%26action%3Ddefault%26mobileredirect%3Dtrue&id=f8e9b996-67ba-4bf2-951c-fc4f89ad104a",
                "last_modified": [
                    "2023-06-27T10:23:32Z"
                ],
                "url": "https://xzr8j.sharepoint.com/sites/wcontosoteam/_layouts/15/Doc.aspx?sourcedoc=%7BE1CBF229-6BE9-4D54-B124-10BD8F3AB43B%7D&file=European%20Backpacking%20Trip.xlsx&action=default&mobileredirect=true"
            },
            {
                "preview_content": [
                    "Five Year Vision\n\nAnne Wallace\n\nLong-Term Project Costs Cataloged:  Done\nLifts and other Large Equipment\nStreamline Financial Reports Process\nCustomer Requests\n\nAnalyze Long Term Costs: NOT STARTED\nBecome Independent of Outside Researchers\nStreamline Financial Reports Process\nInternational Sales Goals?\n\nCheck Short Term Budgeting: In Progress\nBudgets: Over Budget by 12% Avg.\nCustomer Requests\n\nLitware Expense September \nBy Department\n\nR\t&\tD\t25093\t24680\t23044\t21170\t20856\t20644\t20592\tMarketing\t8735\t8768\t8471\t8966\t8205\t8286\t8161\tEngineering\t72140\t73681\t78721\t78980\t71024\t75964\t74524\tProduction\t105968\t107129\t110236\t109116\t100085\t104894\t103277\tBusiness Operations\t14461\t19432\t13132\t12886\t12973\t15345\t13622"
                ],
                "extension": "docx",
                "author": [
                    "Denis Dehenne"
                ],
                "original_file_size": 31780,
                "emptied": false,
                "crawl_date": "2024-06-10T13:13:35.998Z",
                "id": "id_example_3",
                "repo_source": "Simple O365",
                "title": [
                    "Contoso Five Year Vision.docx"
                ],
                "click_url": "https://192.168.254.128/Datafari/rest/v2.0/url?url=https%3A%2F%2Fxzr8j.sharepoint.com%2Fsites%2Fwcontosoteam%2F_layouts%2F15%2FDoc.aspx%3Fsourcedoc%3D%7BE72C3976-D76E-4D0D-A584-FEF51786872F%7D%26file%3DContoso+Five+Year+Vision.docx%26action%3Ddefault%26mobileredirect%3Dtrue&id=f8e9b996-67ba-4bf2-951c-fc4f89ad104a",
                "last_modified": [
                    "2023-06-27T10:23:24Z"
                ],
                "url": "https://xzr8j.sharepoint.com/sites/wcontosoteam/_layouts/15/Doc.aspx?sourcedoc=%7BE72C3976-D76E-4D0D-A584-FEF51786872F%7D&file=Contoso%20Five%20Year%20Vision.docx&action=default&mobileredirect=true"
            },
            {
                "preview_content": [
                    "Shipping Budget\n\tQT300 Accessories Specs\t\t\t\t\t\tCosts Chart\n\t\t\tContinue?\tWhich Regions?\t\t\tPackages\tCount of Package 4\n\t\t\t\t\t\t\tPackage 1\t19\n\t\t\t\t\t\t\tPackage 2\t40\n\t\t\t\t\t\t\tPackage 3\t10\n\t\t\t\t\t\t\tPackage 4\t16\n\t\t\t\t\t\t\tPackage 5\t14\n\t\t\t\t\t\t\tGrand Total\t99\n\n\n\n\nTotal\tPackage 1\tPackage 2\tPackage 3\tPackage 4\tPackage 5\t19\t40\t10\t16\t14\t\n\n\n\n\nData\n\tResults Data\n\tTest Group\tGender\tTest Option\t1\t2\t3\n\t18-25\tMale\tPackage 4\tColor\tCurious\tExcited\n\t36-45\tFemale\tPackage 2\tShape\tExcited\tExcited\n\t36-45\tFemale\tPackage 2\tShape\tInterested\tExcited\n\tOver 65\tMale\tPackage 2\tWords\tExcited\tCurious\n\t26-35\tFemale\tPackage 2\tShape\tNeutral\tExcited\n\t36-45\tFemale\tPackage 1\tShape\tConfused\tNeutral\n\t26-35\tFemale\tPackage 1\tShape\tFrustrated\tConfused\n\tOver 65\tFemale\tPackage 4\tOther\tNeutral\tFrustrated\n\t26-35\tMale\tPackage 4\tShape\tConfused\tConfused\n\t18-25\tFemale\tPackage 2\tShape\tNeutral\tInterested\n\t36-45\tMale\tPackage 2\tOther\tNeutral\tConfused\n\t46-55\tMale\tPackage 3\tWords\tNeutral\tFrustrated\n\t26-35\tMale\tPackage 1\tSymbols\tNeutral\tNeutral\n\t26-35\tMale\tPa"
                ],
                "extension": "xlsx",
                "author": [
                    "Denis Dehenne"
                ],
                "original_file_size": 34713,
                "emptied": false,
                "crawl_date": "2024-06-10T13:13:35.368Z",
                "id": "id_example_4",
                "repo_source": "Simple O365",
                "title": [
                    "QT300 Accessories Specs.xlsx"
                ],
                "click_url": "https://192.168.254.128/Datafari/rest/v2.0/url?url=https%3A%2F%2Fxzr8j.sharepoint.com%2Fsites%2Fwcontosoteam%2F_layouts%2F15%2FDoc.aspx%3Fsourcedoc%3D%7B15DCC143-2211-4D6E-B1EA-65651549C819%7D%26file%3DQT300+Accessories+Specs.xlsx%26action%3Ddefault%26mobileredirect%3Dtrue&id=f8e9b996-67ba-4bf2-951c-fc4f89ad104a",
                "last_modified": [
                    "2023-06-27T10:23:36Z"
                ],
                "url": "https://xzr8j.sharepoint.com/sites/wcontosoteam/_layouts/15/Doc.aspx?sourcedoc=%7B15DCC143-2211-4D6E-B1EA-65651549C819%7D&file=QT300%20Accessories%20Specs.xlsx&action=default&mobileredirect=true"
            }
        ],
        "numFound": 4,
        "start": 0,
        "maxScore": 462.94855,
        "numFoundExact": true
    },
    "responseHeader": {...},
    "highlighting": {
        "id_example_1": {
            "exactContent": [
                "\n\n3 Check Short Term Budgeting: In Progress\nBudgets Q1-Q4: Over <span class=\"em\">Budget</span> by 12% Avg.\nCustomer Requests\n\nimage1.gif\n\n"
            ],
            "content_en": [
                "Reports Process\nInternational Sales Goals?\n\n3 Check Short Term <span class=\"em\">Budgeting</span>: In Progress\n<span class=\"em\">Budgets</span> Q1-Q4: Over <span class=\"em\">Budget</span> by 12% Avg.\nCustomer Requests\n\nimage1.gif\n\n"
            ]
        },
        "id_example_2": {
            "exactContent": [
                "<span class=\"em\">BUDGET</span>\n\t      EUROPEAN BACKPACKING TRIP, SUMMER 2017\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\t\t\t\t\t<span class=\"em\">Budget</span> remaining\t\t\t\t\t\t\t\t\t<span class=\"em\">Budget</span> spent"
            ],
            "content_en": [
                "<span class=\"em\">BUDGET</span>\n\t      EUROPEAN BACKPACKING TRIP, SUMMER 2017\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\t\t\t\t\t<span class=\"em\">Budget</span> remaining\t\t\t\t\t\t\t\t\t<span class=\"em\">Budget</span> spent"
            ]
        },
        "id_example_3": {
            "exactContent": [
                "Shipping <span class=\"em\">Budget</span>\n\tQT300 Accessories Specs\t\t\t\t\t\tCosts Chart\n\t\t\tContinue?\tWhich Regions?\t\t\tPackages\tCount of Package 4\n\t\t\t\t\t\t\tPackage 1\t19\n\t\t\t\t\t\t\tPackage"
            ],
            "content_en": [
                "Shipping <span class=\"em\">Budget</span>\n\tQT300 Accessories Specs\t\t\t\t\t\tCosts Chart\n\t\t\tContinue?\tWhich Regions?\t\t\tPackages\tCount of Package 4\n\t\t\t\t\t\t\tPackage 1\t19\n\t\t\t\t\t\t\tPackage"
            ]
        },
        "id_example_4": {
            "exactContent": [
                "Sales Goals?\n\nCheck Short Term Budgeting: In Progress\nBudgets: Over <span class=\"em\">Budget</span> by 12% Avg.\nCustomer Requests\n\nLitware Expense September \nBy Department\n\nR\t&amp;\tD\t25093\t24680\t23044\t21170\t20856\t20644\t20592\tMarketing"
            ],
            "content_en": [
                "Financial Reports Process\nInternational Sales Goals?\n\nCheck Short Term <span class=\"em\">Budgeting</span>: In Progress\n<span class=\"em\">Budgets</span>: Over <span class=\"em\">Budget</span> by 12% Avg.\nCustomer Requests\n\nLitware Expense September \nBy Department\n\nR\t&amp;\tD\t25093\t24680\t23044"
            ]
        }
    },
    "facet_counts": {
        "facet_intervals": {},
        "facet_queries": {
            "date__lastmodified_facet_3": 4
        },
        "facet_fields": {
            "extension": [
                "docx",
                2,
                "xlsx",
                2
            ],
            "author": [
                "denis dehenne",
                3,
                "microsoft office user",
                1
            ],
            "type_category": [],
            "language": [
                "en",
                4
            ],
            "repo_source": [
                "Simple O365",
                4
            ],
            "urlHierarchy": [
                "0/",
                4,
                "1/xzr8j.sharepoint.com",
                4,
                "2/xzr8j.sharepoint.com/sites",
                4,
                "3/xzr8j.sharepoint.com/sites/wcontosoteam",
                4,
                "4/xzr8j.sharepoint.com/sites/wcontosoteam/_layouts",
                4,
                "5/xzr8j.sharepoint.com/sites/wcontosoteam/_layouts/15",
                4
            ]
        },
        "facet_heatmaps": {},
        "facet_ranges": {}
    }
}