Saturday, November 18, 2017

Sample ODATA Requests



See below for sample odata requests


Test Case Method Expected Status Request URI
$batch - 01 - create entity POST 202/201 /sap/opu/odata/IWFND/RMTSAMPLEFLIGHT/$batch
$batch - 02 - update entity POST 202/204 /sap/opu/odata/IWFND/RMTSAMPLEFLIGHT/$batch
$batch - 03 - 1 changeset, 2 updates POST 202/204/204 /sap/opu/odata/IWFND/RMTSAMPLEFLIGHT/$batch
$batch - 04 - 2 changesets, 1 update each changeset POST 202/204/204 /sap/opu/odata/IWFND/RMTSAMPLEFLIGHT/$batch
$batch - 05 - function import - update POST 202/200 /sap/opu/odata/IWFND/RMTSAMPLEFLIGHT/$batch
$batch - 06 - read - entity POST 202/200 /sap/opu/odata/IWFND/RMTSAMPLEFLIGHT/$batch
$batch - 07 - read & update entity POST 202/200/204 /sap/opu/odata/IWFND/RMTSAMPLEFLIGHT/$batch
$batch - 08 - delete entity POST 202/204 /sap/opu/odata/IWFND/RMTSAMPLEFLIGHT/$batch
$batch - 09 - read - entityset POST 202/200/200 /sap/opu/odata/IWFND/RMTSAMPLEFLIGHT/$batch
$batch - 10 - read - entity / json POST 202/200/200 /sap/opu/odata/IWFND/RMTSAMPLEFLIGHT/$batch
$batch - 11 - read with $filter POST 202/200 /sap/opu/odata/IWFND/RMTSAMPLEFLIGHT/$batch
$batch - 12 - multiple create POST 202/201/201 /sap/opu/odata/IWFND/RMTSAMPLEFLIGHT/$batch
$batch - 13 - multiple delete POST 202/204/204 /sap/opu/odata/IWFND/RMTSAMPLEFLIGHT/$batch
$count GET 200 /sap/opu/odata/IWFND/RMTSAMPLEFLIGHT/TravelagencyCollection/$count
$expand - framework GET 200 /sap/opu/odata/IWFND/RMTSAMPLEFLIGHT/FlightCollection?$expand=FlightCarrier
$expand - framework, if-modified-since GET 200 /sap/opu/odata/IWFND/RMTSAMPLEFLIGHT/FlightCollection?$expand=FlightCarrier
$expand - provider GET 200 /sap/opu/odata/IWFND/RMTSAMPLEFLIGHT/CarrierCollection?$expand=carrierFlights/FlightCarrier
$expand - provider, if-modified-since GET 304 /sap/opu/odata/IWFND/RMTSAMPLEFLIGHT/CarrierCollection?$expand=carrierFlights/FlightCarrier
$expand on entity set - data provider GET 200 /sap/opu/odata/IWBEP/TEA_TEST_APPLICATION/Employees_Expand?$expand=My_Team/Technical_Info
$filter GET 200 /sap/opu/odata/IWFND/RMTSAMPLEFLIGHT/FlightCollection?$filter=carrid eq 'LH' and connid eq '0400'
$filter - complex GET 200 /sap/opu/odata/IWFND/RMTSAMPLEFLIGHT/FlightCollection?$filter=flightDetails/airportFrom eq 'FRA' and
$filter - interval GET 200 /sap/opu/odata/IWFND/RMTSAMPLEFLIGHT/FlightCollection?$filter=carrid ge 'AA' and carrid le 'AC'
$filter - startswith & endswith GET 200 /sap/opu/odata/IWFND/RMTSAMPLEFLIGHT/FlightCollection?$filter=startswith(carrid, 'A') and endswith(c
$filter - substringof GET 200 /sap/opu/odata/IWFND/RMTSAMPLEFLIGHT/FlightCollection?$filter=substringof('H', carrid)
$filter with Id GET 200 /sap/opu/odata/IWBEP/TEA_TEST_APPLICATION/Employees?$filter=Id eq '0001'
$filter with boolean GET 200 /sap/opu/odata/IWBEP/TEA_TEST_APPLICATION/TypeOneEntityCollection?$filter=Boolean eq true
$filter with date GET 200 /sap/opu/odata/IWBEP/TEA_TEST_APPLICATION/TypeOneEntityCollection?$filter=Date_Only gt datetime'2012
$filter with filter conversion on navigation path GET 200 /sap/opu/odata/IWBEP/TEA_TEST_APPLICATION/MassData(1)/Workers_Load?$filter=Id eq '0001'
$filter with guid GET 200 /sap/opu/odata/IWBEP/TEA_TEST_APPLICATION/TypeOneEntityCollection?$filter=GlobalUID eq guid'1F2C6850
$filter with time GET 200 /sap/opu/odata/IWBEP/TEA_TEST_APPLICATION/TypeOneEntityCollection?$filter=Time_Only eq time'PT12H11M
$filter with timestamp GET 200 /sap/opu/odata/IWBEP/TEA_TEST_APPLICATION/TypeOneEntityCollection?$filter=Time_Stamp gt datetime'201
$links - entity GET 200 /sap/opu/odata/IWFND/RMTSAMPLEFLIGHT/FlightCollection(carrid='LH',connid='0400',fldate=datetime'2012
$links - entityset GET 200 /sap/opu/odata/IWFND/RMTSAMPLEFLIGHT/FlightCollection(carrid='LH',connid='0400',fldate=datetime'2012
$links - entityset - count GET 200 /sap/opu/odata/IWFND/RMTSAMPLEFLIGHT/FlightCollection(carrid='LH',connid='0400',fldate=datetime'2012
$orderby GET 200 /sap/opu/odata/IWFND/RMTSAMPLEFLIGHT/FlightCollection?$orderby=carrid desc
$select GET 200 /sap/opu/odata/IWFND/RMTSAMPLEFLIGHT/FlightCollection?$select=carrid,connid
$select with navigation GET 200 /sap/opu/odata/IWFND/RMTSAMPLEFLIGHT/FlightCollection?$select=FlightCarrier
$skip GET 200 /sap/opu/odata/IWFND/RMTSAMPLEFLIGHT/FlightCollection?$top=5&$skip=3
$top GET 200 /sap/opu/odata/IWFND/RMTSAMPLEFLIGHT/FlightCollection?$top=5
$value - complex type GET 200 /sap/opu/odata/IWFND/RMTSAMPLEFLIGHT/FlightCollection(carrid='LH',connid='0400',fldate=datetime'2012
$value - property GET 200 /sap/opu/odata/IWFND/RMTSAMPLEFLIGHT/FlightCollection(carrid='LH',connid='0400',fldate=datetime'2012
entity - 1 - create POST 201 /sap/opu/odata/IWFND/RMTSAMPLEFLIGHT/TravelagencyCollection
entity - 2 - update PUT 204 /sap/opu/odata/IWFND/RMTSAMPLEFLIGHT/TravelagencyCollection(agencynum='00001756')
entity - 3 - read GET 200 /sap/opu/odata/IWFND/RMTSAMPLEFLIGHT/TravelagencyCollection(agencynum='00001756')
entity - 4 - read, json GET 200 /sap/opu/odata/IWFND/RMTSAMPLEFLIGHT/TravelagencyCollection(agencynum='00001756')?$format=json
entity - 5 - read, if-modified-since GET 304 /sap/opu/odata/IWFND/RMTSAMPLEFLIGHT/TravelagencyCollection(agencynum='00001756')
entity - 6 - delete DELETE 204 /sap/opu/odata/IWFND/RMTSAMPLEFLIGHT/TravelagencyCollection(agencynum='00001756')
entityset - read GET 200 /sap/opu/odata/IWFND/RMTSAMPLEFLIGHT/TravelagencyCollection
entityset - read, if-modified-since GET 304 /sap/opu/odata/IWFND/RMTSAMPLEFLIGHT/TravelagencyCollection
function import: CheckFlightAvailability GET 200 /sap/opu/odata/IWFND/RMTSAMPLEFLIGHT/CheckFlightAvailability?airlineid='LH'&connectionid='0400'&flig
media - 1 - create POST 201 400 /sap/opu/odata/IWFND/RMTSAMPLEFLIGHT/CarrierCollection
media - 2 - read GET 200 /sap/opu/odata/IWFND/RMTSAMPLEFLIGHT/CarrierCollection('LH')/$value
media - 3 - read, if-modified-since GET 304 /sap/opu/odata/IWFND/RMTSAMPLEFLIGHT/CarrierCollection('LH')/$value
media - 4 - update PUT 204 /sap/opu/odata/IWFND/RMTSAMPLEFLIGHT/CarrierCollection('LH')/$value
media - 5 - delete DELETE 204 /sap/opu/odata/IWFND/RMTSAMPLEFLIGHT/CarrierCollection('LH')/$value
multi-destination GET 200 /sap/opu/odata/IWFND/RMTSAMPLEFLIGHT;mo/CarrierCollection
multi-destination, expand GET 200 /sap/opu/odata/IWFND/RMTSAMPLEFLIGHT;mo/CarrierCollection?$expand=carrierFlights
multi-destination, expand, json GET 200 /sap/opu/odata/IWFND/RMTSAMPLEFLIGHT;mo/CarrierCollection?$expand=carrierFlights&$format=json
multi-destination, expand, top GET 200 /sap/opu/odata/IWFND/RMTSAMPLEFLIGHT;mo/FlightCollection?$top=1&$expand=FlightCarrier
multi-destination, inlinecount GET 200 /sap/opu/odata/IWFND/RMTSAMPLEFLIGHT;mo/CarrierCollection?$inlinecount=allpages
navigation GET 200 /sap/opu/odata/IWFND/RMTSAMPLEFLIGHT/FlightCollection(carrid='LH',connid='0400',fldate=datetime'2012
opensearchdescription GET 200 /sap/opu/odata/IWFND/RMTSAMPLEFLIGHT/TravelagencyCollection/OpenSearchDescription.xml
sap-ds-debug GET 200 /sap/opu/odata/IWFND/RMTSAMPLEFLIGHT/TravelagencyCollection?sap-ds-debug=true
sp05 - deep insert - 1 - flat structure POST 201 /sap/opu/odata/IWBEP/TEA_TEST_APPLICATION/Employees
sp05 - deep insert - 2 - returned inline POST 201 /sap/opu/odata/IWBEP/TEA_TEST_APPLICATION/Employees
sp05 - deep insert - 3 - flat structure - $batch POST 202/201 /sap/opu/odata/IWBEP/TEA_TEST_APPLICATION/$batch
sp05 - deep insert - 3 - returned inline - $batch POST 202/201 /sap/opu/odata/IWBEP/TEA_TEST_APPLICATION/$batch
sp05 - deep insert - json POST 201 /sap/opu/odata/IWBEP/TEA_TEST_APPLICATION/Employees
sp05 - exception - business GET 400 403 /sap/opu/odata/IWBEP/TEA_TEST_APPLICATION/ErrorCases('BUSI')
sp05 - exception - technical GET 500 /sap/opu/odata/IWBEP/TEA_TEST_APPLICATION/ErrorCases('TECH')
sp05 - exception with bapi info GET 400 /sap/opu/odata/IWBEP/TEA_TEST_APPLICATION/ErrorCases('BUSI_BAPI')
sp05 - exception with details (innererror) GET 400 /sap/opu/odata/IWBEP/TEA_TEST_APPLICATION/ErrorCases('BUSI_DETAILS')
sp05 - exception with previous one GET 400 403 /sap/opu/odata/IWBEP/TEA_TEST_APPLICATION/ErrorCases('BUSI_PREV')
sp05 - idempotent - 1 - create POST 201 412 /sap/opu/odata/IWFND/RMTSAMPLEFLIGHT/TravelagencyCollection
sp05 - idempotent - 2 - create - $batch POST 202/201_400_412/201_400_412 /sap/opu/odata/IWFND/RMTSAMPLEFLIGHT/$batch
sp05 - idempotent - 3 - update PUT 204 412 /sap/opu/odata/IWFND/RMTSAMPLEFLIGHT/TravelagencyCollection(agencynum='00001756')
sp05 - idempotent - 4 - delete DELETE 204 412 /sap/opu/odata/IWFND/RMTSAMPLEFLIGHT/TravelagencyCollection(agencynum='00001756')
sp05 - idempotent - 5 - function import PUT 200 412 /sap/opu/odata/IWBEP/TEA_TEST_APPLICATION/SetEmployeeSalary?Id='0001'&Amount=100
sp06 - $batch - 1 - update with etag POST 202/204_412 /sap/opu/odata/IWFND/RMTSAMPLEFLIGHT/$batch
sp06 - $batch - 2 - multiple updates with etag POST 202/204_412/204_412 /sap/opu/odata/IWFND/RMTSAMPLEFLIGHT/$batch
sp06 - framework expand - 1 - entity GET 200 /sap/opu/odata/IWFND/RMTSAMPLEFLIGHT/FlightCollection(carrid='AA',connid='0017',fldate=datetime'2011
sp06 - framework expand - 1 - entity with two clauses GET 200 /sap/opu/odata/IWFND/RMTSAMPLEFLIGHT/FlightCollection(carrid='AA',connid='0017',fldate=datetime'2011
sp06 - framework expand - 2 - entityset GET 200 /sap/opu/odata/IWFND/RMTSAMPLEFLIGHT/FlightCollection?$expand=FlightCarrier
sp06 - framework expand - 3 - entityset GET 200 /sap/opu/odata/IWFND/RMTSAMPLEFLIGHT/FlightCollection?$expand=FlightCarrier/carrierFlights
sp07 - $batch - 2 changesets, 2 updates each changeset POST 202/204/204/204/204 /sap/opu/odata/IWFND/RMTSAMPLEFLIGHT/$batch
sp07 - $batch - MO - 1 - entityset POST 202/200 /sap/opu/odata/IWFND/RMTSAMPLEFLIGHT;mo/$batch
sp07 - $batch - MO - 2 - entityset - multiple POST 202/200/200 /sap/opu/odata/IWFND/RMTSAMPLEFLIGHT;mo/$batch
sp07 - $batch - MO - 3 - read entityset with SAP__Origin POST 202/200 /sap/opu/odata/IWFND/RMTSAMPLEFLIGHT;mo/$batch
sp07 - $batch - MO - 4 - read entityset with backends POST 202/200/200/200 /sap/opu/odata/IWFND/RMTSAMPLEFLIGHT;mo/$batch
sp07 - $batch - MO - 5 - read entity POST 202/200 /sap/opu/odata/IWFND/RMTSAMPLEFLIGHT;mo/$batch
sp07 - $batch - MO - 6 - changeset POST 202/204_400 /sap/opu/odata/IWFND/RMTSAMPLEFLIGHT;mo/$batch
sp07 - $batch - MO - 7 - entityset & changeset POST 202/200/204_400 /sap/opu/odata/IWFND/RMTSAMPLEFLIGHT;mo/$batch
sp07 - $batch with content id echoing POST 202/400 /sap/opu/odata/IWFND/RMTSAMPLEFLIGHT/$batch
sp07 - $orderby with navigation GET 200 /sap/opu/odata/IWFND/RMTSAMPLEFLIGHT/FlightCollection?$expand=FlightCarrier&$orderby=FlightCarrier/c
sp07 - function import with returning entity GET 200 /sap/opu/odata/IWFND/RMTSAMPLEFLIGHT/CheckFlightAvailability?airlineid='LH'&connectionid='0400'&flig
sp07 - function import with returning entityset GET 200 /sap/opu/odata/IWFND/RMTSAMPLEFLIGHT/GetAvailableFlights?fromdate=datetime'2010-07-20T00%3A00%3A00'&
sp08 - $batch - 1 changeset with BAPI error POST 202/400 /sap/opu/odata/IWBEP/TEA_TEST_APPLICATION/$batch
sp08 - $batch - 2 changesets with BAPI error POST 202/400/400 /sap/opu/odata/IWBEP/TEA_TEST_APPLICATION/$batch
sp08 - $batch - MO - 1 changeset: create+update+delete POST 202/201/204/204 /sap/opu/odata/IWFND/RMTSAMPLEFLIGHT;mo/$batch
sp08 - $batch - MO - 2 changesets: create+update/delete POST 202/201/204/204 /sap/opu/odata/IWFND/RMTSAMPLEFLIGHT;mo/$batch
sp08 - $batch - entity - 1 - create POST 202/201 /sap/opu/odata/IWFND/RMTSAMPLEFLIGHT/$batch
sp08 - $batch - entity - 2 - exists POST 202/200 /sap/opu/odata/IWFND/RMTSAMPLEFLIGHT/$batch
sp08 - $batch - entity - 3 - read POST 202/200 /sap/opu/odata/IWFND/RMTSAMPLEFLIGHT/$batch
sp08 - $batch - entity - 4 - update POST 202/204 /sap/opu/odata/IWFND/RMTSAMPLEFLIGHT/$batch
sp08 - $batch - entity - 5 - read property POST 202/200 /sap/opu/odata/IWFND/RMTSAMPLEFLIGHT/$batch
sp08 - $batch - entity - 6 - read property value POST 202/200 /sap/opu/odata/IWFND/RMTSAMPLEFLIGHT/$batch
sp08 - $batch - entity - 7 - delete POST 202/204 /sap/opu/odata/IWFND/RMTSAMPLEFLIGHT/$batch
sp08 - $batch - entity link exists POST 202/200 /sap/opu/odata/IWFND/RMTSAMPLEFLIGHT/$batch
sp08 - $batch - entity link read POST 202/200 /sap/opu/odata/IWFND/RMTSAMPLEFLIGHT/$batch
sp08 - $batch - entity links count POST 202/200 /sap/opu/odata/IWFND/RMTSAMPLEFLIGHT/$batch
sp08 - $batch - entity links read POST 202/200 /sap/opu/odata/IWFND/RMTSAMPLEFLIGHT/$batch
sp08 - $batch - entity read with navigation POST 202/200 /sap/opu/odata/IWFND/RMTSAMPLEFLIGHT/$batch
sp08 - $batch - entity update with etag POST 202/204_412 /sap/opu/odata/IWFND/RMTSAMPLEFLIGHT/$batch
sp08 - $batch - entityset count POST 202/200 /sap/opu/odata/IWFND/RMTSAMPLEFLIGHT/$batch
sp08 - $batch - entityset read POST 202/200 /sap/opu/odata/IWFND/RMTSAMPLEFLIGHT/$batch
sp08 - $batch - function import - get POST 202/200 /sap/opu/odata/IWFND/RMTSAMPLEFLIGHT/$batch
sp08 - $batch - function import - put POST 202/200 /sap/opu/odata/IWFND/RMTSAMPLEFLIGHT/$batch
sp08 - $batch - function import with RT entityset POST 202/200 /sap/opu/odata/IWFND/RMTSAMPLEFLIGHT/$batch
sp08 - $batch - media - 1 - create POST 202/201_400 /sap/opu/odata/IWFND/RMTSAMPLEFLIGHT/$batch
sp08 - $batch - media - 2 - read POST 202/200 /sap/opu/odata/IWFND/RMTSAMPLEFLIGHT/$batch
sp08 - $batch - media - 3 - delete POST 202/204 /sap/opu/odata/IWFND/RMTSAMPLEFLIGHT/$batch
sp08 - $batch - parallelization POST 202/200/200/200/201/204/200/200/200/204 /sap/opu/odata/IWFND/RMTSAMPLEFLIGHT/$batch
sp08 - SAP note for batch error POST 202/400 /sap/opu/odata/IWFND/RMTSAMPLEFLIGHT/$batch
sp08 - SAP note for provider error GET 403 /sap/opu/odata/IWBEP/TEA_TEST_APPLICATION/ErrorCases('BUSI')
sp08 - entity create with navigation POST 201 400 /sap/opu/odata/IWFND/RMTSAMPLEFLIGHT/FlightCollection(carrid='AA',connid='0017',fldate=datetime'2014
sp08 - entityset - read GET 200 /sap/opu/odata/IWFND/RMTSAMPLEFLIGHT/TravelAgencies_DQ
sp08 - function import with $expand GET 200 /sap/opu/odata/IWFND/RMTSAMPLEFLIGHT/GetAvailableFlights?fromdate=datetime'2010-07-20T00%3A00%3A00'&
sp08 - messages in HTTP header GET 200 /sap/opu/odata/IWBEP/TEA_TEST_APPLICATION/Teams('TEAM_01')
sp08 - warnings in response http-header sap-message: 1 msg GET 200 /sap/opu/odata/IWBEP/TEA_TEST_APPLICATION/Teams('TEAM_01')
sp08 - warnings in response http-header sap-message: 2 msgs GET 200 /sap/opu/odata/IWBEP/TEA_TEST_APPLICATION/Teams('TEAM_02')
sp08 - warnings in response http-header sap-message: 3 msgs GET 200 /sap/opu/odata/IWBEP/TEA_TEST_APPLICATION/Teams('TEAM_03')
sp09 - $batch - deferred processing 1 - ok POST 202/200/200/200/200 /sap/opu/odata/IWFND/RMTSAMPLEFLIGHT/$batch
sp09 - $batch - deferred processing 2 - ok POST 202/204/204 /sap/opu/odata/IWFND/RMTSAMPLEFLIGHT/$batch
sp09 - $batch - deferred processing 3 - error POST 202/400 /sap/opu/odata/IWFND/RMTSAMPLEFLIGHT/$batch
sp09 - conversions: unit & currency GET 200 /sap/opu/odata/IWBEP/TEA_TEST_APPLICATION/Conversions
sp09 - soft state GET 200 /sap/opu/odata/IWBEP/TEA_TEST_APPLICATION/Employees/$count
sp09 - update with etag - error PUT 412 /sap/opu/odata/IWFND/RMTSAMPLEFLIGHT/BookingCollection(carrid='AA',connid='0017',fldate=datetime'201
sp09 - update with etag - ok PUT 204 /sap/opu/odata/IWFND/RMTSAMPLEFLIGHT/BookingCollection(carrid='AA',connid='0017',fldate=datetime'201
sp10 - $batch - 2 updates with etag POST 202 /sap/opu/odata/IWFND/RMTSAMPLEFLIGHT/$batch
sp10 - $select & $expand - entity GET 200 /sap/opu/odata/IWFND/RMTSAMPLEFLIGHT/FlightCollection(carrid='AA',connid='0017',fldate=datetime'2011
sp10 - $select & $expand - entityset GET 200 /sap/opu/odata/IWFND/RMTSAMPLEFLIGHT/FlightCollection?$select=carrid,FlightCarrier/CARRNAME,FlightCa