Skip to main content
System StatusContact Support
VersionOne Community

How to query an asset "as of" a specific time

  1. Last updated
  2. Save as PDF

Use the asof query parameter to retrieve data as it existed at some point in time. This URL finds the version of a Story asset as it existed at 5:30 PM on October 3rd, 2005:

 

http://localhost/VersionOne/rest-1.v1/Hist/Story/1364?asof=2005-08-03T17:30:00.00&sel=Name,ToDo,ChangeDate

 

<History total="1" pageSize="2147483647" pageStart="0">
	<Asset href="/VersionOne/rest-1.v1/Data/Story/1364/903" id="Story:1364:903">
		<Attribute name="Name">Company History</Attribute>
		<Attribute name="ChangeDate">2005-08-03T13:09:05.983</Attribute>
		<Attribute name="ToDo">0</Attribute>
	</Asset>
</History>

Remarks

This query returns the last historical record on or before the date specified in the asof query string. Notice how the ChangeDate attribute indicates it was last changed at 1:09 PM on October 3rd, 2005. Between 1:09 PM and 5:30 PM no other changes occurred for this Story asset.

The asof query parameter can also be used on single-attribute and multi-asset historical queries.