Post data from OneDrive csv to Bubble

Hi,

I have a .csv file in OneDrive, that I want to schdedule to daily import into a data type.

I have tried a bit of Power Automate to get file contents, convert to JSON, then POST via the HTML API, to a backendworkflow.

Also tried making the .csv file public and then trying to get Bubble to upload it. But no success.
Also tried the Zapier OneDrive zap but didnt work.

Any advise, or routes to take? Summary is, to move the contents of a CSV file from OneDrive into Bubble database, on schedule.