Strategy XQuery Editor and Generator (XEG) 10.x generates XQuery script with POST method to query data from REST Web services by default as shown below:
While, POST method is not supported by some REST Web services and error might pop up when executing such XQuery . It's possible to workaround this issue with some user-defined or third-party functions which use GET method instead. For example, some Zorba functions outlined in page below could be used:
http://cf.zorba-xquery.com.s3.amazonaws.com/doc/zorba-0.9.4/zorba/html/rest.html
Here is one sample code with Zorba get() function:
import module namespace zorba-rest = "http://www.zorba-xquery.com/zorba/rest-functions";
declare copy-namespaces no-preserve, no-inherit;
declare namespace mstr-rest = 'http://www.Strategy.com/xquery/rest-functions';
declare function mstr-rest:post($uri,$payload,$header) external;
let $uri := ('http://was-tjiang.corp.Strategy.com:8080/polls/')
let $header := ( )
let $payload := ( )
let $result := zorba-rest:get($uri,$payload,$header)
return
<Table><ColumnHeaders>
<ColumnHeader name='title' type='xs:string' />
</ColumnHeaders>
<Data>{for $ancestor in $result//books/book
return <Row>
<title>{fn:data($ancestor/title)}</title>
</Row>}</Data></Table>