# Legacy Experience

- [Getting Started](/legacy/legacy-experience/readme.md): Learn how to start your automation journey in Kognitos.
- [Logging In](/legacy/legacy-experience/readme/logging-into-kognitos.md): Follow these steps to log into Kognitos and securely access your account.
- [Account Setup](/legacy/legacy-experience/readme/account-setup.md): This guide will walk you through setting up and configuring your new Kognitos account.
- [Core Concepts & Definitions](/legacy/legacy-experience/readme/core-concepts.md): Learn about the core concepts and components of Kognitos.
- [Writing Automations](/legacy/legacy-experience/writing-automations.md)
- [Automation Basics](/legacy/legacy-experience/writing-automations/automation-basics.md): Learn the fundamentals of writing automations in Kognitos.
- [Defining Data](/legacy/legacy-experience/writing-automations/automation-basics/defining-data.md): Learn how to define data in Kognitos.
- [Comments](/legacy/legacy-experience/writing-automations/automation-basics/comments.md): Use comments to add notes or disable parts of your automation.
- [Conditionals](/legacy/legacy-experience/writing-automations/automation-basics/conditionals.md): Learn how to write conditional statements in Kognitos.
- [Keywords](/legacy/legacy-experience/writing-automations/automation-basics/keywords.md): Learn about the basic keywords in Kognitos, their usage, and examples.
- [Loops](/legacy/legacy-experience/writing-automations/automation-basics/loops.md): Learn about writing loops in Kognitos to repeat actions for multiple items.
- [Using the Editor](/legacy/legacy-experience/writing-automations/using-the-editor.md): Guides for different components of the automation editor.
- [Debugger](/legacy/legacy-experience/writing-automations/using-the-editor/debugger.md): Enhance your automation process development workflow with the debugger.
- [Widgets](/legacy/legacy-experience/writing-automations/using-the-editor/widgets.md): Add dynamic and structured content to your automations using widgets.
- [Calling Other Processes](/legacy/legacy-experience/writing-automations/calling-other-processes.md): Learn how one process can call another process in Kognitos.
- [Run a Subprocess](/legacy/legacy-experience/writing-automations/calling-other-processes/run-a-subprocess.md): Learn how to call and run a subprocess using the process run widget.
- [Invoke a Subprocess](/legacy/legacy-experience/writing-automations/calling-other-processes/invoke-a-subprocess.md): Learn how to invoke a subprocess using the invoke keyword.
- [Start Parallel Runs](/legacy/legacy-experience/writing-automations/calling-other-processes/start-parallel-runs.md): Learn how to start parallel runs in Kognitos.
- [Batch Processing](/legacy/legacy-experience/writing-automations/batch-processing.md): Learn how to perform batch processing.
- [Context Based Learning](/legacy/legacy-experience/writing-automations/context-based-learning.md)
- [Sending Emails](/legacy/legacy-experience/writing-automations/sending-emails.md): Learn how to send emails from Kognitos.
- [Validating Data](/legacy/legacy-experience/writing-automations/validating-data.md): Learn how to validate data in your automations.
- [Automation Areas](/legacy/legacy-experience/automation-areas.md)
- [Charts](/legacy/legacy-experience/automation-areas/charts.md)
- [Add Legend](/legacy/legacy-experience/automation-areas/charts/add-legend.md): Enables a legend on an existing pie chart.
- [Add Trendline](/legacy/legacy-experience/automation-areas/charts/add-trendline.md): Add a linear or quadratic trendline to a scatter plot.
- [Create Chart](/legacy/legacy-experience/automation-areas/charts/create-chart.md): Generates a bar or pie chart.
- [Create Plot](/legacy/legacy-experience/automation-areas/charts/create-plot.md): Generates a scatter, line, or box plot.
- [Remove Legend](/legacy/legacy-experience/automation-areas/charts/remove-legend.md): Removes the legend on an existing pie chart.
- [Save Chart](/legacy/legacy-experience/automation-areas/charts/save-chart.md): Renders the current chart and saves it internally.
- [Show Chart](/legacy/legacy-experience/automation-areas/charts/show-chart.md): Renders a previously created chart.
- [Show Plot](/legacy/legacy-experience/automation-areas/charts/show-plot.md): Render a stored plot chart.
- [Date and Time](/legacy/legacy-experience/automation-areas/date-and-time.md): This section covers the automation procedures for working with dates and times in Kognitos.
- [Converting Date Strings Into Dates](/legacy/legacy-experience/automation-areas/date-and-time/converting-date-strings-into-dates.md): This procedure converts date strings (text representations of dates) into date objects.
- [Converting Date Strings to Different Formats](/legacy/legacy-experience/automation-areas/date-and-time/converting-date-strings-to-different-formats.md): This procedure converts text to a date in a specific format.
- [Converting Text to Date](/legacy/legacy-experience/automation-areas/date-and-time/converting-text-to-date.md): This procedure converts text to date in YYYY-MM-DD format.
- [Getting Date and Time Information](/legacy/legacy-experience/automation-areas/date-and-time/getting-date-and-time-information.md): These procedures are used to get current date and time information.
- [Sorting Dates](/legacy/legacy-experience/automation-areas/date-and-time/sorting-dates.md): This procedure sorts a list of dates in ascending order.
- [Department Boxes](/legacy/legacy-experience/automation-areas/department-box.md): Learn how to operate on a department box.
- [Add Items](/legacy/legacy-experience/automation-areas/department-box/add-items.md): Add item(s) to a department box.
- [Clean Items](/legacy/legacy-experience/automation-areas/department-box/clean-items.md): Removes all the keys from the department box.
- [Clean Items Before a Certain Date](/legacy/legacy-experience/automation-areas/department-box/clean-items-before-a-certain-date.md): Removes all the keys from the department box before a certain date.
- [Export Items](/legacy/legacy-experience/automation-areas/department-box/export-items.md): Export all the keys from the specified department box into a table.
- [Migrate to OpenSearch](/legacy/legacy-experience/automation-areas/department-box/migrate-to-opensearch.md): Migrates data from the current department box storage engine to OpenSearch.
- [Remove Item](/legacy/legacy-experience/automation-areas/department-box/remove-item.md): Removes a specified item from a department's box.
- [Remove Items](/legacy/legacy-experience/automation-areas/department-box/remove-items.md): Removes all items from a department box.
- [Retrieve Item](/legacy/legacy-experience/automation-areas/department-box/retrieve-item.md): Retrieve an item from a department box.
- [Excel Files](/legacy/legacy-experience/automation-areas/excel-v2.md): Learn to work with local Excel files in Kognitos.
- [Cells](/legacy/legacy-experience/automation-areas/excel-v2/get-a-cell-value.md): Retrieves the value of a cell in an Excel worksheet.
- [Get a Cell's Column Label](/legacy/legacy-experience/automation-areas/excel-v2/get-a-cell-value/get-a-cells-column-label.md): Retrieves the column label of a specific cell in an Excel worksheet.
- [Get a Cell's Formula](/legacy/legacy-experience/automation-areas/excel-v2/get-a-cell-value/get-a-cells-formula.md): Gets the formula from a specified cell in a worksheet.
- [Get a Cell's Row Number](/legacy/legacy-experience/automation-areas/excel-v2/get-a-cell-value/get-a-cells-row-number.md): Retrieves the row number of a specific cell in an Excel worksheet.
- [Set a Cell's Value](/legacy/legacy-experience/automation-areas/excel-v2/get-a-cell-value/set-a-cells-value.md): Sets the value of a cell in a worksheet to a specified text or formula.
- [Set Cell Values](/legacy/legacy-experience/automation-areas/excel-v2/get-a-cell-value/set-cell-values.md): Updates the values in an Excel file for one or more cells.
- [Columns](/legacy/legacy-experience/automation-areas/excel-v2/insert-a-column.md): Inserts a column into an existing Excel worksheet.
- [Rows](/legacy/legacy-experience/automation-areas/excel-v2/get-a-row.md): Gets a row from an Excel worksheet that contains a specific value.
- [Get a Row's Cell](/legacy/legacy-experience/automation-areas/excel-v2/get-a-row/get-a-rows-cell.md): Retrieves a cell in a specific row of an Excel worksheet.
- [Insert a Row](/legacy/legacy-experience/automation-areas/excel-v2/get-a-row/insert-a-row.md): Inserts a row into an existing Excel worksheet.
- [Tables](/legacy/legacy-experience/automation-areas/excel-v2/extract-a-table-from-a-worksheet.md): Locates and extracts a table from an Excel worksheet.
- [Get a Singular Table from an Excel Worksheet](/legacy/legacy-experience/automation-areas/excel-v2/extract-a-table-from-a-worksheet/get-a-singular-table-from-an-excel-worksheet.md): Retrieves the single table from a worksheet.
- [Insert a Table](/legacy/legacy-experience/automation-areas/excel-v2/extract-a-table-from-a-worksheet/insert-a-table.md): Inserts a table into an Excel worksheet.
- [Workbooks](/legacy/legacy-experience/automation-areas/excel-v2/convert-an-excel-to-a-pdf.md): Converts an Excel file to PDF format.
- [Create an Excel File](/legacy/legacy-experience/automation-areas/excel-v2/convert-an-excel-to-a-pdf/create-an-excel-file.md): Creates a new Excel file.
- [Worksheets](/legacy/legacy-experience/automation-areas/excel-v2/get-a-worksheet.md): Gets a specific worksheet from an Excel file.
- [Add a Worksheet](/legacy/legacy-experience/automation-areas/excel-v2/get-a-worksheet/add-a-worksheet.md): Adds an empty worksheet to an existing Excel file.
- [Copy a Worksheet in the Excel](/legacy/legacy-experience/automation-areas/excel-v2/get-a-worksheet/copy-a-worksheet-in-the-excel.md): Creates a copy of an existing worksheet in the same Excel file.
- [Extract Text from a Worksheet](/legacy/legacy-experience/automation-areas/excel-v2/get-a-worksheet/extract-text-from-a-worksheet.md): Extracts all text from an Excel worksheet
- [Format an Excel](/legacy/legacy-experience/automation-areas/excel-v2/get-a-worksheet/format-an-excel.md): Formats cells in an Excel worksheet.
- [Get a Worksheet Name](/legacy/legacy-experience/automation-areas/excel-v2/get-a-worksheet/get-a-worksheet-name.md): Intelligently retrieves a worksheet name from an Excel file.
- [Get an Item from an Excel Worksheet](/legacy/legacy-experience/automation-areas/excel-v2/get-a-worksheet/get-an-item-from-an-excel-worksheet.md): Retrieves a specific item from a sheet.
- [Get Worksheet Names](/legacy/legacy-experience/automation-areas/excel-v2/get-a-worksheet/get-worksheet-names.md): Retrieves the names of all worksheets in an Excel file.
- [Get Worksheets](/legacy/legacy-experience/automation-areas/excel-v2/get-a-worksheet/get-worksheets.md): Gets all the worksheets from an Excel workbook.
- [Insert a Formula into an Excel](/legacy/legacy-experience/automation-areas/excel-v2/get-a-worksheet/insert-a-formula-into-an-excel.md): Inserts formulas into a specified column across multiple rows in an Excel worksheet.
- [Remove a Worksheet](/legacy/legacy-experience/automation-areas/excel-v2/get-a-worksheet/remove-a-worksheet.md): Removes a specified worksheet.
- [Rename a Worksheet in the Excel](/legacy/legacy-experience/automation-areas/excel-v2/get-a-worksheet/rename-a-worksheet-in-the-excel.md): Renames an existing worksheet in the same Excel file.
- [Save a Worksheet](/legacy/legacy-experience/automation-areas/excel-v2/get-a-worksheet/save-a-worksheet.md): Saves an Excel worksheet to a temporary location.
- [Files and Documents](/legacy/legacy-experience/automation-areas/summary-1.md)
- [JSON](/legacy/legacy-experience/automation-areas/summary-1/to-open-a-json-at-a-file.md): Opens a JSON file from either an S3 URL or an uploaded file.
- [Compare a JSON with a JSON](/legacy/legacy-experience/automation-areas/summary-1/to-open-a-json-at-a-file/to-compare-a-json-with-a-json.md): Compares two JSON objects and identifies differences between them.
- [Create a JSON](/legacy/legacy-experience/automation-areas/summary-1/to-open-a-json-at-a-file/to-create-a-json.md): Creates an empty JSON object.
- [Delete a JSON's Thing](/legacy/legacy-experience/automation-areas/summary-1/to-open-a-json-at-a-file/to-delete-a-jsons-thing.md): Deletes a specified key from a JSON object.
- [Get a JSON as a String](/legacy/legacy-experience/automation-areas/summary-1/to-open-a-json-at-a-file/to-get-a-json-as-a-string.md): Converts a JSON object to a string representation.
- [Get a JSON's Thing](/legacy/legacy-experience/automation-areas/summary-1/to-open-a-json-at-a-file/to-get-a-jsons-thing.md): Extracts a specific element or elements from a JSON structure.
- [Get a String as a JSON](/legacy/legacy-experience/automation-areas/summary-1/to-open-a-json-at-a-file/to-get-a-string-as-a-json.md): Converts a string to a JSON object.
- [Merge a JSON with a JSON](/legacy/legacy-experience/automation-areas/summary-1/to-open-a-json-at-a-file/to-merge-a-json-with-a-json.md): Merges two JSON objects and returns the merged result.
- [Set a JSON's Thing to a Thing](/legacy/legacy-experience/automation-areas/summary-1/to-open-a-json-at-a-file/to-set-a-jsons-thing-to-a-thing.md): Sets or changes a specific value within a JSON object to a new value.
- [PDFs](/legacy/legacy-experience/automation-areas/summary-1/converting-a-file-to-pdf.md): Automation procedures for converting files to PDF.
- [Getting Information from a PDF](/legacy/legacy-experience/automation-areas/summary-1/converting-a-file-to-pdf/getting-information-from-a-pdf.md): Basic procedures for extracting information from a PDF.
- [Merging Documents](/legacy/legacy-experience/automation-areas/summary-1/converting-a-file-to-pdf/merging-documents.md): This automation procedure combines multiple PDFs into a single PDF file.
- [Removing Duplicates from a PDF](/legacy/legacy-experience/automation-areas/summary-1/converting-a-file-to-pdf/removing-duplicates-from-a-pdf.md): Automation procedures for removing duplicates from a PDF file.
- [Saving a PDF](/legacy/legacy-experience/automation-areas/summary-1/converting-a-file-to-pdf/saving-a-pdf.md): Automation procedures for saving a PDF file after making changes.
- [Setting or Changing Information in a PDF](/legacy/legacy-experience/automation-areas/summary-1/converting-a-file-to-pdf/setting-or-changing-information-in-a-pdf.md): Automation procedures to set or change field values in a PDF file.
- [Unlock a PDF File](/legacy/legacy-experience/automation-areas/summary-1/converting-a-file-to-pdf/unlock-a-pdf-file.md): Unlocks a password-protected PDF file.
- [Templates](/legacy/legacy-experience/automation-areas/summary-1/create-pdfs-from-a-template.md): Generates a PDF document for each row in an Excel file by merging data into a .docx template.
- [Fill in a Template File](/legacy/legacy-experience/automation-areas/summary-1/create-pdfs-from-a-template/fill-in-a-template-file.md): Fills in a template with provided placeholder values.
- [Image Manipulation](/legacy/legacy-experience/automation-areas/image-manipulation.md): Automation procedures for image manipulation, including how to resize, rotate, convert to grayscale, and flip images.
- [Converting Images to Grayscale](/legacy/legacy-experience/automation-areas/image-manipulation/converting-images-to-grayscale.md)
- [Flipping Images](/legacy/legacy-experience/automation-areas/image-manipulation/flipping-images.md)
- [QR Code Generation](/legacy/legacy-experience/automation-areas/image-manipulation/qr-code-generation.md)
- [Resizing Images](/legacy/legacy-experience/automation-areas/image-manipulation/resizing-images.md)
- [Rotating Images](/legacy/legacy-experience/automation-areas/image-manipulation/rotating-images.md)
- [Text Visualization](/legacy/legacy-experience/automation-areas/image-manipulation/text-visualization.md)
- [LLMs](/legacy/legacy-experience/automation-areas/llm.md): Learn how to use automation procedures that interact with LLM models.
- [When to Use Ask Koncierge or Extract](/legacy/legacy-experience/automation-areas/llm/when-to-use-ask-koncierge-or-extract.md): Summarizing the differences, strengths, and use cases for each type of LLM procedure.
- [Foundational Procedures](/legacy/legacy-experience/automation-areas/llm/ask-koncierge.md)
- [Ask Koncierge](/legacy/legacy-experience/automation-areas/llm/ask-koncierge/ask-koncierge.md): Asks Koncierge, a virtual assistant, to perform a task, answer a question, or generate a message.
- [Ask Koncierge to Extract Information from a Document](/legacy/legacy-experience/automation-areas/llm/ask-koncierge/ask-koncierge-to-extract-information-from-a-document.md): Asks Koncierge to extract specific information from documents or text.
- [Automation Procedures](/legacy/legacy-experience/automation-areas/llm/automation-procedures.md): Extracts data from texts, documents, or files using LLM models.
- [Extract Data](/legacy/legacy-experience/automation-areas/llm/automation-procedures/extract-data.md): Extracts data from texts, documents, or files using LLM models.
- [Extract Data from Multiple Documents](/legacy/legacy-experience/automation-areas/llm/automation-procedures/extract-data-from-multiple-documents.md): Extracts data from multiple documents in a single LLM call using file upload.
- [Extract Pages](/legacy/legacy-experience/automation-areas/llm/automation-procedures/extract-pages.md): Extracts specified pages from a document or file as individual page documents.
- [Extract Subdocument](/legacy/legacy-experience/automation-areas/llm/automation-procedures/extract-subdocument.md): Extracts a subdocument from a document or file based on page numbers or markers.
- [Extract Subdocuments](/legacy/legacy-experience/automation-areas/llm/automation-procedures/extract-subdocuments.md): Extracts multiple subdocuments from a document using markers or fixed-size chunking.
- [Extract Tables](/legacy/legacy-experience/automation-areas/llm/automation-procedures/extract-tables.md): Extracts table data from documents, text, or files using AI-powered analysis.
- [Identify Elements in a Text](/legacy/legacy-experience/automation-areas/llm/automation-procedures/identify-elements-in-a-text.md): Finds a specified element within a given text using AI-powered text analysis.
- [Merge Pages into Document](/legacy/legacy-experience/automation-areas/llm/automation-procedures/merge-pages-into-document.md): Merges multiple page documents into a single consolidated document.
- [Merge Subdocuments into Document](/legacy/legacy-experience/automation-areas/llm/automation-procedures/merge-subdocuments-into-document.md): Merges multiple subdocuments into a single consolidated document.
- [Query Multiple Documents](/legacy/legacy-experience/automation-areas/llm/automation-procedures/query-multiple-documents.md): Process multiple documents with a custom prompt using LLM file upload APIs.
- [Numbers](/legacy/legacy-experience/automation-areas/numbers.md): Automation procedures for working with numbers in Kognitos.
- [Increase a Number by a Percentage](/legacy/legacy-experience/automation-areas/numbers/increase-a-number-by-a-percentage.md): This procedure increases a number by a percentage.
- [Reduce a Number by a Percentage](/legacy/legacy-experience/automation-areas/numbers/reduce-a-number-by-a-percentage.md): This procedure reduces a number by a percentage
- [Truncate a Number](/legacy/legacy-experience/automation-areas/numbers/truncate-a-number.md): Truncates a decimal number to a specified precision without rounding.
- [Tables](/legacy/legacy-experience/automation-areas/tables-v2.md): Learn to work with tables and tabular data.
- [Table Creation](/legacy/legacy-experience/automation-areas/tables-v2/create-a-table.md): Creates an empty table. The column names and number of rows can be optionally specified.
- [Create a Combined Table](/legacy/legacy-experience/automation-areas/tables-v2/create-a-table/create-a-combined-table.md): Creates a combined table from two or more existing tables.
- [Create a Merged Table](/legacy/legacy-experience/automation-areas/tables-v2/create-a-table/create-a-merged-table.md): Merge two or more tables based on specified matching and merging criteria.
- [Create a Pivot Table](/legacy/legacy-experience/automation-areas/tables-v2/create-a-table/create-a-pivot-table.md): Generates a pivot table from an existing table based on specified criteria.
- [Create a Sample Table](/legacy/legacy-experience/automation-areas/tables-v2/create-a-table/create-a-sample-table.md): Creates a sample table with predefined data.
- [Create a Table from JSON](/legacy/legacy-experience/automation-areas/tables-v2/create-a-table/create-a-table-from-json.md): Creates a table from JSON input.
- [Create a Table from the Rows](/legacy/legacy-experience/automation-areas/tables-v2/create-a-table/create-a-table-from-the-rows.md): Creates a table from one or more rows.
- [Create an Integer Table](/legacy/legacy-experience/automation-areas/tables-v2/create-a-table/create-an-integer-table.md): Creates an integer table with predefined columns and rows.
- [Get a Table from a File](/legacy/legacy-experience/automation-areas/tables-v2/create-a-table/get-a-table-from-a-file.md): Opens a table from a file, provided either through direct upload or at an S3 URL.
- [Cells](/legacy/legacy-experience/automation-areas/tables-v2/set-a-cell-in-a-table.md): Sets the value of a cell in a table.
- [Columns](/legacy/legacy-experience/automation-areas/tables-v2/get-a-column.md): Retrieves a specified column from a table.
- [Cast a Table Column](/legacy/legacy-experience/automation-areas/tables-v2/get-a-column/cast-a-table-column.md): Converts a table column to a specified data type.
- [Column Formulas](/legacy/legacy-experience/automation-areas/tables-v2/get-a-column/column-formulas.md): Use column formulas to dynamically populate and transform column data in your tables.
- [Delete Table Columns](/legacy/legacy-experience/automation-areas/tables-v2/get-a-column/delete-table-columns.md): Deletes one or more specified columns from a table.
- [Get a Column Number](/legacy/legacy-experience/automation-areas/tables-v2/get-a-column/get-a-column-number.md): Gets the column number of a specified column in a table.
- [Get a Column's Values](/legacy/legacy-experience/automation-areas/tables-v2/get-a-column/get-a-columns-values.md): Gets the values of a specified column in a table.
- [Get Column Count](/legacy/legacy-experience/automation-areas/tables-v2/get-a-column/get-column-count.md): Retrieves the number of columns in the table.
- [Get Column Names](/legacy/legacy-experience/automation-areas/tables-v2/get-a-column/get-column-names.md): Retrieves a table's header.
- [Get Column Stats](/legacy/legacy-experience/automation-areas/tables-v2/get-a-column/get-column-stats.md): Calculates an aggregate value of a table column.
- [Insert a Column in a Table](/legacy/legacy-experience/automation-areas/tables-v2/get-a-column/insert-a-column-in-a-table.md): Inserts a column into a table.
- [Move a Column](/legacy/legacy-experience/automation-areas/tables-v2/get-a-column/move-a-column.md): Moves a column in the table to a specified position.
- [Rename a Column](/legacy/legacy-experience/automation-areas/tables-v2/get-a-column/rename-a-column.md): Renames a column in a table.
- [Rename Columns](/legacy/legacy-experience/automation-areas/tables-v2/get-a-column/rename-columns.md): Renames columns in a table to new names specified by the user.
- [Round a Column's Values](/legacy/legacy-experience/automation-areas/tables-v2/get-a-column/round-a-columns-values.md): Rounds numeric values in a table column to a specified number of decimal places.
- [Update a Column in a Table](/legacy/legacy-experience/automation-areas/tables-v2/get-a-column/update-a-column-in-a-table.md): Updates a column in a table.
- [Rows](/legacy/legacy-experience/automation-areas/tables-v2/get-rows.md): Retrieves a single row or multiple rows from a table.
- [Get Row Count](/legacy/legacy-experience/automation-areas/tables-v2/get-rows/get-row-count.md): Retrieves the number of rows in the table.
- [Get Row Number](/legacy/legacy-experience/automation-areas/tables-v2/get-rows/get-row-number.md): Retrieves the row number of the specified row in the table.
- [Get Value from Row](/legacy/legacy-experience/automation-areas/tables-v2/get-rows/get-value-from-row.md): Retrieves the value of a specified column from the row.
- [Group Rows](/legacy/legacy-experience/automation-areas/tables-v2/get-rows/group-rows.md): Groups the rows of a table by specified criteria.
- [Insert a Row](/legacy/legacy-experience/automation-areas/tables-v2/get-rows/insert-a-row.md): Inserts a row into the table with given data.
- [Insert an Empty Row](/legacy/legacy-experience/automation-areas/tables-v2/get-rows/insert-an-empty-row.md): Inserts an empty row into the table at the specified row number.
- [Remove Duplicate Rows](/legacy/legacy-experience/automation-areas/tables-v2/get-rows/remove-duplicate-rows.md): Deletes duplicate rows from the table, optionally based on specified columns.
- [Set a Row to JSON](/legacy/legacy-experience/automation-areas/tables-v2/get-rows/set-a-row-to-json.md): Updates a row in the table using values from a JSON object.
- [Conversions](/legacy/legacy-experience/automation-areas/tables-v2/convert-a-table-to-csv.md): Converts a table to a CSV formatted file.
- [Convert a Table to Excel](/legacy/legacy-experience/automation-areas/tables-v2/convert-a-table-to-csv/convert-a-table-to-excel.md): Converts a table into an Excel file with customizable filename and worksheet name.
- [Convert a Table to JSON](/legacy/legacy-experience/automation-areas/tables-v2/convert-a-table-to-csv/convert-a-table-to-json.md): Converts a table into JSON.
- [Convert a Table to Text](/legacy/legacy-experience/automation-areas/tables-v2/convert-a-table-to-csv/convert-a-table-to-text.md): Converts a table into its text (string) representation.
- [Convert JSONs to Table](/legacy/legacy-experience/automation-areas/tables-v2/convert-a-table-to-csv/convert-jsons-to-table.md): Converts a specified non-empty JSON array of objects (or single object) into a table.
- [Convert Thing to Table](/legacy/legacy-experience/automation-areas/tables-v2/convert-a-table-to-csv/convert-thing-to-table.md): Converts a specified thing, such as a CSV file or JSON, into a table.
- [Manipulations](/legacy/legacy-experience/automation-areas/tables-v2/query-a-table.md): Executes a SQL query on a table and returns the result.
- [Clear a Table](/legacy/legacy-experience/automation-areas/tables-v2/query-a-table/clear-a-table.md): Clears all data from a table.
- [Combine Tables](/legacy/legacy-experience/automation-areas/tables-v2/query-a-table/combine-tables.md): Combines multiple tables into a single table based on specified criteria.
- [Copy a Table](/legacy/legacy-experience/automation-areas/tables-v2/query-a-table/copy-a-table.md): Copies a table to a new table with a specified name.
- [Extract a Subtable from the Table](/legacy/legacy-experience/automation-areas/tables-v2/query-a-table/extract-a-subtable-from-the-table.md): Extracts a table from an existing table.
- [Group a Table](/legacy/legacy-experience/automation-areas/tables-v2/query-a-table/group-a-table.md): Groups a table by a specified column and optionally aggregates other columns.
- [Join Subtables](/legacy/legacy-experience/automation-areas/tables-v2/query-a-table/join-subtables.md): Combines multiple subtables into a single table.
- [Replace Value in a Column](/legacy/legacy-experience/automation-areas/tables-v2/query-a-table/replace-value-in-a-column.md): Replaces occurrences of a value in a table.
- [Replace Value in Table](/legacy/legacy-experience/automation-areas/tables-v2/query-a-table/replace-value-in-table.md): Replaces occurrences of a value in a table.
- [Sort a Table](/legacy/legacy-experience/automation-areas/tables-v2/query-a-table/sort-a-table.md): Sorts a table by one or more columns with optional ascending/descending order.
- [Split a Table](/legacy/legacy-experience/automation-areas/tables-v2/query-a-table/split-a-table.md): Split a large table into smaller subtables.
- [Transpose a Table](/legacy/legacy-experience/automation-areas/tables-v2/query-a-table/transpose-a-table.md): Transposes a given table.
- [Text](/legacy/legacy-experience/automation-areas/text.md): Learn how to manipulate text in your automations.
- [Boolean Checks](/legacy/legacy-experience/automation-areas/text/boolean-checks.md): Automation procedures for evaluating text conditions that yield either a "true" or "false" result.
- [Check Regex Match](/legacy/legacy-experience/automation-areas/text/boolean-checks/check-regex-match.md): Check if a text matches a regular expression pattern.
- [Check Text Contents](/legacy/legacy-experience/automation-areas/text/boolean-checks/check-text-contents.md): Check if a value is present within a text.
- [Check Text End](/legacy/legacy-experience/automation-areas/text/boolean-checks/check-text-end.md): Check if a text ends with another text value.
- [Check Text Start](/legacy/legacy-experience/automation-areas/text/boolean-checks/check-text-start.md): Check if a text is started by another text value.
- [Conversions](/legacy/legacy-experience/automation-areas/text/conversions.md): Automation procedures that transform text from one format or structure to another.
- [Convert a Character to a Number](/legacy/legacy-experience/automation-areas/text/conversions/convert-a-character-to-a-number.md): Convert a character into its corresponding numeric ASCII value.
- [Convert a Number to a Character](/legacy/legacy-experience/automation-areas/text/conversions/convert-a-number-to-a-character.md): Convert a number into its corresponding character ASCII value.
- [Convert Text Date to ISO Format](/legacy/legacy-experience/automation-areas/text/conversions/convert-text-date-to-iso-format.md): Convert a given text date to ISO-8601 format.
- [Convert Text to HTML](/legacy/legacy-experience/automation-areas/text/conversions/convert-text-to-html.md): Create an HTML file by converting text to HTML.
- [Convert Text to Number](/legacy/legacy-experience/automation-areas/text/conversions/convert-text-to-number.md): Convert a text representation of a number into its numeric value.
- [Get Lowercase Text](/legacy/legacy-experience/automation-areas/text/conversions/get-lowercase-text.md): Convert a given text to lowercase format.
- [Get Titlecase Text](/legacy/legacy-experience/automation-areas/text/conversions/get-titlecase-text.md): Convert a given text to title case.
- [Get Uppercase Text](/legacy/legacy-experience/automation-areas/text/conversions/get-uppercase-text.md): Convert a given text to uppercase.
- [Removal](/legacy/legacy-experience/automation-areas/text/removal.md): Automation procedures involving text removal.
- [Remove Text Using Regex](/legacy/legacy-experience/automation-areas/text/removal/remove-text-using-regex.md): Removes occurrences of a specified regular expression from a text.
- [Remove Text Using Substrings](/legacy/legacy-experience/automation-areas/text/removal/remove-text-using-substrings.md): Removes a specific piece of text from a larger text.
- [Combine Texts with Separator](/legacy/legacy-experience/automation-areas/text/combine-texts-with-separator.md): Combine a list of text values using a specified separator.
- [Extract Elements from Text](/legacy/legacy-experience/automation-areas/text/extract-elements-from-text.md): Extract lines, words, characters, URLs, numbers, or patterns from a text.
- [Extract Markdown Headings](/legacy/legacy-experience/automation-areas/text/extract-markdown-headings.md): Extract headings from a given markdown text.
- [Get Text Length](/legacy/legacy-experience/automation-areas/text/get-text-length.md): Get the length of a text string.
- [Replace Text](/legacy/legacy-experience/automation-areas/text/replace-text.md): Replace a text with another text.
- [Split Text](/legacy/legacy-experience/automation-areas/text/split-text.md): Split a text into smaller texts.
- [Books](/legacy/legacy-experience/books.md): Learn how to extend your automation functionality in Kognitos with Books.
- [All Books](/legacy/legacy-experience/books/all-books.md): Learn how to navigate our book library.
- [Connections](/legacy/legacy-experience/books/connections.md): Learn how to add, manage, and switch connections for books.
- [Updating Books](/legacy/legacy-experience/books/updating-books.md): Understand when updates are needed, available, and how to update a book.
- [Custom Books (BDK)](/legacy/legacy-experience/books/custom-books.md): An overview of the development kit used to create custom books.
- [Planning](/legacy/legacy-experience/books/custom-books/planning.md): A checklist to guide the planning of your custom book project, covering key requirements and considerations.
- [Setup](/legacy/legacy-experience/books/custom-books/setup.md): Learn how to set up your custom book project.
- [Development](/legacy/legacy-experience/books/custom-books/development.md): Learn how to develop, package, and run your book locally.
- [Deployment](/legacy/legacy-experience/books/custom-books/deployment.md): Learn the requirements for deploying a custom book.
- [API Reference](/legacy/legacy-experience/books/custom-books/api-reference.md)
- [Concepts](/legacy/legacy-experience/books/custom-books/api-reference/concepts.md): Understand concepts and how they are utilized in procedures.
- [Connections](/legacy/legacy-experience/books/custom-books/api-reference/connections.md): Learn how to connect with third-party tools and services in your custom book project.
- [Docstrings](/legacy/legacy-experience/books/custom-books/api-reference/docstrings.md): Understand how to format and write docstrings to ensure your Book is well-documented.
- [Decorators](/legacy/legacy-experience/books/custom-books/api-reference/decorators.md)
- [@book](/legacy/legacy-experience/books/custom-books/api-reference/decorators/book-decorator.md)
- [@concept](/legacy/legacy-experience/books/custom-books/api-reference/decorators/concept-decorator.md)
- [@config](/legacy/legacy-experience/books/custom-books/api-reference/decorators/config-decorator.md)
- [@connect](/legacy/legacy-experience/books/custom-books/api-reference/decorators/connect-decorator.md)
- [@oauth](/legacy/legacy-experience/books/custom-books/api-reference/decorators/oauth-decorator.md)
- [@oauthtoken](/legacy/legacy-experience/books/custom-books/api-reference/decorators/oauthtoken-decorator.md)
- [@procedure](/legacy/legacy-experience/books/custom-books/api-reference/decorators/procedure-decorator.md)
- [Enums](/legacy/legacy-experience/books/custom-books/api-reference/enums.md)
- [FilterBinaryOperator](/legacy/legacy-experience/books/custom-books/api-reference/enums/filterbinaryoperator-enum.md)
- [FilterUnaryOperator](/legacy/legacy-experience/books/custom-books/api-reference/enums/filterunaryoperator-enum.md)
- [Filter Expressions](/legacy/legacy-experience/books/custom-books/api-reference/enums/filter-expressions.md): Learn about implementing filter expressions in your custom book project.
- [Noun Phrases](/legacy/legacy-experience/books/custom-books/api-reference/noun-phrases.md): Learn about the concept of a noun phrase.
- [Procedures](/legacy/legacy-experience/books/custom-books/api-reference/procedures.md): Learn how to implement a procedure in a custom book.
- [Questions](/legacy/legacy-experience/books/custom-books/api-reference/questions.md): Learn how to implement questions in a custom book.
- [Reference](/legacy/legacy-experience/books/reference.md)
- [Airtable](/legacy/legacy-experience/books/reference/airtable.md): Procedures and concepts for the Airtable integration.
- [Airtable (Legacy)](/legacy/legacy-experience/books/reference/airtable-legacy.md)
- [Amazon Selling Partner](/legacy/legacy-experience/books/reference/amazon.md): Procedures and concepts for the Amazon Selling Partner integration.
- [Asana](/legacy/legacy-experience/books/reference/asana.md): Procedures and concepts for the Asana integration.
- [AWS EC2](/legacy/legacy-experience/books/reference/ec2.md): Procedures and concepts for the AWS EC2 integration.
- [AWS S3](/legacy/legacy-experience/books/reference/s3.md): Procedures and concepts for the AWS S3 integration.
- [AWS Secrets Manager](/legacy/legacy-experience/books/reference/secretsmanager.md): Procedures and concepts for the AWS Secrets Manager integration.
- [AWS SNS](/legacy/legacy-experience/books/reference/sns.md): Procedures and concepts for the AWS SNS integration.
- [AWS SQS](/legacy/legacy-experience/books/reference/sqs.md): Procedures and concepts for the AWS SQS integration.
- [Azure Blob Storage](/legacy/legacy-experience/books/reference/azureblobstorage.md): Procedures and concepts for the Azure Blob Storage integration.
- [Azure Blob Storage (Legacy)](/legacy/legacy-experience/books/reference/azureblobstorage-legacy.md)
- [Azure Key Vault](/legacy/legacy-experience/books/reference/azurekeyvault.md): Procedures and concepts for the Azure Key Vault integration.
- [Azure Service Bus](/legacy/legacy-experience/books/reference/azureservicebus.md): Procedures and concepts for the Azure Service Bus integration.
- [Azure Service Bus (Legacy)](/legacy/legacy-experience/books/reference/azureservicebus-legacy.md)
- [Azure Translator](/legacy/legacy-experience/books/reference/azuretranslator.md): Procedures and concepts for the Azure Translator integration.
- [Azure Translator (Legacy)](/legacy/legacy-experience/books/reference/azuretranslator-legacy.md)
- [Box](/legacy/legacy-experience/books/reference/box.md): Procedures and concepts for the Box integration.
- [Browser Use](/legacy/legacy-experience/books/reference/browser-use.md): Procedures and concepts for the Browser Use integration.
- [ClickUp](/legacy/legacy-experience/books/reference/clickup.md): Procedures and concepts for the ClickUp integration.
- [Database (Legacy)](/legacy/legacy-experience/books/reference/database-legacy.md): Automate CRUD operations in Kognitos with the Database Book.
- [Discord](/legacy/legacy-experience/books/reference/discord.md): Procedures and concepts for the Discord integration.
- [Dropbox](/legacy/legacy-experience/books/reference/dropbox.md): Procedures and concepts for the Dropbox integration.
- [GitHub](/legacy/legacy-experience/books/reference/github.md): Procedures and concepts for the GitHub integration.
- [Gmail](/legacy/legacy-experience/books/reference/gmail.md): Procedures and concepts for the Gmail integration.
- [Google Calendar](/legacy/legacy-experience/books/reference/googlecalendar.md): Procedures and concepts for the Google Calendar integration.
- [Google Cloud Storage (Legacy)](/legacy/legacy-experience/books/reference/googlecloudstorage-legacy.md)
- [Google Docs](/legacy/legacy-experience/books/reference/googledocs.md): Procedures and concepts for the Google Docs integration.
- [Google Drive](/legacy/legacy-experience/books/reference/googledrive.md): Procedures and concepts for the Google Drive integration.
- [Google Sheets](/legacy/legacy-experience/books/reference/googlesheets.md): Procedures and concepts for the Google Sheets integration.
- [HTTP](/legacy/legacy-experience/books/reference/http.md): Procedures and concepts for the HTTP integration.
- [HubSpot (Legacy)](/legacy/legacy-experience/books/reference/hubspot-legacy.md)
- [Katana](/legacy/legacy-experience/books/reference/katana.md): Procedures and concepts for the Katana integration.
- [LaunchDarkly](/legacy/legacy-experience/books/reference/launch-darkly.md): Procedures and concepts for the LaunchDarkly integration.
- [LeaseWorks](/legacy/legacy-experience/books/reference/leaseworks.md): Procedures and concepts for the LeaseWorks integration.
- [Linear](/legacy/legacy-experience/books/reference/linear.md): Procedures and concepts for the Linear integration.
- [Kognitos Meta](/legacy/legacy-experience/books/reference/metabook.md): Procedures and concepts for the Kognitos Meta integration.
- [Microsoft Office 365](/legacy/legacy-experience/books/reference/office365.md): Procedures and concepts for the Microsoft Office 365 integration.
- [Microsoft Outlook](/legacy/legacy-experience/books/reference/outlook.md): Procedures and concepts for the Microsoft Outlook integration.
- [Microsoft SharePoint](/legacy/legacy-experience/books/reference/sharepoint.md): Procedures and concepts for the Microsoft SharePoint integration.
- [NetSuite](/legacy/legacy-experience/books/reference/netsuite.md): Procedures and concepts for the NetSuite integration.
- [Notion](/legacy/legacy-experience/books/reference/notion.md): Procedures and concepts for the Notion integration.
- [OpenSearch](/legacy/legacy-experience/books/reference/opensearch.md): Procedures and concepts for the OpenSearch integration.
- [Open Weather](/legacy/legacy-experience/books/reference/openweather.md): Procedures and concepts for the Open Weather integration.
- [Oracle Fusion](/legacy/legacy-experience/books/reference/oracle-fusion.md): Procedures and concepts for the Oracle Fusion integration.
- [Oracle Cloud Fusion (Legacy)](/legacy/legacy-experience/books/reference/oracle-fusion-legacy.md)
- [PagerDuty](/legacy/legacy-experience/books/reference/pagerduty.md): Procedures and concepts for the PagerDuty integration.
- [Paycom (Legacy)](/legacy/legacy-experience/books/reference/paycom-legacy.md)
- [Photon Commerce](/legacy/legacy-experience/books/reference/photon-commerce.md): Procedures and concepts for the Photon Commerce integration.
- [Postgres](/legacy/legacy-experience/books/reference/postgres.md): Procedures and concepts for the Postgres integration.
- [QuickBooks](/legacy/legacy-experience/books/reference/quickbooks.md): Procedures and concepts for the QuickBooks integration.
- [Reddit](/legacy/legacy-experience/books/reference/reddit.md): Procedures and concepts for the Reddit integration.
- [Salesforce](/legacy/legacy-experience/books/reference/salesforce.md): Procedures and concepts for the Salesforce integration.
- [Salesforce (Legacy)](/legacy/legacy-experience/books/reference/salesforce-legacy.md)
- [SAP](/legacy/legacy-experience/books/reference/sap.md): Procedures and concepts for the SAP integration.
- [ServiceNow](/legacy/legacy-experience/books/reference/servicenow.md): Procedures and concepts for the ServiceNow integration.
- [SFTP](/legacy/legacy-experience/books/reference/sftp.md): Procedures and concepts for the SFTP integration.
- [SFTP (Legacy)](/legacy/legacy-experience/books/reference/sftp-legacy.md): Transfer files securely between systems using the Secure File Transfer Protocol (SFTP).
- [Slack](/legacy/legacy-experience/books/reference/slack.md): Procedures and concepts for the Slack integration.
- [Smartsheet](/legacy/legacy-experience/books/reference/smartsheet.md): Procedures and concepts for the Smartsheet integration.
- [Snowflake](/legacy/legacy-experience/books/reference/snowflake.md): Procedures and concepts for the Snowflake integration.
- [Stripe (Legacy)](/legacy/legacy-experience/books/reference/stripe-legacy.md)
- [Trello](/legacy/legacy-experience/books/reference/trello.md): Procedures and concepts for the Trello integration.
- [TruckMate](/legacy/legacy-experience/books/reference/truckmate.md): Procedures and concepts for the TruckMate integration.
- [Twilio](/legacy/legacy-experience/books/reference/twilio.md): Procedures and concepts for the Twilio integration.
- [YAML](/legacy/legacy-experience/books/reference/yaml.md): Procedures and concepts for the YAML integration.
- [Zendesk](/legacy/legacy-experience/books/reference/zendesk.md): Procedures and concepts for the Zendesk integration.
- [Zendesk (Legacy)](/legacy/legacy-experience/books/reference/zendesk-legacy.md)
- [Processes](/legacy/legacy-experience/processes.md): Learn how to transform your automations into reusable processes.
- [Runs](/legacy/legacy-experience/processes/runs.md): Discover the different ways to run an automation process in Kognitos.
- [Schedule a Process Run](/legacy/legacy-experience/processes/runs/schedule-a-process-run.md): Learn how to schedule automated process runs in Kognitos.
- [Trigger a Process by Email](/legacy/legacy-experience/processes/runs/trigger-a-process-by-email.md): Learn how to trigger an automation process run by email.
- [Starring Data](/legacy/legacy-experience/processes/starring-data.md): Highlight key data elements in a process run to easily track and reference across executions.
- [Test Suite](/legacy/legacy-experience/processes/test-suite.md): Learn how to test and validate changes  made to your processes.
- [Learnings](/legacy/legacy-experience/learnings.md): Discover how to teach your automations so they can learn.
- [Learning Suggestions](/legacy/legacy-experience/learnings/learning-suggestions.md): Understand how to apply learning suggestions in the Guidance Center.
- [Exception Handling](/legacy/legacy-experience/exception-handling.md): Learn what exceptions are and why they keep your automations accurate.
- [Guidance Center](/legacy/legacy-experience/exception-handling/guidance-center.md): Learn how to provide guidance to automations in the Guidance Center.
- [Common Exceptions](/legacy/legacy-experience/exception-handling/common-exceptions.md): Explore the most common exceptions in Kognitos and discover best practices for handling them effectively.
- [Using Ask with Custom Exceptions](/legacy/legacy-experience/exception-handling/using-ask-with-custom-exceptions.md): Learn how to use the ask keyword to create custom exceptions.
- [Exception Routing](/legacy/legacy-experience/exception-handling/exception-routing.md): Learn how to configure assignment and notification rules for exceptions in Kognitos.
- [Automation Management](/legacy/legacy-experience/automation-management.md)
- [BYOM](/legacy/legacy-experience/automation-management/byom.md): Securely connect and manage your LLM providers with custom API credentials.
- [Exporting and Importing Agents](/legacy/legacy-experience/automation-management/exporting-and-importing-agents.md): Learn how to export and import automation agents.
- [Performance Dashboard](/legacy/legacy-experience/automation-management/performance-dashboard.md): A guide to understanding the Performance Dashboard in Kognitos.
- [Platform Capacities](/legacy/legacy-experience/automation-management/platform-capacities.md): Reference the currently supported capacities of the Kognitos platform to confidently design, deploy, and manage automations.
- [Account](/legacy/legacy-experience/account.md)
- [API Keys](/legacy/legacy-experience/account/api-keys.md): Learn how to create and manage API keys in Kognitos.
- [Users, Roles and Permissions](/legacy/legacy-experience/account/users-roles-and-permissions.md): An overview of users, roles, and permissions in Kognitos.
- [REST API](/legacy/legacy-experience/rest-api.md): Our REST API is a programmatic interface for interacting with Kognitos, allowing you to manage agents, processes, files, and runs.
- [FAQ](/legacy/legacy-experience/rest-api/faq.md): Frequently Asked Questions for the Kognitos REST API.
- [Examples](/legacy/legacy-experience/rest-api/examples.md): Examples and workflows for using the Kognitos REST API v2.
- [Migrating to V2](/legacy/legacy-experience/rest-api/migrating-to-v2.md): How to migrate from Kognitos REST API v1 to v2.
- [V2](/legacy/legacy-experience/rest-api/v2.md)
- [Processes](/legacy/legacy-experience/rest-api/v2/processes.md)
- [Runs](/legacy/legacy-experience/rest-api/v2/runs.md)
- [Files](/legacy/legacy-experience/rest-api/v2/files.md)
- [Health](/legacy/legacy-experience/rest-api/v2/health.md)
- [V1](/legacy/legacy-experience/rest-api/v1.md)
- [Organizations](/legacy/legacy-experience/rest-api/v1/organizations.md)
- [Workspaces](/legacy/legacy-experience/rest-api/v1/workspaces.md)
- [Automations](/legacy/legacy-experience/rest-api/v1/automations.md)
- [Runs](/legacy/legacy-experience/rest-api/v1/runs.md)
- [Books](/legacy/legacy-experience/rest-api/v1/books.md)
- [Files](/legacy/legacy-experience/rest-api/v1/files.md)
- [Exceptions](/legacy/legacy-experience/rest-api/v1/exceptions.md)
- [Analytics](/legacy/legacy-experience/rest-api/v1/analytics.md)