I managed to pull CenterPoint Data using the Data Browser and API using the C# sample tutorial. I get output into the Console just for those records with state of "MN".

So I am wondering how to get all the data without any filter from my report and get it downloaded into a csv file.

My two files are below; I have tried different methods without success, what would I need to change on my code to make this happened.

Note: I know on the CenterPoint DataBrowser section I would have to uncheck the State/Province box. I am specifically talking about the code. Ideally, I would want my csv file to look like the one pop up on the
csv file when the export is done within the CenterPoint DataBrowser "Get Data" button.

---

PROGAM.CS FILE;

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Data;
using CenterPointDataBrowser;
using System.IO;

namespace DataPull2CSV
{
class Program
{
static void Main(string[] args)

{

// While each report generates a DataSet, the DataSet will

// only contain one table.

DataSet ds = ReportDataExample.GetCustomerListData("MN");

// Sorting by City and customer name

List<DataRow> rows = ds.Tables[0].Select("", "City, Customer").ToList();

// Output the city and customer to the standard output window

foreach (DataRow row in rows)

Console.WriteLine("{0}: {1}", row["City"], row["Customer"]);




// Wait for key press

/Console.ReadKey();



}
}
}

---

REPORTDATAEXAMPLE.CS FILE;


using System;
using System.Collections.Generic;
using System.Data;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using CenterPointDataBrowser;

namespace CenterPointDataBrowser
{
public class ReportDataExample
{
public static DataSet GetCustomerListData(string stateAbbreviation)
{
string databaseName = "OURDATABASE NAME";
string reportKey = "df93cd71-1691-4925-9526-6d1bd69bc0c5";
string userName = "*******";
string password = "*******";

// Initialize the API
DataAccessAPI api = new DataAccessAPI();

// Open the database
api.OpenDatabase(databaseName,userName,password); // there is an over-loaded method if you need to supply a user/name password

// Retrieve the report
Report report = api.GetReport(reportKey);

// Uncomment the following line of code line if you do not want any filters
// If commented out, then the filters set in CP are applied.
// report.ClearFilters();

// Set filters (optional)
report.SetFilterText("Filter_State", TextOperators.Equals, stateAbbreviation);


// Uncomment the following line of code line if you do not want any options
// If commented out, then the options set in CP are used
// report.ClearOptions();

// Set options (optional)


// Gather the report's data
//
// Note: Some reports only return the data needed to produce the report. If you want
// to return all data, then change GetReportData(false) to GetReportData(true)
DataSet ds = report.GetReportData(false);

// Close the database
api.CloseDatabase();
return ds;
}
}
}


Thank you for the support

I made those changes, but no luck. I saw those instructions on the manual, I guess I am more concern on how my code should look like on the PROGAM.CS FILE.

thank you for the support

Thank you, so I managed to print all Cities and Customer to the console without restricting only to 'MN' state;

How could I modify so I can get all columns(Not just City and Customer) to output? Also, I added the line of code to get file output into a csv but can not seem to get it going.



Thank you for the support.

Below are the changes I made to my PROGRAM.CS FILE:



using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Data;
using CenterPointDataBrowser;
using System.IO;

namespace DataPull2CSV
{
class Program
{
static void Main(string[] args)

{

// While each report generates a DataSet, the DataSet will

// only contain one table.

DataSet ds = ReportDataExample.GetReportData();

// Sorting by City and customer name

List<DataRow> rows = ds.Tables[0].Select().ToList();

// Output the city and customer to the standard output window

foreach (DataRow row in rows)

Console.WriteLine("{0}: {1}", row["City"], row["Customer"]);


// Wait for key press
DataAccessAPI.OutputFile(Report,ds, "C:\\Users\\..\\data_browser_example.csv");
Console.ReadKey();

Thank you, I know how to print now any field I would want from within any report, that worked.


I am still having some issues in the saving into a csv file time. Below are the changes I made;

ERROR I KEEP GETTING;
An unhandled exception of type 'System.IO.FileNotFoundException' occurred in mscorlib.dll
Could not find file 'C:\Users\Documents\CenterPointDownloads\data_browser_example.csv'.





Changes Made to Code:

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Data;
using CenterPointDataBrowser;
using System.IO;

namespace DataPull2CSV
{
class Program
{
static void Main(string[] args)

{

// While each report generates a DataSet, the DataSet will

// only contain one table.

DataSet ds = ReportDataExample.GetReportData();

// Sorting by City and customer name

List<DataRow> rows = ds.Tables[0].Select().ToList();

// Output the city and customer to the standard output window

foreach (DataRow row in rows)
Console.WriteLine($"{row["Abbreviation"]}, {row["Customer"]}, {row["City"]}, {row["State"]}, {row["Zip"]}");
//Console.ReadKey();
// Output data to console
string text = File.ReadAllText("C:\\Users\\Documents\\CenterPointDownloads\\data_browser_example.csv");
Console.WriteLine(text);


Also, how do I mark my code on a block the way you did on the last reply
Thank you for the support

EDIT;
I forgot to add the error message:
Error CS0119 'Report' is a type, which is not valid in the given context

---

I see, I apologized

I made the changes, and below is the code I have now. I am sure you can tell I am a bit new to C#, so thank you for the patience here. So, I don't know what variable "Report" is representing on the following line;



Below is current script for my PROGRAM.CS FILE;


Thank you

Edited by user Thursday, October 7, 2021 12:39:36 AM(UTC)  | Reason: Forgot to add the new error I was getting, now is there

Thank you so much. I got the csv output I was looking for after making the below changes to my code and reading all the notes on the last message you provided.

Now I can go home and sleep comfortably. I might follow up tomorrow for any further questions if you don't mind.

Again, thanks a ton for the support, means a lot.