/// <summary>
/// Method to get queries jsons under Shared folder path
/// </summary>
/// <param name="project"></param>
/// <param name="path"></param>
public void GetQueriesByPath(string project, string path)
{
try
{
using (var client = new HttpClient())
{
client.BaseAddress = new Uri(_sourceConfig.UriString);
client.DefaultRequestHeaders.Accept.Clear();
client.DefaultRequestHeaders.Accept.Add(new System.Net.Http.Headers.MediaTypeWithQualityHeaderValue("application/json"));
client.DefaultRequestHeaders.Authorization = new AuthenticationHeaderValue("Basic", _sourceCredentials);
HttpResponseMessage response = client.GetAsync("/DefaultCollection/" + project + "/_apis/wit/queries/Shared%20Queries?$depth=1&api-version=2.2").Result;
if (response.IsSuccessStatusCode)
{
QueryByPathResponse.query QueryResponse = response.Content.ReadAsAsync <QueryByPathResponse.query>().Result;
if (QueryResponse.hasChildren)
{
foreach (var child in QueryResponse.children)
{
if (!(child.isFolder))
{
HttpResponseMessage responseForQuery = client.GetAsync("/DefaultCollection/" + project + "/_apis/wit/queries/" + child.id + "?$expand=wiql&$depth=2&api-version=4.1").Result;
QueryByPathResponse.QueryWithWiql Query = responseForQuery.Content.ReadAsAsync <QueryByPathResponse.QueryWithWiql>().Result;
if (!Directory.Exists(@"Templates\QueriesByPath"))
{
Directory.CreateDirectory(@"Templates\QueriesByPath");
}
string fetchedCardFieldsJSON = JsonConvert.SerializeObject(Query, Formatting.Indented);
System.IO.File.WriteAllText(@"Templates\QueriesByPath\" + Query.name + ".json", fetchedCardFieldsJSON);
}
}
}
}
}
}
catch (Exception ex)
{
Console.WriteLine("Error occured while generating query template: " + ex.Message);
Console.WriteLine("");
}
}
public Dictionary <string, string> GetQueriesByPath(string project, string path)
{
Dictionary <string, string> QueryList = new Dictionary <string, string>();
using (var client = new HttpClient())
{
client.BaseAddress = new Uri(_sourceConfig.UriString);
client.DefaultRequestHeaders.Accept.Clear();
client.DefaultRequestHeaders.Accept.Add(new System.Net.Http.Headers.MediaTypeWithQualityHeaderValue("application/json"));
client.DefaultRequestHeaders.Authorization = new AuthenticationHeaderValue("Basic", _sourceCredentials);
HttpResponseMessage response = client.GetAsync("/DefaultCollection/" + project + "/_apis/wit/queries/Shared%20Queries?$depth=1&api-version=2.2").Result;
if (response.IsSuccessStatusCode)
{
QueryByPathResponse.query QueryResponse = response.Content.ReadAsAsync <QueryByPathResponse.query>().Result;
if (QueryResponse.hasChildren)
{
foreach (var child in QueryResponse.children)
{
if (!(child.isFolder))
{
QueryList.Add(child.id, child.name);
if (!Directory.Exists(@"Templates\QueriesByPath"))
{
Directory.CreateDirectory(@"Templates\QueriesByPath");
}
string fetchedCardFieldsJSON = JsonConvert.SerializeObject(child, Formatting.Indented);
System.IO.File.WriteAllText(@"Templates\QueriesByPath\" + child.name + ".json", fetchedCardFieldsJSON);
}
}
}
}
}
return(QueryList);
}
