About RalfHandl

RalfHandl

Everyone is using REST APIs nowadays, despite the fact that HTTP is an inherently unreliable protocol. So how to deal with "lost requests" and "lost responses"? Not a problem for GET requests: just repeat them if you get no answer - GET is "safe" and...

RalfHandl

Seven years ago we published OData 4.0 as a set of OASIS Standards - now we have the next incremental, fully compatible "release": the OData 4.01 specifications – Core, JSON Data, JSON Metadata, and XML Metadata – are approved as OASIS Standards and ...

RalfHandl

When I try to upload a new version of an XML file attached to one of my Community wiki pages, I get the following error message: The following error(s) occurred: Virus found in file :upload_d9501a77_068b_4d4d_9554_eaffcb9eb77e_000...

RalfHandl

Four years after OData V4 became an OASIS standard, and two years after it became the ISO/IEC 20802 standard, the first “feature pack” for OData V4 has been officially published. The complete set of changes is described in What’s New in OData Versio...

RalfHandl

Usually REST APIs produce minimized JSON without any line breaks or indentation, which preserves bandwidth and is fine if a machine is reading the produced JSON. If however the intended audience mainly consists of humans, e.g. if the JSON files need...

RalfHandl

Which OData version (V2, V4) and which stack (CAP, RAP, ...) care you using?OData V2 does not allow collections of strings at all.OData V4 allows collections of strings, and they are supported in CAP. Not sure about the implementation state in RAP.

RalfHandl

The API in question uses OData V2, and OData V2 does not allow filtering expanded items.Please check whether there is a newer OData V4 API and switch to it.

RalfHandl

Filters within $expand work independent of the filter on the root.Your example filters on root, and the $expand only filters on schedule lines, there is no filter on items.Adding a filter in $expand for the items should return the desired result:/sap...

RalfHandl

Assuming 2) returns all headers you want, and you only want to have items with material '123', you can extend the query with a nested filter on items:/sap/opu/odata4/sap/zsales_order_srv/srvd_a2x/sap/zsales_order/0001/SalesOrderHeader?$expand=_Item($...

RalfHandl

The main difference is that$skip is well-defined: its value is the non-negative number of entities to skip when constructing the result$skiptoken is reserved for service-specific use in server-driven pagingSome known uses of $skiptoken:Contains the l...

User Statistics

User Activity

Repeatable Requests for REST APIs

OData Version 4.01 published as OASIS Standards

[BUG] Virus error when uploading attachment to community wiki page

OData V4.01 approved as a Committee Specification

Pretty-Printing JSON with CALL TRANSFORMATION

Re: Collection of String in deep entity model

Re: S/4 HANA Public Cloud - Sales Order Odata API - How t...

Re: Usage of filter at grand child level ODATA 4

Re: Usage of filter on multilevel expand

Re: Odata Service $skip vs. $skiptoken