Digital Exchange

last person joined: an hour ago 

This community is a place to discuss the Blue Prism DX and all of the assets hosted there.
#marketplace
#assets
Expand all | Collapse all

Symphony Ventures - JSON Manipulation VBO - Question

Jump to Best Answer
  • 1.  Symphony Ventures - JSON Manipulation VBO - Question

    Posted 11-20-2020 09:27
    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
    ------------------------------


  • 2.  RE: Symphony Ventures - JSON Manipulation VBO - Question
    Best Answer

    Posted 11-20-2020 10:08
    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
    ------------------------------



  • 3.  RE: Symphony Ventures - JSON Manipulation VBO - Question

    Posted 11-20-2020 10:51
    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
    ------------------------------



  • 4.  RE: Symphony Ventures - JSON Manipulation VBO - Question

    Posted 11-20-2020 11:09
    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
    ------------------------------



Share