myneva.daarwin - Externe API - Reporting
Sven Jonigk
Owned by Sven Jonigk
The route "/api/external/reporting/executereportdatasource" is available to call up daarwin internal data sources
Further routes are available to obtain the required additional information, e.g.: data source ID, possible parameters (filtering) of a data source or links to other data sources
Route | Info |
|---|
Route | Info |
|---|---|
/api/external/reporting/getreportdatasources | Get all reporting dataSources |
/api/external/reporting/getreportdatasourceparameter | Get available filter parameters for a DataSource |
/api/external/reporting/getreportdatasourcejoininformation | Get possible Join Information to other Datasource for a DataSource |
/api/external/reporting/getreportdatasourceparameteroperators | Returns a list of all available DataSource parameter operators |
Example Requests / Results
POST /api/external/reporting/executereportdatasource HTTP/1.1
Content-Type: application/json
User-Agent: PostmanRuntime/7.36.0
Accept: */*
Postman-Token: 95b15689-079c-4c26-9db8-34e04969740f
Host: localhost:1146
Accept-Encoding: gzip, deflate, br
Connection: keep-alive
Content-Length: 698
{
"DataSourceId": "676150a3-f111-4a8f-bd93-43b206e5c862",
"Parameters": [
{
"Id": "57137e16-1ab4-4c32-aa42-04d5df93707a",
"Operator": "db73aacc-35e9-4264-85c1-57d527b712a4",
"Value": "EF0D14BE-5468-49EB-ABE5-E3AC9DA65AE0"
},
{
"Id": "57137e16-1ab4-4c32-aa42-04d5df93707a",
"Operator": "db73aacc-35e9-4264-85c1-57d527b712a4",
"Value": "15854987-2875-4040-9094-E668C2B7F06B1"
}
],
"LoginData": {
"DBAlias": "QMCDBPROGLOKAL",
"CustomerNo": "100000",
"ContractNo": "203353",
"Username": "myUser",
"Password": "myPassword"
}
}HTTP/1.1 200 OK
Cache-Control: no-cache
Pragma: no-cache
Content-Type: application/json; charset=utf-8
Expires: -1
Server: Microsoft-IIS/10.0
X-AspNet-Version: 4.0.30319
X-SourceFiles: =?UTF-8?B?QzpcUHJvamVrdGVccW1jMy1zZXJ2ZXJcU2VydmVyU2VydmljZXNcU2VydmVyQmFzZVNlcnZpY2VcYXBpXGV4dGVybmFsXHJlcG9ydGluZ1xleGVjdXRlcmVwb3J0ZGF0YXNvdXJjZQ==?=
X-Powered-By: ASP.NET
Date: Thu, 04 Jan 2024 12:08:52 GMT
Content-Length: 6478
{"Data":{"DataSourceResult":[{"ID":"ef0d14be-5468-49eb-abe5-e3ac9da65ae0","GEBURTSNAME":null,"GEBURTSORT":null,"KUERZEL":null,"FK_STATUS":"00000000-0000-0000-0000-000000000000","FK_BLUTGRUPPE":"00000000-0000-0000-0000-000000000000","FK_NATIONALITAET2":"00000000-0000-0000-0000-000000000000","FK_SPRACHE":"00000000-0000-0000-0000-000000000000","FK_SPRACHE2":"00000000-0000-0000-0000-000000000000","FK_KONFESSION":"00000000-0000-0000-0000-000000000000","FK_HAARFARBE":"00000000-0000-0000-0000-000000000000","FK_AUGENFARBE":"00000000-0000-0000-0000-000000000000","FK_MIGRATIONSHINTERGND":"00000000-0000-0000-0000-000000000000","FK_PERSON":"c40b0e03-56fd-49ea-876f-35ef59660917","FK_OBJEKT":"ef0d14be-5468-49eb-abe5-e3ac9da65ae0","GELOESCHT":0,"PRIOR_ID":null,"VERSION":24,"MAND":1,"FK_GEBURTSLAND":"e8dfa43c-c3d4-408d-87d8-7bf9ccdb0ab7","ISTGETAUFT":0,"FK_INTEGRATION":null,"FK_SPRACHNIVEAU":"00000000-0000-0000-0000-000000000000","FK_SPRACHNIVEAU2":"00000000-0000-0000-0000-000000000000","FK_SPRACHNIVEAU3":"00000000-0000-0000-0000-000000000000","FK_SPRACHE3":"00000000-0000-0000-0000-000000000000","ID1":"c40b0e03-56fd-49ea-876f-35ef59660917","VORNAME":"Marlene","NAME":"Meier","GEBURTSDATUM":"2002-05-01T00:00:00","STERBEDATUM":null,"FK_TITEL":"00000000-0000-0000-0000-000000000000","FK_ANREDE":"8a85bbef-f6b8-4f19-982f-314b5012b4fd","FK_BRIEFANREDE":"08e20de9-c59e-47af-a8c8-47d1d363ef9a","FK_GESCHLECHT":"3513c527-7923-48a0-88be-3640fb678a63","FK_FAMILIENSTAND":"00000000-0000-0000-0000-000000000000","FK_NATIONALITAET":"00000000-0000-0000-0000-000000000000","FK_PERSONSTATUS":"45f0d412-5907-4ced-a236-f88989a2091c","BEMERKUNG_FORMAT":"CAcBAA4AAAAAAAAAAABFAAAATWVpbmUgQXVmeuRobHVuZzoKYQpiCmMKClRleHQgbmFjaCBkZXIgQXVmeuRobHVuZwoKVGV4dCBtYWwgbWl0IEZhcmJlAAADAAADAAEACAACAAAAAAAAAAAAn4cBAAEANAAAAAAAAEAAAAAAAAAAUAEANQAQAAAAAAAAQAAAAAD//wAAAQBFAAEAAAAAAABAAAAAAAAAAFA4/wAAAAAAAJABAAAAAAAAAiJBcmlhbAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAEAAQASAAIAEwAUAAIAFQAWAAIAFwAYAAEAGQAZAAEAGgAyAAEAMwAzAAEANABGAAAAAAAAAAAAAAAAAGQAIAIPAAAAAW4EAdwIAUoNAbgRASYWAZQaAQIfAXAjAd4nAUwsAbowASg1AZY5AQQ+AABrAQAAlf4AAAAAZAAgAg8AAAABbgQB3AgBSg0BuBEBJhYBlBoBAh8BcCMB3icBTCwBujABKDUBljkBBD4AAAAAAAAAAAAAAAAAAAAAQQByAGkAYQBsAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAADkBAAAAQABAAkGAAEAAAAuAAD//wAAAAC3AAEAAAAAQAAAAFACAAEACQYAAQAAAC4AAP//AAAAALcAAQAAAABAAAAAUAEAAAAHBAAAAAAAAAAAAAAAAAEAAJMHBAAAAAAAAAAAAAAAAAEAALUHBAAAAAAAAAAAAAAAAAEAAAAAAAAAAAAAAAAAAAAAAAEAAAAAAAAAAAAAAAAAAAAAAAEAAAAAAAAAAAAAAAAAAAAAAAEAAAAAAAAAAAAAAAAAAAAAAAEAAAAAAAAAAAAAAAAAAAAAAAEAAAAAAAAAAAAAAAAAAAAAAAEAAAAAAAAAAAAAAAAAAAAAAAEAAAAAAAAAAAAAAAAAAAAAAAEAAQABAEYAAAAAAAAAAAAAAAAAAAAAAAEAUwB5AG0AYgBvAGwAAAAIAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAYgEAADAAAAAAAAAAAAAAAAAAAAAAAAAA////AAAAAAAAAAAAAQAAAAEADgAAAAAAAAAAACQBAAABAAAAAAAQ/wAAAAAAAJABAAAAAAAAAiJBcmlhbAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAABBAHIAaQBhAGwAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAABAAAAAUAAAAAAAAAAAAAAAAGQAIAIPAAAAAW4EAdwIAUoNAbgRASYWAZQaAQIfAXAjAd4nAUwsAbowASg1AZY5AQQ+AQABAAkGAAEAAAAuAAD//wAAAAC3AAEAAAAAQAAAAFAAABIAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAABbAE4AbwByAG0AYQBsAF0AAABTAHkAbQBiAG8AbAAAAAEAegAAADIAAAAAQAAAAAA3AjcCNwI3AoIuAADGQQAAbgRuBG4EbgQgCj+AAAAAAAAAAAABAAAAAAAAABsBAAAAAAAAAAAAAAAAAAAAAAAALAAAAAAAAAAAAMYBxgHGAcYBAAAAQAAAAEAAAABAAAAAQAAAAAAAAAAAAAA=","OBJEKTTYP":140000,"FK_OBJEKT1":"ef0d14be-5468-49eb-abe5-e3ac9da65ae0","GELOESCHT1":0,"PRIOR_ID1":null,"ISKOSTENTRAEGER":0,"VERSION1":24,"MAND1":1,"PERSONNR":"184","FK_STAMMHAUS":"db249ce5-c48d-48a2-aeb6-0a0589b90ff4","FK_STAMMHAUSSOURCE":0,"ISGESETZBETREUER":0,"BEMERKUNG":"Meine Aufzählung:\r\na\r\nb\r\nc\r\n\r\nText nach der Aufzählung\r\n\r\nText mal mit Farbe","FK_TODESURSACHE":"00000000-0000-0000-0000-000000000000","SOZIALVERSICHERUNGSNUMMER":"12345","FK_TITELNACH":"00000000-0000-0000-0000-000000000000","REF1":"","REF2":"","REF3":"","KUERZEL1":null,"REF4":"","REF5":"","STEUERIDENTIFIKATIONSNR":"","LASTMODIFIED_DATE":"2022-01-25T12:40:11.073","LASTMODIFIED_USER":"c6a2c143-5302-4171-b1f8-f499a59bae65","LASTMODIFIED_ACTION":2,"CREATION_USER":"c6a2c143-5302-4171-b1f8-f499a59bae65","CREATION_DATE":"2020-10-19T09:35:29.273","FK_HERKUNFTNATION":null,"FK_HERKUNFTNATION2":null,"ALTERPERSON":21,"NACHNAMEVORNAME":"Meier, Marlene","VORNAMENACHNAME":"Marlene Meier","STAMMHAUS":"Betreutes Wohnen","STAMMHAUSOBJ":"db249ce5-c48d-48a2-aeb6-0a0589b90ff4","UEBERGEORDNETESSTAMMHAUS":"[SJ]","UEBERGEORDNETESSTAMMHAUSOBJ":"9a5dcfd5-139c-401c-8fce-25379fd8022b","TITEL":" ","TITELKURZ":" ","TITELBEM":"","TITELIMAGEINDEX":0,"ANREDE":"Frau","ANREDEKURZ":" ","ANREDEBEM":"","ANREDEIMAGEINDEX":0,"GESCHLECHT":"Weiblich","GESCHLECHTKURZ":"w","GESCHLECHTBEM":"","GESCHLECHTIMAGEINDEX":32,"STATUS":"Aktiv","STATUSKURZ":" ","STATUSBEM":"AKTIV Bem","STATUSIMAGEINDEX":0,"GEBURTSLAND":"Deutschland","GEBURTSLANDKURZ":"D","GEBURTSLANDBEM":"","GEBURTSLANDIMAGEINDEX":152,"SPRACHE":" ","SPRACHEKURZ":" ","SPRACHEBEM":"","SPRACHEIMAGEINDEX":0,"SPRACHE2":" ","SPRACHE2KURZ":" ","SPRACHE2BEM":"","SPRACHE3":" ","SPRACHE3KURZ":" ","SPRACHE3BEM":"","SPRACHNIVEAU":" ","SPRACHNIVEAUKURZ":" ","SPRACHNIVEAUBEM":"","SPRACHNIVEAU2":" ","SPRACHNIVEAU2KURZ":" ","SPRACHNIVEAU2BEM":"","SPRACHNIVEAU3":" ","SPRACHNIVEAU3KURZ":" ","SPRACHNIVEAU3BEM":"","SPRACHE2IMAGEINDEX":0,"NATIONALITAET":" ","NATIONALITAETKURZ":" ","NATIONALITAETBEM":"","NATIONALITAETIMAGEINDEX":0,"NATIONALITAET2":" ","NATIONALITAET2KURZ":" ","NATIONALITAET2BEM":"","NATIONALITAET2IMAGEINDEX":0,"MIGRATIONSHINTERGRUND":" ","MIGRATIONSHINTERGRUNDKURZ":" ","MIGRATIONSHINTERGRUNDBEM":"","MIGRATIONSHINTERGRUNDIMAGEINDEX":0,"BLUTGRUPPE":" ","BLUTGRUPPEKURZ":" ","BLUTGRUPPEBEM":"","BLUTGRUPPEIMAGEINDEX":0,"HAARFARBE":" ","HAARFARBEKURZ":" ","HAARFARBEBEM":"","HAARFARBEIMAGEINDEX":0,"AUGENFARBE":" ","AUGENFARBEKURZ":" ","AUGENFARBEBEM":"","AUGENFARBEIMAGEINDEX":0,"BRIEFANREDE":"Sehr geehrte Frau","BRIEFANREDEKURZ":" ","BRIEFANREDEBEM":"","BRIEFANREDEIMAGEINDEX":0,"KONFESSION":" ","KONFESSIONKURZ":" ","KONFESSIONBEM":"","KONFESSIONIMAGEINDEX":0,"FAMILIENSTAND":" ","FAMILIENSTANDKURZ":" ","FAMILIENSTANDBEM":"","FAMILIENSTANDIMAGEINDEX":0,"TITELNACH":" ","TITELNACHKURZ":" ","FK_PERSONSTATUS_TOP":"45f0d412-5907-4ced-a236-f88989a2091c","PERSONSTATUSTOP":"Aktiv","PERMFLAG":210532}]},"Success":true,"Message":"","Error":"","ErrorMessages":[],"Exception":null}Request
POST /api/external/reporting/getreportdatasources HTTP/1.1
Content-Type: application/json
User-Agent: PostmanRuntime/7.36.0
Accept: */*
Postman-Token: 801d3f77-f35a-4507-b9b0-d82381762ad7
Host: localhost:1146
Accept-Encoding: gzip, deflate, br
Connection: keep-alive
Content-Length: 192
{
"LoginData": {
"DBAlias": "EINGL",
"CustomerNo": "100031",
"ContractNo": "203405",
"Username": "myUser",
"Password": "myPassword"
}
}Response