on 09-01-2015 7:47 PM
Hi,
I have created Httpadapter instance and added an Adapter operation.Below is my target URL and passing parameter ' s ' with value ARE.TO.
http://finance.yahoo.com/q/hp
here is my target .xsd file.
<?xml version="1.0" encoding="UTF-8"?>
<xsd:schema xmlns:xsd="http://www.w3.org/2001/XMLSchema">
<xsd:annotation>
<xsd:documentation xml:lang="en">
XML Schema generated by Data Services
</xsd:documentation>
</xsd:annotation>
<xsd:simpleType name="DIType-decimal-13-2">
<xsd:restriction base="xsd:decimal">
<xsd:totalDigits value="13"/>
<xsd:fractionDigits value="2"/>
</xsd:restriction>
</xsd:simpleType>
<xsd:element name="STOCK_RESULT" >
<xsd:complexType>
<xsd:sequence maxOccurs="unbounded">
<xsd:element ref="STOCK_DATE" />
<xsd:element ref="OPEN" />
<xsd:element ref="HIGH" />
<xsd:element ref="LOW" />
<xsd:element ref="CLOSE" />
<xsd:element ref="VOLUME" />
<xsd:element ref="ADJ_CLOSE" />
</xsd:sequence>
</xsd:complexType>
</xsd:element>
<xsd:element name="STOCK_DATE" type = "xsd:date"/>
<xsd:element name="OPEN" type = "DIType-decimal-13-2"/>
<xsd:element name="HIGH" type = "DIType-decimal-13-2"/>
<xsd:element name="LOW" type = "DIType-decimal-13-2"/>
<xsd:element name="CLOSE" type = "DIType-decimal-13-2"/>
<xsd:element name="VOLUME" type = "xsd:integer"/>
<xsd:element name="ADJ_CLOSE" type = "DIType-decimal-13-2"/>
</xsd:schema>
But while running the BODS job I am getting below error.
5092 22512 XML-240308 09/01/2015 2:41:50 PM XML parser failed: Error: <unable to open file 'http://www.w3.org/TR/html4/strict.dtd'> at line <1>, char <91> in file <>.
Can some provide the input on why it is giving this error.
Thanks
Hi Eswari,
We have a similar requirement (ie., Need to post a XML file to https:// url thru BODS 3.2). Would you please help me with required steps to perform the job. I am totally new to this area and the requirement is 'should be done yesterday' kind of.
I truly appreciate your help.
Thanks,
Ramesh
P.661.317.7770
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
HI Manoj,
Thankyou for your response. I created REST webservice using .wadl file and imported function. When I call function in query transform it is returning EMPTYBODY. Can you please
suggest what could be the reason.
Thanks
Eswari Penta
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
EMPTYBODY for input means the input schema is not defined, how did you get the WADL file ? was it provided by the service provider or you have generated it from a tool ? can you post the complete URL that you are trying to consume ? I can try generating a WADL for you from SoapUI that you can use with DS RESTFul WebServices datastore
Hi Manoj,
Above is the URL we are trying to consume. We used Ready API tool to generate wadl file.
Thanks
Eswari
when you directly post this URL in IE, do you get an XML response ?
this link is displaying a webpage, can you check if the URL is correct
also, if this a RESTFul WebService use RESTFul WebService Datastore instead of HTTP Adapter
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
25 | |
12 | |
9 | |
6 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.