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 (plus PDF and Word), 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 | N/A | |
Word files | N/A | |
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 |