With CSVBase, you authenticate using by putting your username and API key straight in the url (known as "HTTP "basic" auth").
Here's an example:
https://<some_user>:<some_api_key>@csvbase.com/ubieratlupa/monuments
Basic auth is widely supported and is usually accepted anywhere that accepts urls.
However, ubieratlupa/monuments is public so auth is needed only for writes.
CSVBase APIs use content negotiation to decide what formats are in use. This means it consults HTTP headers to decide what format to send back in response to a request.
It important that you set the Content-Type
and Accept headers to be the mimetype you want:
typically that is application/json for both. If you fail to
include these headers in your requests, the API will still work but
CSVBase will pick a sensible default: CSV for tables, JSON for rows.
You can bypass content negotiation for read-only requests by appending a
file extension to the url, eg .json. Here's an example
of that (same resource as above):
https://<some_user>:<some_api_key>@csvbase.com/ubieratlupa/monuments/export/json
This is useful when dealing with software where you aren't able to set headers.
There are three kinds of thing in csvbase:
While there's no API for users so far, there is for tables and rows.
This table looks like this in JSON:
{
"name": "monuments",
"is_public": true,
"caption": "",
"data_licence": "All rights reserved",
"created": "2023-01-17T12:45:45.668799+00:00",
"last_changed": "2023-01-17T12:45:45.668799+00:00",
"columns": [
{
"name": "csvbase_row_id",
"type": "integer"
},
{
"name": "id",
"type": "integer"
},
{
"name": "url",
"type": "string"
},
{
"name": "title",
"type": "string"
},
{
"name": "comment",
"type": "string"
},
{
"name": "object_type",
"type": "string"
},
{
"name": "monument_type",
"type": "string"
},
{
"name": "finding_place",
"type": "string"
},
{
"name": "finding_place_comment",
"type": "string"
},
{
"name": "finding_comment",
"type": "string"
},
{
"name": "lat",
"type": "float"
},
{
"name": "long",
"type": "float"
},
{
"name": "ancient_finding_place",
"type": "string"
},
{
"name": "conservation_place",
"type": "string"
},
{
"name": "conservation_place_comment",
"type": "string"
},
{
"name": "conservation_comment",
"type": "string"
},
{
"name": "conservation_state",
"type": "string"
},
{
"name": "museum",
"type": "string"
},
{
"name": "museum_inventory_number",
"type": "string"
},
{
"name": "material",
"type": "string"
},
{
"name": "literature",
"type": "string"
},
{
"name": "literature_online",
"type": "string"
},
{
"name": "inscription",
"type": "string"
},
{
"name": "inscription_type",
"type": "string"
},
{
"name": "inscription_name_donor",
"type": "string"
},
{
"name": "inscription_function",
"type": "string"
},
{
"name": "iconography",
"type": "string"
},
{
"name": "dating_phase",
"type": "string"
},
{
"name": "dating_from",
"type": "integer"
},
{
"name": "dating_to",
"type": "integer"
},
{
"name": "width",
"type": "string"
},
{
"name": "height",
"type": "string"
},
{
"name": "depth",
"type": "string"
},
{
"name": "modified",
"type": "string"
}
],
"page": {
"rows": [
{
"row": {
"id": 1,
"url": "http://lupa.at/1",
"title": "Grabstele des Marcus Praeconius Iucundus",
"comment": null,
"object_type": "Stele",
"monument_type": null,
"finding_place": "Petronell-Carnuntum, Bruck an der Leitha [Bezirk], Nieder\u00f6sterreich, \u00d6sterreich",
"finding_place_comment": null,
"finding_comment": "1897 Gr\u00e4berstra\u00dfe ",
"lat": 48.112,
"long": 16.8652,
"ancient_finding_place": "Carnuntum, Pannonia Superior",
"conservation_place": "Hainburg, Bruck an der Leitha [Bezirk], Nieder\u00f6sterreich, \u00d6sterreich",
"conservation_place_comment": null,
"conservation_comment": "Arch\u00e4olog. Zentraldepot",
"conservation_state": "rechte ob. Ecke abgebr.",
"museum": "Bad Deutsch Altenburg - Arch\u00e4ologisches Museum Carnuntinum Bad Deutsch Altenburg",
"museum_inventory_number": "CAR-S 551",
"material": "Kalkstein",
"literature": "CIL 03, 14358 /21a; Schober, Grabst. Nr. 132; Vorbeck, Milit\u00e4rinschr. 150; CSIR Carnuntum 385; Fitz, Verwaltung Pannoniens 1, 1993, 346 Nr. 255; Mosser 2003 Nr. 88; Gschwantler, Festschrift E. Weber 2005, 526; I. Weber-Hiden, CIL 03-02 (in Vorbereitung);J. Besz\u00e9des, R\u00f6mische Grabsteine aus Carnuntum und seinem Stadtgebiet, Studia ad Archaeologiam Pazmaniensia, Budapest 2020, 252 Nr. 146 ",
"literature_online": "EDCS-30100759; HD028525; TM 196132",
"inscription": "M(arcus) Praecon[i(us)] / Iucundus Sir(mio) / tub(icen) leg(ionis) XV Ap(ollinaris) / (centuria) Sibidien(i) Max(imi) / Aponi(us) Pude(ns) / fratri p(ro) p(ietate) /an(norum) XL stip(endiorum) XX / d(onis) d(onatus) h(ic) s(itus) e(st)",
"inscription_type": "Grabinschrift",
"inscription_name_donor": "frater",
"inscription_function": "tubicen legionis",
"iconography": "Eingeschriebener Giebel mit Seitenakroteren, im Giebelfeld Gorgoneion zwischen Bl\u00e4ttern. Im Hauptbild Girlande zwischen S\u00e4ulen. Im Sockelbild Musikinstrument (tuba).",
"dating_phase": "Traianisch",
"dating_from": 92,
"dating_to": 110,
"width": "094",
"height": "187",
"depth": "023",
"modified": "Kalkstein"
},
"row_id": 1,
"url": "https://csvbase.com/ubieratlupa/monuments/rows/1"
}
],
"previous_page_url": null,
"next_page_url": "https://csvbase.com/ubieratlupa/monuments?op=gt&n=1"
},
"approx_size": 33095
}
Note that there is the top-level metadata, plus a "page" of rows. Tables
are often (usually) too big to be put into a single JSON object so they
are "paginated". To follow the table, page by page, you can use
the next_page_url and previous_page_url
dictionary keys. They will be null if you've reached
the end or are at the beginning, respectively.
GET from https://csvbase.com/ubieratlupa/monuments
You'll need to follow the next_page_url urls (described
above) to get to the end of the table.
Rows from ubieratlupa/monuments look like this in JSON:
{
"row": {
"id": 1,
"url": "http://lupa.at/1",
"title": "Grabstele des Marcus Praeconius Iucundus",
"comment": null,
"object_type": "Stele",
"monument_type": null,
"finding_place": "Petronell-Carnuntum, Bruck an der Leitha [Bezirk], Nieder\u00f6sterreich, \u00d6sterreich",
"finding_place_comment": null,
"finding_comment": "1897 Gr\u00e4berstra\u00dfe ",
"lat": 48.112,
"long": 16.8652,
"ancient_finding_place": "Carnuntum, Pannonia Superior",
"conservation_place": "Hainburg, Bruck an der Leitha [Bezirk], Nieder\u00f6sterreich, \u00d6sterreich",
"conservation_place_comment": null,
"conservation_comment": "Arch\u00e4olog. Zentraldepot",
"conservation_state": "rechte ob. Ecke abgebr.",
"museum": "Bad Deutsch Altenburg - Arch\u00e4ologisches Museum Carnuntinum Bad Deutsch Altenburg",
"museum_inventory_number": "CAR-S 551",
"material": "Kalkstein",
"literature": "CIL 03, 14358 /21a; Schober, Grabst. Nr. 132; Vorbeck, Milit\u00e4rinschr. 150; CSIR Carnuntum 385; Fitz, Verwaltung Pannoniens 1, 1993, 346 Nr. 255; Mosser 2003 Nr. 88; Gschwantler, Festschrift E. Weber 2005, 526; I. Weber-Hiden, CIL 03-02 (in Vorbereitung);J. Besz\u00e9des, R\u00f6mische Grabsteine aus Carnuntum und seinem Stadtgebiet, Studia ad Archaeologiam Pazmaniensia, Budapest 2020, 252 Nr. 146 ",
"literature_online": "EDCS-30100759; HD028525; TM 196132",
"inscription": "M(arcus) Praecon[i(us)] / Iucundus Sir(mio) / tub(icen) leg(ionis) XV Ap(ollinaris) / (centuria) Sibidien(i) Max(imi) / Aponi(us) Pude(ns) / fratri p(ro) p(ietate) /an(norum) XL stip(endiorum) XX / d(onis) d(onatus) h(ic) s(itus) e(st)",
"inscription_type": "Grabinschrift",
"inscription_name_donor": "frater",
"inscription_function": "tubicen legionis",
"iconography": "Eingeschriebener Giebel mit Seitenakroteren, im Giebelfeld Gorgoneion zwischen Bl\u00e4ttern. Im Hauptbild Girlande zwischen S\u00e4ulen. Im Sockelbild Musikinstrument (tuba).",
"dating_phase": "Traianisch",
"dating_from": 92,
"dating_to": 110,
"width": "094",
"height": "187",
"depth": "023",
"modified": "Kalkstein"
},
"row_id": 1,
"url": "https://csvbase.com/ubieratlupa/monuments/rows/1"
}
POST to https://<some_user>:<some_api_key>@csvbase.com/ubieratlupa/monuments/rows/
{
"row": {
"id": 1,
"url": "http://lupa.at/1",
"title": "Grabstele des Marcus Praeconius Iucundus",
"comment": null,
"object_type": "Stele",
"monument_type": null,
"finding_place": "Petronell-Carnuntum, Bruck an der Leitha [Bezirk], Nieder\u00f6sterreich, \u00d6sterreich",
"finding_place_comment": null,
"finding_comment": "1897 Gr\u00e4berstra\u00dfe ",
"lat": 48.112,
"long": 16.8652,
"ancient_finding_place": "Carnuntum, Pannonia Superior",
"conservation_place": "Hainburg, Bruck an der Leitha [Bezirk], Nieder\u00f6sterreich, \u00d6sterreich",
"conservation_place_comment": null,
"conservation_comment": "Arch\u00e4olog. Zentraldepot",
"conservation_state": "rechte ob. Ecke abgebr.",
"museum": "Bad Deutsch Altenburg - Arch\u00e4ologisches Museum Carnuntinum Bad Deutsch Altenburg",
"museum_inventory_number": "CAR-S 551",
"material": "Kalkstein",
"literature": "CIL 03, 14358 /21a; Schober, Grabst. Nr. 132; Vorbeck, Milit\u00e4rinschr. 150; CSIR Carnuntum 385; Fitz, Verwaltung Pannoniens 1, 1993, 346 Nr. 255; Mosser 2003 Nr. 88; Gschwantler, Festschrift E. Weber 2005, 526; I. Weber-Hiden, CIL 03-02 (in Vorbereitung);J. Besz\u00e9des, R\u00f6mische Grabsteine aus Carnuntum und seinem Stadtgebiet, Studia ad Archaeologiam Pazmaniensia, Budapest 2020, 252 Nr. 146 ",
"literature_online": "EDCS-30100759; HD028525; TM 196132",
"inscription": "M(arcus) Praecon[i(us)] / Iucundus Sir(mio) / tub(icen) leg(ionis) XV Ap(ollinaris) / (centuria) Sibidien(i) Max(imi) / Aponi(us) Pude(ns) / fratri p(ro) p(ietate) /an(norum) XL stip(endiorum) XX / d(onis) d(onatus) h(ic) s(itus) e(st)",
"inscription_type": "Grabinschrift",
"inscription_name_donor": "frater",
"inscription_function": "tubicen legionis",
"iconography": "Eingeschriebener Giebel mit Seitenakroteren, im Giebelfeld Gorgoneion zwischen Bl\u00e4ttern. Im Hauptbild Girlande zwischen S\u00e4ulen. Im Sockelbild Musikinstrument (tuba).",
"dating_phase": "Traianisch",
"dating_from": 92,
"dating_to": 110,
"width": "094",
"height": "187",
"depth": "023",
"modified": "Kalkstein"
}
}
{
"row": {
"id": 1,
"url": "http://lupa.at/1",
"title": "Grabstele des Marcus Praeconius Iucundus",
"comment": null,
"object_type": "Stele",
"monument_type": null,
"finding_place": "Petronell-Carnuntum, Bruck an der Leitha [Bezirk], Nieder\u00f6sterreich, \u00d6sterreich",
"finding_place_comment": null,
"finding_comment": "1897 Gr\u00e4berstra\u00dfe ",
"lat": 48.112,
"long": 16.8652,
"ancient_finding_place": "Carnuntum, Pannonia Superior",
"conservation_place": "Hainburg, Bruck an der Leitha [Bezirk], Nieder\u00f6sterreich, \u00d6sterreich",
"conservation_place_comment": null,
"conservation_comment": "Arch\u00e4olog. Zentraldepot",
"conservation_state": "rechte ob. Ecke abgebr.",
"museum": "Bad Deutsch Altenburg - Arch\u00e4ologisches Museum Carnuntinum Bad Deutsch Altenburg",
"museum_inventory_number": "CAR-S 551",
"material": "Kalkstein",
"literature": "CIL 03, 14358 /21a; Schober, Grabst. Nr. 132; Vorbeck, Milit\u00e4rinschr. 150; CSIR Carnuntum 385; Fitz, Verwaltung Pannoniens 1, 1993, 346 Nr. 255; Mosser 2003 Nr. 88; Gschwantler, Festschrift E. Weber 2005, 526; I. Weber-Hiden, CIL 03-02 (in Vorbereitung);J. Besz\u00e9des, R\u00f6mische Grabsteine aus Carnuntum und seinem Stadtgebiet, Studia ad Archaeologiam Pazmaniensia, Budapest 2020, 252 Nr. 146 ",
"literature_online": "EDCS-30100759; HD028525; TM 196132",
"inscription": "M(arcus) Praecon[i(us)] / Iucundus Sir(mio) / tub(icen) leg(ionis) XV Ap(ollinaris) / (centuria) Sibidien(i) Max(imi) / Aponi(us) Pude(ns) / fratri p(ro) p(ietate) /an(norum) XL stip(endiorum) XX / d(onis) d(onatus) h(ic) s(itus) e(st)",
"inscription_type": "Grabinschrift",
"inscription_name_donor": "frater",
"inscription_function": "tubicen legionis",
"iconography": "Eingeschriebener Giebel mit Seitenakroteren, im Giebelfeld Gorgoneion zwischen Bl\u00e4ttern. Im Hauptbild Girlande zwischen S\u00e4ulen. Im Sockelbild Musikinstrument (tuba).",
"dating_phase": "Traianisch",
"dating_from": 92,
"dating_to": 110,
"width": "094",
"height": "187",
"depth": "023",
"modified": "Kalkstein"
},
"row_id": 1,
"url": "https://csvbase.com/ubieratlupa/monuments/rows/1"
}
Status code 201 upon success.
GET from https://csvbase.com/ubieratlupa/monuments/rows/1
No body is provided with this request. Status code 200 upon success.
{
"row": {
"id": 1,
"url": "http://lupa.at/1",
"title": "Grabstele des Marcus Praeconius Iucundus",
"comment": null,
"object_type": "Stele",
"monument_type": null,
"finding_place": "Petronell-Carnuntum, Bruck an der Leitha [Bezirk], Nieder\u00f6sterreich, \u00d6sterreich",
"finding_place_comment": null,
"finding_comment": "1897 Gr\u00e4berstra\u00dfe ",
"lat": 48.112,
"long": 16.8652,
"ancient_finding_place": "Carnuntum, Pannonia Superior",
"conservation_place": "Hainburg, Bruck an der Leitha [Bezirk], Nieder\u00f6sterreich, \u00d6sterreich",
"conservation_place_comment": null,
"conservation_comment": "Arch\u00e4olog. Zentraldepot",
"conservation_state": "rechte ob. Ecke abgebr.",
"museum": "Bad Deutsch Altenburg - Arch\u00e4ologisches Museum Carnuntinum Bad Deutsch Altenburg",
"museum_inventory_number": "CAR-S 551",
"material": "Kalkstein",
"literature": "CIL 03, 14358 /21a; Schober, Grabst. Nr. 132; Vorbeck, Milit\u00e4rinschr. 150; CSIR Carnuntum 385; Fitz, Verwaltung Pannoniens 1, 1993, 346 Nr. 255; Mosser 2003 Nr. 88; Gschwantler, Festschrift E. Weber 2005, 526; I. Weber-Hiden, CIL 03-02 (in Vorbereitung);J. Besz\u00e9des, R\u00f6mische Grabsteine aus Carnuntum und seinem Stadtgebiet, Studia ad Archaeologiam Pazmaniensia, Budapest 2020, 252 Nr. 146 ",
"literature_online": "EDCS-30100759; HD028525; TM 196132",
"inscription": "M(arcus) Praecon[i(us)] / Iucundus Sir(mio) / tub(icen) leg(ionis) XV Ap(ollinaris) / (centuria) Sibidien(i) Max(imi) / Aponi(us) Pude(ns) / fratri p(ro) p(ietate) /an(norum) XL stip(endiorum) XX / d(onis) d(onatus) h(ic) s(itus) e(st)",
"inscription_type": "Grabinschrift",
"inscription_name_donor": "frater",
"inscription_function": "tubicen legionis",
"iconography": "Eingeschriebener Giebel mit Seitenakroteren, im Giebelfeld Gorgoneion zwischen Bl\u00e4ttern. Im Hauptbild Girlande zwischen S\u00e4ulen. Im Sockelbild Musikinstrument (tuba).",
"dating_phase": "Traianisch",
"dating_from": 92,
"dating_to": 110,
"width": "094",
"height": "187",
"depth": "023",
"modified": "Kalkstein"
},
"row_id": 1,
"url": "https://csvbase.com/ubieratlupa/monuments/rows/1"
}
PUT to https://<some_user>:<some_api_key>@csvbase.com/ubieratlupa/monuments/rows/1
{
"row": {
"id": 1,
"url": "http://lupa.at/1",
"title": "Grabstele des Marcus Praeconius Iucundus",
"comment": null,
"object_type": "Stele",
"monument_type": null,
"finding_place": "Petronell-Carnuntum, Bruck an der Leitha [Bezirk], Nieder\u00f6sterreich, \u00d6sterreich",
"finding_place_comment": null,
"finding_comment": "1897 Gr\u00e4berstra\u00dfe ",
"lat": 48.112,
"long": 16.8652,
"ancient_finding_place": "Carnuntum, Pannonia Superior",
"conservation_place": "Hainburg, Bruck an der Leitha [Bezirk], Nieder\u00f6sterreich, \u00d6sterreich",
"conservation_place_comment": null,
"conservation_comment": "Arch\u00e4olog. Zentraldepot",
"conservation_state": "rechte ob. Ecke abgebr.",
"museum": "Bad Deutsch Altenburg - Arch\u00e4ologisches Museum Carnuntinum Bad Deutsch Altenburg",
"museum_inventory_number": "CAR-S 551",
"material": "Kalkstein",
"literature": "CIL 03, 14358 /21a; Schober, Grabst. Nr. 132; Vorbeck, Milit\u00e4rinschr. 150; CSIR Carnuntum 385; Fitz, Verwaltung Pannoniens 1, 1993, 346 Nr. 255; Mosser 2003 Nr. 88; Gschwantler, Festschrift E. Weber 2005, 526; I. Weber-Hiden, CIL 03-02 (in Vorbereitung);J. Besz\u00e9des, R\u00f6mische Grabsteine aus Carnuntum und seinem Stadtgebiet, Studia ad Archaeologiam Pazmaniensia, Budapest 2020, 252 Nr. 146 ",
"literature_online": "EDCS-30100759; HD028525; TM 196132",
"inscription": "M(arcus) Praecon[i(us)] / Iucundus Sir(mio) / tub(icen) leg(ionis) XV Ap(ollinaris) / (centuria) Sibidien(i) Max(imi) / Aponi(us) Pude(ns) / fratri p(ro) p(ietate) /an(norum) XL stip(endiorum) XX / d(onis) d(onatus) h(ic) s(itus) e(st)",
"inscription_type": "Grabinschrift",
"inscription_name_donor": "frater",
"inscription_function": "tubicen legionis",
"iconography": "Eingeschriebener Giebel mit Seitenakroteren, im Giebelfeld Gorgoneion zwischen Bl\u00e4ttern. Im Hauptbild Girlande zwischen S\u00e4ulen. Im Sockelbild Musikinstrument (tuba).",
"dating_phase": "Traianisch",
"dating_from": 92,
"dating_to": 110,
"width": "094",
"height": "187",
"depth": "023",
"modified": "Kalkstein"
},
"row_id": 1,
"url": "https://csvbase.com/ubieratlupa/monuments/rows/1"
}
Upon success the body you sent will be echoed back, with status code 200.
DELETE from https://<some_user>:<some_api_key>@csvbase.com/ubieratlupa/monuments/rows/1
No body is required. Status code 204 upon success.