Publishing Data
Using data
Open Booking API
Specifications
Implementing RPDE
Always use a JSON library to generate the output, and never construct the JSON manually.
Language-specific examples of library implementations that also support the removal of nulls, empty strings and empty arrays - as the specification stipulates - are included here.
.NET, PHP, Ruby and JavaScript/TypeScript Libraries
Several libraries are available that make it really easy to create open opportunity data feeds.
The table below lists the available OpenActive libraries:
Language
Open Opportunity Data Feeds
Dataset Site
Transactions: Preventing delayed item interleaving
When concurrent transactions are used to write to tables that power RPDE feeds, the timestamp and change number update must be done outside of the transaction, with high accuracy timestamp, and a "visible" timestamp column added.
Example of race condition
Delayed item interleaving is a race condition that occurs when two concurrent transactions containing "timestamps" or "change numbers" are committed out of order. For example using the Modified Timestamp and ID ordering strategy:
- Transaction 1: Starts at 10:00:01 and updates RPDE item timestamps
- Transaction 2: Starts at 10:00:02 and updates RPDE item timestamps
- Transaction 2: Commits
- Data consumer reads the feed at 10:00:03, and gets the latest items up to 10:00:02
- Transaction 1: Commits
- Items from Transaction 1 appear in the feed with timestamp 10:00:01, but the data consumer has already moved past them
- Transaction 1: Creates change number 001 and updates RPDE item timestamp
- Transaction 2: Creates change number 002 and updates RPDE item timestamp
- Transaction 2: Commits
- Data consumer reads the feed up to 002
- Transaction 1: Commits
- Item from Transaction 1 appears in the feed with change number 001, but the data consumer has already moved past it
Preventing the race condition
In order to prevent this race condition, one solution is to simply separate the more intensive work of the transaction from the atomic timestamp and change number update, filter out recent changes in the feed, and ensure you are using accurate timestamps:
- 1.First commit the transaction, then update the timestamps or change numbers after the transaction has been committed as an atomic operation, outside of a transaction, using
GETDATE()or similar - 2.Ensure the RPDE endpoint filters out all items with a "modified" date after 2 seconds in the past, to delay items appearing in the feed
- 3.If using the Modified Timestamp and ID ordering strategy, use a timestamp column with a high degree of accuracy (e.g.
datetime2in SQL Server).
Updating items in the feed without updating their timestamp/change number immediately does not have any negative effects, as data consumers who are reading the feed will read the updated item earlier than they would otherwise instead of an older version, then read it again after the timestamp/change number is updated as they would normally.
Using the RPDE endpoint filter to delay items appearing is a belt-and-braces measure that ensures that small variances between timestamp and change number update order are accounted for under high database load, by only presenting data to the data consumer after a small delay, when all timestamp/change number updates have commited.
C# and .NET Framework
OpenActive.NET Library
We highly recommend using the OpenActive.NET library for .NET implementations. It includes strongly typed classes for the OpenActive data model including beta properties, and fully compliant serialisation methods too.
Manual Implementation
Use JSON.NET / Newtonsoft.Json with a
ContractResolver to remove empty strings, and NullValueHandling to remove nulls. Empty list values must be removed by setting them to null in the generating code, aided by the extension ToListOrNullIfEmpty which is useful at the end of LINQ expressions.1
public class RPDERestUtils
2
{
3
public static HttpResponseMessage CreateJSONResponse(RpdePage page, HttpRequestMessage req)
4
{
5
var e = JsonConvert.SerializeObject(page,
6
Newtonsoft.Json.Formatting.None,
7
new JsonSerializerSettings
8
{
9
NullValueHandling = NullValueHandling.Ignore,
10
ContractResolver = NoEmptyStringsContractResolver.Instance
11
});
12
​
13
var resp = req.CreateResponse(HttpStatusCode.OK);
14
resp.Headers.CacheControl = new CacheControlHeaderValue()
15
{
16
Public = true,
17
// Recommended cache settings from:
18
// https://developer.openactive.io/publishing-data/data-feeds/scaling-feeds
19
MaxAge = page?.items?.Count > 0 ? TimeSpan.FromHours(1) : TimeSpan.FromSeconds(8)
20
};
21
resp.Content = new StringContent(e, Encoding.UTF8, "application/json");
22
return resp;
23
}
24
​
25
public class NoEmptyStringsContractResolver : DefaultContractResolver
26
{
27
public static readonly NoEmptyStringsContractResolver Instance = new NoEmptyStringsContractResolver();
28
​
29
protected override JsonProperty CreateProperty(MemberInfo member, MemberSerialization memberSerialization)
30
{
31
JsonProperty property = base.CreateProperty(member, memberSerialization);
32
​
33
if (property.PropertyType == typeof(string))
34
{
35
// Do not include empty strings in JSON output (as per OpenActive Modelling Specification)
36
property.ShouldSerialize = instance =>
37
{
38
return !string.IsNullOrWhiteSpace(instance.GetType().GetRuntimeProperty(member.Name).GetValue(instance, null) as string);
39
};
40
}
41
​
42
return property;
43
}
44
}
45
​
46
public static List<TSource> ToListOrNullIfEmpty<TSource>(this IEnumerable<TSource> source)
47
{
48
if (source != null && source.Count() > 0)
49
return source.ToList();
50
else
51
return null;
52
}
53
}
Copied!
PHP
OpenActive PHP Models Library
We highly recommend using the OpenActive PHP Models Library for PHP implementations. It includes strongly typed classes for the OpenActive data model including beta properties, and fully compliant serialisation methods too.
Manual Implementation
The specification requires that no null or empty strings are present in the OpenActive feed. To achieve this, define the RPDE response structure as nested arrays, and recursively unset empty properties before using json_encode to generate the response.
1
<?php
2
​
3
$testResponseStructure = [
4
"@context" => "https://openactive.io/",
5
"@id" => "https://example.com/api/sessions/1402CBP20150217",
6
"identifier" => "1402CBP20150217",
7
"@type" => "SessionSeries",
8
"organizer" => [
9
"@type" => "Organization",
10
"name" => "Everyone Active",
11
"url" => null,
12
"logo" => [
13
"type" => "ImageObject",
14
"url" => "",
15
],
16
"email" => null,
17
"telephone" => "01455 890508",
18
"sameAs" => [
19
null,
20
""
21
],
22
],
23
];
24
​
25
echo json_encode_without_null_or_empty($testResponseStructure);
26
​
27
function json_encode_without_null_or_empty($nestedarr) {
28
$nestedarr = array_filter_recursive($nestedarr);
29
return json_encode($nestedarr, JSON_PRETTY_PRINT);
30
}
31
​
32
function array_filter_recursive($array) {
33
$clean = [];
34
foreach ($array as $key => $value) {
35
// First clean the array, in case it ends up empty
36
if (is_array($value)) {
37
$value = array_filter_recursive($value);
38
// Remove arrays containing only a "type" property
39
if (count($value) === 1 && isset($value["type"])) {
40
continue;
41
}
42
}
43
​
44
// ignore null values, empty strings, and empty lists
45
if ($value === null || $value === "" || $value === []) {
46
continue;
47
}
48
$clean[$key] = $value;
49
}
50
return $clean;
51
}
Copied!
Last modified 7mo ago