I wanted to capture all the actual node and compare it with expected response nodes. I cannot compare the whole response as most of the node values would change every time, so I would want to check if all the expected nodes are available or not.
To achieve this I thought of comparing with list of actual nodes names and expected.
Champion Level 1Hi Rao,
As per my requirement I need to capture all node values individually & store into an Excel without passing the node names.
Apart from this I also need to compare few nodes like branch number, status and branch email etc to compared with expected.
Champion Level 1Not sure why to store hierarchical data (json in your case) and put it in flat format? How do you accommodate json arrays? IMO, it does not make sense to put in excel.
In case it is needed for later use, just persist the entire response into a file and give file reference in the excel if it is mandatory so you would not lose context where the file and what was the response then.
It is very much possible to compare the specific keys of the json.
