A small tool to view real-world ActivityPub objects as JSON! Enter a URL
or username from Mastodon or a similar service below, and we'll send a
request with
the right
Accept
header
to the server to view the underlying object.
{
"@context": [
"https://www.w3.org/ns/activitystreams",
{
"ostatus": "http://ostatus.org#",
"atomUri": "ostatus:atomUri",
"inReplyToAtomUri": "ostatus:inReplyToAtomUri",
"conversation": "ostatus:conversation",
"sensitive": "as:sensitive",
"toot": "http://joinmastodon.org/ns#",
"votersCount": "toot:votersCount",
"Hashtag": "as:Hashtag"
}
],
"id": "https://mastodon.social/users/arabiccola/statuses/114454623361488844",
"type": "Note",
"summary": null,
"inReplyTo": null,
"published": "2025-05-05T09:55:55Z",
"url": "https://mastodon.social/@arabiccola/114454623361488844",
"attributedTo": "https://mastodon.social/users/arabiccola",
"to": [
"https://www.w3.org/ns/activitystreams#Public"
],
"cc": [
"https://mastodon.social/users/arabiccola/followers",
"https://fosstodon.org/users/jankatins"
],
"sensitive": false,
"atomUri": "https://mastodon.social/users/arabiccola/statuses/114454623361488844",
"inReplyToAtomUri": null,
"conversation": "tag:mastodon.social,2025-05-05:objectId=989122145:objectType=Conversation",
"content": "<p>In a short exchange with <span class=\"h-card\" translate=\"no\"><a href=\"https://fosstodon.org/@jankatins\" class=\"u-url mention\">@<span>jankatins</span></a></span> I was stimulated to figure out a concise answer to needing to grab the previous or the upcoming non-null value in a column in PostgreSQL, in the order decided by the user, which would be similar to using `lead` and `lag` with the non-supported IGNORE NULLS directive.</p><p>The implementation I came up with nears poetry in its simplicity and elegance: <a href=\"https://gist.github.com/diraneyya/4455b69e034651151983228cd8b2114b\" target=\"_blank\" rel=\"nofollow noopener\" translate=\"no\"><span class=\"invisible\">https://</span><span class=\"ellipsis\">gist.github.com/diraneyya/4455</span><span class=\"invisible\">b69e034651151983228cd8b2114b</span></a></p><p><a href=\"https://mastodon.social/tags/postgresql\" class=\"mention hashtag\" rel=\"tag\">#<span>postgresql</span></a> <a href=\"https://mastodon.social/tags/sql\" class=\"mention hashtag\" rel=\"tag\">#<span>sql</span></a> <a href=\"https://mastodon.social/tags/aggregate\" class=\"mention hashtag\" rel=\"tag\">#<span>aggregate</span></a> <a href=\"https://mastodon.social/tags/excel\" class=\"mention hashtag\" rel=\"tag\">#<span>excel</span></a> <a href=\"https://mastodon.social/tags/lookahead\" class=\"mention hashtag\" rel=\"tag\">#<span>lookahead</span></a> <a href=\"https://mastodon.social/tags/lookback\" class=\"mention hashtag\" rel=\"tag\">#<span>lookback</span></a> <a href=\"https://mastodon.social/tags/lead\" class=\"mention hashtag\" rel=\"tag\">#<span>lead</span></a> <a href=\"https://mastodon.social/tags/lag\" class=\"mention hashtag\" rel=\"tag\">#<span>lag</span></a> <a href=\"https://mastodon.social/tags/window\" class=\"mention hashtag\" rel=\"tag\">#<span>window</span></a> <a href=\"https://mastodon.social/tags/programming\" class=\"mention hashtag\" rel=\"tag\">#<span>programming</span></a></p>",
"contentMap": {
"en": "<p>In a short exchange with <span class=\"h-card\" translate=\"no\"><a href=\"https://fosstodon.org/@jankatins\" class=\"u-url mention\">@<span>jankatins</span></a></span> I was stimulated to figure out a concise answer to needing to grab the previous or the upcoming non-null value in a column in PostgreSQL, in the order decided by the user, which would be similar to using `lead` and `lag` with the non-supported IGNORE NULLS directive.</p><p>The implementation I came up with nears poetry in its simplicity and elegance: <a href=\"https://gist.github.com/diraneyya/4455b69e034651151983228cd8b2114b\" target=\"_blank\" rel=\"nofollow noopener\" translate=\"no\"><span class=\"invisible\">https://</span><span class=\"ellipsis\">gist.github.com/diraneyya/4455</span><span class=\"invisible\">b69e034651151983228cd8b2114b</span></a></p><p><a href=\"https://mastodon.social/tags/postgresql\" class=\"mention hashtag\" rel=\"tag\">#<span>postgresql</span></a> <a href=\"https://mastodon.social/tags/sql\" class=\"mention hashtag\" rel=\"tag\">#<span>sql</span></a> <a href=\"https://mastodon.social/tags/aggregate\" class=\"mention hashtag\" rel=\"tag\">#<span>aggregate</span></a> <a href=\"https://mastodon.social/tags/excel\" class=\"mention hashtag\" rel=\"tag\">#<span>excel</span></a> <a href=\"https://mastodon.social/tags/lookahead\" class=\"mention hashtag\" rel=\"tag\">#<span>lookahead</span></a> <a href=\"https://mastodon.social/tags/lookback\" class=\"mention hashtag\" rel=\"tag\">#<span>lookback</span></a> <a href=\"https://mastodon.social/tags/lead\" class=\"mention hashtag\" rel=\"tag\">#<span>lead</span></a> <a href=\"https://mastodon.social/tags/lag\" class=\"mention hashtag\" rel=\"tag\">#<span>lag</span></a> <a href=\"https://mastodon.social/tags/window\" class=\"mention hashtag\" rel=\"tag\">#<span>window</span></a> <a href=\"https://mastodon.social/tags/programming\" class=\"mention hashtag\" rel=\"tag\">#<span>programming</span></a></p>"
},
"updated": "2025-05-05T12:42:01Z",
"attachment": [],
"tag": [
{
"type": "Mention",
"href": "https://fosstodon.org/users/jankatins",
"name": "@jankatins@fosstodon.org"
},
{
"type": "Hashtag",
"href": "https://mastodon.social/tags/postgresql",
"name": "#postgresql"
},
{
"type": "Hashtag",
"href": "https://mastodon.social/tags/sql",
"name": "#sql"
},
{
"type": "Hashtag",
"href": "https://mastodon.social/tags/aggregate",
"name": "#aggregate"
},
{
"type": "Hashtag",
"href": "https://mastodon.social/tags/excel",
"name": "#excel"
},
{
"type": "Hashtag",
"href": "https://mastodon.social/tags/lookahead",
"name": "#lookahead"
},
{
"type": "Hashtag",
"href": "https://mastodon.social/tags/lookback",
"name": "#lookback"
},
{
"type": "Hashtag",
"href": "https://mastodon.social/tags/lead",
"name": "#lead"
},
{
"type": "Hashtag",
"href": "https://mastodon.social/tags/lag",
"name": "#lag"
},
{
"type": "Hashtag",
"href": "https://mastodon.social/tags/window",
"name": "#window"
},
{
"type": "Hashtag",
"href": "https://mastodon.social/tags/programming",
"name": "#programming"
}
],
"replies": {
"id": "https://mastodon.social/users/arabiccola/statuses/114454623361488844/replies",
"type": "Collection",
"first": {
"type": "CollectionPage",
"next": "https://mastodon.social/users/arabiccola/statuses/114454623361488844/replies?only_other_accounts=true&page=true",
"partOf": "https://mastodon.social/users/arabiccola/statuses/114454623361488844/replies",
"items": []
}
},
"likes": {
"id": "https://mastodon.social/users/arabiccola/statuses/114454623361488844/likes",
"type": "Collection",
"totalItems": 0
},
"shares": {
"id": "https://mastodon.social/users/arabiccola/statuses/114454623361488844/shares",
"type": "Collection",
"totalItems": 3
}
}