Connecting to Sharepoint

Hey all, relatively knew to Knime! Trying to learn the different ways I can retreive data. I’ve been exploring how to retreieve data like CSVs or Excels from Sharepoint sites/lists. I’ve heard conflicting things like Office 365 Connectors (seemed deprecated since installation did not work for me), REST APIs, & other ways to connect to Sharepoint. Anybody have a solution or a method that has worked for them relatively simply?