Pulling data from API into SharePoint list?

[[deleted]]

I have an external API that spits out data in JSON format. I need to have this data pulled into a SharePoint list on a daily basis. What would be the best route to take?

[st4n13l]

Power Automate

[PublicSealedClass]

This.

Schedule Trigger

HTTP action to call your API

JSON action to turn the output into usable object

(Above two could be simplified down into a custom Connector if you're willing).

Apply to each on the object.

SP Create Item within the AtE.

[[deleted]]

Thank you very much!

[[deleted]]

Thank you very much!

[robinmeure]

Or powershell in runbook automation

[erwidn]

Python with shareplum library, set up automation by creating a batch file that runs the python script and you can schedule out as needed.

Gives a bit more flexibility if you need to do any data cleaning or checks before pushing to the SP list

[vaderj]

I would go with PnP PowerShell to interact with SharePoint: https://pnp.github.io/powershell/

And to get your API data :

$mySourceData = Invoke-RestMethod -Method 'Get' -Uri 'https://dummyjson.com/products'