Compare a set of elements of the JSON response to the standard set of elements

Baahubali · June 2017

I have a JSON reponse with 152 currency codes fields. I need to compare the whole set of currency codes in the response with the standard set of codes. The issue is the currency codes in the JSON response are dynamic and they do not have a order, if they would have I would have added a string comparison and mapped to my standard set of codes. What can I do here?

benken_parasoft · June 2017

I recommend using the Diff tool for your validation. Field order in JSON objects doesn't matter in the sense that it doesn't affect the semantics of the message. For this reason, the Diff tool's JSON mode will ignore the order of fields within objects. However, if you need to ignore order of an array of JSON objects, as opposed to order of fields within a JSON object, then you would likely need should sort the objects prior to diffing. One way to do this would be to convert the JSON to XML using the XML Converter then use the Diff tool's XML mode which has an option to ignore element order. There is also an XML Sort tool if you wanted to sort the XML then wanted to convert it back to JSON afterwards, for example.

Baahubali · June 2017

I unable to reproduce the method you described.
I have this list of currencies to validate if they are present in the JSON response.
AED
ALL
AMD
ANG
AOA
ARS
AUD
AWG
AZN
BAM
BBD
BDT
BGN
BHD
BIF
BMD
BND
BOB
BRL
BSD
BWP
BYR
BZD
CDF
CHF
CLP
CNY
COP
CRC
CUP
CVE
CZK
DJF
DKK
DOP
DZD
EGP
ERN
ETB
EUR
FJD
FKP
GBP
GEL
GHS
GIP
GMD
GNF
GTQ
GYD
HKD
HNL
HRK
HTG
HUF
IDR
ILS
INR
IQD
IRR
ISK
JMD
JOD
JPY
KES
KGS
KHR
KMF
KPW
KRW
KWD
KYD
KZT
LAK
LBP
LKR
LRD
LSL
LTL
LYD
MAD
MDL
MGA
MKD
MMK
MNT
MOP
MRO
MUR
MVR
MWK
MXN
MYR
MZN
NAD
NGN
NIO
NOK
NPR
NZD
OMR
PAB
PEN
PGK
PHP
PKR
PLN
PYG
QAR
RON
RSD
RUB
RWF
SAR
SBD
SCR
SDD
SEK
SGD
SHP
SLL
SOS
SRD
STD
SYP
SZL
THB
TJS
TMT
TND
TOP
TRY
TTD
TWD
TZS
UAH
UGX
USD
UYU
UZS
VEF
VND
VUV
WST
XAF
XCD
XOF
XPF
YER
ZAR
ZMW
ZWL

