Name is required.
Email address is required.
Invalid email address
Answer is required.
Exceeding max length of 5KB

SharePoint download Excel file

Hi,
I'm doing my first job in Matillion and wonder about the use case when I need to download Excel file from Microsoft SharePoint. Then I would like to parse that Excel and put into RedShift table.
Question is how to actually download an Excel from Sharepoint?
I managed to list SharePoint files in target space, however have no clue how to download it. Excel Query as a data source doesn't provide SharePoint option

Any examples to share?
Thanks in advance

3 Community Answers

Best Answer  >Matillion Agent  

Paul Johnson —

Hi Sergey,
You should be able to use the data transfer component to download the SharePoint excel files to S3, and then use the Excel query component to load it into Redshift.

Regards,
Paul

Best Answer  Matillion Agent  

Paul Johnson —

Hi Sergey,
You should be able to use the data transfer component to download the SharePoint excel files to S3, and then use the Excel query component to load it into Redshift.

Regards,
Paul


Sergey Nekhviadovich —

Hi Paul,
Thank you for the quick response!
I've managed to download the file
Hint for the community: File URL should contain relative path to file inside the site

Also SharePoint is not described yet in https://redshiftsupport.matillion.com/customer/en/portal/articles/2953509-data-transfer-component?b_id=8915 - worth updating


Matillion Agent  

Arawan Gajajiva —

Hi Sergey -

Thanks for the additional tip! And we’ll get that documentation updated ASAP!

Best regards,
Arawan

Post Your Community Answer

To add an answer please login