Hello All -
I am working on a process where I am making multiple web service calls and pulling out bits of data to pass along to the next web service call. We can do this within Nintex Workflow for Office 365, but want to explore the possibilities using NWC.
When I call the web service, my Response content Collection variable does contain data (JSON), but for some reason it is storing each character as an item in the collection.
Here is my workflow and actions (just focusing on the first call):
Web Service | Count items | Send Email |
---|---|---|
Email:
Response Code: 200
Response Content: {"result":{"credentials":{"database":"xxxxxxxxxxxxx","sessionId":"4733467139606425463","userName":"xxxxxxxxxx@duqlight.com"},"path":"ThisServer","securityToken":{"database":"xxxxxxxxxxxxx","sessionId":"4733467139606425463","userName":"xxxxxxxxxx@duqlight.com"}},"jsonrpc":"2.0"}
Collection Count: 278
Check on Collection character count:
Within Nintex Workflow for O365, I would simply put the response in a dictionary and be able to target the sessionId like so:
...but that does not exist within NWC, or at least I am unaware.
My question is two parts:
1. How would I go about parsing this data so that I can get something out of it (specifically sessionId)?
2. Why is the collection storing it as individual characters? It is coming back as JSON (response header: "content-type"=>["application/json; charset=utf-8"], )
Thanks in advance.