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 |