SAS Intelligent Decision Json array output question

[a_sasusr]

Hi !

Working on a SAS Intelligent Decision (SID) architecture where we have an external application calling the url endpoint of a master decision flow.

Based on the parameters supplied in the POST, the master decision flow redirect the request to a sub decision flow. Each sub decision flow has specific tasks and the answer (variables and parameters) are transferred back up to master decision flow and back out to the external application. Each sub decision flow has different variables and parameters.

What is the best approach of making a neat json array out from SID that only contains variables and parameters from the sub decision flow that returned the answer ?

[alexal]

Just mark those desired variables as the output in your decision flow, and you will see them in the results. That's it.

[a_sasusr]

Done that.. The problem is that the more sub decision flows you have the more variables will be attached into the json array even though its only 1 flow returning actual values. So the json array gets littered with metadata from variables that have NULL values. So need a more dynamic output of JSON array where only the variables containing values are present

[alexal]

SID will return all variables that you have marked as output, doesn't matter whether they have values or not. From my point of view, you have the following options:
1. Filter empty output variables in your application that works with the results
2. Change the decision flow logic and add DS2 file as the last node, which will check which variables are available and return only those available.
3. Change the decision flow logic without adding DS2 file.