question

DevBuster-3739 avatar image
0 Votes"
DevBuster-3739 asked MikeUrnun commented

Get data from API and send it in csv file in azure

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?

azure-functionsazure-logic-apps
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

MikeUrnun avatar image
0 Votes"
MikeUrnun answered MikeUrnun commented

Hey @DevBuster-3739 - Welcome to MS QnA!

The following:

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.

will definitely work, and you'd build the solution & manage DevOps like any codebase, not to mention any billing difference there maybe. I would suggest Logic Apps though because you can build your solution very quickly using the design-first approach & leverage the connectors ecosystem for CosmosDB & SFTP, etc. If you have any specific queries around implementation, let me know and I'd be happy to weigh in and help.

· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

@DevBuster-3739 - just checking in here, have you made a decision as to which service & implementation to go with?

0 Votes 0 ·