0
I have installed the atlassian sdk and I am now following the documentation to try and query the tickets:
https://bitbucket.org/farmas/atlassian.net-sdk/wiki/Home
The docs show this:
<span>// create a connection to JIRA using the Rest client</span>
<span>var</span><span> jira </span><span>=</span> <span>Jira</span><span>.</span><span>CreateRestClient</span><span>(</span><span>"http://<your_jira_server>"</span><span>,</span> <span>"<user>"</span><span>,</span> <span>"<password>"</span><span>);</span>
<span>// use LINQ syntax to retrieve issues</span>
<span>var</span><span> issues </span><span>=</span> <span>from</span><span> i </span><span>in</span><span> jira</span><span>.</span><span>Issues</span><span>.</span><span>Queryable</span>
<span>where</span><span> i</span><span>.</span><span>Assignee</span> <span>==</span> <span>"admin"</span> <span>&&</span><span> i</span><span>.</span><span>Priority</span> <span>==</span> <span>"Major"</span>
<span>orderby</span><span> i</span><span>.</span><span>Created</span>
<span>select</span><span> i</span><span>;</span>I have the code listed below this but I am entering the catch statement with the following error (it;s much bigger - this is just the first part of it!)
System.AggregateException: One or more errors occurred. ---> Newtonsoft.Json.JsonSerializationException: Cannot deserialize the current JSON object (e.g. {"name":"value"}) into type 'Atlassian.Jira.Remote.RemoteField[]' because the type requires a JSON array (e.g. [1,2,3]) to deserialize correctly. To fix this error either change the JSON to a JSON array (e.g. [1,2,3]) or change the deserialized type so that it is a normal .NET type (e.g. not a primitive type like integer, not a collection type like an array or List) that can be deserialized from a JSON object. JsonObjectAttribute can also be added to the type to force it to deserialize from a JSON object. Path '', line 1, position 2. at Newtonsoft.Json.Serialization.JsonSerializerInternalReader.CreateObject(JsonReader reader, Type objectType, JsonContract contract, JsonProperty member, JsonContainerContract containerContract, JsonProperty containerMember, Object existingValue) at Newtonsoft.Json.Serialization.JsonSerializerInternalReader.CreateValueInternal
So I think the way that I'm trying to retrieve the results through the foreach loop is incorrect?
<span>foreach</span> <span>(</span><span>var</span><span> issue </span><span>in</span><span> issues</span><span>)</span>
<span>{</span><span> results</span><span>.</span><span>InnerHtml</span> <span>+=</span> <span>(</span><span>issue</span><span>.</span><span>Key</span><span>.</span><span>Value</span> <span>+</span> <span>" -- "</span> <span>+</span><span> issue</span><span>.</span><span>Summary</span><span>);</span>
<span>}</span>But I'm really stuck as to how to retrieve them. Any help would be welcome! I'm a bit stumped!
Full code sample:
<span>namespace JIRA_service_desk</span><span>{</span>
<span>public</span> <span>partial</span> <span>class</span> <span>WebForm3</span> <span>:</span> <span>System</span><span>.</span><span>Web</span><span>.</span><span>UI</span><span>.</span><span>Page</span>
<span>{</span>
<span>protected</span> <span>void</span> <span>Page_Load</span><span>(</span><span>object</span><span> sender</span><span>,</span> <span>EventArgs</span><span> e</span><span>)</span>
<span>{</span>
<span>ServicePointManager</span><span>.</span><span>SecurityProtocol</span> <span>=</span> <span>SecurityProtocolType</span><span>.</span><span>Tls12</span><span>;</span>
<span>var</span><span> jira </span><span>=</span> <span>Jira</span><span>.</span><span>CreateRestClient</span><span>(</span><span>"https://myurl.co.uk"</span><span>,</span> <span>"username"</span><span>,</span> <span>"pwd"</span><span>);</span>
<span>var</span><span> issues </span><span>=</span> <span>from</span><span> i </span><span>in</span><span> jira</span><span>.</span><span>Issues</span><span>.</span><span>Queryable</span>
<span>where</span><span> i</span><span>.</span><span>Assignee</span> <span>==</span> <span>"bob"</span>
<span>orderby</span><span> i</span><span>.</span><span>Created</span>
<span>select</span><span> i</span><span>;</span>
<span>try</span>
<span>{</span>
<span>foreach</span> <span>(</span><span>var</span><span> issue </span><span>in</span><span> issues</span><span>)</span>
<span>{</span><span> results</span><span>.</span><span>InnerHtml</span> <span>+=</span> <span>(</span><span>issue</span><span>.</span><span>Key</span><span>.</span><span>Value</span> <span>+</span> <span>" -- "</span> <span>+</span><span> issue</span><span>.</span><span>Summary</span><span>);</span>
<span>}</span>
<span>}</span>
<span>catch</span><span>(</span><span>Exception</span><span> ex</span><span>)</span>
<span>{</span><span> results</span><span>.</span><span>InnerHtml</span> <span>=</span><span> ex</span><span>.</span><span>ToString</span><span>();</span>
<span>}</span>
<span>//results.InnerHtml = issues.ToString();</span>
<span>}</span>
<span>}</span>
<span>}</span>