Connect to L3 Workbench

https://developer.precisionlender.com/l3-workbench-api-v1/docs/workbench/auth

Create a Service User in PrecisionLender Administration tab

Connect to L3 Workbench as Service User

Determine CoreCommercialLoanAccounts Path!

Do not forgot to URL encode the directory path!

Read most recent CoreCommercialLoanAccounts file into Pandas DataFrame

Upload file into Workspace directory

The Workspace folder is the only folder in L3 that has write access. All other folders are read only. This provides a guardrail to not accidentally delete your raw production data!

Create the file or directory name. In this case, we are creating a file name.

Modify the Pandas DataFrame

Update the file with our Pandas DataFrame

Check if file successfully uploaded