Flat File API

The Flat File API is designed to handle the following file types

1. XLSX
   1. When using an XLSX file, a table will be uploaded to Compyl for each Sheet. The tables will inherit the Sheet Names. For example, if you have a sheet named "Products", a [FlatFiles].[Products] table will be added to your Compyl environment.
2. CSV
   1. When using a CSV file, a single table will be loaded to Compyl based on the FileName parameter passed via the Request Body.

Formatting

When you are creating your flat file, it is important to do the following:

1. Provide a header row for the first row of every Sheet or the first row of your CSV
2. Remove special characters from your file

Viewing your data in Compyl

There are a few ways you can interact and/or view your data within Compyl.

All flat file tables can be found under the [dbo].[FlatfileTables] Compyl table.

1. Navigate to the query builder and create a query for your flat file table. You can operationalize this data for popular use cases like user access review, or change management by associating this query with a task.
2. Create a dashboard and/or report under Dashboard Designer or Report Designer