Exporting Webi document to Excel using REST getting time out

[Former Member]

Hi I am trying to export in excel.

First time it works but from second time it gives cached data.

So I tried refreshing the document, but after second time it is getting time-out

// Refreshing document string RefreshDocUrl = "http://" + Session.IP + ":" + Session.port + "/biprws/raylight/v1/documents/" + DocId + "/parameters?refresh=true"; HttpWebRequest RefreshRequest = (HttpWebRequest)WebRequest.Create(RefreshDocUrl); RefreshRequest.Method = "PUT"; RefreshRequest.ContentType = "application/xml"; RefreshRequest.Headers.Set("X-SAP-LogonToken", Session.LoginToken); HttpWebResponse RefreshResponse = (HttpWebResponse)RefreshRequest.GetResponse();

Export to excel code :

string GetReportUrl = "http://" + Utilities.Session.IP + ":" + Utilities.Session.port + Utilities.Session.version + "/documents/" + DocId + "/reports/" + RptId; HttpWebRequest GetRequest = (HttpWebRequest)WebRequest.Create(GetReportUrl); GetRequest.Method = "GET"; //GetRequest.Timeout = 1200; GetRequest.Accept = "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet"; GetRequest.Headers.Set("X-SAP-LogonToken", Utilities.Session.LoginToken); WebResponse GETResponse = GetRequest.GetResponse();