Exposing ODS Bookmarks via /sparql

#1

I would like to access my ODS Bookmarks using Virtuoso’s /sparql endpoint. How can I achieve this? The select * results do not contain my ODS dataspace, although I have bookmarks in ODS.

0 Likes

#2

I wonder if the articles at the bottom of the How Do I…? section here give you enough guidance?

0 Likes

#3

Thank you Ted, yes this is what I was looking for. When I queried as dba, I got no results. I am assuming dba does not have permission to query my user (smonroe), which is the user that has the Bookmarks.

When I try to execute the Bookmarks dump query (from this page mentioned on the link above), I get the below message:

image

This is the query I tried:

PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#>
PREFIX sioc: <http://rdfs.org/sioc/ns#>
PREFIX sioct: <http://rdfs.org/sioc/types#>
PREFIX dct: <http://purl.org/dc/elements/1.1/>
SELECT distinct ?forum_name, ?post, ?title, ?link, ?url
WHERE 
  {
    ?forum a sioct:BookmarkFolder .
    ?forum sioc:id ?forum_name.
    ?forum sioc:scope_of ?role. 
    ?role sioc:function_of ?f . filter (?f like '%http://demo.openlinksw.com/dataspace/demo#this' ).
    ?forum sioc:container_of ?post .
    OPTIONAL{ ?post dct:title ?title }.
    OPTIONAL{ ?post sioc:link ?link  } .
    OPTIONAL{ ?post sioc:links_to ?url }
  }

I then went to System Admin > User Accounts, and gave the user SQL/ODBC and WebDAV user type, and SPARQL_SELECT_RAW Account Role, but that doesn’t seem like the right approach. At any rate, I no longer get the auth error, but the result set is empty.

image

0 Likes