Add new field JsonData to AD_PInstance and AD_PInstance_Log

Description

Create two new fields called "JsonData" in the AD_PInstance and AD_PInstance_Log tables of type JSON to store data to be used as a return of a process on the REST API.

As discussed at https://mattermost.idempiere.org/idempiere/pl/bz74x1bcstgmte3q3kb9ygkxto

 

This new implementation allows processes to be used as a foundation for creating specialized endpoints that receive parameters, perform processing, and deliver a ready to use response for handling on the frontend and/or integrated system, in a secure and auditable manner.

Environment

None

Attachments

3

relates to

Activity

Murilo Habermann Torquato 
September 5, 2024 at 2:17 AM

With the new implementation, we can use the following approach from a process:

We can check the result at the Process Audit window:

And also at the Process Audit → Log tab:

I am also submitting a PR for the idempiere-rest project to allow the inclusion of AD_PInstance.JsonData column in the response, under the data property, as follows:

Fixed

Details

Assignee

Reporter

Labels

Fix versions

Affects versions

Priority

Created September 4, 2024 at 6:58 PM
Updated December 2, 2024 at 2:30 PM
Resolved September 6, 2024 at 10:28 AM