Zuwendungsdatenbank
Zuwendungsdatenbank
Description: Read-only REST-API for SimpleSearch. Parameters are attached to method calls like in normal URL query parameters. If output type for requests is omitted, API will return HTML by default.
BaseUrl: https://www.berlin.de/sen/finanzen/service/zuwendungsdatenbank/index.php
Authentication: No authentication required
Contact: Jean.Winkler-Schneider@senfin.berlin.de
Licence: cc-by-sa
Formats:- XML
- JSON
- RSS
- CSV
- HTML
- JSON-RSS
- GeoJSON
- KML
Key | Value |
---|---|
200 | Your request is valid, you will find the data in your payload |
400 | Wrong syntax in request, do no repeat this request |
Methods
ResultList
Description: Search for entries. Search parameters will be linked by AND.
Url: /index.php[/index/:PAGINATION_MODE:INDEX_OUTPUT_TYPE]
ExampleCall: https://www.berlin.de/sen/finanzen/service/zuwendungsdatenbank/index.php/index/index.json?q=Test
Method: GET
AuthRequired: No
Parameters
order
Description: Change order of results
Type: ValueList ORDER_ATTRIBUTE [+ ' ' + ValueList ORDER_MODIFIER]
Required: No
Default: id
page
Description: Welche Ergebnisseite soll gezeigt werden
Type: int
Required: No
Default: 1
q
Description: Fulltext-search for fields: name, geber, anschrift, zweck, empfaengerid
Type: string
Required: No
name
Description: Name
Type: string
Required: No
geber
Description: Geber
Type: string
Required: No
art
Description: Art
Type: string
Required: No
jahr
Description: Jahr
Type: string
Required: No
anschrift
Description: Anschrift
Type: string
Required: No
politikbereich
Description: Politikbereich
Type: string
Required: No
zweck
Description: Zweck
Type: string
Required: No
Detail
Description: Show single entry
Url: /index.php/detail/:ITEM_ID[:DETAIL_OUTPUT_TYPE]
Method: GET
AuthRequired: No
EntityKeys
ITEM_ID
Description: ID to find a single row by
Type: int
INDEX_OUTPUT_TYPE
Description: In welchem Format soll das Ergebnis sein
Type: ValueList INDEX_OUTPUT_TYPE
DETAIL_OUTPUT_TYPE
Description: In welchem Format soll das Ergebnis sein
Type: ValueList DETAIL_OUTPUT_TYPE
ValueLists
PAGINATION_MODE
Description: Welche Ergebnisseite soll gezeigt werden
Type: string
Values:Key | Value |
---|---|
index | Show a single page with a restricted set of results |
all | Show all results at once |
INDEX_OUTPUT_TYPE
Description: List of all available output types
Type: string
Values:Key | Value |
---|---|
.html | Full-blown HTML |
.xml | Genric XML |
.json | JSON |
.rss | RSS with Geo:RSS |
.jrss | JSON-RSS (see https://support-2023.berlin.de/wiki/index.php/JSON-RSS) |
.csv | Excel-type CSV |
.kml | Keyhole markup lanuage (for Google Earth) |
.geojson | GeoJson (see https://geojson.org/) |
DETAIL_OUTPUT_TYPE
Description: List of all available output types
Type: string
Values:Key | Value |
---|---|
.html | Full-blown HTML |
.xml | Generic XML |
.json | JSON |
ORDER_ATTRIBUTE
Description: List of all available columns to order by
Type: string
Values:Key | Value |
---|---|
name | Order by name |
geber | Order by geber |
art | Order by art |
jahr | Order by jahr |
anschrift | Order by anschrift |
politikbereich | Order by politikbereich |
zweck | Order by zweck |
ORDER_MODIFIER
Description: How to order results
Type: string
Values:Key | Value |
---|---|
ASC | Ascending order |
DESC | Descending order |