Skip to Content
avatar image
Former Member

Supported OData Query Options

Hi all,

OData supports query options like $filter=cityfrom eq 'SINGAPORE' or $select=...

(A full list can be found [here|http://www.odata.org/media/16352/%5Bms-odata%5D.pdf])

1) Which options are supported by Gateway?

2) What is the "Gateway Solution" to filter the result of the GetList/Query command for a specific entity?

(e.g. return all flights with city of departure equal to 'Singapore')

Best Regards,

Florian

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Best Answer
    avatar image
    Former Member
    Sep 07, 2011 at 03:03 PM

    Hi -

    Supported options are listed in [Note 1574568 - SAP NetWeaver Gateway 2.0 - Known Constraints|https://service.sap.com/sap/support/notes/1574568]. There are currently some limitations for query options like $filter.

    But it can handle what you describe (e.g. filtering flights by depart city). It would be just as you had it. For example, .../FlightService/FlightCollection?$filter=cityfrom eq 'SINGAPORE'&...

    Regards,

    Jin

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hello Ashwin,

      Many thanks for the hint, it is indeed working now!

      I got an error message due to a missing & before the $filter,

      which I found out through debugging.

      Regards, Rolf

  • avatar image
    Former Member
    Dec 10, 2015 at 03:53 AM

    This message was moderated.

    Add comment
    10|10000 characters needed characters exceeded

  • Apr 14, 2016 at 07:37 PM

    Supported options are listed in [Note 1574568 - SAP NetWeaver Gateway 2.0 - Known Constraints|https://service.sap.com/sap/support/notes/1574568].   There are currently some limitations for query options like $filter.

    But it can handle what you describe (e.g. filtering flights by depart city).  It would be just as you had it.  For example,  .../FlightService/FlightCollection?$filter=cityfrom eq 'SINGAPORE'&...

    Regards,

    Suman

    Add comment
    10|10000 characters needed characters exceeded

    • Hi Arslan,

      Sap s-user user name and password.Sap service market place user name.

      other way

      1 . Transaction SNOTE

      2 . Goto-Download sap note ( Top of the screen)

      3 . Enter the note number (1574568) then Execute

      4 . After download the note, Double Click on the note number

      5 . Or go back click on overview,enter the note number ,Execute