Access json array object and it's attributes based on specific condition

From jdbc request I have stored a random transaction reference in custom properties at test case level. Now I have to search that transaction reference in the json response and validates it's attributes values against jdbc response

Json response
{[ Transactions{
Tid : 123
Amount : 2000
}
{
Tid : 456
Amount : 10000
}
]}

XML response
<Rows>
<Row = 1>
<Tid>123</Tid>
<Amount>2000</Amount>
</Row>
<Rows>
Please suggest