An external API will call our API end point and push payment info every few minutes. We only need id# and need to write it in CSV file.
Store data in csv file for 1 hour. Once an hour is complete send the file to sftp server.
Then again create a new file start writing the data. We need to perform this operation 24*7.
Which azure resource should be appropriate to use here. Any help is greatly appreciated.
I can use Azure function and build an API to get the data and store in Cosmos DB.
Then another Azure function which will run every hour, get the data, place in file and push to sftp server.
Please suggest if there is any better alternative?