How can I save the data pulled from API in my notebook to SharePoint?

[alee023]

I have a notebook that calls an API and the response is data in a comma delimited string format - I'm looking to store this as a CSV file in Sharepoint. The data is guaranteed to have around 100k rows. I have a Dataflow that connects to Sharepoint, transforms the CSV data, and puts it in the Lakehouse. Although I was planning to store the raw API data as a CSV, I don't mind storing a copy of the transformed data from the lakehouse as a CSV in Sharepoint. In any case, this would require some way to connect to Sharepoint through the notebook.

I only see tutorials to store data in lakehouses online. The reason I would like to avoid storing this in the lakehouse only is because I plan to run the notebook monthly - so I may want to have a record of the previous months' data stored somewhere, in a CSV format. 

[v-cboorla-msft]

Hi @alee023 

Thanks for using Microsoft Fabric Community.
At this time, we are reaching out to the internal team to get some help on this.
We will update you once we hear back from them.

Appreciate your patience.

Thanks

[v-cboorla-msft · Accepted solution]

Hi @alee023 

Got an update from internal team.

Please refer the below documentation that might help you.

Link : Working with SharePoint sites in Microsoft Graph.

I hope this information helps. Please do let us know if you have any further questions.

Thanks.