querying JSON strings

[m_essaid]

Hi,

I have some JSON strings I would like to query (have the list of a node, the count...).

Is this possible ?

Thank you,

Mehdi

[AlexKaras · Accepted solution]

Hi Mehdi,

JScript/JavaScript contains built-in JSON support.

My guess is that Python should have relevant library as well.

For other script languages you have two options: a) create jScript-based Script Extension to process JSON as required; or b) use some third-party library and use it from your test code.

Because of certain considerations, I went the latter way and tried .Net Newtonsoft.Json.dll. The current overall result is positive though I am still in the process of implementing the functionality that I would like to have in my test code.

[m_essaid]

Hi Alex,

Thank you very much, I noticed that some of my colleagues also use Newtonsoft.Json.dll

I will add it in the CLR bridge and use it as I use PdfBox.

[AlexKaras]

Hi Mehdi,

---

I noticed that some of my colleagues also use Newtonsoft.Json.dll

If you have someone who can help you with Russian text, then http://software-testing.ru/forum/index.php?/topic/33135-jsonpath-dlia-testcomplete/#entry151695 thread was a helpful starting point for me.

Also https://goessner.net/articles/JsonPath/ and samples from https://www.newtonsoft.com/json/help/html/Introduction.htm

[m_essaid]

Hi Alex,

Google translate gives me something quite enough understandable.

It's very interesting, thank you.