How to handle json from fn.fnSsh function

[janhoelscher]

Hey,

maybe this is some kind of question or enhancement for the docs.

I want to use some JSON Output that i am getting from an fn.fnSsh Function. Here is my example:

I have a field that outputs something like this from ssh script:

[
"{"name": "Bob", "languages": ["English", "French"]}",
"",
"exit(0)"
]

And in another field i want to use the corresponding JSON from the first Array Element, since with the fn.fnSsh i cant modify the output. Just like this as an expression:

fn.fnJq('$(scriptfield[0])','.name')

It outputs null. When i'm inspect this field it shows like:

fn.fnJq('{\"name\": \"Bob\", \"languages\": [\"English\", \"French\"]}','.name')

Do anyone see my error or have any ideas about this?

[ansibleguy76]

Use A local Expression First and use JSON.parse. this will convert it to a JavaScript object that you can then further manipulate if you can give me exactly what do you want to manipulate? I can give you some examples.

[ansibleguy76]

fnSsh returns string output. it doesn't know it is json.

[janhoelscher]

That works perfect, thanks for your quick help!

Maybe its important to mention somewhere that many times you have to use additional field to solve this type of problems.