Re: [DBpedia-discussion] rest api for dbpedia

2025-04-07 Thread Martynas Jusevičius
For the record, this is the "game engines written in C/C++/Objective C
with software licenses" query I came up with:

https://dbpedia.org/snorql/?query=PREFIX++dbo%3A++%3Chttp%3A%2F%2Fdbpedia.org%2Fontology%2F%3E%0D%0APREFIX++rdfs%3A+%3Chttp%3A%2F%2Fwww.w3.org%2F2000%2F01%2Frdf-schema%23%3E%0D%0APREFIX++dbp%3A++%3Chttp%3A%2F%2Fdbpedia.org%2Fproperty%2F%3E%0D%0APREFIX++dbr%3A++%3Chttp%3A%2F%2Fdbpedia.org%2Fresource%2F%3E%0D%0APREFIX++rdf%3A++%3Chttp%3A%2F%2Fwww.w3.org%2F1999%2F02%2F22-rdf-syntax-ns%23%3E%0D%0A%0D%0ASELECT+DISTINCT++%3Fengine+%3FengineLabel+%3FprogrammingLanguage+%3Flicense%0D%0AWHERE%0D%0A++%7B+%3Fengine++rdfs%3Alabel%3FengineLabel+%3B%0D%0A+dbp%3AprogrammingLanguage++%3FprogrammingLanguage%0D%0AFILTER+%28+%3FprogrammingLanguage+IN+%28%3Chttp%3A%2F%2Fdbpedia.org%2Fresource%2FC_%28programming_language%29%3E%2C+dbr%3AObjective-C%2C+%3Chttp%3A%2F%2Fdbpedia.org%2Fresource%2FC%2B%2B%3E%29+%29%0D%0AFILTER+langMatches%28lang%28%3FengineLabel%29%2C+%22en%22%29%0D%0A++%7B+%3Fengine++dbo%3Agenre++dbr%3AGame_engine+%7D%0D%0AUNION%0D%0A++%7B+%3Fengine++%3Chttp%3A%2F%2Fpurl.org%2Fdc%2Fterms%2Fsubject%3E++dbr%3ACategory%3AVideo_game_engines+%7D%0D%0AOPTIONAL%0D%0A++%7B+%3Fengine++dbo%3Alicense++%3Flicense+%7D%0D%0A++%7D%0D%0AORDER+BY+%3FengineLabel%0D%0ALIMIT+++100

On Mon, Apr 7, 2025 at 8:09 AM Sebastian Hellmann
 wrote:
