You can translate the question and the replies:

POST Rest Webservice Failling

Hi, I am using the sample stored procedureCalculateAvgRevenue . I created a rest webservice. http://localhost:9090/server/tutorial/p_getrev/views/p_getrev POST with X-HTTP-Method-Override GET below request works JSON Request { “$filter”:”taxid_list={ ROW( ‘1’) }”} but with below request it doesnt work. It throws error as :The value of the parameter ‘taxid_list’ is not valid. JSON Request: { “taxid_list”: [ { “taxid”: “1” } ]} Is this limitation of rest web service?. Can you please help. Thanks Prashant

1 Answer

Hi, For your scenario, I would use the below filter condition in the Post body of the JSON data source. > \{ > > "$filter":"(taxid_list).taxid=1" > \} As of now, it is only possible to pass the JSON document(i.e., Array vaule ) using $filter parameter, not as a value of the field. For more information, you can have look at [Parameters of the Web Service RESTful and REST Web Services](https://community.denodo.com/docs/html/browse/latest/vdp/administration/restful_architecture/restful_web_service/input_parameters_of_the_restful_web_service) and [Restrictions of the JSON syntax](https://community.denodo.com/docs/html/browse/latest/vdp/administration/restful_architecture/restful_web_service/requests_with_input_compound_values) section of the Virtual DataPort Administration Guide. Hope this helps!
Denodo Team
08-01-2021 04:45:01 -0500
You must sign in to add an answer. If you do not have an account, you can register here