topic RE: Symphony Ventures - JSON Manipulation VBO - Question in Digital Exchange

Symphony Ventures - JSON Manipulation VBO - Question

MattPalmer — Fri, 20 Nov 2020 14:27:00 GMT

Hello,
Is anyone familiar with using the VBO for Symphony Ventures - JSON Manipulation VBO? I'm attempting to use the action 'Filter JSON Keys', however, I can't figure out the syntax for the Keys input. I've attempted to use JSONPath syntax, but that doesn't appear to work. And the documentation doesn't provide an example.

Thanks,
Matt

------------------------------
Matt Palmer
Business Process Specialist
Chesapeake Energy
America/Chicago
------------------------------

RE: Symphony Ventures - JSON Manipulation VBO - Question

ewilson — Fri, 20 Nov 2020 15:08:00 GMT

It looks like the input to that action is a simple collection with a single column titled "Keys". Each row in the collection would be the actual key value that you're wanting to include/exclude.

Cheers,

------------------------------
Eric Wilson
Director, Partner Integrations for Digital Exchange
Blue Prism
------------------------------

RE: Symphony Ventures - JSON Manipulation VBO - Question

MattPalmer — Fri, 20 Nov 2020 15:51:00 GMT

Thank you for the response Eric! I may need to read up some more on JSON and key values. When I input ($..fields['Report Number'].text) as the Key, is that not the correct syntax for a Key? It works in the BluePrism Web API Services JSONPath response, but I'm trying to build out process specific logic for responses within the process rather than muddy up the Web API Object with logic no other process is going to use.

------------------------------
Matt Palmer
Business Process Specialist
Chesapeake Energy
America/Chicago
------------------------------

RE: Symphony Ventures - JSON Manipulation VBO - Question

ewilson — Fri, 20 Nov 2020 16:09:00 GMT

The basis of JSON is key/value pairs. So in the following example the keys are employees, firstName, and lastName. The value associated with the key employees is an JSON array whereas the values associated with the keys firstName and lastName are sinple text strings.

{
"employees":[
    {
      "firstName":"John", 
      "lastName":"Doe"
    },
    {
      "firstName":"Anna", 
      "lastName":"Smith"
    },
    {
      "firstName":"Peter", 
      "lastName":"Jones"
    }
  ]
}

So in your example the keys would be the name of the array (from the raw JSON) and then the field key "Report Number". Symphony's code does discern between the input JSON being a JArray or JObject though, so I'd say just pass in the JSON that makes up the JArray and then set the keys collection to have a single "Key" row with the value of "Report Number".

Cheers,

------------------------------
Eric Wilson
Director, Partner Integrations for Digital Exchange
Blue Prism
------------------------------