Responsive Ads Here

Friday, November 9, 2012

Retrieving Data From SAP Using REST Webservice URL

Fetching Data From SAP using REST Web Service

 string strURL = @" http://10.10.10.90:8000/sap/opu/odata/sap/Z_INSPQC_RFC_CM_02/z_inspqc_rfc_02Collection?$format=xml";  
 //rest webservice URL  
 public DataSet getData(string URL)  
     {  
       DataSet ds = new DataSet();  
       HttpWebRequest wRequest1 = (HttpWebRequest)WebRequest.Create(URL);  
       wRequest1.Credentials = new NetworkCredential("abapuser", "admin123");  
       HttpWebResponse wResponse1 = (HttpWebResponse)wRequest1.GetResponse();  
       if (wRequest1.HaveResponse)  
       {  
         if (wResponse1.StatusCode == HttpStatusCode.OK)  
         {  
           StreamReader StreamHandler = new System.IO.StreamReader(wResponse1.GetResponseStream());  
           xmlDoc.LoadXml(StreamHandler.ReadToEnd());  
           XmlNodeReader data = new XmlNodeReader(xmlDoc);  
           ds.ReadXml(data);  
         }  
       }  
       return ds;  
     }  

Update Data to SAP using REST Web Service

 string strDetailsURL1 = @"http://10.10.10.90:8000/sap/opu/odata/sap/Z_INSPQC_RFC_CM_06/z_inspqc_rfc_06Collection?$filter=inspdet eq '" + data + "'&$format=xml";  
         HttpWebRequest wRequest1 = (HttpWebRequest)WebRequest.Create(strDetailsURL1);  
         wRequest1.Credentials = new NetworkCredential("abapuser", "admin123");  
         XmlDocument xmlDoc = new XmlDocument();  
         DataSet ds = new DataSet();  
         HttpWebResponse wResponse = (HttpWebResponse)wRequest1.GetResponse();  
         if (wRequest1.HaveResponse)  
         {  
           if (wResponse.StatusCode == HttpStatusCode.OK)  
           {  
            //success fully updated  
            }  
          }  

1 comment: