Contributions
- 12 years agoPlace ReadyAPI QuestionsReadyAPI Questions1.6KViews0likes0Comments
Re: [Res]How to test the Cust list for which the order is undefi
Thanks for the reply and sorry for my delayed reply. I am happy to hear that this is doable. I want to validate in a way to check that every customer profile in the JSON response exists in an excel spreadsheet. I will pull the data from Data Base to a excel file and then wanted to validate the JSON response against the data I have in the excel file.12 years agoPlace ReadyAPI QuestionsReadyAPI Questions1.6KViews0likes0Comments[Res]How to test the Cust list for which the order is undefi
I have a REST Response where I get the customer list but the order is not defined. I want to validate each and every customer returned in the list with my data file (in Excel format). Please help me in achieving this. Below is the response I am getting (JSON format) {"custProfile": { "_elapsedTime": "699", "code": "00", "custProfileList": [ { "addr": { "addrLocTyp": "HOME", "stCd": "2" }, "brthdyDt": "1945-04-01T00:00:00-04:00", "custCmntTxt": "eksjdf ksdjfh skdjfh ksdjfh djskfh sdjkfh sdjkfh sdkjfh sdkf sdf sdf", "custId": "501491", "custRefNm": "Duckworth Vera", "custStusCd": "Y", "dytmPhonNr": "121021021021111", "dytmStdPhonCd": "02", "emailAddrTxt": "vera@sound.com", "evngPhonNr": "056405405405405", "evngStdPhonCd": "02", "frstNm": "Duckworth", "lastNm": "Vera", "repAcctNr": "33949401", "success": "true", "timeZoneCd": "Australia/Sydney", "titlCd": "2" }, { "addr": { "addrLocTyp": "HOME", "stCd": "0" }, "custId": "501635", "custRefNm": "Ewen Jackie", "custStusCd": "Y", "emailAddrTxt": "jackie.ewen@avon.com", "frstNm": "Ewen", "lastNm": "Jackie", "repAcctNr": "33949401", "success": "true", "timeZoneCd": "Australia/Sydney", "titlCd": "2" }, { "addr": { "addrLocTyp": "HOME", "custAddr2Txt": "dasdasd", "custAddr3Txt": "asdasdas", "custAddrTxt": "43dadasdas", "stCd": "QLD" }, "brthdyDt": "1974-01-01T00:00:00-05:00", "custCmntTxt": "sadasdasd", "custId": "501495", "custRefNm": "ykhjkjh kjhkjhkhjk", "custStusCd": "Y", "dytmPhonNr": "234234234234234", "dytmStdPhonCd": "02", "emailAddrTxt": "erterter@jggj.com", "evngPhonNr": "234234342342342", "evngStdPhonCd": "02", "frstNm": "ykhjkjh", "lastNm": "kjhkjhkhjk", "mobilePhonNr": "2342342342", "repAcctNr": "33949401", "success": "true", "timeZoneCd": "Australia/Sydney", "titlCd": "3" }, { "addr": { "addrLocTyp": "HOME", "stCd": "0" }, "custId": "501814", "custRefNm": "jhkh hkhk", "custStusCd": "Y", "frstNm": "jhkh", "lastNm": "hkhk", "repAcctNr": "33949401", "success": "true", "timeZoneCd": "Australia/Sydney", "titlCd": "1" }, { "addr": { "addrLocTyp": "HOME", "stCd": "0" }, "brthdyDt": "1980-01-01T00:00:00-05:00", "custId": "501574", "custRefNm": "Test Test", "custStusCd": "Y", "emailAddrTxt": "test@test.com", "frstNm": "Test", "lastNm": "Test", "repAcctNr": "33949401", "success": "true", "timeZoneCd": "Australia/Sydney", "titlCd": "3" }, { "addr": { "addrLocTyp": "HOME", "pstlCd": "1212", "stCd": "5" }, "brthdyDt": "1974-05-04T00:00:00-04:00", "custCmntTxt": "wt rwet ret ert qetqr qwert qert qerteqrt erte", "custId": "501490", "custRefNm": "Bank Jeff", "custStusCd": "Y", "frstNm": "Bank", "lastNm": "Jeff", "repAcctNr": "33949401", "success": "true", "timeZoneCd": "Australia/Sydney", "titlCd": "3" }, { "addr": { "addrLocTyp": "HOME", "stCd": "0" }, "custId": "501594", "custRefNm": "tst tst", "custStusCd": "Y", "frstNm": "tst", "lastNm": "tst", "repAcctNr": "33949401", "success": "true", "timeZoneCd": "Australia/Sydney", "titlCd": "3" }, { "addr": { "addrLocTyp": "HOME", "stCd": "0" }, "brthdyDt": "1981-12-12T00:00:00-05:00", "custCmntTxt": "test", "custId": "502943", "custRefNm": "Jeff ohlmann", "custStusCd": "Y", "frstNm": "Jeff", "lastNm": "ohlmann", "repAcctNr": "33949401", "success": "true", "timeZoneCd": "Australia/Sydney", "titlCd": "0" }, { "addr": { "addrLocTyp": "HOME", "stCd": "0" }, "brthdyDt": "1954-06-04T00:00:00-04:00", "custCmntTxt": "JKF JKSDFH JKSDFH SJKDFH JKSDFH KSDJFH KSDJFH SDJKFH JKSDFH KDSJFH KJDSFH K KJH SDJKFH KSDJFH KSDJFH SDKJF KSDJFH SDKJFH KDSJ FHKSDJFH KDJFH KSDJ KDSFH KSDJFH SDKJ", "custId": "501492", "custRefNm": "Jammin Seoul", "custStusCd": "Y", "emailAddrTxt": "DANCE@GREAT.COM", "frstNm": "Jammin", "lastNm": "Seoul", "repAcctNr": "33949401", "success": "true", "timeZoneCd": "Australia/Sydney", "titlCd": "2" }, { "addr": { "addrLocTyp": "HOME", "stCd": "0" }, "custId": "501497", "custRefNm": "vbnvbnvbnvbnvbn vbnvbnvbn", "custStusCd": "Y", "frstNm": "vbnvbnvbnvbnvbn", "lastNm": "vbnvbnvbn", "repAcctNr": "33949401", "success": "true", "timeZoneCd": "Australia/Sydney", "titlCd": "1" }, { "addr": { "addrLocTyp": "HOME", "stCd": "0" }, "brthdyDt": "1964-01-01T00:00:00-05:00", "custId": "501496", "custRefNm": "asdasdarwerwer rwerwfertyerte", "custStusCd": "Y", "dytmPhonNr": "104054065406540", "dytmStdPhonCd": "05", "emailAddrTxt": "jgjgj@lsls.com", "evngPhonNr": "654065406540654", "evngStdPhonCd": "05", "frstNm": "asdasdarwerwer", "lastNm": "rwerwfertyerte", "repAcctNr": "33949401", "success": "true", "timeZoneCd": "Australia/Sydney", "titlCd": "1" }, { "addr": { "addrLocTyp": "HOME", "cityNm": "gsdfgsdfgsd", "custAddr2Txt": "sdgdsfg", "custAddr3Txt": "sdfgsdf", "custAddrTxt": "fdsgsdfg", "pstlCd": "2345", "stCd": "ACT" }, "brthdyDt": "1984-12-10T00:00:00-05:00", "custCmntTxt": "sdfgdfsgdsf", "custId": "502371", "custRefNm": "Krishnan Rajesh", "custStusCd": "Y", "dytmPhonNr": "342523452435", "dytmStdPhonCd": "02", "emailAddrTxt": "rajesh_krishnan02@infosys.com", "frstNm": "Krishnan", "lastNm": "Rajesh", "mobilePhonNr": "2345234524", "repAcctNr": "33949401", "success": "true", "timeZoneCd": "Australia/Sydney", "titlCd": "3" } ], "mrktCd": "AU", "repAcctNr": "33949401", "success": "true", "timeStamp": "2013-04-01 14:12:08 122", "token": "f3BwleNr5AbIUIQfyM0PICN+tidoAGLWjYY1X3gga9e7u6o3W0M1ybPZQffn6vIKwnpmQjMC7PIUYsGKi3+pB+TJpqFfmv4a" }}12 years agoPlace ReadyAPI QuestionsReadyAPI Questions3.1KViews0likes5Comments