Compare the above list of codes with the below
{
    "foreignExchageRates": [{
            "sourceCurrencyCode": "STD",
            "destinationCurrencyCode": "CAD",
            "conversionRate": 0.00005125,
            "rateRetrievalDate": "2017-06-29T12:57:07+0000"
        },
        {
            "sourceCurrencyCode": "BOB",
            "destinationCurrencyCode": "CAD",
            "conversionRate": 0.146998325,
            "rateRetrievalDate": "2017-06-29T12:56:45+0000"
        },
        {
            "sourceCurrencyCode": "UAH",
            "destinationCurrencyCode": "CAD",
            "conversionRate": 0.125106375,
            "rateRetrievalDate": "2017-06-29T12:57:10+0000"
        },
        {
            "sourceCurrencyCode": "CLP",
            "destinationCurrencyCode": "CAD",
            "conversionRate": 0.002127900,
            "rateRetrievalDate": "2017-06-29T12:56:47+0000"
        },
        {
            "sourceCurrencyCode": "FKP",
            "destinationCurrencyCode": "CAD",
            "conversionRate": 1.642346225,
            "rateRetrievalDate": "2017-06-29T12:56:50+0000"
        },
        {
            "sourceCurrencyCode": "NOK",
            "destinationCurrencyCode": "CAD",
            "conversionRate": 0.177890800,
            "rateRetrievalDate": "2017-06-29T12:57:02+0000"
        },
        {
            "sourceCurrencyCode": "GMD",
            "destinationCurrencyCode": "CAD",
            "conversionRate": 0.029563050,
            "rateRetrievalDate": "2017-06-29T12:56:51+0000"
        },
        {
            "sourceCurrencyCode": "VND",
            "destinationCurrencyCode": "CAD",
            "conversionRate": 0.000049200,
            "rateRetrievalDate": "2017-06-29T12:57:11+0000"
        },
        {
            "sourceCurrencyCode": "TOP",
            "destinationCurrencyCode": "CAD",
            "conversionRate": 0.591981575,
            "rateRetrievalDate": "2017-06-29T12:57:09+0000"
        },
        {
            "sourceCurrencyCode": "SGD",
            "destinationCurrencyCode": "CAD",
            "conversionRate": 0.836364125,
            "rateRetrievalDate": "2017-06-29T12:57:06+0000"
        },
        {
            "sourceCurrencyCode": "BBD",
            "destinationCurrencyCode": "CAD",
            "conversionRate": 0.514032375,
            "rateRetrievalDate": "2017-06-29T12:56:44+0000"
        },
        {
            "sourceCurrencyCode": "AED",
            "destinationCurrencyCode": "CAD",
            "conversionRate": 0.278548875,
            "rateRetrievalDate": "2017-06-29T12:56:41+0000"
        },
        {
            "sourceCurrencyCode": "AMD",
            "destinationCurrencyCode": "CAD",
            "conversionRate": 0.002557375,
            "rateRetrievalDate": "2017-06-29T12:56:42+0000"
        },
        {
            "sourceCurrencyCode": "ILS",
            "destinationCurrencyCode": "CAD",
            "conversionRate": 0.262591675,
            "rateRetrievalDate": "2017-06-29T12:56:54+0000"
        },
        {
            "sourceCurrencyCode": "CZK",
            "destinationCurrencyCode": "CAD",
            "conversionRate": 0.053090900,
            "rateRetrievalDate": "2017-06-29T12:56:48+0000"
        },
        {
            "sourceCurrencyCode": "DOP",
            "destinationCurrencyCode": "CAD",
            "conversionRate": 0.026085225,
            "rateRetrievalDate": "2017-06-29T12:56:49+0000"
        },
        {
            "sourceCurrencyCode": "ZMW",
            "destinationCurrencyCode": "CAD",
            "conversionRate": 1.025,
            "rateRetrievalDate": "2017-06-29T12:57:13+0000"
        },
        {
            "sourceCurrencyCode": "JMD",
            "destinationCurrencyCode": "CAD",
            "conversionRate": 0.011354950,
            "rateRetrievalDate": "2017-06-29T12:56:55+0000"
        },
        {
            "sourceCurrencyCode": "MAD",
            "destinationCurrencyCode": "CAD",
            "conversionRate": 0.120094125,
            "rateRetrievalDate": "2017-06-29T12:56:58+0000"
        },
        {
            "sourceCurrencyCode": "JOD",
            "destinationCurrencyCode": "CAD",
            "conversionRate": 1.440825075,
            "rateRetrievalDate": "2017-06-29T12:56:55+0000"
        },
        {
            "sourceCurrencyCode": "SYP",
            "destinationCurrencyCode": "CAD",
            "conversionRate": 0.014730275,
            "rateRetrievalDate": "2017-06-29T12:57:07+0000"
        },
        {
            "sourceCurrencyCode": "MRO",
            "destinationCurrencyCode": "CAD",
            "conversionRate": 0.003477825,
            "rateRetrievalDate": "2017-06-29T12:57:00+0000"
        },
        {
            "sourceCurrencyCode": "BND",
            "destinationCurrencyCode": "CAD",
            "conversionRate": 0.836364125,
            "rateRetrievalDate": "2017-06-29T12:56:45+0000"
        },
        {
            "sourceCurrencyCode": "ISK",
            "destinationCurrencyCode": "CAD",
            "conversionRate": 0.01022950,
            "rateRetrievalDate": "2017-06-29T12:56:54+0000"
        },
        {
            "sourceCurrencyCode": "LBP",
            "destinationCurrencyCode": "CAD",
            "conversionRate": 0.000685725,
            "rateRetrievalDate": "2017-06-29T12:56:57+0000"
        },
        {
            "sourceCurrencyCode": "TMT",
            "destinationCurrencyCode": "CAD",
            "conversionRate": 0.359771925,
            "rateRetrievalDate": "2017-06-29T12:57:08+0000"
        },
        {
            "sourceCurrencyCode": "AOA",
            "destinationCurrencyCode": "CAD",
            "conversionRate": 0.010638475,
            "rateRetrievalDate": "2017-06-29T12:56:42+0000"
        },
        {
            "sourceCurrencyCode": "SDD",
            "destinationCurrencyCode": "CAD",
            "conversionRate": 1.025,
            "rateRetrievalDate": "2017-06-29T12:57:06+0000"
        },
        {
            "sourceCurrencyCode": "HTG",
            "destinationCurrencyCode": "CAD",
            "conversionRate": 0.024141825,
            "rateRetrievalDate": "2017-06-29T12:56:53+0000"
        },
        {
            "sourceCurrencyCode": "SHP",
            "destinationCurrencyCode": "CAD",
            "conversionRate": 1.642346225,
            "rateRetrievalDate": "2017-06-29T12:57:07+0000"
        },
        {
            "sourceCurrencyCode": "SBD",
            "destinationCurrencyCode": "CAD",
            "conversionRate": 0.13820075,
            "rateRetrievalDate": "2017-06-29T12:57:05+0000"
        },
        {
            "sourceCurrencyCode": "FJD",
            "destinationCurrencyCode": "CAD",
            "conversionRate": 0.569476675,
            "rateRetrievalDate": "2017-06-29T12:56:50+0000"
        },
        {
            "sourceCurrencyCode": "EGP",
            "destinationCurrencyCode": "CAD",
            "conversionRate": 0.167457325,
            "rateRetrievalDate": "2017-06-29T12:56:49+0000"
        },
        {
            "sourceCurrencyCode": "ARS",
            "destinationCurrencyCode": "CAD",
            "conversionRate": 0.214410525,
            "rateRetrievalDate": "2017-06-29T12:56:43+0000"
        },
        {
            "sourceCurrencyCode": "NIO",
            "destinationCurrencyCode": "CAD",
            "conversionRate": 0.042758900,
            "rateRetrievalDate": "2017-06-29T12:57:01+0000"
        },
        {
            "sourceCurrencyCode": "MOP",
            "destinationCurrencyCode": "CAD",
            "conversionRate": 0.12786875,
            "rateRetrievalDate": "2017-06-29T12:56:59+0000"
        },
        {
            "sourceCurrencyCode": "AWG",
            "destinationCurrencyCode": "CAD",
            "conversionRate": 0.571522575,
            "rateRetrievalDate": "2017-06-29T12:56:43+0000"
        },
        {
            "sourceCurrencyCode": "MGA",
            "destinationCurrencyCode": "CAD",
            "conversionRate": 1.025,
            "rateRetrievalDate": "2017-06-29T12:56:59+0000"
        },
        {
            "sourceCurrencyCode": "TTD",
            "destinationCurrencyCode": "CAD",
            "conversionRate": 0.160603150,
            "rateRetrievalDate": "2017-06-29T12:57:09+0000"
        },
        {
            "sourceCurrencyCode": "TRY",
            "destinationCurrencyCode": "CAD",
            "conversionRate": 0.56783975,
            "rateRetrievalDate": "2017-06-29T12:57:09+0000"
        },
        {
            "sourceCurrencyCode": "CRC",
            "destinationCurrencyCode": "CAD",
            "conversionRate": 0.002045900,
            "rateRetrievalDate": "2017-06-29T12:56:47+0000"
        },
        {
            "sourceCurrencyCode": "PHP",
            "destinationCurrencyCode": "CAD",
            "conversionRate": 0.024755800,
            "rateRetrievalDate": "2017-06-29T12:57:03+0000"
        },
        {
            "sourceCurrencyCode": "GTQ",
            "destinationCurrencyCode": "CAD",
            "conversionRate": 0.130528625,
            "rateRetrievalDate": "2017-06-29T12:56:52+0000"
        },
        {
            "sourceCurrencyCode": "XOF",
            "destinationCurrencyCode": "CAD",
            "conversionRate": 0.002045900,
            "rateRetrievalDate": "2017-06-29T12:57:12+0000"
        },
        {
            "sourceCurrencyCode": "RUB",
            "destinationCurrencyCode": "CAD",
            "conversionRate": 0.032529400,
            "rateRetrievalDate": "2017-06-29T12:57:05+0000"
        },
        {
            "sourceCurrencyCode": "KHR",
            "destinationCurrencyCode": "CAD",
            "conversionRate": 0.0002050,
            "rateRetrievalDate": "2017-06-29T12:56:56+0000"
        },
        {
            "sourceCurrencyCode": "BGN",
            "destinationCurrencyCode": "CAD",
            "conversionRate": 0.678829825,
            "rateRetrievalDate": "2017-06-29T12:56:44+0000"
        },
        {
            "sourceCurrencyCode": "BDT",
            "destinationCurrencyCode": "CAD",
            "conversionRate": 0.012480400,
            "rateRetrievalDate": "2017-06-29T12:56:44+0000"
        },
        {
            "sourceCurrencyCode": "NPR",
            "destinationCurrencyCode": "CAD",
            "conversionRate": 0.011763925,
            "rateRetrievalDate": "2017-06-29T12:57:02+0000"
        },
        {
            "sourceCurrencyCode": "QAR",
            "destinationCurrencyCode": "CAD",
            "conversionRate": 0.281004775,
            "rateRetrievalDate": "2017-06-29T12:57:04+0000"
        },
        {
            "sourceCurrencyCode": "TJS",
            "destinationCurrencyCode": "CAD",
            "conversionRate": 0.21492200,
            "rateRetrievalDate": "2017-06-29T12:57:08+0000"
        },
        {
            "sourceCurrencyCode": "MYR",
            "destinationCurrencyCode": "CAD",
            "conversionRate": 0.335016125,
            "rateRetrievalDate": "2017-06-29T12:57:01+0000"
        },
        {
            "sourceCurrencyCode": "HUF",
            "destinationCurrencyCode": "CAD",
            "conversionRate": 0.004705775,
            "rateRetrievalDate": "2017-06-29T12:56:53+0000"
        },
        {
            "sourceCurrencyCode": "MMK",
            "destinationCurrencyCode": "CAD",
            "conversionRate": 0.001207450,
            "rateRetrievalDate": "2017-06-29T12:56:59+0000"
        },
        {
            "sourceCurrencyCode": "BYR",
            "destinationCurrencyCode": "CAD",
            "conversionRate": 0.0001025,
            "rateRetrievalDate": "2017-06-29T12:56:46+0000"
        },
        {
            "sourceCurrencyCode": "IDR",
            "destinationCurrencyCode": "CAD",
            "conversionRate": 0.0001025,
            "rateRetrievalDate": "2017-06-29T12:56:53+0000"
        },
        {
            "sourceCurrencyCode": "BRL",
            "destinationCurrencyCode": "CAD",
            "conversionRate": 0.503393900,
            "rateRetrievalDate": "2017-06-29T12:56:45+0000"
        },
        {
            "sourceCurrencyCode": "MDL",
            "destinationCurrencyCode": "CAD",
            "conversionRate": 0.083472925,
            "rateRetrievalDate": "2017-06-29T12:56:59+0000"
        },
        {
            "sourceCurrencyCode": "SAR",
            "destinationCurrencyCode": "CAD",
            "conversionRate": 0.272821175,
            "rateRetrievalDate": "2017-06-29T12:57:05+0000"
        },
        {
            "sourceCurrencyCode": "HNL",
            "destinationCurrencyCode": "CAD",
            "conversionRate": 0.051965450,
            "rateRetrievalDate": "2017-06-29T12:56:52+0000"
        },
        {
            "sourceCurrencyCode": "VEF",
            "destinationCurrencyCode": "CAD",
            "conversionRate": 0.237938375,
            "rateRetrievalDate": "2017-06-29T12:57:11+0000"
        },
        {
            "sourceCurrencyCode": "LTL",
            "destinationCurrencyCode": "CAD",
            "conversionRate": 0.384526700,
            "rateRetrievalDate": "2017-06-29T12:56:58+0000"
        },
        {
            "sourceCurrencyCode": "AZN",
            "destinationCurrencyCode": "CAD",
            "conversionRate": 1.025,
            "rateRetrievalDate": "2017-06-29T12:56:43+0000"
        },
        {
            "sourceCurrencyCode": "COP",
            "destinationCurrencyCode": "CAD",
            "conversionRate": 0.000511475,
            "rateRetrievalDate": "2017-06-29T12:56:47+0000"
        },
        {
            "sourceCurrencyCode": "PYG",
            "destinationCurrencyCode": "CAD",
            "conversionRate": 0.0002050,
            "rateRetrievalDate": "2017-06-29T12:57:04+0000"
        },
        {
            "sourceCurrencyCode": "ANG",
            "destinationCurrencyCode": "CAD",
            "conversionRate": 0.571522575,
            "rateRetrievalDate": "2017-06-29T12:56:42+0000"
        },
        {
            "sourceCurrencyCode": "XPF",
            "destinationCurrencyCode": "CAD",
            "conversionRate": 0.011047450,
            "rateRetrievalDate": "2017-06-29T12:57:12+0000"
        },
        {
            "sourceCurrencyCode": "NZD",
            "destinationCurrencyCode": "CAD",
            "conversionRate": 0.836261625,
            "rateRetrievalDate": "2017-06-29T12:57:02+0000"
        },
        {
            "sourceCurrencyCode": "DKK",
            "destinationCurrencyCode": "CAD",
            "conversionRate": 0.177481825,
            "rateRetrievalDate": "2017-06-29T12:56:48+0000"
        },
        {
            "sourceCurrencyCode": "MNT",
            "destinationCurrencyCode": "CAD",
            "conversionRate": 0.000716475,
            "rateRetrievalDate": "2017-06-29T12:56:59+0000"
        },
        {
            "sourceCurrencyCode": "PKR",
            "destinationCurrencyCode": "CAD",
            "conversionRate": 0.010638475,
            "rateRetrievalDate": "2017-06-29T12:57:03+0000"
        },
        {
            "sourceCurrencyCode": "SLL",
            "destinationCurrencyCode": "CAD",
            "conversionRate": 0.00023575,
            "rateRetrievalDate": "2017-06-29T12:57:07+0000"
        },
        {
            "sourceCurrencyCode": "SEK",
            "destinationCurrencyCode": "CAD",
            "conversionRate": 0.1536475,
            "rateRetrievalDate": "2017-06-29T12:57:06+0000"
        },
        {
            "sourceCurrencyCode": "RSD",
            "destinationCurrencyCode": "CAD",
            "conversionRate": 0.011661425,
            "rateRetrievalDate": "2017-06-29T12:57:04+0000"
        },
        {
            "sourceCurrencyCode": "WST",
            "destinationCurrencyCode": "CAD",
            "conversionRate": 0.446006200,
            "rateRetrievalDate": "2017-06-29T12:57:11+0000"
        },
        {
            "sourceCurrencyCode": "HKD",
            "destinationCurrencyCode": "CAD",
            "conversionRate": 0.131960550,
            "rateRetrievalDate": "2017-06-29T12:56:52+0000"
        },
        {
            "sourceCurrencyCode": "KWD",
            "destinationCurrencyCode": "CAD",
            "conversionRate": 3.635052825,
            "rateRetrievalDate": "2017-06-29T12:56:56+0000"
        },
        {
            "sourceCurrencyCode": "CDF",
            "destinationCurrencyCode": "CAD",
            "conversionRate": 0.001125450,
            "rateRetrievalDate": "2017-06-29T12:56:46+0000"
        },
        {
            "sourceCurrencyCode": "BAM",
            "destinationCurrencyCode": "CAD",
            "conversionRate": 0.677090400,
            "rateRetrievalDate": "2017-06-29T12:56:44+0000"
        },
        {
            "sourceCurrencyCode": "GIP",
            "destinationCurrencyCode": "CAD",
            "conversionRate": 1.642346225,
            "rateRetrievalDate": "2017-06-29T12:56:51+0000"
        },
        {
            "sourceCurrencyCode": "XCD",
            "destinationCurrencyCode": "CAD",
            "conversionRate": 0.380537400,
            "rateRetrievalDate": "2017-06-29T12:57:12+0000"
        },
        {
            "sourceCurrencyCode": "JPY",
            "destinationCurrencyCode": "CAD",
            "conversionRate": 0.012786875,
            "rateRetrievalDate": "2017-06-29T12:56:55+0000"
        },
        {
            "sourceCurrencyCode": "KRW",
            "destinationCurrencyCode": "CAD",
            "conversionRate": 0.000920450,
            "rateRetrievalDate": "2017-06-29T12:56:56+0000"
        },
        {
            "sourceCurrencyCode": "CHF",
            "destinationCurrencyCode": "CAD",
            "conversionRate": 1.095579450,
            "rateRetrievalDate": "2017-06-29T12:56:47+0000"
        },
        {
            "sourceCurrencyCode": "TND",
            "destinationCurrencyCode": "CAD",
            "conversionRate": 0.650289725,
            "rateRetrievalDate": "2017-06-29T12:57:08+0000"
        },
        {
            "sourceCurrencyCode": "OMR",
            "destinationCurrencyCode": "CAD",
            "conversionRate": 2.656703650,
            "rateRetrievalDate": "2017-06-29T12:57:02+0000"
        },
        {
            "sourceCurrencyCode": "YER",
            "destinationCurrencyCode": "CAD",
            "conversionRate": 0.004757025,
            "rateRetrievalDate": "2017-06-29T12:57:12+0000"
        },
        {
            "sourceCurrencyCode": "VUV",
            "destinationCurrencyCode": "CAD",
            "conversionRate": 0.010535975,
            "rateRetrievalDate": "2017-06-29T12:57:11+0000"
        },
        {
            "sourceCurrencyCode": "MZN",
            "destinationCurrencyCode": "CAD",
            "conversionRate": 0.035086775,
            "rateRetrievalDate": "2017-06-29T12:57:01+0000"
        },
        {
            "sourceCurrencyCode": "ETB",
            "destinationCurrencyCode": "CAD",
            "conversionRate": 0.05615975,
            "rateRetrievalDate": "2017-06-29T12:56:50+0000"
        },
        {
            "sourceCurrencyCode": "LRD",
            "destinationCurrencyCode": "CAD",
            "conversionRate": 0.014423800,
            "rateRetrievalDate": "2017-06-29T12:56:58+0000"
        },
        {
            "sourceCurrencyCode": "MUR",
            "destinationCurrencyCode": "CAD",
            "conversionRate": 0.032836900,
            "rateRetrievalDate": "2017-06-29T12:57:00+0000"
        },
        {
            "sourceCurrencyCode": "MXN",
            "destinationCurrencyCode": "CAD",
            "conversionRate": 0.0784125,
            "rateRetrievalDate": "2017-06-29T12:57:00+0000"
        },
        {
            "sourceCurrencyCode": "NGN",
            "destinationCurrencyCode": "CAD",
            "conversionRate": 0.006546675,
            "rateRetrievalDate": "2017-06-29T12:57:01+0000"
        },
        {
            "sourceCurrencyCode": "TZS",
            "destinationCurrencyCode": "CAD",
            "conversionRate": 0.000613975,
            "rateRetrievalDate": "2017-06-29T12:57:10+0000"
        },
        {
            "sourceCurrencyCode": "SRD",
            "destinationCurrencyCode": "CAD",
            "conversionRate": 0.305350575,
            "rateRetrievalDate": "2017-06-29T12:57:07+0000"
        },
        {
            "sourceCurrencyCode": "NAD",
            "destinationCurrencyCode": "CAD",
            "conversionRate": 0.117127775,
            "rateRetrievalDate": "2017-06-29T12:57:01+0000"
        },
        {
            "sourceCurrencyCode": "PAB",
            "destinationCurrencyCode": "CAD",
            "conversionRate": 1.022950,
            "rateRetrievalDate": "2017-06-29T12:57:03+0000"
        },
        {
            "sourceCurrencyCode": "CVE",
            "destinationCurrencyCode": "CAD",
            "conversionRate": 0.01022950,
            "rateRetrievalDate": "2017-06-29T12:56:48+0000"
        },
        {
            "sourceCurrencyCode": "RWF",
            "destinationCurrencyCode": "CAD",
            "conversionRate": 1.022950,
            "rateRetrievalDate": "2017-06-29T12:57:05+0000"
        },
        {
            "sourceCurrencyCode": "CNY",
            "destinationCurrencyCode": "CAD",
            "conversionRate": 0.16377450,
            "rateRetrievalDate": "2017-06-29T12:56:47+0000"
        },
        {
            "sourceCurrencyCode": "ZWL",
            "destinationCurrencyCode": "CAD",
            "conversionRate": 1.025,
            "rateRetrievalDate": "2017-06-29T12:57:13+0000"
        },
        {
            "sourceCurrencyCode": "IQD",
            "destinationCurrencyCode": "CAD",
            "conversionRate": 0.000920450,
            "rateRetrievalDate": "2017-06-29T12:56:54+0000"
        },
        {
            "sourceCurrencyCode": "HRK",
            "destinationCurrencyCode": "CAD",
            "conversionRate": 0.176458875,
            "rateRetrievalDate": "2017-06-29T12:56:53+0000"
        },
        {
            "sourceCurrencyCode": "KES",
            "destinationCurrencyCode": "CAD",
            "conversionRate": 0.011968925,
            "rateRetrievalDate": "2017-06-29T12:56:55+0000"
        },
        {
            "sourceCurrencyCode": "LYD",
            "destinationCurrencyCode": "CAD",
            "conversionRate": 0.822349300,
            "rateRetrievalDate": "2017-06-29T12:56:58+0000"
        },
        {
            "sourceCurrencyCode": "EUR",
            "destinationCurrencyCode": "CAD",
            "conversionRate": 1.3245050,
            "rateRetrievalDate": "2017-06-29T12:56:50+0000"
        },
        {
            "sourceCurrencyCode": "ZAR",
            "destinationCurrencyCode": "CAD",
            "conversionRate": 0.117127775,
            "rateRetrievalDate": "2017-06-29T12:57:13+0000"
        },
        {
            "sourceCurrencyCode": "DZD",
            "destinationCurrencyCode": "CAD",
            "conversionRate": 0.012889375,
            "rateRetrievalDate": "2017-06-29T12:56:49+0000"
        },
        {
            "sourceCurrencyCode": "SCR",
            "destinationCurrencyCode": "CAD",
            "conversionRate": 0.079995100,
            "rateRetrievalDate": "2017-06-29T12:57:06+0000"
        },
        {
            "sourceCurrencyCode": "ERN",
            "destinationCurrencyCode": "CAD",
            "conversionRate": 0.068231175,
            "rateRetrievalDate": "2017-06-29T12:56:49+0000"
        },
        {
            "sourceCurrencyCode": "CUP",
            "destinationCurrencyCode": "CAD",
            "conversionRate": 1.022950,
            "rateRetrievalDate": "2017-06-29T12:56:48+0000"
        },
        {
            "sourceCurrencyCode": "BIF",
            "destinationCurrencyCode": "CAD",
            "conversionRate": 0.000716475,
            "rateRetrievalDate": "2017-06-29T12:56:45+0000"
        },
        {
            "sourceCurrencyCode": "GEL",
            "destinationCurrencyCode": "CAD",
            "conversionRate": 0.616020900,
            "rateRetrievalDate": "2017-06-29T12:56:51+0000"
        },
        {
            "sourceCurrencyCode": "BHD",
            "destinationCurrencyCode": "CAD",
            "conversionRate": 2.713068400,
            "rateRetrievalDate": "2017-06-29T12:56:44+0000"
        },
        {
            "sourceCurrencyCode": "GBP",
            "destinationCurrencyCode": "CAD",
            "conversionRate": 1.6429725,
            "rateRetrievalDate": "2017-06-29T12:56:51+0000"
        },
        {
            "sourceCurrencyCode": "TWD",
            "destinationCurrencyCode": "CAD",
            "conversionRate": 0.034985300,
            "rateRetrievalDate": "2017-06-29T12:57:09+0000"
        },
        {
            "sourceCurrencyCode": "THB",
            "destinationCurrencyCode": "CAD",
            "conversionRate": 1.025,
            "rateRetrievalDate": "2017-06-29T12:57:08+0000"
        },
        {
            "sourceCurrencyCode": "XAF",
            "destinationCurrencyCode": "CAD",
            "conversionRate": 0.002045900,
            "rateRetrievalDate": "2017-06-29T12:57:12+0000"
        },
        {
            "sourceCurrencyCode": "UZS",
            "destinationCurrencyCode": "CAD",
            "conversionRate": 0.000511475,
            "rateRetrievalDate": "2017-06-29T12:57:11+0000"
        },
        {
            "sourceCurrencyCode": "KYD",
            "destinationCurrencyCode": "CAD",
            "conversionRate": 1.2275400,
            "rateRetrievalDate": "2017-06-29T12:56:57+0000"
        },
        {
            "sourceCurrencyCode": "MVR",
            "destinationCurrencyCode": "CAD",
            "conversionRate": 0.065263800,
            "rateRetrievalDate": "2017-06-29T12:57:00+0000"
        },
        {
            "sourceCurrencyCode": "MWK",
            "destinationCurrencyCode": "CAD",
            "conversionRate": 0.003273850,
            "rateRetrievalDate": "2017-06-29T12:57:00+0000"
        },
        {
            "sourceCurrencyCode": "KMF",
            "destinationCurrencyCode": "CAD",
            "conversionRate": 0.002659875,
            "rateRetrievalDate": "2017-06-29T12:56:56+0000"
        },
        {
            "sourceCurrencyCode": "KZT",
            "destinationCurrencyCode": "CAD",
            "conversionRate": 0.006751675,
            "rateRetrievalDate": "2017-06-29T12:56:57+0000"
        },
        {
            "sourceCurrencyCode": "LSL",
            "destinationCurrencyCode": "CAD",
            "conversionRate": 0.117127775,
            "rateRetrievalDate": "2017-06-29T12:56:58+0000"
        },
        {
            "sourceCurrencyCode": "INR",
            "destinationCurrencyCode": "CAD",
            "conversionRate": 0.018822075,
            "rateRetrievalDate": "2017-06-29T12:56:54+0000"
        },
        {
            "sourceCurrencyCode": "AUD",
            "destinationCurrencyCode": "CAD",
            "conversionRate": 1.0582100,
            "rateRetrievalDate": "2017-06-29T12:56:43+0000"
        },
        {
            "sourceCurrencyCode": "KGS",
            "destinationCurrencyCode": "CAD",
            "conversionRate": 0.021686950,
            "rateRetrievalDate": "2017-06-29T12:56:55+0000"
        },
        {
            "sourceCurrencyCode": "SZL",
            "destinationCurrencyCode": "CAD",
            "conversionRate": 0.117127775,
            "rateRetrievalDate": "2017-06-29T12:57:08+0000"
        },
        {
            "sourceCurrencyCode": "BWP",
            "destinationCurrencyCode": "CAD",
            "conversionRate": 0.130119650,
            "rateRetrievalDate": "2017-06-29T12:56:46+0000"
        },
        {
            "sourceCurrencyCode": "BZD",
            "destinationCurrencyCode": "CAD",
            "conversionRate": 0.515975775,
            "rateRetrievalDate": "2017-06-29T12:56:46+0000"
        },
        {
            "sourceCurrencyCode": "GYD",
            "destinationCurrencyCode": "CAD",
            "conversionRate": 0.00501225,
            "rateRetrievalDate": "2017-06-29T12:56:52+0000"
        },
        {
            "sourceCurrencyCode": "IRR",
            "destinationCurrencyCode": "CAD",
            "conversionRate": 0.00008200,
            "rateRetrievalDate": "2017-06-29T12:56:54+0000"
        },
        {
            "sourceCurrencyCode": "GNF",
            "destinationCurrencyCode": "CAD",
            "conversionRate": 0.0001025,
            "rateRetrievalDate": "2017-06-29T12:56:51+0000"
        },
        {
            "sourceCurrencyCode": "DJF",
            "destinationCurrencyCode": "CAD",
            "conversionRate": 1.025,
            "rateRetrievalDate": "2017-06-29T12:56:48+0000"
        },
        {
            "sourceCurrencyCode": "LKR",
            "destinationCurrencyCode": "CAD",
            "conversionRate": 0.007877125,
            "rateRetrievalDate": "2017-06-29T12:56:57+0000"
        },
        {
            "sourceCurrencyCode": "BMD",
            "destinationCurrencyCode": "CAD",
            "conversionRate": 1.022950,
            "rateRetrievalDate": "2017-06-29T12:56:45+0000"
        },
        {
            "sourceCurrencyCode": "PEN",
            "destinationCurrencyCode": "CAD",
            "conversionRate": 0.395575175,
            "rateRetrievalDate": "2017-06-29T12:57:03+0000"
        },
        {
            "sourceCurrencyCode": "UGX",
            "destinationCurrencyCode": "CAD",
            "conversionRate": 0.000398725,
            "rateRetrievalDate": "2017-06-29T12:57:10+0000"
        },
        {
            "sourceCurrencyCode": "LAK",
            "destinationCurrencyCode": "CAD",
            "conversionRate": 0.00012300,
            "rateRetrievalDate": "2017-06-29T12:56:57+0000"
        },
        {
            "sourceCurrencyCode": "PGK",
            "destinationCurrencyCode": "CAD",
            "conversionRate": 0.479558550,
            "rateRetrievalDate": "2017-06-29T12:57:03+0000"
        },
        {
            "sourceCurrencyCode": "SOS",
            "destinationCurrencyCode": "CAD",
            "conversionRate": 0.000613975,
            "rateRetrievalDate": "2017-06-29T12:57:07+0000"
        },
        {
            "sourceCurrencyCode": "BSD",
            "destinationCurrencyCode": "CAD",
            "conversionRate": 1.022950,
            "rateRetrievalDate": "2017-06-29T12:56:46+0000"
        },
        {
            "sourceCurrencyCode": "UYU",
            "destinationCurrencyCode": "CAD",
            "conversionRate": 0.0513525,
            "rateRetrievalDate": "2017-06-29T12:57:11+0000"
        },
        {
            "sourceCurrencyCode": "ALL",
            "destinationCurrencyCode": "CAD",
            "conversionRate": 0.009513025,
            "rateRetrievalDate": "2017-06-29T12:56:42+0000"
        },
        {
            "sourceCurrencyCode": "MKD",
            "destinationCurrencyCode": "CAD",
            "conversionRate": 0.021584450,
            "rateRetrievalDate": "2017-06-29T12:56:59+0000"
        },
        {
            "sourceCurrencyCode": "KPW",
            "destinationCurrencyCode": "CAD",
            "conversionRate": 0.4603275,
            "rateRetrievalDate": "2017-06-29T12:56:56+0000"
        },
        {
            "sourceCurrencyCode": "USD",
            "destinationCurrencyCode": "CAD",
            "conversionRate": 1.022950,
            "rateRetrievalDate": "2017-06-29T12:57:10+0000"
        },
        {
            "sourceCurrencyCode": "GHS",
            "destinationCurrencyCode": "CAD",
            "conversionRate": 0.545538825,
            "rateRetrievalDate": "2017-06-29T12:56:51+0000"
        },
        {
            "sourceCurrencyCode": "RON",
            "destinationCurrencyCode": "CAD",
            "conversionRate": 0.292563700,
            "rateRetrievalDate": "2017-06-29T12:57:04+0000"
        },
        {
            "sourceCurrencyCode": "PLN",
            "destinationCurrencyCode": "CAD",
            "conversionRate": 0.320388350,
            "rateRetrievalDate": "2017-06-29T12:57:04+0000"
        }
    ]
}

OmarR · June 2017

Baahubali,

What particular section of @benken_parasoft 's method are you having difficulty with? It would be very helpful to see your current progress to understand how we can help.

[Deleted User] · June 2017

For just validating one currency if it exists in response or not you can add JSON Assertor to response and add "Value Occurrence Assertion" in selected element specifying this regular expression "/root/foreignExchageRates/item/(sourceCurrencyCode|destinationCurrencyCode)/text()" assuming the JSON structure is not changing.
For verifying all currencies maybe add table data source with all currencies and parameterize the value in JOSN Assertor.

[Deleted User] · June 2017

One better solution is to use Custom Assertion with above specified xpath as Selected Element.
Something like this
boolean checkCurrency(String input, Context context) {
String[] currencies = {"AED", "ALL", "AMD"... "ZWL"};
for(String currency: currencies) {
if (!input.contains(currency)) {
return false;
}
}
return true;
}

Baahubali · July 2017

My requirement is to check the occurenceof sourceCurrencyCode element in the JSON with a set of standard list of sourceCurrencyCode which I have on a excel sheet.
There are 152 sourceCurrencyCode's expected in the JSON which is to be compared or asserted against the standard list in the excel sheet

venkata · July 2017

from com.parasoft.api import *
from soaptest.api import *
import java.util.ArrayList as ArrayList
def Test(input, context): # Defining a function with input,context parameters
list = ArrayList() #Defining a ArrayList
list = context.getValues("BaahubaliDataSourceName","BaahubaliColumnName") # Getting all the values in the columns as an arrayList
Application.showMessage(input) # Printing the value before comparing
if list.contains(input):
return 1
else:
return 0

Hope this helps!!

[Deleted User] · July 2017

One more better solution will be to add Custom Assertion with the same regular expression and specify the code something like this.
import com.parasoft.api.*;
boolean checkCurrency(input, context) {
String[] currencies = [
"AED",
"ALL",
"AMD",
"ANG",
"AOA",
"ARS",
"AUD",
"AWG",
"AZN",
"BAM",
"BBD",
"BDT",
"BGN",
"BHD",
"BIF",
"BMD",
"BND",
"BOB",
"BRL",
"BSD",
"BWP",
"BYR",
"BZD",
"CDF",
"CHF",
"CLP",
"CNY",
"COP",
"CRC",
"CUP",
"CVE",
"CZK",
"DJF",
"DKK",
"DOP",
"DZD",
"EGP",
"ERN",
"ETB",
"EUR",
"FJD",
"FKP",
"GBP",
"GEL",
"GHS",
"GIP",
"GMD",
"GNF",
"GTQ",
"GYD",
"HKD",
"HNL",
"HRK",
"HTG",
"HUF",
"IDR",
"ILS",
"INR",
"IQD",
"IRR",
"ISK",
"JMD",
"JOD",
"JPY",
"KES",
"KGS",
"KHR",
"KMF",
"KPW",
"KRW",
"KWD",
"KYD",
"KZT",
"LAK",
"LBP",
"LKR",
"LRD",
"LSL",
"LTL",
"LYD",
"MAD",
"MDL",
"MGA",
"MKD",
"MMK",
"MNT",
"MOP",
"MRO",
"MUR",
"MVR",
"MWK",
"MXN",
"MYR",
"MZN",
"NAD",
"NGN",
"NIO",
"NOK",
"NPR",
"NZD",
"OMR",
"PAB",
"PEN",
"PGK",
"PHP",
"PKR",
"PLN",
"PYG",
"QAR",
"RON",
"RSD",
"RUB",
"RWF",
"SAR",
"SBD",
"SCR",
"SDD",
"SEK",
"SGD",
"SHP",
"SLL",
"SOS",
"SRD",
"STD",
"SYP",
"SZL",
"THB",
"TJS",
"TMT",
"TND",
"TOP",
"TRY",
"TTD",
"TWD",
"TZS",
"UAH",
"UGX",
"USD",
"UYU",
"UZS",
"VEF",
"VND",
"VUV",
"WST",
"XAF",
"XCD",
"XOF",
"XPF",
"YER",
"ZAR",
"ZMW",
"ZWL" ];

if (!currencies.contains(input)) {
    return false;
}
return true;

}

