Hi Virtuoso Users,
I would like to be able to import several JSON-LD published datasets into
virtuoso and run a crawl job.
I have tried this approach
https://stackoverflow.com/questions/32298456/how-to-import-json-ld-into-virtuoso
<https://stackoverflow.com/questions/32298456/how-to-import-json-ld-into-virtuoso>
I used the following SPARQL query to import the JSON-LD document from the DAV
folder:
define get:soft "replace" SELECT * FROM
<http://34.228.166.79:8890/DAV/home/dba/rdf_sink/xapi-authored-profiles/adb.jsonld>
WHERE {?s ?p ?o}
The SPARQL interface returned the following:
{ "head": { "link": [], "vars": ["s", "p", "o"] },
"results": { "distinct": false, "ordered": true, "bindings": [
{ "s": { "type": "uri", "value":
"http://34.228.166.79:8890/about/id/http/34.228.166.79:8890/DAV/home/dba/rdf_sink/xapi-authored-profiles/adb.jsonld";
} , "p": { "type": "uri", "value":
"http://www.w3.org/1999/02/22-rdf-syntax-ns#type"; } , "o": { "type": "uri",
"value": "http://xmlns.com/foaf/0.1/Document"; }},
{ "s": { "type": "uri", "value":
"http://34.228.166.79:8890/about/id/http/34.228.166.79:8890/DAV/home/dba/rdf_sink/xapi-authored-profiles/adb.jsonld";
} , "p": { "type": "uri", "value":
"http://xmlns.com/foaf/0.1/primaryTopic"; } , "o": { "type": "uri", "value":
"http://34.228.166.79:8890/about/id/entity/http/34.228.166.79:8890/DAV/home/dba/rdf_sink/xapi-authored-profiles/adb.jsonld";
}},
{ "s": { "type": "uri", "value":
"http://34.228.166.79:8890/about/id/http/34.228.166.79:8890/DAV/home/dba/rdf_sink/xapi-authored-profiles/adb.jsonld";
} , "p": { "type": "uri", "value": "http://vocab.deri.ie/void#inDataset"; }
, "o": { "type": "uri", "value":
"http://34.228.166.79:8890/DAV/home/dba/rdf_sink/xapi-authored-profiles/adb.jsonld";
}},
{ "s": { "type": "uri", "value":
"http://34.228.166.79:8890/DAV/home/dba/rdf_sink/xapi-authored-profiles/adb.jsonld";
} , "p": { "type": "uri", "value":
"http://rdfs.org/ns/void#sparqlEndpoint"; } , "o": { "type": "uri", "value":
"http://localhost:8890/sparql/"; }} ] } }
If I search for the named entity using the Faceted Browser, I get the following
error:
> Error 42000
>
> SR186:SECURITY: No permission to execute procedure DB.DBA.rdfdesc_http_url
> with user ID 107, group ID 107
>
Is there a better way to import JSON-LD?
I also tried to import using sponger pragmas and the actual graph IRI:
define get:accept "application/ld+json" SELECT * FROM
<https://w3id.org/xapi/adb> WHERE {?s ?p ?o} .
And it returned the following.
s p o
http://34.228.166.79:8890/about/id/https/w3id.org/xapi/adb
<http://34.228.166.79:8890/about/id/https/w3id.org/xapi/adb>
http://www.w3.org/1999/02/22-rdf-syntax-ns#type
<http://www.w3.org/1999/02/22-rdf-syntax-ns#type>
http://xmlns.com/foaf/0.1/Document <http://xmlns.com/foaf/0.1/Document>
http://34.228.166.79:8890/about/id/https/w3id.org/xapi/adb
<http://34.228.166.79:8890/about/id/https/w3id.org/xapi/adb>
http://xmlns.com/foaf/0.1/primaryTopic <http://xmlns.com/foaf/0.1/primaryTopic>
http://34.228.166.79:8890/about/id/entity/https/adlnet.github.io/xapi-authored-profiles/adb.jsonld
<http://34.228.166.79:8890/about/id/entity/https/adlnet.github.io/xapi-authored-profiles/adb.jsonld>
http://34.228.166.79:8890/about/id/https/w3id.org/xapi/adb
<http://34.228.166.79:8890/about/id/https/w3id.org/xapi/adb>
http://vocab.deri.ie/void#inDataset <http://vocab.deri.ie/void#inDataset>
https://w3id.org/xapi/adb <https://w3id.org/xapi/adb>
https://w3id.org/xapi/adb <https://w3id.org/xapi/adb>
http://rdfs.org/ns/void#sparqlEndpoint <http://rdfs.org/ns/void#sparqlEndpoint>
http://localhost:8890/sparql/ <http://localhost:8890/sparql/>
So it appears to be creating the graph IRI in virtuoso, but I’m not
understanding why it isn’t importing the data. None of the triples in the
JSON-LD document are showing up when I query via SPARQL or search via FCT.
Appreciate any tips or guidance.
Regards,
J Haag------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
_______________________________________________
Virtuoso-users mailing list
Virtuoso-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/virtuoso-users
