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",
"litepub": "http://litepub.social/ns#",
"directMessage": "litepub:directMessage"
}
],
"id": "https://corteximplant.com/users/Sirs0ri/statuses/110650383899177880",
"type": "Note",
"summary": "screenreader unfriendly",
"inReplyTo": "https://corteximplant.com/users/Sirs0ri/statuses/110650371910877488",
"published": "2023-07-03T13:27:47Z",
"url": "https://corteximplant.com/@Sirs0ri/110650383899177880",
"attributedTo": "https://corteximplant.com/users/Sirs0ri",
"to": [
"https://www.w3.org/ns/activitystreams#Public"
],
"cc": [
"https://corteximplant.com/users/Sirs0ri/followers"
],
"sensitive": true,
"atomUri": "https://corteximplant.com/users/Sirs0ri/statuses/110650383899177880",
"inReplyToAtomUri": "https://corteximplant.com/users/Sirs0ri/statuses/110650371910877488",
"conversation": "tag:corteximplant.com,2023-07-03:objectId=6412419:objectType=Conversation",
"content": "<p>Most updated entity's id:</p><pre><code>SELECT <br> states_meta.entity_id,<br> count(*) as count,<br> Datetime(max(last_updated_ts), 'unixepoch') as last_update,<br> Datetime(min(last_updated_ts), 'unixepoch') as first_update <br>FROM <br> states <br> LEFT JOIN states_meta ON ( states.metadata_id = states_meta.metadata_id ) <br>GROUP BY <br> states_meta.entity_id <br>ORDER BY count DESC LIMIT 1;<br></code></pre><p>And a version of that limited to the last 24h:</p><pre><code>(...)<br>WHERE <br> Datetime(last_updated_ts, 'unixepoch') >= Datetime('now', '-1 day')<br>(...)<br></code></pre><p>Newest entity's id:</p><pre><code>SELECT<br> states_meta.entity_id, <br> Datetime(min(last_updated_ts), 'unixepoch') as last_state <br>FROM <br> states <br> LEFT JOIN states_meta ON (<br> states.metadata_id = states_meta.metadata_id<br> )<br>GROUP BY <br> states_meta.entity_id <br>ORDER BY <br> last_state DESC LIMIT 1;<br></code></pre>",
"contentMap": {
"en": "<p>Most updated entity's id:</p><pre><code>SELECT <br> states_meta.entity_id,<br> count(*) as count,<br> Datetime(max(last_updated_ts), 'unixepoch') as last_update,<br> Datetime(min(last_updated_ts), 'unixepoch') as first_update <br>FROM <br> states <br> LEFT JOIN states_meta ON ( states.metadata_id = states_meta.metadata_id ) <br>GROUP BY <br> states_meta.entity_id <br>ORDER BY count DESC LIMIT 1;<br></code></pre><p>And a version of that limited to the last 24h:</p><pre><code>(...)<br>WHERE <br> Datetime(last_updated_ts, 'unixepoch') >= Datetime('now', '-1 day')<br>(...)<br></code></pre><p>Newest entity's id:</p><pre><code>SELECT<br> states_meta.entity_id, <br> Datetime(min(last_updated_ts), 'unixepoch') as last_state <br>FROM <br> states <br> LEFT JOIN states_meta ON (<br> states.metadata_id = states_meta.metadata_id<br> )<br>GROUP BY <br> states_meta.entity_id <br>ORDER BY <br> last_state DESC LIMIT 1;<br></code></pre>"
},
"attachment": [],
"tag": [],
"replies": {
"id": "https://corteximplant.com/users/Sirs0ri/statuses/110650383899177880/replies",
"type": "Collection",
"first": {
"type": "CollectionPage",
"next": "https://corteximplant.com/users/Sirs0ri/statuses/110650383899177880/replies?only_other_accounts=true&page=true",
"partOf": "https://corteximplant.com/users/Sirs0ri/statuses/110650383899177880/replies",
"items": []
}
},
"likes": {
"id": "https://corteximplant.com/users/Sirs0ri/statuses/110650383899177880/likes",
"type": "Collection",
"totalItems": 0
},
"shares": {
"id": "https://corteximplant.com/users/Sirs0ri/statuses/110650383899177880/shares",
"type": "Collection",
"totalItems": 0
}
}