cancel
Showing results for 
Search instead for 
Did you mean: 

Getting error while calling rest webservice through BODS

Former Member
0 Kudos


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

http://finance.yahoo.com/q/hphttp://finance.yahoo.com/q/hp

Accepted Solutions (0)

Answers (3)

Answers (3)

Former Member
0 Kudos

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

Former Member
0 Kudos

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

Former Member
0 Kudos

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

Former Member
0 Kudos

https://query.yahooapis.com/v1/public/yql?q=select%20*%20from%20yahoo.finance.historicaldata%20where...

Hi Manoj,

  Above is the URL we are trying to consume. We used Ready API tool to generate wadl file.

Thanks

Eswari

Former Member
0 Kudos

I generated the WADL using SoapUI, but looks like there is a bug in DS where it's escaping /, which is causing invalid input

do you have a support case open for this ? if yes, what is the message # ?

Former Member
0 Kudos

Hi Manoj,

    I have created SAP ticket # 670782 for this incident.

Thanks

Eswari Penta

Former Member
0 Kudos

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