Create and save csv or text file in D365 Finance and Operations

In this example, we are going to create a CSV or Text File in Dynamics 365 Finance and Operations. We're going to fill the file with customer records from the CustTable table and download the file locally using your browser. Lets start by adding a new runnable class to our Visual Studio Project. Right Click project name and select add.

Lets add a new class to our Visual Studio Project. Right Click project name. Right Click our project in Visual Studio, if you don't know how to create a project refer back to our earlier tutorials 

In the pop up window or menu items which is displayed , Click the Add menu item.

Click New Item... In the pop up window which is displayed I am going to select code in the left hand window. This will show me all the code options I can add.

Select runnable class in the code pane options and give the class a name. I am going to call the class RunnableClassCreateCSV 

Click Name at the bottom of the dialog or window to give the class the name you would like.

In the Name insert the name of the class RunnableClassCreateCSV 

In the code pane of the class I'll paste some code i prepared earlier

The code we will insert in in the screen shot below. The full code is at the bottom of the article as well  We start by creating a text stream object. the next line then writes to the object and populates it with the header of our file using the write method.We then open the CustTable making sure we are in the USRT company , this is an optional steps and just swithces the company to the one sepecified. We then initialise a while look and populate all the customer records into the stream method using the same write method we used previously. 

Now we have a stream of content we need to read it before it can be send to a file. The stream reader does this. When the stream reader is initialised it is with the text stream object. Reading the  Content to the end converts this to our XML object.

The sendstringasfiletouser method of the file object does the magic and sends the file to the browser.