Distributed Sql Server Cache

post

https://app.financekey.com/OData/DistributedSqlServerCaches

Stores cached data for faster retrieval and better performance. It is accessed by all web instances to ensure that data is consistent across all nodes. The table stores key-value pairs, where the keys are unique identifiers for the cached data, and the values are the actual cached data.

Recent Requests

Time	Status	User Agent
Retrieving recent requests…

Loading…

Body Params

string

required

length between 1 and 449

Id: This primary key field is an nvarchar data type with a maximum length of 449 in the DistributedSqlServerCache table. Its purpose is to uniquely identify each record in the table, providing an indexed field for faster retrieval of data.

value

string

required

expiresAtTime

date-time

required

ExpiresAtTime is a datetimeoffset field in the DistributedSqlServerCache table which indicates the time at which a record stored in the cache table is no longer valid and can be purged from the cache.

slidingExpirationInSeconds

int64 | null

The SlidingExpirationInSeconds field in DistributedSqlServerCache table is a bigint field that stores the amount of seconds that a cached item can remain in the table after being accessed. During this time, the cached item can continue to be accessed without having to be looked up again. When the specified amount of seconds elapses after the cached item was last accessed, the cached item will expire and will no longer be accessible. This data is important in order to ensure that

absoluteExpiration

date-time | null

The DistributedSqlServerCache table stores data that is cached in the distributed SQL Server. The AbsoluteExpiration field is of data type datetimeoffset and stores the absolute time and date when the cache will expire. When AbsoluteExpiration is reached, the data is removed from the cache.

Headers

content-type

string

enum

Defaults to application/json;odata.metadata=minimal;odata.streaming=true

Generated from available request content types

Response

200

Language

URL

Loading…

Response

Click Try It! to start a request and see the response here!