BIML WebService get a stock quote

gravatar

John Minkjan

How to execute a webservice to get a stock quote using BIML:

published 09.17.12

last updated 04.30.13


Share

Tags

  • BIML
  • WebServiceTask
                            


<Biml xmlns="http://schemas.varigence.com/biml.xsd">
	<Connections>
		<HttpConnection Name="HTTPConnection" 
						ServerUrl="HTTP://www.webservicex.net/stockquote.asmx?wsdl"></HttpConnection>
		<FileConnection Name="FCOutputXmL" 
						FilePath="c:\\Output.XML" 
						FileUsageType="CreateFile"></FileConnection>
	</Connections>
	<Annotations>
		<Annotation>
			File: WebServiceTask.GetXML.biml
			Demo biml using the Web Service Task to
			get a stock quote
			Enviroment:
			DB: MS-SQL2012
			BIML: 1.6 VS2010 BIDS Helper
			(c) John Minkjan biml101.blogspot.com
		</Annotation>
	</Annotations>
	<Packages>		
		<Package Name="WebServiceTask.GetXML" ConstraintMode="Linear">
			<Variables>
				<Variable Name ="StockSymbol" 
						  DataType="String" 
						  EvaluateAsExpression="false">"CBR"</Variable>
				<!--Stock symbol has to be enclosed in double quotes-->
			</Variables>
			<Tasks>
				<WebService Name="WST Get Stock Quote" 
							ServiceName="StockQuote" 
							OverwriteWsdlFile ="true" 
							ConnectionName="HTTPConnection"  
							WebMethod="GetQuote">
					<ExternalWsdlFile ExternalFilePath="c:\\qoute.wsdl" 
									  FileUsageType="ExistingFile" ></ExternalWsdlFile>
					<FileOutput ConnectionName="FCOutputXmL"></FileOutput>
					<Parameters>
						<Parameter  Name="symbol" 
									DataType="String" 
									ParameterType="Variable" 
									VariableName="User.StockSymbol"></Parameter>
					</Parameters>
				</WebService>
			</Tasks>
		</Package>
	</Packages>
</Biml>
                        

How to execute a webservice to get a stock quote using BIML. Also published on http://biml101.blogspot.com

You are not authorized to comment. A verification email has been sent to your email address. Please verify your account.

Comments

There are no comments yet.