private static void UploadAndBindCampaignContributionsReport(string datasetId)
{
// upload report PBIX
string reportName = "Campaign Contributions Report";
// delay until import process has completed
if (ReportDoesNotExist(reportName))
{
Console.WriteLine("Uploading report " + reportName);
Stream pbixStream = new MemoryStream(Properties.Resources.CampaignContributionsReport_pbix);
Import import = pbiClient.Imports.PostImportWithFileInGroup(appWorkspaceId, pbixStream, reportName);
import = pbiClient.Imports.GetImportById(import.Id);
Console.Write("Waiting for import process to complete");
while (!import.ImportState.Equals("Succeeded"))
{
Console.Write(".");
Thread.Sleep(1000);
import = pbiClient.Imports.GetImportById(import.Id);
}
Console.WriteLine();
Console.WriteLine("Binding " + reportName + " to dataset...");
string reportID = import.Reports[0].Id;
RebindReportRequest bindRequest = new RebindReportRequest(datasetId);
pbiClient.Reports.RebindReportInGroup(appWorkspaceId, reportID, bindRequest);
}
}
private static async Task RebindReport()
{
EnsureBasicParams(EnsureExtras.WorkspaceCollection | EnsureExtras.WorspaceId);
reportId = userInput.EnsureParam(reportId, "Report Id");
datasetId = userInput.EnsureParam(datasetId, "Dataset Id to rebind to");
var rebindReportRequest = new RebindReportRequest(datasetId);
using (var client = await CreateClient())
{
await client.Reports.RebindReportAsync(
workspaceCollectionName,
workspaceId,
reportId,
rebindReportRequest);
}
}
/// <summary>
/// Rebinds the specified report to requested dataset id
/// </summary>
/// <param name='operations'>
/// The operations group for this extension method.
/// </param>
/// <param name='groupId'>
/// The group id
/// </param>
/// <param name='reportId'>
/// The report id
/// </param>
/// <param name='requestParameters'>
/// Rebind report parameters
/// </param>
/// <param name='cancellationToken'>
/// The cancellation token.
/// </param>
public static async Task RebindReportAsync(this IReportsOperations operations, Guid groupId, Guid reportId, RebindReportRequest requestParameters, CancellationToken cancellationToken = default(CancellationToken))
{
(await operations.RebindReportInGroupWithHttpMessagesAsync(groupId, reportId, requestParameters, null, cancellationToken).ConfigureAwait(false)).Dispose();
}
/// <summary>
/// Rebinds the specified report to requested dataset id
/// </summary>
/// <param name='operations'>
/// The operations group for this extension method.
/// </param>
/// <param name='groupId'>
/// The group id
/// </param>
/// <param name='reportId'>
/// The report id
/// </param>
/// <param name='requestParameters'>
/// Rebind report parameters
/// </param>
public static void RebindReport(this IReportsOperations operations, Guid groupId, Guid reportId, RebindReportRequest requestParameters)
{
operations.RebindReportAsync(groupId, reportId, requestParameters).GetAwaiter().GetResult();
}
/// <summary>
/// Rebinds the specified report to requested dataset id
/// </summary>
/// <param name='operations'>
/// The operations group for this extension method.
/// </param>
/// <param name='groupId'>
/// The group id
/// </param>
/// <param name='reportKey'>
/// The report id
/// </param>
/// <param name='requestParameters'>
/// Rebind report parameters
/// </param>
/// <param name='cancellationToken'>
/// The cancellation token.
/// </param>
public static async Task <object> RebindReportInGroupAsync(this IReports operations, string groupId, string reportKey, RebindReportRequest requestParameters, CancellationToken cancellationToken = default(CancellationToken))
{
using (var _result = await operations.RebindReportInGroupWithHttpMessagesAsync(groupId, reportKey, requestParameters, null, cancellationToken).ConfigureAwait(false))
{
return(_result.Body);
}
}
/// <summary>
/// Rebinds the specified report to requested dataset id
/// </summary>
/// <param name='operations'>
/// The operations group for this extension method.
/// </param>
/// <param name='groupId'>
/// The group id
/// </param>
/// <param name='reportKey'>
/// The report id
/// </param>
/// <param name='requestParameters'>
/// Rebind report parameters
/// </param>
public static object RebindReportInGroup(this IReports operations, string groupId, string reportKey, RebindReportRequest requestParameters)
{
return(operations.RebindReportInGroupAsync(groupId, reportKey, requestParameters).GetAwaiter().GetResult());
}
/// <summary>
/// Rebinds the specified report to requested dataset id
/// </summary>
/// <param name='collectionName'>
/// The workspace collection name
/// </param>
/// <param name='workspaceId'>
/// The workspace id
/// </param>
/// <param name='reportKey'>
/// The report id
/// </param>
/// <param name='requestParameters'>
/// Rebind report parameters
/// </param>
/// <param name='customHeaders'>
/// Headers that will be added to request.
/// </param>
/// <param name='cancellationToken'>
/// The cancellation token.
/// </param>
/// <return>
/// A response object containing the response body and response headers.
/// </return>
public async Task <HttpOperationResponse <object> > RebindReportWithHttpMessagesAsync(string collectionName, string workspaceId, string reportKey, RebindReportRequest requestParameters, Dictionary <string, List <string> > customHeaders = null, CancellationToken cancellationToken = default(CancellationToken))
{
if (collectionName == null)
{
throw new ValidationException(ValidationRules.CannotBeNull, "collectionName");
}
if (workspaceId == null)
{
throw new ValidationException(ValidationRules.CannotBeNull, "workspaceId");
}
if (reportKey == null)
{
throw new ValidationException(ValidationRules.CannotBeNull, "reportKey");
}
if (requestParameters == null)
{
throw new ValidationException(ValidationRules.CannotBeNull, "requestParameters");
}
// Tracing
bool _shouldTrace = ServiceClientTracing.IsEnabled;
string _invocationId = null;
if (_shouldTrace)
{
_invocationId = ServiceClientTracing.NextInvocationId.ToString();
Dictionary <string, object> tracingParameters = new Dictionary <string, object>();
tracingParameters.Add("collectionName", collectionName);
tracingParameters.Add("workspaceId", workspaceId);
tracingParameters.Add("reportKey", reportKey);
tracingParameters.Add("requestParameters", requestParameters);
tracingParameters.Add("cancellationToken", cancellationToken);
ServiceClientTracing.Enter(_invocationId, this, "RebindReport", tracingParameters);
}
// Construct URL
var _baseUrl = this.Client.BaseUri.AbsoluteUri;
var _url = new Uri(new Uri(_baseUrl + (_baseUrl.EndsWith("/") ? "" : "/")), "v1.0/collections/{collectionName}/workspaces/{workspaceId}/reports/{reportKey}/Rebind").ToString();
_url = _url.Replace("{collectionName}", Uri.EscapeDataString(collectionName));
_url = _url.Replace("{workspaceId}", Uri.EscapeDataString(workspaceId));
_url = _url.Replace("{reportKey}", Uri.EscapeDataString(reportKey));
// Create HTTP transport objects
HttpRequestMessage _httpRequest = new HttpRequestMessage();
HttpResponseMessage _httpResponse = null;
_httpRequest.Method = new HttpMethod("POST");
_httpRequest.RequestUri = new Uri(_url);
// Set Headers
if (customHeaders != null)
{
foreach (var _header in customHeaders)
{
if (_httpRequest.Headers.Contains(_header.Key))
{
_httpRequest.Headers.Remove(_header.Key);
}
_httpRequest.Headers.TryAddWithoutValidation(_header.Key, _header.Value);
}
}
// Serialize Request
string _requestContent = null;
if (requestParameters != null)
{
_requestContent = SafeJsonConvert.SerializeObject(requestParameters, this.Client.SerializationSettings);
_httpRequest.Content = new StringContent(_requestContent, Encoding.UTF8);
_httpRequest.Content.Headers.ContentType = MediaTypeHeaderValue.Parse("application/json; charset=utf-8");
}
// Set Credentials
if (this.Client.Credentials != null)
{
cancellationToken.ThrowIfCancellationRequested();
await this.Client.Credentials.ProcessHttpRequestAsync(_httpRequest, cancellationToken).ConfigureAwait(false);
}
// Send Request
if (_shouldTrace)
{
ServiceClientTracing.SendRequest(_invocationId, _httpRequest);
}
cancellationToken.ThrowIfCancellationRequested();
_httpResponse = await this.Client.HttpClient.SendAsync(_httpRequest, cancellationToken).ConfigureAwait(false);
if (_shouldTrace)
{
ServiceClientTracing.ReceiveResponse(_invocationId, _httpResponse);
}
HttpStatusCode _statusCode = _httpResponse.StatusCode;
cancellationToken.ThrowIfCancellationRequested();
string _responseContent = null;
if ((int)_statusCode != 200)
{
var ex = new HttpOperationException(string.Format("Operation returned an invalid status code '{0}'", _statusCode));
_responseContent = await _httpResponse.Content.ReadAsStringAsync().ConfigureAwait(false);
ex.Request = new HttpRequestMessageWrapper(_httpRequest, _requestContent);
ex.Response = new HttpResponseMessageWrapper(_httpResponse, _responseContent);
if (_shouldTrace)
{
ServiceClientTracing.Error(_invocationId, ex);
}
_httpRequest.Dispose();
if (_httpResponse != null)
{
_httpResponse.Dispose();
}
throw ex;
}
// Create Result
var _result = new HttpOperationResponse <object>();
_result.Request = _httpRequest;
_result.Response = _httpResponse;
// Deserialize Response
if ((int)_statusCode == 200)
{
_responseContent = await _httpResponse.Content.ReadAsStringAsync().ConfigureAwait(false);
try
{
_result.Body = SafeJsonConvert.DeserializeObject <object>(_responseContent, this.Client.DeserializationSettings);
}
catch (JsonException ex)
{
_httpRequest.Dispose();
if (_httpResponse != null)
{
_httpResponse.Dispose();
}
throw new SerializationException("Unable to deserialize the response.", _responseContent, ex);
}
}
if (_shouldTrace)
{
ServiceClientTracing.Exit(_invocationId, _result);
}
return(_result);
}
/// <summary>
/// Rebinds the specified report to requested dataset id
/// </summary>
/// <param name='operations'>
/// The operations group for this extension method.
/// </param>
/// <param name='collectionName'>
/// The workspace collection name
/// </param>
/// <param name='workspaceId'>
/// The workspace id
/// </param>
/// <param name='reportKey'>
/// The report id
/// </param>
/// <param name='requestParameters'>
/// Rebind report parameters
/// </param>
public static object RebindReport(this IReports operations, string collectionName, string workspaceId, string reportKey, RebindReportRequest requestParameters)
{
return(operations.RebindReportAsync(collectionName, workspaceId, reportKey, requestParameters).GetAwaiter().GetResult());
}
/// <summary>
/// Rebinds the specified report to requested dataset id
/// </summary>
/// <param name='operations'>
/// The operations group for this extension method.
/// </param>
/// <param name='collectionName'>
/// The workspace collection name
/// </param>
/// <param name='workspaceId'>
/// The workspace id
/// </param>
/// <param name='reportKey'>
/// The report id
/// </param>
/// <param name='requestParameters'>
/// Rebind report parameters
/// </param>
public static object RebindReport(this IReports operations, string collectionName, string workspaceId, string reportKey, RebindReportRequest requestParameters)
{
return(Task.Factory.StartNew(s => ((IReports)s).RebindReportAsync(collectionName, workspaceId, reportKey, requestParameters), operations, CancellationToken.None, TaskCreationOptions.None, TaskScheduler.Default).Unwrap().GetAwaiter().GetResult());
}
