You can use the Drive.* providers supplied by FINBOURNE to interact with data stored in Drive, LUSID's built-in file repository and manager.
Providing you have suitable access control permissions, you can:
- Read from CSV, Excel, SQLite, XML, Parquet and plain text files stored in Drive, perhaps in preparation for loading investment data into LUSID.
- Write to files of the same types, perhaps having retrieved investment data from LUSID.
- Search a folder or folders for files.
- Perform operations such as moving, renaming and deleting files.
| To interact with... | Read from using the ... provider | Write to using the ... provider |
| CSV and similarly-structured files | Drive.Csv | Drive.SaveAs |
| Excel files | Drive.Excel | |
| PDF files | ||
| Word files | ||
| SQlite files | Drive.Sqlite | |
| XML files | Drive.Xml | |
| Text files | Drive.RawText | |
| Apache Parquet files | Drive.Parquet | |
| Find files | Drive.File | n/a |
| Move, rename and delete files | n/a | Drive.File.Operation |