>
> Hi Joe,
>
> both linked data and sparql are REST. I guess what you are looking for
> is some sort of swagger/json API, which sometimes aren't real REST.
>
> SPARQL is really the way to go, especially, if you already have the URI.
> First do:
>
> SELECT distinct ?p count(?p) as?count {
>  ?p ?o
> } order by desc (?count)
>
> https://dbpedia.org/snorql/?query=SELECT+distinct+%3Fp+count%28%3Fp%29+as%3Fcount+%7B+%0D%0A%3Chttp%3A%2F%2Fdbpedia.org%2Fresource%2FSource_%28game_engine%29%3E+%3Fp+%3Fo%0D%0A%7D+order+by+desc+%28%3Fcount%29+
>
> then select the props you need:
>
> SELECT * {
> OPTIONAL { 
>  ?license . }
> OPTIONAL { 
>  ?pl . }
> }
>
> https://dbpedia.org/snorql/?query=SELECT+*+%7B+%0D%0AOPTIONAL+%7B+%3Chttp%3A%2F%2Fdbpedia.org%2Fresource%2FSource_%28game_engine%29%3E+%3Chttp%3A%2F%2Fdbpedia.org%2Fontology%2Flicense%3E+%3Flicense+.+%7D%0D%0AOPTIONAL+%7B+%3Chttp%3A%2F%2Fdbpedia.org%2Fresource%2FSource_%28game_engine%29%3E++%3Chttp%3A%2F%2Fdbpedia.org%2Fontology%2FprogrammingLanguage%3E+%3Fpl+.+%7D%0D%0A%7D+
>
> here is a list of all accept headers for SPARQL on dbpedia.org/sparql
>
> text/html
> text/x-html+tr
> auto
> application/vnd.ms-excel
> application/sparql-results+xml
> application/sparql-results+json
> application/javascript
> text/turtle
> application/rdf+xml
> text/plain
> text/csv
> text/tab-separated-values
>
> you can also query 1000 uris at once, if you rewrite the query a bit or
> let chatgpt do it. Not sure how to get the language.
>
> https://dbpedia.org/sparql?default-graph-uri=http%3A%2F%2Fdbpedia.org&query=SELECT+*+%7B%0D%0AOPTIONAL+%7B+%3Chttp%3A%2F%2Fdbpedia.org%2Fresource%2FSource_%28game_engine%29%3E+%3Chttp%3A%2F%2Fdbpedia.org%2Fontology%2Flicense%3E+%3Flicense+.+%7D%0D%0AOPTIONAL+%7B+%3Chttp%3A%2F%2Fdbpedia.org%2Fresource%2FSource_%28game_engine%29%3E++%3Chttp%3A%2F%2Fdbpedia.org%2Fontology%2FprogrammingLanguage%3E+%3Fpl+.+%7D%0D%0A%7D+&format=text%2Fhtml&timeout=3&signal_void=on&signal_unconnected=on
>
> -- Sebastian
>
>
> On 06.04.25 11:54, Martynas Jusevičius wrote:
> > DBpedia also supports Linked Data. You can request RDF formats using
> > the resource (not the page) URIs, for example:
> >
> > curl -L -H "Accept: text/turtle"
> > 'http://dbpedia.org/resource/Source_(game_engine)'
> >
> > On Sun, Apr 6, 2025 at 3:07 AM joe Alambert  wrote:
> >> I finally decided to migrate from sparql client.
> >>
> >> Best regards.
> >>
> >> On Sat, Apr 5, 2025 at 9:08 PM joe Alambert  
> >> wrote:
> >>> Hello.
> >>> here is
> >>> I want to use an rest api (if possible, not spark) to get the language, 
> >>> license and programming language of a game engine page found previously 
> >>> with the lookup api. For example the page 
> >>> https://dbpedia.org/page/Source_(game_engine) should return C++, etc..
> >>>
> >>> Is there a rest api already rxisting please.?
> >>>
> >>>
> >>> BEst regards.
> >> ___
> >> DBpedia-discussion mailing list
> >> [email protected]
> >> https://lists.sourceforge.net/lists/listinfo/dbpedia-discussion
> >
> > ___
> > DBpedia-discussion mailing list
> > [email protected]
> > https://lists.sourceforge.net/lists/listinfo/dbpedia-discussion
>
>
> ___
> DBpedia-discussion mailing 

Re: [DBpedia-discussion] rest api for dbpedia

2025-04-06 Thread Sebastian Hellmann

Hi Joe,

both linked data and sparql are REST. I guess what you are looking for 
is some sort of swagger/json API, which sometimes aren't real REST.


SPARQL is really the way to go, especially, if you already have the URI. 
First do:


SELECT distinct ?p count(?p) as?count {
 ?p ?o
} order by desc (?count)

https://dbpedia.org/snorql/?query=SELECT+distinct+%3Fp+count%28%3Fp%29+as%3Fcount+%7B+%0D%0A%3Chttp%3A%2F%2Fdbpedia.org%2Fresource%2FSource_%28game_engine%29%3E+%3Fp+%3Fo%0D%0A%7D+order+by+desc+%28%3Fcount%29+

then select the props you need:

SELECT * {
OPTIONAL {  
 ?license . }
OPTIONAL {  
 ?pl . }

}

https://dbpedia.org/snorql/?query=SELECT+*+%7B+%0D%0AOPTIONAL+%7B+%3Chttp%3A%2F%2Fdbpedia.org%2Fresource%2FSource_%28game_engine%29%3E+%3Chttp%3A%2F%2Fdbpedia.org%2Fontology%2Flicense%3E+%3Flicense+.+%7D%0D%0AOPTIONAL+%7B+%3Chttp%3A%2F%2Fdbpedia.org%2Fresource%2FSource_%28game_engine%29%3E++%3Chttp%3A%2F%2Fdbpedia.org%2Fontology%2FprogrammingLanguage%3E+%3Fpl+.+%7D%0D%0A%7D+

