Obtener TRM de BanRep

uiautomation

#1

Buenas tardes,

Quisiera obtener desde la página del Banco de la república el valor de la TRM.

Tengo dos opciones:

Espero una pronta colaboración.

Muchas gracias.


#2

Buenas tardes,

Este error ocurre cuando trato de consumir un WSDL con parámetros con clases, el envío del parámetro lo realizo de la siguiente forma:

New ReportRef With { .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", .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:sequence></xsd:complextype></xsd:schema>" }

Generando el siguiente error:

Main has thrown an exception

Message: Cannot create unknown type ‘{http://schemas.microsoft.com/netfx/2009/xaml/activities}InArgument({clr-namespace:;assembly=2azv5yd0}ReportRef)’.

Source: System.Xaml

Exception Type: XamlObjectWriterException

System.Xaml.XamlObjectWriterException: Cannot create unknown type ‘{http://schemas.microsoft.com/netfx/2009/xaml/activities}InArgument({clr-namespace:;assembly=2azv5yd0}ReportRef)’.
at System.Xaml.XamlObjectWriter.WriteStartObject(XamlType xamlType)
at System.Xaml.XamlWriter.WriteNode(XamlReader reader)
at System.Xaml.XamlServices.Transform(XamlReader xamlReader, XamlWriter xamlWriter, Boolean closeWriter)
at System.Activities.XamlIntegration.FuncFactory1.Evaluate() at System.Activities.DynamicActivity.OnInternalCacheMetadata(Boolean createEmptyBindings) at System.Activities.Activity.InternalCacheMetadata(Boolean createEmptyBindings, IList1& validationErrors)
at System.Activities.ActivityUtilities.ProcessActivity(ChildActivity childActivity, ChildActivity& nextActivity, Stack1& activitiesRemaining, ActivityCallStack parentChain, IList1& validationErrors, ProcessActivityTreeOptions options, ProcessActivityCallback callback)
at System.Activities.ActivityUtilities.ProcessActivityTreeCore(ChildActivity currentActivity, ActivityCallStack parentChain, ProcessActivityTreeOptions options, ProcessActivityCallback callback, IList1& validationErrors) at System.Activities.ActivityUtilities.CacheRootMetadata(Activity activity, LocationReferenceEnvironment hostEnvironment, ProcessActivityTreeOptions options, ProcessActivityCallback callback, IList1& validationErrors)
at System.Activities.Hosting.WorkflowInstance.ValidateWorkflow(WorkflowInstanceExtensionManager extensionManager)
at System.Activities.Hosting.WorkflowInstance.RegisterExtensionManager(WorkflowInstanceExtensionManager extensionManager)
at System.Activities.WorkflowApplication.EnsureInitialized()
at System.Activities.WorkflowApplication.Enqueue(InstanceOperation operation, Boolean push)
at System.Activities.WorkflowApplication.SimpleOperationAsyncResult.Run(TimeSpan timeout)
at System.Activities.WorkflowApplication.BeginRun(AsyncCallback callback, Object state)
at UiPath.Executor.RobotRunner.<>c__DisplayClass49_0.b__0()