QueryCorpusWQnA.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "id": "96ad09b2-5a4a-4763-8251-353030daf17a",
   "metadata": {
    "tags": []
   },
   "outputs": [],
   "source": [
    "import json\n",
    "import os\n",
    "import requests\n",
    "\n",
    "from typing import Any\n",
    "\n",
    "customer_id = \"2906470669\"\n",
    "corpus_id = \"2\"\n",
    "api_key = os.getenv(\"VECTARA_API_KEY\") or \"VECTARA_API_KEY\"\n",
    "\n",
    "post_headers = {\n",
    "    \"x-api-key\": api_key,\n",
    "    \"customer-id\": customer_id\n",
    "}"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "id": "fc312abb-5a72-410e-8052-ba11d7c7d041",
   "metadata": {
    "tags": []
   },
   "outputs": [],
   "source": [
    "def _get_query_json(query_value: str, response_mode: bool, no_title: bool):\n",
    "    \"\"\" Returns a query json. \"\"\"\n",
    "    corpus_key = dict(\n",
    "        customer_id=customer_id,\n",
    "        corpus_id=corpus_id\n",
    "    )\n",
    "    if response_mode:\n",
    "        corpus_key[\"semantics\"] = \"RESPONSE\"\n",
    "    if no_title:\n",
    "        corpus_key[\"metadata_filter\"] = \"part.is_title = false\"\n",
    "\n",
    "    summarizer = dict(\n",
    "        summarizer_prompt_name=\"vectara-experimental-summary-ext-2023-10-23-med\",\n",
    "        response_lang=\"en\",\n",
    "        max_summarized_results=5\n",
    "    )\n",
    "    query_obj = dict(\n",
    "        query=query_value,\n",
    "        num_results=10,\n",
    "        corpus_key=[corpus_key],\n",
    "        summary=[summarizer]\n",
    "    )\n",
    "    query = dict(query=[query_obj])\n",
    "\n",
    "    return json.dumps(query)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "id": "d6776dc4-caf1-4049-a66a-15ea6f63be88",
   "metadata": {
    "tags": []
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "{'responseSet': [{'response': [{'text': 'Question: Can the User make adjustments on the Cash Flow Control page?Answer: Yes, the User can make adjustments on the Cash Flow Control page. The page allows the User to override inputs made on the Step 3 input page for both Income/Expense and EBITDA growth projections. If the User chooses to make adjustments on the Cash Flow Control page, these adjustments will override any inputs made on the previous pages. It is important to note that once adjustments are made on the Cash Flow Control page, the previous inputs will no longer be visible from that page.\\n',\n",
       "     'score': 0.8108312,\n",
       "     'metadata': [{'name': 'is_title', 'value': 'true'},\n",
       "      {'name': 'title_level', 'value': '2'}],\n",
       "     'documentIndex': 0,\n",
       "     'corpusKey': {'customerId': 0,\n",
       "      'corpusId': 2,\n",
       "      'semantics': 'DEFAULT',\n",
       "      'dim': [],\n",
       "      'metadataFilter': '',\n",
       "      'lexicalInterpolationConfig': None},\n",
       "     'resultOffset': 0,\n",
       "     'resultLength': 563},\n",
       "    {'text': 'Question: Can the User make adjustments on the Cash Flow Control page?Answer: Yes, the User can make adjustments on the Cash Flow Control page. If the User chooses to input projections from the Historical Worksheet into the Cash Flow Control page, they will have the option to make adjustments to the income/expense or EBITDA growth inputs that were made on the Step 3 input page. These adjustments will override the inputs made on the Step 3 input page. Additionally, the User can directly make projections for income/expense or EBITDA on the Cash Flow Control page without using the Step 3 input page. Any inputs made on the Cash Flow Control page will also override the inputs made on the Step 3 input page.\\n',\n",
       "     'score': 0.8054869,\n",
       "     'metadata': [{'name': 'is_title', 'value': 'true'},\n",
       "      {'name': 'title_level', 'value': '2'}],\n",
       "     'documentIndex': 1,\n",
       "     'corpusKey': {'customerId': 0,\n",
       "      'corpusId': 2,\n",
       "      'semantics': 'DEFAULT',\n",
       "      'dim': [],\n",
       "      'metadataFilter': '',\n",
       "      'lexicalInterpolationConfig': None},\n",
       "     'resultOffset': 0,\n",
       "     'resultLength': 711},\n",
       "    {'text': 'Question: Can the Worksheet projections be used for the projections in the Cash Flow Control page?Answer: Yes, the Worksheet projections can be used for the projections in the Cash Flow Control page. There is an input option available on the lower portion of the Historical Worksheet Input page that allows the User to incorporate the Worksheet projections into the ThruThink analysis.By selecting this option, the Company sales total will be adjusted in the Sales Override Inputs on the Cash Flow Control page. The Company COGS % of Sales will also be adjusted in the COGS Percent of Sales Override Inputs on the Cash Flow Control page. Additionally, the Company Operating Expense projections total will be entered into the Cash Flow Operating Expense Input page, which will show up on the Cash Flow Control page under Adjustments to Operating Expense.It is important to note that these projection adjustments will replace any manual override inputs made by the User in the Cash Flow Control to Sales Override and the COGS Percent of Sales Override. The original override inputs made by the User will be lost and cannot be restored by pressing the Clear button. However, these adjustments will only affect the manual User inputs for those items on the Cash Flow Control page and will not affect any Step 3 User inputs.\\n',\n",
       "     'score': 0.7979364,\n",
       "     'metadata': [{'name': 'is_title', 'value': 'true'},\n",
       "      {'name': 'title_level', 'value': '2'}],\n",
       "     'documentIndex': 2,\n",
       "     'corpusKey': {'customerId': 0,\n",
       "      'corpusId': 2,\n",
       "      'semantics': 'DEFAULT',\n",
       "      'dim': [],\n",
       "      'metadataFilter': '',\n",
       "      'lexicalInterpolationConfig': None},\n",
       "     'resultOffset': 0,\n",
       "     'resultLength': 1320},\n",
       "    {'text': 'Even though the Historical Worksheet is a stand alone tool, the User may choose to use the Worksheet projections for the projections in the Cash Flow Control page which are the projections used in the ThruThink analysis.There is an input option that is available on the lower portion of the Historical Worksheet Input page that will incorporate the Worksheet projections into the ThruThink analysis.The Company sales total will be adjusted in the Sales Override Inputs on the Cash Flow Control page.Company COGS % of Sales will be adjusted in the COGS Percent of Sales Override Inputs on the Cash Flow Control page.The Company Operating Expense projections total will entered into the Cash Flow Operating Expense Input page which will show up on the Cash Flow Control page under Adjustments to Operating Expense.An adjustment will be made in the Scheduled Income/Expense page to zero out the effect of any inputs on those pages.Please Note-These projection adjustments will replace any manual override inputs made by the User in the Cash Flow Control to Sales Override and the COGS Percent of Sales Override.',\n",
       "     'score': 0.7916247,\n",
       "     'metadata': [{'name': 'title',\n",
       "       'value': 'Use Worksheet Projections for Cash Flow Control\\n'},\n",
       "      {'name': 'breadcrumb',\n",
       "       'value': '[\"Historical Worksheet\\\\n\",\"Category: Summary\\\\n\"]'},\n",
       "      {'name': 'lang', 'value': 'eng'},\n",
       "      {'name': 'offset', 'value': '0'},\n",
       "      {'name': 'len', 'value': '1108'}],\n",
       "     'documentIndex': 3,\n",
       "     'corpusKey': {'customerId': 0,\n",
       "      'corpusId': 2,\n",
       "      'semantics': 'DEFAULT',\n",
       "      'dim': [],\n",
       "      'metadataFilter': '',\n",
       "      'lexicalInterpolationConfig': None},\n",
       "     'resultOffset': 0,\n",
       "     'resultLength': 1108},\n",
       "    {'text': 'Question: How can the Worksheet Adjustments be removed from the Cash Flow Control page?Answer: The Worksheet Adjustments can be removed from the Cash Flow Control page by selecting the \"Remove Option\" found in the \"Input to Cash Flow Control\" button. This will undo the updates made to the Cash Flow Control page and revert it back to its original state before the Worksheet Adjustments were applied. If inputs from another source occur after removing the Worksheet Adjustments, the user can repeat the process to re-enter updated Worksheet Adjustments.\\n',\n",
       "     'score': 0.7815804,\n",
       "     'metadata': [{'name': 'is_title', 'value': 'true'},\n",
       "      {'name': 'title_level', 'value': '2'}],\n",
       "     'documentIndex': 4,\n",
       "     'corpusKey': {'customerId': 0,\n",
       "      'corpusId': 2,\n",
       "      'semantics': 'DEFAULT',\n",
       "      'dim': [],\n",
       "      'metadataFilter': '',\n",
       "      'lexicalInterpolationConfig': None},\n",
       "     'resultOffset': 0,\n",
       "     'resultLength': 554},\n",
       "    {'text': 'Question: What are the updates to the Cash Flow Control page referred to when the Input to Cash Flow Control button is used?Answer: When the Input to Cash Flow Control button is used, the updates to the Cash Flow Control page are referred to as Worksheet Adjustments. These adjustments are made in order to ensure that the Cash Flow Control page aligns with the sales and expense projections from the Historical Worksheet. By selecting the button, the Cash Flow Control page will be updated with the latest projections from the Historical Worksheet. These adjustments help to maintain accuracy and consistency between the two pages. If the Input to Cash Flow Control button has been used, the Worksheet Adjustments can also be removed by selecting the Remove Option found in the Input to Cash Flow Control button.\\n',\n",
       "     'score': 0.77907777,\n",
       "     'metadata': [{'name': 'is_title', 'value': 'true'},\n",
       "      {'name': 'title_level', 'value': '2'}],\n",
       "     'documentIndex': 4,\n",
       "     'corpusKey': {'customerId': 0,\n",
       "      'corpusId': 2,\n",
       "      'semantics': 'DEFAULT',\n",
       "      'dim': [],\n",
       "      'metadataFilter': '',\n",
       "      'lexicalInterpolationConfig': None},\n",
       "     'resultOffset': 0,\n",
       "     'resultLength': 814},\n",
       "    {'text': 'If the button is not used, the User will need to proceed to either the Cash Flow Control page or Step 3, the Sales/EBITDA Input page to make alternate inputs.When the Input to Cash Flow Control button is used, the updates to the Cash Flow Control page are referred to as Worksheet Adjustments and are made in order that the Cash Flow Control page will match the Worksheet projections.If the Input to Cash Flow Control button has been used, the Worksheet Adjustments may also be removed by selecting the Remove Option found in the Input to Cash Flow Control button.After updating the Cash Flow Control page with the Worksheet Adjustments, if inputs from another source occur, the User should remove the old Worksheet Adjustments and repeat the process to re-enter updated Worksheet Adjustments.',\n",
       "     'score': 0.7785512,\n",
       "     'metadata': [{'name': 'title',\n",
       "       'value': 'Category: Historical Worksheet\\n'},\n",
       "      {'name': 'breadcrumb',\n",
       "       'value': '[\"Historical Worksheet - Input to Cash Flow Control\\\\n...\"]'},\n",
       "      {'name': 'lang', 'value': 'eng'},\n",
       "      {'name': 'offset', 'value': '346'},\n",
       "      {'name': 'len', 'value': '793'}],\n",
       "     'documentIndex': 5,\n",
       "     'corpusKey': {'customerId': 0,\n",
       "      'corpusId': 2,\n",
       "      'semantics': 'DEFAULT',\n",
       "      'dim': [],\n",
       "      'metadataFilter': '',\n",
       "      'lexicalInterpolationConfig': None},\n",
       "     'resultOffset': 0,\n",
       "     'resultLength': 793},\n",
       "    {'text': 'Question: Can the user override the Step 3 inputs on the Cash Flow Control page?Answer: Yes, the user has the option to override the Step 3 inputs on the Cash Flow Control page. If the user chooses to make projections for Income/Expense or EBITDA directly on the Cash Flow Control page, these inputs will override any inputs made on the Step 3 input page. Additionally, if the user has made override inputs for each of the Step 3 inputs on the Cash Flow Control page, they will continue to have the opportunity to make adjustments on that page, which will then override the inputs made on the Step 3 input page.\\n',\n",
       "     'score': 0.77738184,\n",
       "     'metadata': [{'name': 'is_title', 'value': 'true'},\n",
       "      {'name': 'title_level', 'value': '2'}],\n",
       "     'documentIndex': 6,\n",
       "     'corpusKey': {'customerId': 0,\n",
       "      'corpusId': 2,\n",
       "      'semantics': 'DEFAULT',\n",
       "      'dim': [],\n",
       "      'metadataFilter': '',\n",
       "      'lexicalInterpolationConfig': None},\n",
       "     'resultOffset': 0,\n",
       "     'resultLength': 612},\n",
       "    {'text': 'On the Cash Flow Control page, the User will have the opportunity to make adjustments and overrides to the inputs transferred from the Historical Worksheet.',\n",
       "     'score': 0.7766611,\n",
       "     'metadata': [{'name': 'title',\n",
       "       'value': 'Question: What does EBITDA stand for?Answer: EBITDA stands for Earnings before Interest, Income Taxes, Depreciation, and Amortization.\\n'},\n",
       "      {'name': 'lang', 'value': 'eng'},\n",
       "      {'name': 'section', 'value': '1'},\n",
       "      {'name': 'offset', 'value': '686'},\n",
       "      {'name': 'len', 'value': '156'}],\n",
       "     'documentIndex': 1,\n",
       "     'corpusKey': {'customerId': 0,\n",
       "      'corpusId': 2,\n",
       "      'semantics': 'DEFAULT',\n",
       "      'dim': [],\n",
       "      'metadataFilter': '',\n",
       "      'lexicalInterpolationConfig': None},\n",
       "     'resultOffset': 0,\n",
       "     'resultLength': 156},\n",
       "    {'text': 'Question: What does the Cash Flow Control page reflect?Answer: The Cash Flow Control page reflects the cash flow results from the user inputs in the Step Process. It provides a layout of the cash flow for the horizon years chosen by the user. The page allows the user to make manual adjustments or additional inputs in the yellow input boxes. By entering adjustments for sales, cost of goods sold, overhead expenses, debt payments, capital expenditures, and non-business cash payments, the user can observe the effect on the annual and cumulative cash balance listed at the top and bottom of the page. The page also provides the ability to manage cash by making extra debt paydowns or drawing on loans as cash flow dictates. Additionally, the income tax expense on the Cash Flow Control page reflects the inputs made by the user.\\n',\n",
       "     'score': 0.77366614,\n",
       "     'metadata': [{'name': 'is_title', 'value': 'true'},\n",
       "      {'name': 'title_level', 'value': '2'}],\n",
       "     'documentIndex': 7,\n",
       "     'corpusKey': {'customerId': 0,\n",
       "      'corpusId': 2,\n",
       "      'semantics': 'DEFAULT',\n",
       "      'dim': [],\n",
       "      'metadataFilter': '',\n",
       "      'lexicalInterpolationConfig': None},\n",
       "     'resultOffset': 0,\n",
       "     'resultLength': 830}],\n",
       "   'status': [],\n",
       "   'document': [{'id': 'EBITDA_EBITDAInput_qna.md',\n",
       "     'metadata': [{'name': 'title',\n",
       "       'value': 'Question: What is EBITDA an acronym for?Answer: EBITDA is an acronym for Earnings before Interest, Income Taxes, Depreciation, and Amortization.\\n'},\n",
       "      {'name': 'url', 'value': ''},\n",
       "      {'name': 'category', 'value': 'EBITDA'},\n",
       "      {'name': 'category_slug', 'value': 'EBITDA'},\n",
       "      {'name': 'slug', 'value': 'EBITDAInput'},\n",
       "      {'name': 'file_name', 'value': 'EBITDA_EBITDAInput_qna.md'},\n",
       "      {'name': 'file_path', 'value': './qna/EBITDA_EBITDAInput_qna.md'},\n",
       "      {'name': 'qna', 'value': 'true'}]},\n",
       "    {'id': 'Expenses_ExpenseInput_qna.md',\n",
       "     'metadata': [{'name': 'title',\n",
       "       'value': 'Question: What does EBITDA stand for?Answer: EBITDA stands for Earnings before Interest, Income Taxes, Depreciation, and Amortization.\\n'},\n",
       "      {'name': 'url', 'value': ''},\n",
       "      {'name': 'category', 'value': 'Expenses'},\n",
       "      {'name': 'category_slug', 'value': 'Expenses'},\n",
       "      {'name': 'slug', 'value': 'ExpenseInput'},\n",
       "      {'name': 'file_name', 'value': 'Expenses_ExpenseInput_qna.md'},\n",
       "      {'name': 'file_path', 'value': './qna/Expenses_ExpenseInput_qna.md'},\n",
       "      {'name': 'qna', 'value': 'true'}]},\n",
       "    {'id': 'Summary_HistoricalWorksheet_qna.md',\n",
       "     'metadata': [{'name': 'title',\n",
       "       'value': 'Question: What is the purpose of the Historical Worksheet?Answer: The purpose of the Historical Worksheet is to allow the user to input historical performance data in a format that is requested by the ThruThink analysis. It assists the user in making sound projections based on historical performance. The Historical Worksheet is a stand-alone analysis tool that does not affect the calculations in the ThruThink analysis. It provides calculation results that are examples of the results requested in the Sales/EBITDA Input page and the Accounts Payable Future Terms Set-Up page of the ThruThink analysis. These numbers can be helpful in guiding the inputs requested in those forms. Additionally, the user has the option to use the projections from the Historical Worksheet for the projections in the Cash Flow Control page, which are the projections used in the ThruThink analysis. There is an input option available on the Historical Worksheet Input page to incorporate the Worksheet projections into the ThruThink analysis. However, it is important to note that using the Worksheet projections will replace any manual override inputs made by the user in the Cash Flow Control to Sales Override and the COGS Percent of Sales Override. These original override inputs will be lost and cannot be restored by pressing the Clear button.\\n'},\n",
       "      {'name': 'url', 'value': ''},\n",
       "      {'name': 'category', 'value': 'Summary'},\n",
       "      {'name': 'category_slug', 'value': 'Summary'},\n",
       "      {'name': 'slug', 'value': 'HistoricalWorksheet'},\n",
       "      {'name': 'file_name', 'value': 'Summary_HistoricalWorksheet_qna.md'},\n",
       "      {'name': 'file_path',\n",
       "       'value': './qna/Summary_HistoricalWorksheet_qna.md'},\n",
       "      {'name': 'qna', 'value': 'true'}]},\n",
       "    {'id': 'Summary_HistoricalWorksheet.md',\n",
       "     'metadata': [{'name': 'title', 'value': 'Historical Worksheet\\n'},\n",
       "      {'name': 'category', 'value': 'Summary'},\n",
       "      {'name': 'category_slug', 'value': 'Summary'},\n",
       "      {'name': 'slug', 'value': 'HistoricalWorksheet'},\n",
       "      {'name': 'file_name', 'value': 'Summary_HistoricalWorksheet.md'}]},\n",
       "    {'id': 'HistoricalWorksheet_HistoricalWorksheetInputtoCashFlowControl_qna.md',\n",
       "     'metadata': [{'name': 'title',\n",
       "       'value': 'Question: How can the projections on the Historical Worksheet be used on the Cash Flow Control page?Answer: The projections on the Historical Worksheet can be used on the Cash Flow Control page by selecting the button \"Input to Cash Flow Control\" located at the lower right portion of the Historical Worksheet. This button updates the Cash Flow Control page with the sales and expense projections from the Historical Worksheet. By using this button, the Cash Flow Control page will be adjusted to match the projections on the Historical Worksheet. If the button is not used, the user will need to manually input the sales and expense projections on either the Cash Flow Control page or the Sales/EBITDA Input page. It is important to note that if the Input to Cash Flow Control button has been used and the user wants to remove the Worksheet Adjustments, they can do so by selecting the Remove Option found in the Input to Cash Flow Control button. Additionally, if inputs from another source occur after updating the Cash Flow Control page with the Worksheet Adjustments, the user should remove the old Worksheet Adjustments and repeat the process to re-enter the updated Worksheet Adjustments.\\n'},\n",
       "      {'name': 'url', 'value': ''},\n",
       "      {'name': 'category', 'value': 'Historical Worksheet'},\n",
       "      {'name': 'category_slug', 'value': 'HistoricalWorksheet'},\n",
       "      {'name': 'slug', 'value': 'HistoricalWorksheetInputtoCashFlowControl'},\n",
       "      {'name': 'file_name',\n",
       "       'value': 'HistoricalWorksheet_HistoricalWorksheetInputtoCashFlowControl_qna.md'},\n",
       "      {'name': 'file_path',\n",
       "       'value': './qna/HistoricalWorksheet_HistoricalWorksheetInputtoCashFlowControl_qna.md'},\n",
       "      {'name': 'qna', 'value': 'true'}]},\n",
       "    {'id': 'HistoricalWorksheet_HistoricalWorksheetInputtoCashFlowControl.md',\n",
       "     'metadata': [{'name': 'title',\n",
       "       'value': 'Historical Worksheet - Input to Cash Flow Control\\n'},\n",
       "      {'name': 'category', 'value': 'Historical Worksheet'},\n",
       "      {'name': 'category_slug', 'value': 'HistoricalWorksheet'},\n",
       "      {'name': 'slug', 'value': 'HistoricalWorksheetInputtoCashFlowControl'},\n",
       "      {'name': 'file_name',\n",
       "       'value': 'HistoricalWorksheet_HistoricalWorksheetInputtoCashFlowControl.md'}]},\n",
       "    {'id': 'Income_IncomeInput_qna.md',\n",
       "     'metadata': [{'name': 'title',\n",
       "       'value': 'Question: What does EBITDA stand for?Answer: EBITDA stands for Earnings before Interest, Income Taxes, Depreciation, and Amortization.\\n'},\n",
       "      {'name': 'url', 'value': ''},\n",
       "      {'name': 'category', 'value': 'Income'},\n",
       "      {'name': 'category_slug', 'value': 'Income'},\n",
       "      {'name': 'slug', 'value': 'IncomeInput'},\n",
       "      {'name': 'file_name', 'value': 'Income_IncomeInput_qna.md'},\n",
       "      {'name': 'file_path', 'value': './qna/Income_IncomeInput_qna.md'},\n",
       "      {'name': 'qna', 'value': 'true'}]},\n",
       "    {'id': 'Cash_CashFlowControl_qna.md',\n",
       "     'metadata': [{'name': 'title',\n",
       "       'value': 'Question: What does the Cash Flow Control page reflect?Answer: The Cash Flow Control page reflects the cash flow results from the user inputs in the Step Process. It provides a layout of the cash flow for the horizon years chosen by the user. The page allows the user to make manual adjustments or additional inputs in the yellow input boxes. By entering adjustments for sales, cost of goods sold, overhead expenses, debt payments, capital expenditures, and non-business cash payments, the user can observe the effect on the annual and cumulative cash balance listed at the top and bottom of the page. The page also provides the ability to manage cash by making extra debt paydowns or drawing on loans as cash flow dictates. Additionally, the income tax expense on the Cash Flow Control page reflects the inputs made by the user.\\n'},\n",
       "      {'name': 'url', 'value': ''},\n",
       "      {'name': 'category', 'value': 'Cash'},\n",
       "      {'name': 'category_slug', 'value': 'Cash'},\n",
       "      {'name': 'slug', 'value': 'CashFlowControl'},\n",
       "      {'name': 'file_name', 'value': 'Cash_CashFlowControl_qna.md'},\n",
       "      {'name': 'file_path', 'value': './qna/Cash_CashFlowControl_qna.md'},\n",
       "      {'name': 'qna', 'value': 'true'}]}],\n",
       "   'generated': [],\n",
       "   'summary': [{'text': 'Yes, in ThruThink, you can make adjustments on the Cash Flow Control page. These adjustments can override inputs made on the Step 3 input page for both Income/Expense and EBITDA growth projections [1]. You also have the option to input projections from the Historical Worksheet into the Cash Flow Control page [2]. If you choose to use the Worksheet projections, the Company sales total, COGS % of Sales, and Operating Expense projections total will be adjusted accordingly on the Cash Flow Control page [3][4]. However, these adjustments will replace any manual override inputs made by the User in the Cash Flow Control to Sales Override and the COGS Percent of Sales Override [4]. If you wish to remove the Worksheet Adjustments, you can do so by selecting the \"Remove Option\" found in the \"Input to Cash Flow Control\" button [5].',\n",
       "     'lang': 'eng',\n",
       "     'prompt': '',\n",
       "     'status': [],\n",
       "     'futureId': 2}],\n",
       "   'futureId': 1}],\n",
       " 'status': [],\n",
       " 'metrics': None}"
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "query = \"In ThruThink can I make adjustments on the Cash Flow Control page?\"\n",
    "response = requests.post(\n",
    "    f\"https://api.vectara.io/v1/query\",\n",
    "    data=_get_query_json(query, False, False),\n",
    "    verify=True,\n",
    "    headers=post_headers)\n",
    "\n",
    "if response.status_code != 200:\n",
    "    print(f\"Query failed with code {response.status_code}, reason {response.reason}, text {response.text}\")\n",
    "\n",
    "# print(f\"Code {response.status_code}, reason {response.reason}, text {response.text}\")\n",
    "res = json.loads(response.text)\n",
    "res"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "id": "b9eb3c74-47ae-4676-a96f-d3cb21880dc4",
   "metadata": {
    "tags": []
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "{'responseSet': [{'response': [{'text': 'Category: ThruThink\\n',\n",
       "     'score': 0.7805325,\n",
       "     'metadata': [{'name': 'is_title', 'value': 'true'},\n",
       "      {'name': 'title_level', 'value': '3'}],\n",
       "     'documentIndex': 0,\n",
       "     'corpusKey': {'customerId': 0,\n",
       "      'corpusId': 2,\n",
       "      'semantics': 'DEFAULT',\n",
       "      'dim': [],\n",
       "      'metadataFilter': '',\n",
       "      'lexicalInterpolationConfig': None},\n",
       "     'resultOffset': 0,\n",
       "     'resultLength': 20},\n",
       "    {'text': 'Category: ThruThink\\n',\n",
       "     'score': 0.7805325,\n",
       "     'metadata': [{'name': 'is_title', 'value': 'true'},\n",
       "      {'name': 'title_level', 'value': '3'}],\n",
       "     'documentIndex': 1,\n",
       "     'corpusKey': {'customerId': 0,\n",
       "      'corpusId': 2,\n",
       "      'semantics': 'DEFAULT',\n",
       "      'dim': [],\n",
       "      'metadataFilter': '',\n",
       "      'lexicalInterpolationConfig': None},\n",
       "     'resultOffset': 0,\n",
       "     'resultLength': 20},\n",
       "    {'text': 'ThruThink reserves the right to set an upper limit on the number of individual projects or combinations at some point in the future due to unforseen storage or computation issues in the future',\n",
       "     'score': 0.7763537,\n",
       "     'metadata': [{'name': 'title', 'value': 'Resource Usage Policy\\n'},\n",
       "      {'name': 'breadcrumb',\n",
       "       'value': '[\"Pricing By Type of Accounts\\\\n\",\"Category: ThruThink\\\\n\"]'},\n",
       "      {'name': 'lang', 'value': 'eng'},\n",
       "      {'name': 'section', 'value': '4'},\n",
       "      {'name': 'offset', 'value': '0'},\n",
       "      {'name': 'len', 'value': '192'}],\n",
       "     'documentIndex': 1,\n",
       "     'corpusKey': {'customerId': 0,\n",
       "      'corpusId': 2,\n",
       "      'semantics': 'DEFAULT',\n",
       "      'dim': [],\n",
       "      'metadataFilter': '',\n",
       "      'lexicalInterpolationConfig': None},\n",
       "     'resultOffset': 0,\n",
       "     'resultLength': 192},\n",
       "    {'text': 'The ThruThink analysis presents the User Inputs on an Accrual  Basis.',\n",
       "     'score': 0.76887167,\n",
       "     'metadata': [{'name': 'title', 'value': 'Category: Accrual\\n'},\n",
       "      {'name': 'breadcrumb', 'value': '[\"Accrual Basis\\\\n\"]'},\n",
       "      {'name': 'lang', 'value': 'eng'},\n",
       "      {'name': 'offset', 'value': '424'},\n",
       "      {'name': 'len', 'value': '69'}],\n",
       "     'documentIndex': 2,\n",
       "     'corpusKey': {'customerId': 0,\n",
       "      'corpusId': 2,\n",
       "      'semantics': 'DEFAULT',\n",
       "      'dim': [],\n",
       "      'metadataFilter': '',\n",
       "      'lexicalInterpolationConfig': None},\n",
       "     'resultOffset': 0,\n",
       "     'resultLength': 69},\n",
       "    {'text': 'ARRAffinity                            App.thruthink.com    Used to distribute traffic to the website on      Session         HTTP Cookie\\n                                                  several servers in order to optimize response\\ntimes.',\n",
       "     'score': 0.76763815,\n",
       "     'metadata': [{'name': 'lang', 'value': 'eng'},\n",
       "      {'name': 'section', 'value': '54'},\n",
       "      {'name': 'offset', 'value': '0'},\n",
       "      {'name': 'len', 'value': '240'}],\n",
       "     'documentIndex': 3,\n",
       "     'corpusKey': {'customerId': 0,\n",
       "      'corpusId': 2,\n",
       "      'semantics': 'DEFAULT',\n",
       "      'dim': [],\n",
       "      'metadataFilter': '',\n",
       "      'lexicalInterpolationConfig': None},\n",
       "     'resultOffset': 0,\n",
       "     'resultLength': 240},\n",
       "    {'text': 'The ThruThink analysis illustrates the projected performance of a business in concert with its debt and equity structure.Before beginning the Input Process (Step Process), if there are historical operating results for the Company available, this information should be entered into the Historical Worksheet in the ThruThink analysis.',\n",
       "     'score': 0.766939,\n",
       "     'metadata': [{'name': 'title', 'value': 'Category: Summary\\n'},\n",
       "      {'name': 'breadcrumb',\n",
       "       'value': '[\"Historical Worksheet - Before Beginning\\\\n\"]'},\n",
       "      {'name': 'lang', 'value': 'eng'},\n",
       "      {'name': 'offset', 'value': '0'},\n",
       "      {'name': 'len', 'value': '332'}],\n",
       "     'documentIndex': 4,\n",
       "     'corpusKey': {'customerId': 0,\n",
       "      'corpusId': 2,\n",
       "      'semantics': 'DEFAULT',\n",
       "      'dim': [],\n",
       "      'metadataFilter': '',\n",
       "      'lexicalInterpolationConfig': None},\n",
       "     'resultOffset': 0,\n",
       "     'resultLength': 332},\n",
       "    {'text': 'Question: Who can give access permission to specific individuals in ThruThink?Answer: In ThruThink, the \"Author\" has the ability to give access permission to specific individuals. This means that the Author can grant access to individuals such as the Division Manager, VP of Manufacturing, Senior VP of Operations, and the CEO.\\n',\n",
       "     'score': 0.7653224,\n",
       "     'metadata': [{'name': 'is_title', 'value': 'true'},\n",
       "      {'name': 'title_level', 'value': '2'}],\n",
       "     'documentIndex': 5,\n",
       "     'corpusKey': {'customerId': 0,\n",
       "      'corpusId': 2,\n",
       "      'semantics': 'DEFAULT',\n",
       "      'dim': [],\n",
       "      'metadataFilter': '',\n",
       "      'lexicalInterpolationConfig': None},\n",
       "     'resultOffset': 0,\n",
       "     'resultLength': 328},\n",
       "    {'text': 'Question: What does ThruThink reserve the right to do in the future?Answer: In the future, ThruThink reserves the right to set an upper limit on the number of individual projects or combinations. This is due to potential storage or computation issues that may arise.\\n',\n",
       "     'score': 0.7637368,\n",
       "     'metadata': [{'name': 'is_title', 'value': 'true'},\n",
       "      {'name': 'title_level', 'value': '2'}],\n",
       "     'documentIndex': 5,\n",
       "     'corpusKey': {'customerId': 0,\n",
       "      'corpusId': 2,\n",
       "      'semantics': 'DEFAULT',\n",
       "      'dim': [],\n",
       "      'metadataFilter': '',\n",
       "      'lexicalInterpolationConfig': None},\n",
       "     'resultOffset': 0,\n",
       "     'resultLength': 267},\n",
       "    {'text': 'The ThruThink analysis requires the input of historical operating results for the company in order to generate a comprehensive evaluation of the projected performance of the business.',\n",
       "     'score': 0.76344365,\n",
       "     'metadata': [{'name': 'title',\n",
       "       'value': 'Question: What information is used in the ThruThink Evaluation?Answer: The ThruThink Evaluation uses information from the Historical Worksheet. This includes historical operating results for the company. By entering this historical information into the Historical Worksheet before beginning the input process, it allows the user to make informed input decisions and provides a basis of comparison in a similar format as the ThruThink analysis. The Evaluation and Deal Score will not be complete unless the historical information is provided.\\n'},\n",
       "      {'name': 'lang', 'value': 'eng'},\n",
       "      {'name': 'section', 'value': '4'},\n",
       "      {'name': 'offset', 'value': '191'},\n",
       "      {'name': 'len', 'value': '183'}],\n",
       "     'documentIndex': 6,\n",
       "     'corpusKey': {'customerId': 0,\n",
       "      'corpusId': 2,\n",
       "      'semantics': 'DEFAULT',\n",
       "      'dim': [],\n",
       "      'metadataFilter': '',\n",
       "      'lexicalInterpolationConfig': None},\n",
       "     'resultOffset': 0,\n",
       "     'resultLength': 183},\n",
       "    {'text': 'Access the ThruThink software.',\n",
       "     'score': 0.75937855,\n",
       "     'metadata': [{'name': 'title',\n",
       "       'value': 'Question: Where can the TTM DSC calculation be found in ThruThink?Answer: The TTM DSC calculation can be found in ThruThink through the Information Browser - Projection Guidance to Actual to Date page. It is located on the right portion of the page under Month 12.\\n'},\n",
       "      {'name': 'lang', 'value': 'eng'},\n",
       "      {'name': 'section', 'value': '5'},\n",
       "      {'name': 'offset', 'value': '243'},\n",
       "      {'name': 'len', 'value': '30'}],\n",
       "     'documentIndex': 7,\n",
       "     'corpusKey': {'customerId': 0,\n",
       "      'corpusId': 2,\n",
       "      'semantics': 'DEFAULT',\n",
       "      'dim': [],\n",
       "      'metadataFilter': '',\n",
       "      'lexicalInterpolationConfig': None},\n",
       "     'resultOffset': 0,\n",
       "     'resultLength': 30}],\n",
       "   'status': [],\n",
       "   'document': [{'id': 'ThruThink_CustomerAssistance.md',\n",
       "     'metadata': [{'name': 'title', 'value': 'Customer Assistance\\n'},\n",
       "      {'name': 'category', 'value': 'ThruThink'},\n",
       "      {'name': 'category_slug', 'value': 'ThruThink'},\n",
       "      {'name': 'slug', 'value': 'CustomerAssistance'},\n",
       "      {'name': 'file_name', 'value': 'ThruThink_CustomerAssistance.md'}]},\n",
       "    {'id': 'ThruThink_PricingByTypeOfAccounts.md',\n",
       "     'metadata': [{'name': 'title', 'value': 'Pricing By Type of Accounts\\n'},\n",
       "      {'name': 'category', 'value': 'ThruThink'},\n",
       "      {'name': 'category_slug', 'value': 'ThruThink'},\n",
       "      {'name': 'slug', 'value': 'PricingByTypeOfAccounts'},\n",
       "      {'name': 'file_name', 'value': 'ThruThink_PricingByTypeOfAccounts.md'}]},\n",
       "    {'id': 'Accrual_AccrualBasis.md',\n",
       "     'metadata': [{'name': 'title', 'value': 'Accrual Basis\\n'},\n",
       "      {'name': 'category', 'value': 'Accrual'},\n",
       "      {'name': 'category_slug', 'value': 'Accrual'},\n",
       "      {'name': 'slug', 'value': 'AccrualBasis'},\n",
       "      {'name': 'file_name', 'value': 'Accrual_AccrualBasis.md'}]},\n",
       "    {'id': 'ThruThink Cookie Policy.pdf',\n",
       "     'metadata': [{'name': 'CreationDate', 'value': '1527555084'},\n",
       "      {'name': 'Producer', 'value': 'Microsoft® Word 2013'},\n",
       "      {'name': 'Creator', 'value': 'Microsoft® Word 2013'},\n",
       "      {'name': 'ModDate', 'value': '1527555084'},\n",
       "      {'name': 'title', 'value': 'Posted/Revised: May 26, 2018'},\n",
       "      {'name': 'url',\n",
       "       'value': 'https://app.thruthink.com/docs/ThruThink Cookie Policy.pdf'},\n",
       "      {'name': 'category', 'value': 'Customer Use Policies'},\n",
       "      {'name': 'category_slug', 'value': 'CookiePolicy'},\n",
       "      {'name': 'slug', 'value': ''},\n",
       "      {'name': 'file_name', 'value': 'ThruThink Cookie Policy.pdf'},\n",
       "      {'name': 'file_path', 'value': 'pdf/ThruThink Cookie Policy.pdf'}]},\n",
       "    {'id': 'Summary_HistoricalWorksheetBeforeBeginning.md',\n",
       "     'metadata': [{'name': 'title',\n",
       "       'value': 'Historical Worksheet - Before Beginning\\n'},\n",
       "      {'name': 'category', 'value': 'Summary'},\n",
       "      {'name': 'category_slug', 'value': 'Summary'},\n",
       "      {'name': 'slug', 'value': 'HistoricalWorksheetBeforeBeginning'},\n",
       "      {'name': 'file_name',\n",
       "       'value': 'Summary_HistoricalWorksheetBeforeBeginning.md'}]},\n",
       "    {'id': 'ThruThink_PricingByTypeOfAccounts_qna.md',\n",
       "     'metadata': [{'name': 'title',\n",
       "       'value': 'Question: What is included in the Individual Quick Deal purchase?Answer: The Individual Quick Deal purchase includes a ThruThink Evaluation and a report containing a Deal Summary, Balance Sheet, Income Statement, Cash Flow, and Sources and Uses of Cash. It does not involve a subscription to the ThruThink site. Additionally, the purchase price of the Individual Quick Deal can be applied to a subscription within 3 months of purchasing the analysis.\\n'},\n",
       "      {'name': 'url', 'value': ''},\n",
       "      {'name': 'category', 'value': 'ThruThink'},\n",
       "      {'name': 'category_slug', 'value': 'ThruThink'},\n",
       "      {'name': 'slug', 'value': 'PricingByTypeOfAccounts'},\n",
       "      {'name': 'file_name',\n",
       "       'value': 'ThruThink_PricingByTypeOfAccounts_qna.md'},\n",
       "      {'name': 'file_path',\n",
       "       'value': './qna/ThruThink_PricingByTypeOfAccounts_qna.md'},\n",
       "      {'name': 'qna', 'value': 'true'}]},\n",
       "    {'id': 'Summary_HistoricalWorksheetBeforeBeginning_qna.md',\n",
       "     'metadata': [{'name': 'title',\n",
       "       'value': 'Question: What does the ThruThink analysis illustrate?Answer: The ThruThink analysis illustrates the projected performance of a business in conjunction with its debt and equity structure.\\n'},\n",
       "      {'name': 'url', 'value': ''},\n",
       "      {'name': 'category', 'value': 'Summary'},\n",
       "      {'name': 'category_slug', 'value': 'Summary'},\n",
       "      {'name': 'slug', 'value': 'HistoricalWorksheetBeforeBeginning'},\n",
       "      {'name': 'file_name',\n",
       "       'value': 'Summary_HistoricalWorksheetBeforeBeginning_qna.md'},\n",
       "      {'name': 'file_path',\n",
       "       'value': './qna/Summary_HistoricalWorksheetBeforeBeginning_qna.md'},\n",
       "      {'name': 'qna', 'value': 'true'}]},\n",
       "    {'id': 'DebtServiceCoverage_DebtServiceCoverage_qna.md',\n",
       "     'metadata': [{'name': 'title',\n",
       "       'value': 'Question: What is Debt Service Coverage expressed as?Answer: Debt Service Coverage is expressed as a ratio called the Debt Service Coverage (DSC) Ratio.\\n'},\n",
       "      {'name': 'url', 'value': ''},\n",
       "      {'name': 'category', 'value': 'Debt Service Coverage'},\n",
       "      {'name': 'category_slug', 'value': 'DebtServiceCoverage'},\n",
       "      {'name': 'slug', 'value': 'DebtServiceCoverage'},\n",
       "      {'name': 'file_name',\n",
       "       'value': 'DebtServiceCoverage_DebtServiceCoverage_qna.md'},\n",
       "      {'name': 'file_path',\n",
       "       'value': './qna/DebtServiceCoverage_DebtServiceCoverage_qna.md'},\n",
       "      {'name': 'qna', 'value': 'true'}]}],\n",
       "   'generated': [],\n",
       "   'summary': [{'text': 'The returned results did not contain sufficient information to be summarized into a useful answer for your query. Please try a different search or restate your query differently.',\n",
       "     'lang': 'eng',\n",
       "     'prompt': '',\n",
       "     'status': [],\n",
       "     'futureId': 2}],\n",
       "   'futureId': 1}],\n",
       " 'status': [],\n",
       " 'metrics': None}"
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "query = \"What is ThruThink?\"\n",
    "response = requests.post(\n",
    "    f\"https://api.vectara.io/v1/query\",\n",
    "    data=_get_query_json(query, False, False),\n",
    "    verify=True,\n",
    "    headers=post_headers)\n",
    "\n",
    "if response.status_code != 200:\n",
    "    print(f\"Query failed with code {response.status_code}, reason {response.reason}, text {response.text}\")\n",
    "\n",
    "# print(f\"Code {response.status_code}, reason {response.reason}, text {response.text}\")\n",
    "res = json.loads(response.text)\n",
    "res"
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3 (ipykernel)",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.9.13"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}