You can translate the question and the replies:

passing one of regiser or array fields as parameter in webservice url

hi, how to convert the below query to a webservice url? select * from tableA where (x).y.z=1 here x is a register of array y with field z Thanks, chethan
REST Webservice
user
16-09-2019 08:04:44 -0400
code

1 Answer

Hi You could filter the field with compound data types in a web service URL by using the $filter Parameter. For example, `http://<host>:<posrt>/..../.../views/view1?$filter=array_field_name='[{"id":1, "id2": 2, "field1": "a", "field2": true}]'` For more details, you can refer to the[ Requests with Input Compound Values](https://community.denodo.com/docs/html/browse/7.0/vdp/administration/restful_architecture/restful_web_service/requests_with_input_compound_values#requests-with-input-compound-values) section of the Virtual DataPort Administration Guide which explains in detail with examples to pass the filter conditions with fields belonging to arrays and register data types. Hope this helps.
Denodo Team
18-09-2019 09:22:17 -0400
code
You must sign in to add an answer. If you do not have an account, you can register here