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]( and [Restrictions of the JSON syntax]( 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