Page Comparison

...

Export revisions effected by the user identified by userId = 1 during the time period March 1 (startDate) to March 15 (endDate). The exported list should include the list of modified record attributes/properties during each revision. The exported file contains the list of revisions arranged in reverse chronological order i.e. the latest revision at the top and ancient revision at the bottom of the file.

Note: Request entities and OpenSpecimen Record Types relations added at the end of page.

URL

/openspecimen/rest/ng/audit/export-revisions

Method

POST

Body

Expand

title	Request: Single User

Code Block

{
  "startDate": 1551398400000,
  "endDate": 1552608000000,
  "userId": 1,
  "includeModifiedProps": true,
  "entities": ["Participant", "ParticipantMedicalIdentifier", "CollectionProtocolRegistration", "ParticipantExtension"]
}

Expand

title	Request: Multiple Users

Code Block

language	js

{
  "startDate": 1551398400000,
  "endDate": 1552608000000,
  "userIds": [1, 2, 3],
  "includeModifiedProps": true,
  "entities": ["Participant", "ParticipantMedicalIdentifier", "CollectionProtocolRegistration", "ParticipantExtension"]
}

Response

The response contains the file ID that can be used to download the exported revisions file.

...

Parameter	Description
startDate	Start date of the interval for which the revisions list is queried. If not specified, startDate = endDate - 30 days
endDate	End date of the interval for which the revisions list is queried. If not specified endDate = end of today.
userId	Restrict the exported list to revisions effected by the user identified by userId. Optional parameter.
userIds	Restrict the exported list to revisions effected by the users identified by the list of userIds. Optional parameter. (Supported from v6.3)
entities	Optional parameter. Specifies the list of entities or record types whose revisions need to be exported. This is very useful when the requestor intends to review the revisions of only certain record types say Shipment and ShipmentItem. ShipmentSpecimen. This parameter was added in v6.1.RC5.
includeModifiedProps	Specifies whether the exported list should include modified attributes list for each revision.

...

Given below is an example of the CSV file created when includeModifiedProps = true. Notice the change log column, it includes the list of properties that got modified during the op along with their new values.

Revision ID	Revision Time	User	User Email ID	Operation	Record Type	Record	Change Log
169879	09 Jul 2019 15:26	John Doe	john.doe@openspecimen.org	Edit	Specimen	244004	collectionStatus=Collected,createdOn=Tue Jul 09 15:26:00 IST 2019,position={id=295350}
169879	09 Jul 2019 15:26	John Doe	john.doe@openspecimen.org	Add	Storage Container Position	295354	blocked=false,container={id=514},occupyingSpecimen={id=244010},posOne=8,posOneOrdinal=8,posTwo=3,posTwoOrdinal=3

When includeModifiedProps = false, the generated CSV file is as below. Notice the change log column is empty. It goes without saying that generating this kind of file is much faster than the above one as the API has to do lesser work.

Revision ID	Revision Time	User	User Email ID	Operation	Record Type	Record	Change Log
169879	09 Jul 2019 15:26	John Doe	john.doe@openspecimen.org	Edit	Specimen	244004
169879	09 Jul 2019 15:26	John Doe	john.doe@openspecimen.org	Add	Storage Container Position	295354

The below table explains request entities and OpenSpecimen record type relation details.

Request Entities	OpenSpecimen Record Type
`SpecimenList`	Carts
`Specimen`	Specimen
`SpecimenExternalIdentifier`	Specimen External Identifier
`Visit`	Visit
`CollectionProtocolRegistration`	Collection Protocol Registration
`Participant`	Participant
`ParticipantMedicalIdentifier`	Participant Medical Identifier
`StorageContainerPosition`	Container Position
`ShipmentSpecimen`	Shipment Specimen
`Shipment`	Shipment
`User`	User
`StorageContainer`	Storage Container
`CollectionProtocol`	Collection Protocol
`SpecimenRequirement`	Specimen Requirement
`CollectionProtocolEvent`	Collection Protocol Event
`CollectionProtocolSite`	CP Site
`DistributionOrderItem`	Distribution Order Items
`DistributionOrder`	Distribution Order
`ContainerType`	Container Type
`Role`	Role
`RoleAccessControl`	Role Access List
`DistributionProtocol`	Distribution Protocol
`ResourceInstanceOp`	Access List Operation
`CpConsentTier`	CP Consent
`Institute`	Institute
`SubjectRole`	User Role
`Site`	Site
`ShipmentContainer`	Shipment Container
`DpRequirement`	DP Requirement
`FormContextBean`	Form Association
`CpSpecimenLabelPrintSetting`	CP Specimen Label Print Setting
`DpDistributionSite`	DP Site

Versions Compared

Old Version 4

New Version Current

Key

Response