Skip to main content
System StatusContact Support
VersionOne Community

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

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.

  • Was this article helpful?