コード例 #1
0
ファイル: RequestTests.cs プロジェクト: salesforce/MagiQL
        public async Task SimpleQueryAsync()
        {
            var client = new ReportsServiceClient();

            var columns = await client.GetSelectableColumnsAsync(this.platform, 1, null, null);

            var request = new SearchRequest()
            {
                SelectedColumns     = columns.Data.Take(30).Select(x => new SelectedColumn(x.Id)).ToList(),
                TemporalAggregation = TemporalAggregation.Total,
                PageSize            = 100,
                SortByColumn        = columns.Data.Where(x => x.UniqueName == "CampaignID").Select(x => new SelectedColumn(x.Id)).First(),
                GroupByColumn       = columns.Data.Where(x => x.UniqueName == "CampaignID").Select(x => new SelectedColumn(x.Id)).First(),
                GetCount            = true,
            };


            var result = await client.SearchAsync(this.platform, 1, null, request);

            Assert.IsNotNull(result);
            Assert.IsNotNull(result.Data);
            Assert.GreaterOrEqual(result.Data.Count, 1);

            Console.WriteLine("{0} rows returned", result.Data.Count);
        }
コード例 #2
0
ファイル: RequestTests.cs プロジェクト: salesforce/MagiQL
        public async Task GetColumnsAsync()
        {
            var client = new ReportsServiceClient();

            client.RequestHeaders = new List <RequestHeader>
            {
                new RequestHeader()
                {
                    Name = "x-correlation-id", Value = Guid.NewGuid().ToString()
                },
                new RequestHeader()
                {
                    Name = "x-requesting-component", Value = "Tests"
                }
            };

            var columns = await client.GetSelectableColumnsAsync(this.platform, 1, null, null);

            Assert.IsNotNull(columns);
            Assert.IsNotNull(columns.Data);
            Assert.GreaterOrEqual(columns.Data.Count, 1);

            Console.WriteLine("{0} columns returned", columns.Data.Count);
        }