download excel file from sharepoint

[Zak_234]

Please provide a solution on, how to download an excel file from MS Sharepoint.

Thanks in advance.

Zak

[sidd]

I do have the same task where i tried couple of steps provided in other article(https://community.talend.com/s/feed/0D53p00007vCkqHCAS) but i am getting the below error.

Exception in component tHttpRequest_1 (Copy_of_TBC_PP_LOAD_MEASURE_DIM)

java.lang.RuntimeException: Request failed:403 Forbidden

{"error":{"code":"-2147024891, System.UnauthorizedAccessException","message":{"lang":"en-US","value":"Access denied. You do not have permission to perform this action or access this resource."}}}

at tbbi_firm_etl.copy_of_tbc_pp_load_measure_dim_0_1.Copy_of_TBC_PP_LOAD_MEASURE_DIM.tHttpRequest_1Process(Copy_of_TBC_PP_LOAD_MEASURE_DIM.java:2014)

at tbbi_firm_etl.copy_of_tbc_pp_load_measure_dim_0_1.Copy_of_TBC_PP_LOAD_MEASURE_DIM.runJobInTOS(Copy_of_TBC_PP_LOAD_MEASURE_DIM.java:3192)

at tbbi_firm_etl.copy_of_tbc_pp_load_measure_dim_0_1.Copy_of_TBC_PP_LOAD_MEASURE_DIM.main(Copy_of_TBC_PP_LOAD_MEASURE_DIM.java:2326)

[FATAL] 04:00:48 tbbi_firm_etl.copy_of_tbc_pp_load_measure_dim_0_1.Copy_of_TBC_PP_LOAD_MEASURE_DIM- tHttpRequest_1 Request failed:403 Forbidden