here is a list of all accept headers for SPARQL on dbpedia.org/sparql

text/html
text/x-html+tr
auto
application/vnd.ms-excel
application/sparql-results+xml
application/sparql-results+json
application/javascript
text/turtle
application/rdf+xml
text/plain
text/csv
text/tab-separated-values

you can also query 1000 uris at once, if you rewrite the query a bit or 
let chatgpt do it. Not sure how to get the language.


https://dbpedia.org/sparql?default-graph-uri=http%3A%2F%2Fdbpedia.org&query=SELECT+*+%7B%0D%0AOPTIONAL+%7B+%3Chttp%3A%2F%2Fdbpedia.org%2Fresource%2FSource_%28game_engine%29%3E+%3Chttp%3A%2F%2Fdbpedia.org%2Fontology%2Flicense%3E+%3Flicense+.+%7D%0D%0AOPTIONAL+%7B+%3Chttp%3A%2F%2Fdbpedia.org%2Fresource%2FSource_%28game_engine%29%3E++%3Chttp%3A%2F%2Fdbpedia.org%2Fontology%2FprogrammingLanguage%3E+%3Fpl+.+%7D%0D%0A%7D+&format=text%2Fhtml&timeout=3&signal_void=on&signal_unconnected=on

-- Sebastian


On 06.04.25 11:54, Martynas Jusevičius wrote:

DBpedia also supports Linked Data. You can request RDF formats using
the resource (not the page) URIs, for example:

curl -L -H "Accept: text/turtle"
'http://dbpedia.org/resource/Source_(game_engine)'

On Sun, Apr 6, 2025 at 3:07 AM joe Alambert  wrote:

I finally decided to migrate from sparql client.

Best regards.

On Sat, Apr 5, 2025 at 9:08 PM joe Alambert  wrote:

Hello.
here is
I want to use an rest api (if possible, not spark) to get the language, license 
and programming language of a game engine page found previously with the lookup 
api. For example the page https://dbpedia.org/page/Source_(game_engine) should 
return C++, etc..

Is there a rest api already rxisting please.?


BEst regards.

___
DBpedia-discussion mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/dbpedia-discussion


___
DBpedia-discussion mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/dbpedia-discussion



___
DBpedia-discussion mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/dbpedia-discussion


Re: [DBpedia-discussion] rest api for dbpedia

2025-04-06 Thread Martynas Jusevičius
DBpedia also supports Linked Data. You can request RDF formats using
the resource (not the page) URIs, for example:

curl -L -H "Accept: text/turtle"
'http://dbpedia.org/resource/Source_(game_engine)'

On Sun, Apr 6, 2025 at 3:07 AM joe Alambert  wrote:
>
> I finally decided to migrate from sparql client.
>
> Best regards.
>
> On Sat, Apr 5, 2025 at 9:08 PM joe Alambert  wrote:
>>
>> Hello.
>>
>> I want to use an rest api (if possible, not spark) to get the language, 
>> license and programming language of a game engine page found previously with 
>> the lookup api. For example the page 
>> https://dbpedia.org/page/Source_(game_engine) should return C++, etc..
>>
>> Is there a rest api already rxisting please.?
>>
>>
>> BEst regards.
>
> ___
> DBpedia-discussion mailing list
> [email protected]
> https://lists.sourceforge.net/lists/listinfo/dbpedia-discussion


___
DBpedia-discussion mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/dbpedia-discussion


Re: [DBpedia-discussion] rest api for dbpedia

2025-04-05 Thread joe Alambert
I finally decided to migrate from sparql client.

Best regards.

On Sat, Apr 5, 2025 at 9:08 PM joe Alambert  wrote:

> Hello.
>
> I want to use an rest api (if possible, not spark) to get the language,
> license and programming language of a game engine page found previously
> with the lookup api. For example the page
> https://dbpedia.org/page/Source_(game_engine) should return C++, etc..
>
> Is there a rest api already rxisting please.?
>
>
> BEst regards.
>
___
DBpedia-discussion mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/dbpedia-discussion