You can translate the question and the replies:

Dynamically Query a WS With Compound Values

Hello, We have a requirement in which a soap ws needs to be dynamically queried. The mandatory input parameter to query the ws is a compound type: * { ROW( '', Parameter1, '' ),ROW( '', Parameter2, '' )} Is it possible to pass a text Parameter inside ROW('','','') in order to filter dynamically? If something other than a literal text is added inside ROW, it returns an error. Thanks.
user
14-12-2022 05:24:30 -0500
code

1 Answer

Hi, Denodo webservices can be queried with compound values. There is more information in the the manual page [Requests with Input Compound Values] (https://community.denodo.com/docs/html/browse/8.0/en/vdp/administration/restfularchitecture/restfulwebservice/requestswithinputcompoundvalues) and, in those compound values, "each value can be an attribute, a literal, a number, a logical value, an expression to evaluate or a new ROW element" according to the the more general page about how Denodo handles [queries with compound values](https://community.denodo.com/docs/html/browse/latest/en/vdp/vql/queriesselectstatement/whereclause/whereclause). These pages do assume a RESTful service but inputs to a SOAP should be similar as Denodo SOAP webservices can accept soapenc:Array and soapenc:complexType comlpex types. Hope this helps!
Denodo Team
20-12-2022 11:18:32 -0500
code
You must sign in to add an answer. If you do not have an account, you can register here