Getting an issue while reading excel file using "dkuManagedFolderDownloadPath" function of dataiku

[shashankmittal]

Hi Team
I am trying to read an excel file from the managed folder in the dataiku which is of "Server's Filesystem" type and reading files from "filesystem_root".

Now, I am trying to read an excel file which is present in this managed folder using the below R code and getting an attached error. 

folder_name <- "DXbBXaww"

path_to_folder<- "/Input/app/"

data_path <- dkuManagedFolderDownloadPath(folder_name ,paste0(path_to_folder,"file_name.xlsx"))

data <- read.xlsx(data_path ,sheet ="model_applicability")

[CatalinaS]

Below is an example code that shows how to read an Excel file from a local managed folder:

library(dataiku)
library(xlsx)

folder_name <- "hRJwLbQS"
path <- dkuManagedFolderPath(folder_name)
data <- read.xlsx(paste0(path,"/xl2.xlsx"), sheetName="Sheet1")

print(data)

[shashankmittal]

Hi @CatalinaS 

Thanks for the response!

I have also tried with the solution which you have provided but getting an attached error and also I have verified the path which I am providing and its also looking fine.

Please consider the below configuration of my managed folder.

Managed Folder Configuration:

- Managed Folder Type: Server's file system 

- Source: filesystem_root 

Thank you in advance for your attention to this issue. Please let me know if you require any additional information.

[CatalinaS]

The error indicates that the file is not found at the location /data/dataiku/dss_data/config/projects/.../DS Module/Input/app.

You need to check if the path is correct and the Excel file exists at that location.