Skip to Content
author's profile photo Former Member
Former Member

ODATA service on HANA based on Calc. view with parameters.

Hi,

I have an issue with OData service declaration based on the view with input parameters.

Service declaration :

service {

"sizegrid::GROUP_SEARCH" as "Cartons"

keys generate local "Box_HID"

aggregates always

parameters via entity "InputParams";

}


Calculation view GROUP_SEARCH has 2 input parameters :


After service has been activated, I can succesfully access $metadata and .xsodata links. However, if I try to pass inbound parameters, there is an error :

http://instance:8000/sizegrid/ztest/services/cartons.xsodata/InputParams(positive_selection_threshold=0.8,ordered_boxes='')/?


<error xmlns="http://schemas.microsoft.com/ado/2007/08/dataservices/metadata">

<code/>

<message xml:lang="en-US">Illegal query syntax.</message>

</error>

I've searched through all the blogs and discussions but still can't understand what is wrong with the syntax.

Can somebody help, please ?

Thanks !

view_params.png (11.9 kB)
Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

3 Answers

  • Posted on May 18, 2015 at 04:11 PM
    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on May 18, 2015 at 06:57 PM

    Hello Yuri,

    which types do your parameters in the view have? I had the issue one time, because I passed a double value within quotes (e.g. '10.00') to a parameter of type double. Maybe the type of your parameter "ordered_boxes" is not a character based type.

    At the end of the URL you have a '?'. This causes no issue, but if you wann get the results you should add "Results" which is the default name for the result navigation property.

    Best Regards,

    Florian

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on May 20, 2015 at 08:48 AM

    Your URL looks incorrect, it should be something like this:

    /blah/blah/cartons.xsodata/InputParameters(P_PARM1='X', P_PARM2='Y')/Results

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.