search

wso2 / financial-open-banking

WSO2 Open Banking Accelerator is a collection of technologies that increases the speed and reduces the complexity of adopting open banking compliance. Instead of building a solution from scratch, you can use WSO2 Open Banking Accelerator to meet all legislative requirements with additional benefits beyond compliance.
Apache License 2.0
7 stars 21 forks source link

[OB3] [Accelerator] Saving Periodic Limits as Consent Attributes During Variable Recurring Payment Consent Inititation #73

Open Sandaru-Vithanage opened 6 days ago

Sandaru-Vithanage commented 6 days ago

Description: The current open banking accelerator is able to validate only one entry in the periodic limits array in a variable recurring payment consent initiation request payload which is sent to POST /domestic-vrp-consents endpoint defined by Open banking specification (https://openbankinguk.github.io/read-write-api-site3/v3.1.11/resources-and-data-models/vrp/domestic-vrp-consents.html).

The below table depicts the consent attributes stored to validate the first entry of the periodic limits which will be omitted from the new implementation.

Instead a new format will be introduced to store all the control parameters and maximum periodic limits (6 Available Periodic Limits) of a Variable consent request for open banking consent attributes as below.

afinal

Suggested Labels: [For non-committers only. Optional comma separated list of suggested labels. Non committers can’t assign labels to issues, so this will help issue creators who are not a committer to suggest possible labels. Labels can be found here - https://github.com/wso2/financial-open-banking/labels]

Suggested Assignees: [For non-committers only. Optional comma separated list of suggested team members who should attend the issue. Non committers can’t assign issues to assignees, so this will help issue creators who are not a committer to suggest possible assignees]

Affected Product Version:

OS, DB, other environment details and versions:

Steps to reproduce:

Related Issues: [Any related issues such as sub tasks, issues reported in other repositories (e.g component repositories), similar problems, etc. ]

Sandaru-Vithanage commented 6 days ago

Add the Following line to Alter Consent Attributes Table in Configure.sh & configure.bat/ps1 in WSO2 Support Repository

    mysql "ALTER TABLE ${DB_OPEN_BANKING_STORE}.`ob_consent_attribute` CHANGE COLUMN `ATT_VALUE` `ATT_VALUE` VARCHAR(1023) NOT NULL" ;