Search code examples
javascriptjsonblueprism

Blue Prism: Cannot Iterate through JSON items withing injected JS script

So I am trying to iterate through JSON items via injected script. And BP is throwing me a syntax error that it is incapable of compiling my code.

code:

function fillInputs(json){ 
    alert(json[0].Email); 
}

through Invoke I am giving [JSON] variable that has a well structured JSON object which I created with help of Utility - JSON and it is working fine on test websites. But BP will not initialize specifically this part / alert(json[0].Email); / and is throwing a standard error which usually means syntax errors.

Could someone tell me if there is a better way to iterate through JSON objects with Blue Prism injected Javascript code and if I am choosing a harsh way to do it?

Solution

  • This is easily accomplished using the built-in Internet Explorer browser automation features provided out of the box in Blue Prism.

    For organization, place your custom Javascript in a data item of type text on your action page:

    enter image description here

    Then use a Navigate stage to insert the fragment and invoke it:

    enter image description here

    enter image description here

    enter image description here

    With your current snippet, you'll get a nice alert window in Internet Explorer:

    enter image description here

    A good way to retrieve this data using Blue Prism would be to use the Javascript snippet you insert to create a hidden input element, the value of which is set a string representation of the JSON data you're attempting to exfiltrate.

    You can then create a manual Application Modeler entry based off of an existing one to target this hidden element, and then use a Read stage to copy the data into a Data Item within Blue Prism. Further, you can use the bundled JSON object (or write your own as a wrapper around a better VB/C# library) to extract and manipulate the data within as you wish.