Skip to end of banner
Go to start of banner

1Report Section

Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

Version 1 Next »

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

/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

 api/external/reporting/executereportdatasource
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}
 api/external/reporting/getreportdatasources

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

{
"Data":
  {
    "DataSources":
	[
		{
		  "Id":"a6ae718c-8124-47a2-b89f-6fdaf012b1cb",
		  "Name":"Abgerechnete Fachleistungsdokumentationen"
		},
		{
		  "Id":"d76dca7b-722c-4240-b476-af77021d545c",
		  "Name":"Abgerechnete FLS Dienstzeiten"
		},...
	]
  },
"Success":true,
"Message":"",
"Error":"","ErrorMessages":[],
"Exception":null
}
  • No labels