API Integration with TolaData

[sleidig]

Summary issue on all API Integration related topics

• API Integration: draft Auth concept query-backend#5
• API Integration: draft Report request and result endpoints query-backend#6
• API Integration: implement report endpoints query-backend#7
• integrate SQS to run SQL-based reports query-backend#8
  • check schema generation from sqs report statement
• implement webhook endpoints for report notifications query-backend#15
• move schema update/generation from frontend (https://github.com/Aam-Digital/ndb-core/pull/2226/files) to backend query-backend#26
• make CouchDbClient injectable with a certain DB's config query-backend#20
• detect changes to reports from _changes feed query-backend#16
• draft notification concept (+ OpenAPI) specs to inform clients of results ready / report results changed query-backend#9
• Authentication checks for query backend query-backend#34
• e2e and API spec tests #8
• Adapt Reporting Service (frontend) to handle new query-backend API ndb-core#2239
• trigger an initial notification event upon subscribing to a report query-backend#33

Framework Migration

• migrate e2e tests
• complete feature set
  • trigger webhooks
• deployment
• logging/sentry

Later:

• Logging
• simplify architecture and let report-changes module only create calculations, notifications module check for updates?
• improve change detection to avoid unnecessary calculations
• implement an OAuth-based process to get/generate a Keycloak Client for an API access #7