Uploaded image for project: 'OASIS Open Data Protocol (OData) TC'
  1. OASIS Open Data Protocol (OData) TC
  2. ODATA-1239

Define a mechanism to distinguish between inserted and updated entities in a Delta Response

    XMLWordPrintable

    Details

    • Type: Improvement
    • Status: Open
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: V4.01_CS02
    • Fix Version/s: V4.02_WD01
    • Component/s: JSON Format, Protocol
    • Labels:
      None

      Description

      In a delta response, Added and Changed entities are represented as Entities in the delta response.  There is no way for the client to distinguish between an Inserted entity and a Changed entity.  If the client is using the delta response to keep data in a cache or data warehouse in sync, then the distinction between an Inserted and Updated entity doesn't really matter.  The client would do an upsert of the Inserted / Updated entity.  If the entity exists it gets updated and if it doesn't it gets inserted.

      However, in cases where the changes are being tracked for auditing or reporting purposes, it is useful to be able to distinguish between an inserted or updated entity.  There is a difference between inserted and updated entities in a delta response in that an inserted entity must include all selected properties where as an updated entity must only include all selected properties that changed.  The distinction is not reliable for detecting the difference though.  It is possible that all of the selected properties of an existing entity have change and it is also possible that a server would always return all selected properties of an updated entity.

      Consider adding an optional @inserted or @updated annotation or both to make the distinction between the Inserted and Updated entities,  This is similar to the @removed annotation that already exists.

      When a delta payload is provided to the service in the body of an update request, the @inserted or @updated annotations would typically would not be needed, but it should be fine to include them if for example the delta payload was originally received as a delta response.

       

       

        Attachments

          Activity

            People

            • Assignee:
              Unassigned
              Reporter:
              mark.biamonte Mark Biamonte
            • Watchers:
              1 Start watching this issue

              Dates

              • Created:
                Updated: