Connect to Sharepoint folder

Hi - at the moment we are manually taking client reports from Pipedrive and putting them into a Sharepoint folder. We have set up Power BI to connect to the Sharepoint folder to produce the dashboards we need.
We would like to use the Pipedrive API to populate the Sharepoint folder. Sorry for the broad question, but is this a simple task? Do you have any links to understand this?

Welcome to the community @phillm

Just curious to know how it works. Are you consuming the data in these folders as .csv or excel files for reporting in PowerBI?

Depending on how you interface with PowerBI, you very well use the API as a data source directly than moving it to SharePoint and then to PowerBI. However, this depends on your use case too.

Feel free to add further details :slight_smile: