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|
|Apache Parquet files||Drive.Parquet|
|Move, rename and delete files||N/A||Drive.File.Operation|