Data Sources

Rest Service

Json

var financialDataSourceItem = new RestServiceBuilder("https://excel2json.io/api/share/8bb2cd78-1b87-4142-00a2-08da188ec9ab")
    .SetTitle("Finance Data Source")
    .SetSubtitle("OHLC")
    .SetFields(new List<IField>
    {
        new DateField("Date"),
        new NumberField("Open"),
        new NumberField("High"),
        new NumberField("Low"),
        new NumberField("Close"),
        new NumberField("Volume"),
    })
    .Build();

Excel

var excelDataSourceItem = new RestServiceBuilder("http://dl.infragistics.com/reportplus/reveal/samples/Samples.xlsx")
    .UseExcel("Marketing")
    .SetTitle("Excel Data Source")
    .SetSubtitle("Marketing Sheet")
    .SetFields(new List<IField>
    {
        new DateField("Date"),
        new NumberField("Spend"),
        new NumberField("Budget"),
        new NumberField("CTR"),
        new NumberField("Avg. CPC"),
        new NumberField("Traffic"),
        new NumberField("Paid Traffic"),
        new NumberField("Other Traffic"),
        new NumberField("Conversions"),
        new TextField("Territory"),
        new TextField("CampaignID"),
        new NumberField("New Seats"),
        new NumberField("Paid %"),
        new NumberField("Organic %")
    })
    .Build();

CSV

var csvDataSourceItem = new RestServiceBuilder("https://query.data.world/s/y32gtgblzpemyyvtig47dz7tedgkto")
    .UseCsv()
    .SetTitle("CSV Data Source")
    .SetSubtitle("Illinois School Info")
    .SetFields(new List<IField>
    {
        new TextField("the_geom"),
        new NumberField("School_ID"),
        new TextField("School_Nm"),
        new TextField("Sch_Addr"),
        new TextField("Grade_Cat"),
        new TextField("Grades"),
        new TextField("Sch_Type"),
        new NumberField("X"),
        new NumberField("Y"),
    })
    .Build();

MS SQL Server

var sqlServerDataSourceItem = new SqlServerBuilder("host", "database", "table")
    .SetTitle("SQL Server")
    .SetSubtitle("Orders")
    .SetFields(new List<IField>()
    {
        new TextField("CustomerID"),
        new NumberField("OrderID"),
    })
    .Build();