5 Replies Latest reply on Feb 26, 2015 5:41 AM by shawkins

Error importing Rest Web Service Source

jjaideep2000 Oct 23, 2014 6:05 PM

Hello all -

I am trying to import Rest Web Service data source. This Rest web service sends a simple JSON response. After I create REST Web Service source, I get error message:

"Parse Error: The markup in the document folllowing the root element must be well formed."

The JSON response from the web service looks exactly like:

{

"ObTypes": [

"Ob1",

"Ob2",

"Ob3"

]

}

Appreciate your help !

Thanks,

1. Re: Error importing Rest Web Service Source

shawkins Oct 23, 2014 6:32 PM (in response to jjaideep2000)

I don't recognize this message as coming from the server. Do you have a stack trace or more log entries related to this? More than likely it's something specific to Teiid Designer.
Actions
2. Re: Error importing Rest Web Service Source

jjaideep2000 Oct 23, 2014 7:05 PM (in response to shawkins)

Hi Steven,

Yes, that seems right. I am checking the server log (rhc tail jbossdv) and I don't see any activity when I get this error. This could very well be Teiid Designer issue. Do you know any workaround ? or anyone who can help here?

Thanks,
Jaideep
Actions
3. Re: Error importing Rest Web Service Source

tejones Oct 24, 2014 9:26 AM (in response to jjaideep2000)

Hi Jaideep,

Have you set your response type to JSON in the REST connection profile? It sounds like we are expecting XML.

Thanks,
Ted
Actions
4. Re: Error importing Rest Web Service Source

jjaideep2000 Oct 29, 2014 5:58 PM (in response to tejones)

After some trial and errors, I figured out the issue. This is regarding the JSON structure. Just having a valid JSON is not enough, it requires a root element. Instead of
{
    "ObTypes": [
        "Ob1",
        "Ob2",
        "Ob3"
    ]
}
I needed {"Root":
{
    "ObTypes": [
        "Ob1",
        "Ob2",
        "Ob3"
    ]
}}.
Actions
5. Re: Error importing Rest Web Service Source

shawkins Feb 26, 2015 5:41 AM (in response to jjaideep2000)

We should address this as the error is unclear and it seems common - [TEIIDDES-2439] Import from JSON error not helpful - JBoss Issue Tracker
Actions

Go to original post