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

BaahubaliBaahubali Posts: 9

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?

Comments

  • benken_parasoftbenken_parasoft Posts: 269 ✭✭✭
    edited June 27

    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.

  • BaahubaliBaahubali Posts: 9
    edited June 29

    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"
            }
        ]
    }
    
  • OmarROmarR Posts: 158 ✭✭✭

    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. :)

  • grigorbgrigorb Posts: 11

    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.

  • grigorbgrigorb Posts: 11

    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;
    }

  • BaahubaliBaahubali Posts: 9

    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

  • venkatavenkata Posts: 1

    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!!

  • grigorbgrigorb Posts: 11

    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;
    

    }

  • grigorbgrigorb Posts: 11

    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;
    

    }

Sign In or Register to comment.