Why am i getting "The operation has timed out" when i try to exract data ?

Nada El Boustaoui

0down votefavorite

I am trying to to extract data from Jira via JIRA REST API from a c# application. to do so i execute this method :

<span>public</span> <span>string</span> <span>RunQuerry</span><span>(</span><span>JiraRessource</span><span> resource</span><span>,</span> <span>string</span><span> project_id</span><span>,</span> <span>int</span><span> startAt</span><span>,</span> <span>int</span><span> maxResults</span><span>,</span> <span>string</span><span> method </span><span>=</span> <span>"GET"</span><span>)</span>
        <span>{</span>
             <span>string</span><span> url </span><span>=</span> <span>string</span><span>.</span><span>Format</span><span>(</span><span>m_BaseUrl</span><span>);</span>
            <span>if</span> <span>(</span><span>project_id </span><span>!=</span> <span>null</span><span>)</span>
            <span>{</span>
                <span>string</span><span> jql </span><span>=</span> <span>"search?jql=project="</span> <span>+</span><span> project_id</span><span>;</span><span>                url </span><span>=</span> <span>string</span><span>.</span><span>Format</span><span>(</span><span>"{0}{1}"</span><span>,</span><span> url</span><span>,</span><span> jql</span><span>);</span>
            <span>}</span>
            <span>string</span><span> jqr </span><span>=</span> <span>"&startAt="</span> <span>+</span><span> startAt </span><span>+</span> <span>"&maxResults="</span> <span>+</span><span> maxResults</span><span>;</span><span>            url </span><span>=</span> <span>string</span><span>.</span><span>Format</span><span>(</span><span>"{0}{1}"</span><span>,</span><span> url</span><span>,</span><span> jqr</span><span>);</span>

            <span>HttpWebRequest</span><span> request </span><span>=</span> <span>WebRequest</span><span>.</span><span>Create</span><span>(</span><span>url</span><span>)</span> <span>as</span> <span>HttpWebRequest</span><span>;</span><span>            request</span><span>.</span><span>ContentType</span> <span>=</span> <span>"application/json"</span><span>;</span><span>            request</span><span>.</span><span>Method</span> <span>=</span><span> method</span><span>;</span>

            <span>string</span><span> base64Credentials </span><span>=</span> <span>GetEncodedCredentials</span><span>();</span><span>            request</span><span>.</span><span>Headers</span><span>.</span><span>Add</span><span>(</span><span>"Authorization"</span><span>,</span> <span>"Basic "</span> <span>+</span><span> base64Credentials</span><span>);</span>
            <span>string</span><span> result </span><span>=</span> <span>string</span><span>.</span><span>Empty</span><span>;</span><span>            using </span><span>(</span><span>WebResponse</span><span> response </span><span>=</span><span> request</span><span>.</span><span>GetResponse</span><span>())</span>
            <span>{</span><span>                using </span><span>(</span><span>StreamReader</span><span> reader </span><span>=</span> <span>new</span> <span>StreamReader</span><span>(</span><span>response</span><span>.</span><span>GetResponseStream</span><span>()))</span>
                <span>{</span><span>                    result </span><span>=</span><span> reader</span><span>.</span><span>ReadToEnd</span><span>();</span>
                    <span>return</span><span> result</span><span>;</span>
                <span>}</span>
            <span>}</span>
        <span>}</span>

i execute this method in a loop in order to be able to get all issues after i read that the REST API only gives 50 issues each time. I get errors such as "connection timed out" or "unable to read data from the transport connection". i searched online and all i found is that the connection to the server is lost but i do not know how to solve this. If anyone knows anything about the reason why i'm getting this error or how to solve it i will be very thankful.

Nada El Boustaoui

The problem is that although i put a condition on the StartAt it always starts form 0 while extracting the data. 

for example if i use the link :

http://eudca-jira01/jira/rest/api/latest/search?jql=project=C1A&startAt=0&maxResults=50 

i get the first last 50 issues on my list. But if i use the following :

http://eudca-jira01/jira/rest/api/latest/search?jql=project=C1A&startAt=50&maxResults=100

the result is 100 issues it includes the first 50 issues too. 
so after it gets to thousands of issues the data becomes voluminous and it breaks the connection. 

does anyone have any idea on how to set the startAt parameter in other to only get the issues in the chosen range of values ??