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