Supported OData Query Options

[Former Member]

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

[former_member477623]

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

[Former Member]

hi Suman. It is asking for username password when I try to open this note. What is the username and password for it?

[former_member477623]

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