Don't miss out Virtual Happy Hour this Friday (April 26).

Try our conversational search powered by Generative AI!

AI OnAI Off

Creating a flat file with EpiServer scheduled job

Dileep D
Dileep D
Vote:
 

Hello,

I have a need to create a flat file of some data from EpiServer database and send it to a third party AWS S3 bucket for reporting purpose. Now the steps I am thinking is to create a scheduled job which will fetch data which I am familiar with.

Question is where should I output the file in the DXC environment so once the file is ready I can send the file either through SFTP or AWS S3 API something. Is there any preferred way of doing this?

#217011
Feb 12, 2020 16:34
Ravindra S. Rathore
Ravindra S. Rathore
Vote:
 

Hi Dileep,

I suggest you to avoid storing the file to physical location instead of this you can go with Azure blobs storage and then serve the file from there.

https://docs.microsoft.com/en-us/samples/azure-samples/storage-blob-dotnet-getting-started/storage-blob-dotnet-getting-started/

https://www.c-sharpcorner.com/article/upload-and-download-file-to-azure-blob-storage-using-c-sharp/

#217013
Edited, Feb 12, 2020 16:53
* You are NOT allowed to include any hyperlinks in the post because your account hasn't associated to your company. User profile should be updated.