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: klaus.loetsch@senfin.berlin.de

Licence: cc-by-sa

Formats:
  • XML
  • JSON
  • RSS
  • CSV
  • HTML
  • JSON-RSS
  • GeoJSON
  • KML
HttpStatusCodes:
KeyValue
200Your request is valid, you will find the data in your payload
400Wrong 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

AuthenticationRequired: No

Parameters

order

Description: Change order of results

Type: ValueList ORDER_ATTRIBUTE [+ ' ' + ValueList ORDER_MODIFIER]

Required: No

Default: id

page

Description: Which "page" of results should be shown

Type: int

Required: No

Default: 1

q

Description: Fulltext-search for fields: name, geber, anschrift, zweck, betrag, 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

AuthenticationRequired: No

EntityKeys

ITEM_ID

Description: ID to find a single row by

Type: int

INDEX_OUTPUT_TYPE

Description: Which format the output should be in

Type: ValueList INDEX_OUTPUT_TYPE

PAGINATION_MODE

Description: How to represent results

Type: ValueList PAGINATION_MODE

DETAIL_OUTPUT_TYPE

Description: Which format the output should be in

Type: ValueList DETAIL_OUTPUT_TYPE

ValueLists

PAGINATION_MODE

Description: How many results should be shown

Type: string

Values:
KeyValue
indexShow a single page with a restricted set of results
allShow all results at once

INDEX_OUTPUT_TYPE

Description: List of all available output types

Type: string

Values:
KeyValue
.htmlFull-blown HTML
.xmlGenric XML
.jsonJSON
.rssRSS with Geo:RSS
.jrssJSON-RSS (see http://support.berlin.de/wiki/index.php/JSON-RSS)
.csvExcel-type CSV
.kmlKeyhole markup lanuage (for Google Earth)
.gjsonGeoJson (see http://geojson.org/)

DETAIL_OUTPUT_TYPE

Description: List of all available output types

Type: string

Values:
KeyValue
.htmlFull-blown HTML
.xmlGenric XML
.jsonJSON

ORDER_ATTRIBUTE

Description: List of all available columns to order by

Type: string

Values:
KeyValue
nameOrder by name
geberOrder by geber
artOrder by art
jahrOrder by jahr
anschriftOrder by anschrift
politikbereichOrder by politikbereich
zweckOrder by zweck

ORDER_MODIFIER

Description: How to order results

Type: string

Values:
KeyValue
ASCAscending order
DESCDescending order