public async Task <HttpResponseMessage> AddRowsString([FromUri][Metadata("Dataset ID", "The Dataset ID from Power BI", VisibilityType.Default)] string datasetId,
[FromUri][Metadata("Table Name", "The name of the Table from Power BI", VisibilityType.Default)] string table,
[FromBody][Metadata("Rows", "Comma-separated list of JSON Objects for each row to be inputted")] string rows)
{
PowerBIRows pbiRows = ConvertRowStringToPowerBIRows(rows);
return(await AddRowsShared(datasetId, table, pbiRows));
}
public async Task <HttpResponseMessage> AddRowsString([FromUri][Metadata("Dataset ID", "The Dataset ID from Power BI", VisibilityType.Default)] string datasetId,
[FromUri][Metadata("Table Name", "The name of the Table from Power BI", VisibilityType.Default)] string table,
[FromBody][Metadata("Rows Array", "Array of rows to add to Power BI")] JArray rowsArray)
{
PowerBIRows pbiRows = new PowerBIRows {
rows = rowsArray.ToList()
};
return(await AddRowsShared(datasetId, table, pbiRows));
}
private async Task <HttpResponseMessage> AddRowsShared(string datasetId, string table, PowerBIRows pbiRows)
{
await authHelper.CheckToken();
using (var client = new HttpClient())
{
client.DefaultRequestHeaders.Authorization = new System.Net.Http.Headers.AuthenticationHeaderValue("Bearer", authorization.AccessToken);
var result = await client.PostAsync(string.Format("https://api.powerbi.com/v1.0/myorg/datasets/{0}/tables/{1}/rows", datasetId, table), new StringContent(JsonConvert.SerializeObject(pbiRows), Encoding.UTF8, "application/json"));
if (result.StatusCode == HttpStatusCode.OK)
{
return(Request.CreateResponse <PowerBIRows>(HttpStatusCode.OK, pbiRows));
}
else
{
return(result);
}
}
}
