Can anyone tell me how they would handle a former SQL Server process where SSIS package was uploaded to a server/API?

New solution has data in is a Postgres view, Postgres is hosted in AWS. How would you schedule this to upload the view data to a REST API using AWS? This needs to be weekly. Looking for general solution direction or guide on this ETL need. Thanks!