El primer paso es agregar la referencia web al proyecto en Visual. En este caso específico es: http://obiee.banrep.gov.co/analytics/saw.dll?wsdl
Luego viene el código para leer el reporte específico:
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 | using System;using System.Collections.Generic;using System.Globalization;using System.Linq;using System.Text;using System.Threading.Tasks;using System.Xml;using System.Data.SqlClient;using System.Configuration;using TRM_BanRep.banrep;using System.Data;namespace TRM_BanRep{ class Program { /// <summary> /// Based on Obiee Web Services – Using .net and C# post on http://tipsonobiee.blogspot.com/2009/07/obiee-web-services-using-net-and-c.html /// </summary> /// <param name="args"> static void Main(string[] args) { //Open SAW session in OracleBI - Banco de la Republica SAWSessionServiceSoapClient sawSession = new SAWSessionServiceSoapClient(); string sessionID = sawSession.logon("publico", "publico"); //Set report parameters ReportRef repRef = new ReportRef(); //path: get from report http url repRef.reportPath = @"/shared/Consulta Series Estadisticas desde Excel/1. Tasa de Cambio Peso Colombiano" + "/1.1 TRM - Disponible desde el 27 de noviembre de 1991/TRM para un dia"; //xml: get from report http url + &format=xml repRef.reportXml = "<xsd:schema targetnamespace="\" urn:schemas-microsoft-com:xml-analysis:rowset=""><xsd:complextype name="\">" + "<xsd:sequence><xsd:element 35="" as="" ate="" char="" character="" dd="" de="" echa="" evaluate="" fmday="" maxoccurs="\" minoccurs="\" month="" name="\" nls_date_language="SPANISH" nonagg="" none="" saw-sql:aggregationrule="\" saw-sql:aggregationtype="\" saw-sql:columnheading="\" saw-sql:displayformula="\" saw-sql:tableheading="\" saw-sql:type="\" type="\" xsd:string="" yyyy="">" + "<xsd:element a="" del="" echa="" maxoccurs="\" mes="" minoccurs="\" name="\" nonagg="" none="" saw-sql:aggregationrule="\" saw-sql:aggregationtype="\" saw-sql:columnheading="\" saw-sql:displayformula="\" saw-sql:tableheading="\" saw-sql:type="\" tinyint="" type="\" xsd:byte="">" + "<xsd:element agg="" double="" max="" maxoccurs="\" minoccurs="\" name="\" saw-sql:aggregationrule="\" saw-sql:aggregationtype="\" saw-sql:columnheading="\" saw-sql:displayformula="\" saw-sql:tableheading="\" saw-sql:type="\" type="\" xsd:double=""></xsd:element></xsd:element></xsd:element></xsd:sequence></xsd:complextype></xsd:schema>"; //Create xml view, set xml options XmlViewServiceSoapClient xmlView = new XmlViewServiceSoapClient(); XMLQueryExecutionOptions xmlOpts = new XMLQueryExecutionOptions(); xmlOpts.maxRowsPerPage = 100; xmlOpts.refresh = true; //Pass report parameters ReportParams repParams = new ReportParams(); //Execute XML Query QueryResults qResults = xmlView.executeXMLQuery(repRef, XMLQueryOutputFormat.SAWRowsetData, xmlOpts, repParams, sessionID); //Print rowset sawSession.logoff(sessionID); //Get rate value from result XML XmlDocument results = new XmlDocument(); results.LoadXml(qResults.rowset); DateTime trmDate = DateTime.Today.AddDays(-5); XmlNodeList xnlDate = results.GetElementsByTagName("Column0"); foreach (XmlNode xn in xnlDate) trmDate = DateTime.ParseExact(xn.InnerText, "dddd d 'de' MMMM 'de' yyyy", CultureInfo.CreateSpecificCulture("es-CO")); decimal trm = decimal.Zero; XmlNodeList xnlRate = results.GetElementsByTagName("Column2"); foreach (XmlNode xn in xnlRate) trm = Convert.ToDecimal(xn.InnerText, CultureInfo.InvariantCulture); } }} |
Nota: La URL del reporte mencionada en los comentarios se obtiene del código fuente de la página.
