Welcome Serena Central users! CLICK HERE
The migration of the Serena Central community is currently underway. Be sure to read THIS MESSAGE to get your new login set up to access your account.

JSONPath filter

Idea ID 1641485

JSONPath filter

DESCRIPTION

Add a "JSONPath" fitler to the list of available filters

BENEFIT

Reduced complexity of flow design/development - JSON is now ubiquitous in the integration market. The current workaround is to go onto the web, download a JSONPath script (in minified format), paste the code into a script and do the the query inside of the script (there are detriments to this, which I will mention in another request).

Increased security - the JSONPath code that MF recommends to customers uses "exec" which is both slow and is very [very] insecure.  It is theoretically possible to inject javascript inside of an input that gets run through that parser, which is then executed by OO.

By building this functionaltiy directly into OO, and using one of the more secure libraries out there (that do not use exec) OO could allow developers to use a JSON Path query in a filter, and that library could ALSO be made available to scriptlets as well (without having to paste in the JSONPath code).

DESIGN

  1.  Pick a JSONPath library that does not use exec (this could be challenging because many of the libraries out there are for node.js and have additional dependencies) and load it into OO's execution context (so it is available to both filters and scriptlets OOTB)
  2. Add a "JSON Path query" option to the dropdown that is displayed when adding a new filter
4 Comments
AndreiTruta Outstanding Contributor.
Outstanding Contributor.
Status changed to: Declined

Hi David,

We have reviewed the idea and we consider it a good enhancement to the product in general.

However considering that we are going forward with the web based implementation of the authoring tool - OO Designer - where you have the ability to filter stuff (both inputs and outputs) through python based expressions we decided to decline it at the moment.

Best regards,

Andrei Vasile Truta

AndreiTruta Outstanding Contributor.
Outstanding Contributor.
Status changed to: Waiting for Votes

As there are 6 votes already after further consideration we decided to open it for more votes for an OO Designer future implementation.

Micro Focus Contributor
Micro Focus Contributor
Status changed to: Under Consideration

The idea has received enough support from the community and has been reviewed by Micro Focus for strategic fit. The idea is continually monitored and considered for prioritization in our development planning.

Micro Focus Contributor
Micro Focus Contributor
Status changed to: Declined

After careful consideration, it was decided to decline this idea.

The reason posted by Andrei above still stands, such this idea does not fit with the current strategy of the product and there are good workarounds that can be considered.

The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.