Welcome to the new Parasoft forums! We hope you will enjoy the site and try out some of the new features, like sharing an idea you may have for one of our products or following a category.

How to apply an x-path into an array.

Neil
Neil Posts: 38

below is the sample JSON response, I want to get the documentid whose "subcategory" : "Loans" only

i tried below, didn't work out.
//documents/documentId[subcategory="Loans"]/text()

I want to apply a condition on subcategory field and retrieve only document id which satisfy the condition mentioned.

{
"documents" : [
{
"documentId" : "FO85L_rlLqZbYIKYznec2kazlBDVh7zcvQeJ9ocxYPLlqd_LRYIHTqPg6q8",
"formName" : "Entente relative au prêt personnel CIBC",
"ingestionDate" : "2017-02-03",
"fileSize" : 205820,
"note" : "Different",
"mimeType" : "application/pdf",
"products" : [
{
"accountNumber" : "0007508061",
"transitNumber" : "00153",
"closedDate" : null,
"category" : "LENDING",
"subcategory" : "Loans"
}
]
},
{

    {
        "documentId" : "nVr94RcSPG7b03E6b-7SvK9HbIyg3Vr53nAqmKipEtR2j87DzHi3bjosEK7r",
        "formName" : "Demande de fermeture de compte pour consolidation de dettes",
        "ingestionDate" : "2017-02-03",
        "fileSize" : 88552,
        "note" : "Demande de fermeture de compte pour consolidation de dettes",
        "mimeType" : "application/pdf",
        "products" : [
            {
                "accountNumber" : "6244831",
                "transitNumber" : "00153",
                "closedDate" : null,
                "category" : "LENDING",
                "subcategory" : "PLC"
            }
        ]
    },
    {

        ]
    }
]

}

Comments

  • jakubiak
    jakubiak Posts: 810 admin

    Try /root/documents/item/documentId[../products/item/subcategory/text()="Loans"]/text()

  • Neil
    Neil Posts: 38

    Thank You Jakubiak..:)