[Deleted User] · July 2017

One better solution is to use Custom Assertion with above specified xpath as Selected Element.
Something like this
import com.parasoft.api.*;
boolean checkCurrency(input, context) {
String[] currencies = [
"AED",
"ALL",
"AMD",
"ANG",
"AOA",
"ARS",
"AUD",
"AWG",
"AZN",
"BAM",
"BBD",
"BDT",
"BGN",
"BHD",
"BIF",
"BMD",
"BND",
"BOB",
"BRL",
"BSD",
"BWP",
"BYR",
"BZD",
"CDF",
"CHF",
"CLP",
"CNY",
"COP",
"CRC",
"CUP",
"CVE",
"CZK",
"DJF",
"DKK",
"DOP",
"DZD",
"EGP",
"ERN",
"ETB",
"EUR",
"FJD",
"FKP",
"GBP",
"GEL",
"GHS",
"GIP",
"GMD",
"GNF",
"GTQ",
"GYD",
"HKD",
"HNL",
"HRK",
"HTG",
"HUF",
"IDR",
"ILS",
"INR",
"IQD",
"IRR",
"ISK",
"JMD",
"JOD",
"JPY",
"KES",
"KGS",
"KHR",
"KMF",
"KPW",
"KRW",
"KWD",
"KYD",
"KZT",
"LAK",
"LBP",
"LKR",
"LRD",
"LSL",
"LTL",
"LYD",
"MAD",
"MDL",
"MGA",
"MKD",
"MMK",
"MNT",
"MOP",
"MRO",
"MUR",
"MVR",
"MWK",
"MXN",
"MYR",
"MZN",
"NAD",
"NGN",
"NIO",
"NOK",
"NPR",
"NZD",
"OMR",
"PAB",
"PEN",
"PGK",
"PHP",
"PKR",
"PLN",
"PYG",
"QAR",
"RON",
"RSD",
"RUB",
"RWF",
"SAR",
"SBD",
"SCR",
"SDD",
"SEK",
"SGD",
"SHP",
"SLL",
"SOS",
"SRD",
"STD",
"SYP",
"SZL",
"THB",
"TJS",
"TMT",
"TND",
"TOP",
"TRY",
"TTD",
"TWD",
"TZS",
"UAH",
"UGX",
"USD",
"UYU",
"UZS",
"VEF",
"VND",
"VUV",
"WST",
"XAF",
"XCD",
"XOF",
"XPF",
"YER",
"ZAR",
"ZMW",
"ZWL" ];

if (!currencies.contains(input)) {
    return false;
}
return true;

}

Compare a set of elements of the JSON response to the standard set of elements

Comments

Categories

Tagged