Forum Discussion

AmitA's avatar
AmitA
Occasional Contributor
11 years ago

JSON conversion to XML does not work

Hi Team

I'm using Soap UI 5.0.0.
I am facing a problem that Json response is not being converted to XML and returned <xml/> in XML response tab. Also the Json which I got in JSON response tab is valid one.

Please help me ASAP if anyone come across this issue and find the below JSON response


{"GetBookingResult": {
"TraceId": "",
"ResponseStatus": 2,
"Error": {
"ErrorCode": 2,
"ErrorMessage": "Object reference not set to an instance of an object."
},
"BookingRefNo": null,
"ConfirmationNo": null,
"Status": 0
}}

6 Replies

  • SmartBear_Suppo's avatar
    SmartBear_Suppo
    Icon for Alumni rankAlumni
    11 years ago
    Hello,

    I just tested this and it works fine, can you please send me your project or screen shots of the parameters in the Request along with its json response. Also please send me the error log and SoapUI log. Thanks.

    Regards,
    Temil
  • AmitA's avatar
    AmitA
    Occasional Contributor
    11 years ago
    Hi Team

    Please find the attached request and screenshot of error log and request you to reply asap.

    JSON Request:

    {
    "AgencyId": 8428,
    "ResultIndex": 1,
    "HotelCode": "${BE Request#ResponseAsXml#declare namespace ns1='http://iapi.tbotechnology.in/searchrequest/'; //ns1:Response[1]/ns1:HotelSearchResult[1]/ns1:HotelResults[1]/ns1:e[1]/ns1:HotelCode[1]}",
    "HotelName": "${BE Request#ResponseAsXml#declare namespace ns1='http://iapi.tbotechnology.in/searchrequest/'; //ns1:Response[1]/ns1:HotelSearchResult[1]/ns1:HotelResults[1]/ns1:e[1]/ns1:HotelName[1]}",
    "GuestNationality": "IN",
    "NoOfRooms": 4,
    "ClientReferenceNo": 0,
    "HotelRoomsDetails": [
    {
    "RoomIndex": "${BE RoomDetails#ResponseAsXml#declare namespace ns1='http://iapi.tbotechnology.in/searchrequest/'; //ns1:Response[1]/ns1:GetHotelRoomResult[1]/ns1:RoomCombinations[1]/ns1:RoomCombination[1]/ns1:e[3]/ns1:RoomIndex[1]/ns1:e[1]}",
    "RoomTypeCode": "${BE RoomDetails#ResponseAsXml#declare namespace ns1='http://iapi.tbotechnology.in/searchrequest/'; //ns1:Response[1]/ns1:GetHotelRoomResult[1]/ns1:HotelRoomsDetails[1]/ns1:e[3]/ns1:RoomTypeCode[1]}",
    "RoomTypeName": "${BE RoomDetails#ResponseAsXml#declare namespace ns1='http://iapi.tbotechnology.in/searchrequest/'; //ns1:Response[1]/ns1:GetHotelRoomResult[1]/ns1:HotelRoomsDetails[1]/ns1:e[3]/ns1:RoomTypeName[1]}",
    "RatePlanCode": "${BE RoomDetails#ResponseAsXml#declare namespace ns1='http://iapi.tbotechnology.in/searchrequest/'; //ns1:Response[1]/ns1:GetHotelRoomResult[1]/ns1:HotelRoomsDetails[1]/ns1:e[3]/ns1:RatePlanCode[1]}",
    "BedTypeCode": null,
    "SmokingPreference": 0,
    "Supplements": null,
    "Price": {
    "RoomPrice": "${BE RoomDetails#ResponseAsXml#declare namespace ns1='http://iapi.tbotechnology.in/searchrequest/'; //ns1:Response[1]/ns1:GetHotelRoomResult[1]/ns1:HotelRoomsDetails[1]/ns1:e[3]/ns1:Price[1]/ns1:RoomPrice[1]}",
    "Tax": "${BE RoomDetails#ResponseAsXml#declare namespace ns1='http://iapi.tbotechnology.in/searchrequest/'; //ns1:Response[1]/ns1:GetHotelRoomResult[1]/ns1:HotelRoomsDetails[1]/ns1:e[3]/ns1:Price[1]/ns1:Tax[1]}",
    "ExtraGuestCharge": "${BE RoomDetails#ResponseAsXml#declare namespace ns1='http://iapi.tbotechnology.in/searchrequest/'; //ns1:Response[1]/ns1:GetHotelRoomResult[1]/ns1:HotelRoomsDetails[1]/ns1:e[3]/ns1:Price[1]/ns1:ExtraGuestCharge[1]}",
    "ChildCharge": "${BE RoomDetails#ResponseAsXml#declare namespace ns1='http://iapi.tbotechnology.in/searchrequest/'; //ns1:Response[1]/ns1:GetHotelRoomResult[1]/ns1:HotelRoomsDetails[1]/ns1:e[3]/ns1:Price[1]/ns1:ChildCharge[1]}",
    "OtherCharges": "${BE RoomDetails#ResponseAsXml#declare namespace ns1='http://iapi.tbotechnology.in/searchrequest/'; //ns1:Response[1]/ns1:GetHotelRoomResult[1]/ns1:HotelRoomsDetails[1]/ns1:e[3]/ns1:Price[1]/ns1:OtherCharges[1]}",
    "Discount": "${BE RoomDetails#ResponseAsXml#declare namespace ns1='http://iapi.tbotechnology.in/searchrequest/'; //ns1:Response[1]/ns1:GetHotelRoomResult[1]/ns1:HotelRoomsDetails[1]/ns1:e[3]/ns1:Price[1]/ns1:Discount[1]}",
    "PublishedPrice": "${BE RoomDetails#ResponseAsXml#declare namespace ns1='http://iapi.tbotechnology.in/searchrequest/'; //ns1:Response[1]/ns1:GetHotelRoomResult[1]/ns1:HotelRoomsDetails[1]/ns1:e[3]/ns1:Price[1]/ns1:PublishedPrice[1]}",
    "PublishedPriceRoundedOff": "${BE RoomDetails#ResponseAsXml#declare namespace ns1='http://iapi.tbotechnology.in/searchrequest/'; //ns1:Response[1]/ns1:GetHotelRoomResult[1]/ns1:HotelRoomsDetails[1]/ns1:e[3]/ns1:Price[1]/ns1:OfferedPriceRoundedOff[1]}",
    "OfferedPrice": "${BE RoomDetails#ResponseAsXml#declare namespace ns1='http://iapi.tbotechnology.in/searchrequest/'; //ns1:Response[1]/ns1:GetHotelRoomResult[1]/ns1:HotelRoomsDetails[1]/ns1:e[3]/ns1:Price[1]/ns1:OfferedPrice[1]}",
    "OfferedPriceRoundedOff": "${BE RoomDetails#ResponseAsXml#declare namespace ns1='http://iapi.tbotechnology.in/searchrequest/'; //ns1:Response[1]/ns1:GetHotelRoomResult[1]/ns1:HotelRoomsDetails[1]/ns1:e[3]/ns1:Price[1]/ns1:OfferedPriceRoundedOff[1]}",
    "AgentCommission": "${BE RoomDetails#ResponseAsXml#declare namespace ns1='http://iapi.tbotechnology.in/searchrequest/'; //ns1:Response[1]/ns1:GetHotelRoomResult[1]/ns1:HotelRoomsDetails[1]/ns1:e[3]/ns1:Price[1]/ns1:AgentCommission[1]}",
    "AgentMarkUp": "${BE RoomDetails#ResponseAsXml#declare namespace ns1='http://iapi.tbotechnology.in/searchrequest/'; //ns1:Response[1]/ns1:GetHotelRoomResult[1]/ns1:HotelRoomsDetails[1]/ns1:e[3]/ns1:Price[1]/ns1:AgentMarkUp[1]}",
    "ServiceTax": "${BE RoomDetails#ResponseAsXml#declare namespace ns1='http://iapi.tbotechnology.in/searchrequest/'; //ns1:Response[1]/ns1:GetHotelRoomResult[1]/ns1:HotelRoomsDetails[1]/ns1:e[3]/ns1:Price[1]/ns1:ServiceTax[1]}",
    "TDS": "${BE RoomDetails#ResponseAsXml#declare namespace ns1='http://iapi.tbotechnology.in/searchrequest/'; //ns1:Response[1]/ns1:GetHotelRoomResult[1]/ns1:HotelRoomsDetails[1]/ns1:e[3]/ns1:Price[1]/ns1:TDS[1]}"
    },
    "HotelPassenger": [
    {
    "Title": "mr",
    "Firstname": "Rohit",
    "Middlename": null,
    "Lastname": "Bisariya",
    "Phoneno": null,
    "Email": null,
    "PaxType": 1,
    "LeadPassenger": true,
    "Age": 0,
    "PassportNo": null,
    "PassportIssueDate": null,
    "PassportExpDate": null
    },
    {
    "Title": "mr",
    "Firstname": "Rohit",
    "Middlename": "two",
    "Lastname": "Bisariya",
    "Phoneno": null,
    "Email": null,
    "PaxType": 2,
    "LeadPassenger": false,
    "Age": 12,
    "PassportNo": null,
    "PassportIssueDate": null,
    "PassportExpDate": null
    },
    {
    "Title": "mr",
    "Firstname": "Rohit",
    "Middlename": "two",
    "Lastname": "Bisariya",
    "Phoneno": null,
    "Email": null,
    "PaxType": 2,
    "LeadPassenger": false,
    "Age": 16,
    "PassportNo": null,
    "PassportIssueDate": null,
    "PassportExpDate": null
    }
    ]
    },
    {
    "RoomIndex": "${BE RoomDetails#ResponseAsXml#declare namespace ns1='http://iapi.tbotechnology.in/searchrequest/'; //ns1:Response[1]/ns1:GetHotelRoomResult[1]/ns1:RoomCombinations[1]/ns1:RoomCombination[1]/ns1:e[4]/ns1:RoomIndex[1]/ns1:e[1]}",
    "RoomTypeCode": "${BE RoomDetails#ResponseAsXml#declare namespace ns1='http://iapi.tbotechnology.in/searchrequest/'; //ns1:Response[1]/ns1:GetHotelRoomResult[1]/ns1:HotelRoomsDetails[1]/ns1:e[4]/ns1:RoomTypeCode[1]}",
    "RoomTypeName": "${BE RoomDetails#ResponseAsXml#declare namespace ns1='http://iapi.tbotechnology.in/searchrequest/'; //ns1:Response[1]/ns1:GetHotelRoomResult[1]/ns1:HotelRoomsDetails[1]/ns1:e[4]/ns1:RoomTypeName[1]}",
    "RatePlanCode": "${BE RoomDetails#ResponseAsXml#declare namespace ns1='http://iapi.tbotechnology.in/searchrequest/'; //ns1:Response[1]/ns1:GetHotelRoomResult[1]/ns1:HotelRoomsDetails[1]/ns1:e[4]/ns1:RatePlanCode[1]}",
    "BedTypeCode": null,
    "SmokingPreference": 0,
    "Supplements": null,
    "Price": {
    "RoomPrice": "${BE RoomDetails#ResponseAsXml#declare namespace ns1='http://iapi.tbotechnology.in/searchrequest/'; //ns1:Response[1]/ns1:GetHotelRoomResult[1]/ns1:HotelRoomsDetails[1]/ns1:e[4]/ns1:Price[1]/ns1:RoomPrice[1]}",
    "Tax": "${BE RoomDetails#ResponseAsXml#declare namespace ns1='http://iapi.tbotechnology.in/searchrequest/'; //ns1:Response[1]/ns1:GetHotelRoomResult[1]/ns1:HotelRoomsDetails[1]/ns1:e[4]/ns1:Price[1]/ns1:Tax[1]}",
    "ExtraGuestCharge": "${BE RoomDetails#ResponseAsXml#declare namespace ns1='http://iapi.tbotechnology.in/searchrequest/'; //ns1:Response[1]/ns1:GetHotelRoomResult[1]/ns1:HotelRoomsDetails[1]/ns1:e[4]/ns1:Price[1]/ns1:ExtraGuestCharge[1]}",
    "ChildCharge": "${BE RoomDetails#ResponseAsXml#declare namespace ns1='http://iapi.tbotechnology.in/searchrequest/'; //ns1:Response[1]/ns1:GetHotelRoomResult[1]/ns1:HotelRoomsDetails[1]/ns1:e[4]/ns1:Price[1]/ns1:ChildCharge[1]}",
    "OtherCharges": "${BE RoomDetails#ResponseAsXml#declare namespace ns1='http://iapi.tbotechnology.in/searchrequest/'; //ns1:Response[1]/ns1:GetHotelRoomResult[1]/ns1:HotelRoomsDetails[1]/ns1:e[4]/ns1:Price[1]/ns1:OtherCharges[1]}",
    "Discount": "${BE RoomDetails#ResponseAsXml#declare namespace ns1='http://iapi.tbotechnology.in/searchrequest/'; //ns1:Response[1]/ns1:GetHotelRoomResult[1]/ns1:HotelRoomsDetails[1]/ns1:e[4]/ns1:Price[1]/ns1:Discount[1]}",
    "PublishedPrice": "${BE RoomDetails#ResponseAsXml#declare namespace ns1='http://iapi.tbotechnology.in/searchrequest/'; //ns1:Response[1]/ns1:GetHotelRoomResult[1]/ns1:HotelRoomsDetails[1]/ns1:e[4]/ns1:Price[1]/ns1:PublishedPrice[1]}",
    "PublishedPriceRoundedOff": "${BE RoomDetails#ResponseAsXml#declare namespace ns1='http://iapi.tbotechnology.in/searchrequest/'; //ns1:Response[1]/ns1:GetHotelRoomResult[1]/ns1:HotelRoomsDetails[1]/ns1:e[4]/ns1:Price[1]/ns1:OfferedPriceRoundedOff[1]}",
    "OfferedPrice": "${BE RoomDetails#ResponseAsXml#declare namespace ns1='http://iapi.tbotechnology.in/searchrequest/'; //ns1:Response[1]/ns1:GetHotelRoomResult[1]/ns1:HotelRoomsDetails[1]/ns1:e[4]/ns1:Price[1]/ns1:OfferedPrice[1]}",
    "OfferedPriceRoundedOff": "${BE RoomDetails#ResponseAsXml#declare namespace ns1='http://iapi.tbotechnology.in/searchrequest/'; //ns1:Response[1]/ns1:GetHotelRoomResult[1]/ns1:HotelRoomsDetails[1]/ns1:e[4]/ns1:Price[1]/ns1:OfferedPriceRoundedOff[1]}",
    "AgentCommission": "${BE RoomDetails#ResponseAsXml#declare namespace ns1='http://iapi.tbotechnology.in/searchrequest/'; //ns1:Response[1]/ns1:GetHotelRoomResult[1]/ns1:HotelRoomsDetails[1]/ns1:e[4]/ns1:Price[1]/ns1:AgentCommission[1]}",
    "AgentMarkUp": "${BE RoomDetails#ResponseAsXml#declare namespace ns1='http://iapi.tbotechnology.in/searchrequest/'; //ns1:Response[1]/ns1:GetHotelRoomResult[1]/ns1:HotelRoomsDetails[1]/ns1:e[4]/ns1:Price[1]/ns1:AgentMarkUp[1]}",
    "ServiceTax": "${BE RoomDetails#ResponseAsXml#declare namespace ns1='http://iapi.tbotechnology.in/searchrequest/'; //ns1:Response[1]/ns1:GetHotelRoomResult[1]/ns1:HotelRoomsDetails[1]/ns1:e[4]/ns1:Price[1]/ns1:ServiceTax[1]}",
    "TDS": "${BE RoomDetails#ResponseAsXml#declare namespace ns1='http://iapi.tbotechnology.in/searchrequest/'; //ns1:Response[1]/ns1:GetHotelRoomResult[1]/ns1:HotelRoomsDetails[1]/ns1:e[4]/ns1:Price[1]/ns1:TDS[1]}"
    },
    "HotelPassenger": [
    {
    "Title": "mr",
    "Firstname": "Rohit",
    "Middlename": null,
    "Lastname": "Bisariya",
    "Phoneno": null,
    "Email": null,
    "PaxType": 1,
    "LeadPassenger": true,
    "Age": 0,
    "PassportNo": null,
    "PassportIssueDate": null,
    "PassportExpDate": null
    }
    ]
    }
    ],
    "EndUserIp": "123.1.1.1",
    "TokenId": "${LOGIN (Authenticate)#Response#declare namespace a='SharedServices'; declare namespace ns1='http://tempuri.org/'; //ns1:AuthenticateResponse[1]/ns1:AuthenticateResult[1]/a:TokenId[1]}",
    "ClientId": "nishant",
    "TokenAgencyId": 8428,
    "TokenMemberId": 9611,
    "TraceId": "${BE Request#ResponseAsXml#declare namespace ns1='http://iapi.tbotechnology.in/searchrequest/'; //ns1:Response[1]/ns1:HotelSearchResult[1]/ns1:TraceId[1]}"
    }
  • AmitA's avatar
    AmitA
    Occasional Contributor
    11 years ago
    Hi Team
    Please let me know can we use loops in json request and how?

    For eg in the below json request component instead of e[2] how can I change the value [2] everytime according to the response I am getting from the previous step using loops


    --- "HotelCode": "${BE Request#ResponseAsXml#declare namespace ns1='http://iapi.tbotechnology.in/searchrequest/'; //ns1:Response[1]/ns1:HotelSearchResult[1]/ns1:HotelResults[1]/ns1:e[2]/ns1:HotelCode[1]}",




    {
    "AgencyId": 8428,
    "ResultIndex": 1,
    "HotelCode": "${BE Request#ResponseAsXml#declare namespace ns1='http://iapi.tbotechnology.in/searchrequest/'; //ns1:Response[1]/ns1:HotelSearchResult[1]/ns1:HotelResults[1]/ns1:e[2]/ns1:HotelCode[1]}",
    "HotelName": "${BE Request#ResponseAsXml#declare namespace ns1='http://iapi.tbotechnology.in/searchrequest/'; //ns1:Response[1]/ns1:HotelSearchResult[1]/ns1:HotelResults[1]/ns1:e[1]/ns1:HotelName[1]}",
    "GuestNationality": "IN",
    "NoOfRooms": 4,
    "ClientReferenceNo": 0,
    "HotelRoomsDetails": [
    {
    "RoomIndex": "${BE RoomDetails#ResponseAsXml#declare namespace ns1='http://iapi.tbotechnology.in/searchrequest/'; //ns1:Response[1]/ns1:GetHotelRoomResult[1]/ns1:RoomCombinations[1]/ns1:RoomCombination[1]/ns1:e[3]/ns1:RoomIndex[1]/ns1:e[1]}",
    "RoomTypeCode": "${BE RoomDetails#ResponseAsXml#declare namespace ns1='http://iapi.tbotechnology.in/searchrequest/'; //ns1:Response[1]/ns1:GetHotelRoomResult[1]/ns1:HotelRoomsDetails[1]/ns1:e[3]/ns1:RoomTypeCode[1]}",
    "RoomTypeName": "${BE RoomDetails#ResponseAsXml#declare namespace ns1='http://iapi.tbotechnology.in/searchrequest/'; //ns1:Response[1]/ns1:GetHotelRoomResult[1]/ns1:HotelRoomsDetails[1]/ns1:e[3]/ns1:RoomTypeName[1]}",
    "RatePlanCode": "${BE RoomDetails#ResponseAsXml#declare namespace ns1='http://iapi.tbotechnology.in/searchrequest/'; //ns1:Response[1]/ns1:GetHotelRoomResult[1]/ns1:HotelRoomsDetails[1]/ns1:e[3]/ns1:RatePlanCode[1]}",
    "BedTypeCode": null,
    "SmokingPreference": 0,
    "Supplements": null,
    "Price": {
    "RoomPrice": "${BE RoomDetails#ResponseAsXml#declare namespace ns1='http://iapi.tbotechnology.in/searchrequest/'; //ns1:Response[1]/ns1:GetHotelRoomResult[1]/ns1:HotelRoomsDetails[1]/ns1:e[3]/ns1:Price[1]/ns1:RoomPrice[1]}",
    "Tax": "${BE RoomDetails#ResponseAsXml#declare namespace ns1='http://iapi.tbotechnology.in/searchrequest/'; //ns1:Response[1]/ns1:GetHotelRoomResult[1]/ns1:HotelRoomsDetails[1]/ns1:e[3]/ns1:Price[1]/ns1:Tax[1]}",
    "ExtraGuestCharge": "${BE RoomDetails#ResponseAsXml#declare namespace ns1='http://iapi.tbotechnology.in/searchrequest/'; //ns1:Response[1]/ns1:GetHotelRoomResult[1]/ns1:HotelRoomsDetails[1]/ns1:e[3]/ns1:Price[1]/ns1:ExtraGuestCharge[1]}",
    "ChildCharge": "${BE RoomDetails#ResponseAsXml#declare namespace ns1='http://iapi.tbotechnology.in/searchrequest/'; //ns1:Response[1]/ns1:GetHotelRoomResult[1]/ns1:HotelRoomsDetails[1]/ns1:e[3]/ns1:Price[1]/ns1:ChildCharge[1]}",
    "OtherCharges": "${BE RoomDetails#ResponseAsXml#declare namespace ns1='http://iapi.tbotechnology.in/searchrequest/'; //ns1:Response[1]/ns1:GetHotelRoomResult[1]/ns1:HotelRoomsDetails[1]/ns1:e[3]/ns1:Price[1]/ns1:OtherCharges[1]}",
    "Discount": "${BE RoomDetails#ResponseAsXml#declare namespace ns1='http://iapi.tbotechnology.in/searchrequest/'; //ns1:Response[1]/ns1:GetHotelRoomResult[1]/ns1:HotelRoomsDetails[1]/ns1:e[3]/ns1:Price[1]/ns1:Discount[1]}",
    "PublishedPrice": "${BE RoomDetails#ResponseAsXml#declare namespace ns1='http://iapi.tbotechnology.in/searchrequest/'; //ns1:Response[1]/ns1:GetHotelRoomResult[1]/ns1:HotelRoomsDetails[1]/ns1:e[3]/ns1:Price[1]/ns1:PublishedPrice[1]}",
    "PublishedPriceRoundedOff": "${BE RoomDetails#ResponseAsXml#declare namespace ns1='http://iapi.tbotechnology.in/searchrequest/'; //ns1:Response[1]/ns1:GetHotelRoomResult[1]/ns1:HotelRoomsDetails[1]/ns1:e[3]/ns1:Price[1]/ns1:OfferedPriceRoundedOff[1]}",
    "OfferedPrice": "${BE RoomDetails#ResponseAsXml#declare namespace ns1='http://iapi.tbotechnology.in/searchrequest/'; //ns1:Response[1]/ns1:GetHotelRoomResult[1]/ns1:HotelRoomsDetails[1]/ns1:e[3]/ns1:Price[1]/ns1:OfferedPrice[1]}",
    "OfferedPriceRoundedOff": "${BE RoomDetails#ResponseAsXml#declare namespace ns1='http://iapi.tbotechnology.in/searchrequest/'; //ns1:Response[1]/ns1:GetHotelRoomResult[1]/ns1:HotelRoomsDetails[1]/ns1:e[3]/ns1:Price[1]/ns1:OfferedPriceRoundedOff[1]}",
    "AgentCommission": "${BE RoomDetails#ResponseAsXml#declare namespace ns1='http://iapi.tbotechnology.in/searchrequest/'; //ns1:Response[1]/ns1:GetHotelRoomResult[1]/ns1:HotelRoomsDetails[1]/ns1:e[3]/ns1:Price[1]/ns1:AgentCommission[1]}",
    "AgentMarkUp": "${BE RoomDetails#ResponseAsXml#declare namespace ns1='http://iapi.tbotechnology.in/searchrequest/'; //ns1:Response[1]/ns1:GetHotelRoomResult[1]/ns1:HotelRoomsDetails[1]/ns1:e[3]/ns1:Price[1]/ns1:AgentMarkUp[1]}",
    "ServiceTax": "${BE RoomDetails#ResponseAsXml#declare namespace ns1='http://iapi.tbotechnology.in/searchrequest/'; //ns1:Response[1]/ns1:GetHotelRoomResult[1]/ns1:HotelRoomsDetails[1]/ns1:e[3]/ns1:Price[1]/ns1:ServiceTax[1]}",
    "TDS": "${BE RoomDetails#ResponseAsXml#declare namespace ns1='http://iapi.tbotechnology.in/searchrequest/'; //ns1:Response[1]/ns1:GetHotelRoomResult[1]/ns1:HotelRoomsDetails[1]/ns1:e[3]/ns1:Price[1]/ns1:TDS[1]}"
    },
    "HotelPassenger": [
    {
    "Title": "mr",
    "Firstname": "Rohit",
    "Middlename": null,
    "Lastname": "Bisariya",
    "Phoneno": null,
    "Email": null,
    "PaxType": 1,
    "LeadPassenger": true,
    "Age": 0,
    "PassportNo": null,
    "PassportIssueDate": null,
    "PassportExpDate": null
    },
    {
    "Title": "mr",
    "Firstname": "Rohit",
    "Middlename": "two",
    "Lastname": "Bisariya",
    "Phoneno": null,
    "Email": null,
    "PaxType": 2,
    "LeadPassenger": false,
    "Age": 12,
    "PassportNo": null,
    "PassportIssueDate": null,
    "PassportExpDate": null
    },
    {
    "Title": "mr",
    "Firstname": "Rohit",
    "Middlename": "two",
    "Lastname": "Bisariya",
    "Phoneno": null,
    "Email": null,
    "PaxType": 2,
    "LeadPassenger": false,
    "Age": 16,
    "PassportNo": null,
    "PassportIssueDate": null,
    "PassportExpDate": null
    }
    ]
    },
    {
    "RoomIndex": "${BE RoomDetails#ResponseAsXml#declare namespace ns1='http://iapi.tbotechnology.in/searchrequest/'; //ns1:Response[1]/ns1:GetHotelRoomResult[1]/ns1:RoomCombinations[1]/ns1:RoomCombination[1]/ns1:e[4]/ns1:RoomIndex[1]/ns1:e[1]}",
    "RoomTypeCode": "${BE RoomDetails#ResponseAsXml#declare namespace ns1='http://iapi.tbotechnology.in/searchrequest/'; //ns1:Response[1]/ns1:GetHotelRoomResult[1]/ns1:HotelRoomsDetails[1]/ns1:e[4]/ns1:RoomTypeCode[1]}",
    "RoomTypeName": "${BE RoomDetails#ResponseAsXml#declare namespace ns1='http://iapi.tbotechnology.in/searchrequest/'; //ns1:Response[1]/ns1:GetHotelRoomResult[1]/ns1:HotelRoomsDetails[1]/ns1:e[4]/ns1:RoomTypeName[1]}",
    "RatePlanCode": "${BE RoomDetails#ResponseAsXml#declare namespace ns1='http://iapi.tbotechnology.in/searchrequest/'; //ns1:Response[1]/ns1:GetHotelRoomResult[1]/ns1:HotelRoomsDetails[1]/ns1:e[4]/ns1:RatePlanCode[1]}",
    "BedTypeCode": null,
    "SmokingPreference": 0,
    "Supplements": null,
    "Price": {
    "RoomPrice": "${BE RoomDetails#ResponseAsXml#declare namespace ns1='http://iapi.tbotechnology.in/searchrequest/'; //ns1:Response[1]/ns1:GetHotelRoomResult[1]/ns1:HotelRoomsDetails[1]/ns1:e[4]/ns1:Price[1]/ns1:RoomPrice[1]}",
    "Tax": "${BE RoomDetails#ResponseAsXml#declare namespace ns1='http://iapi.tbotechnology.in/searchrequest/'; //ns1:Response[1]/ns1:GetHotelRoomResult[1]/ns1:HotelRoomsDetails[1]/ns1:e[4]/ns1:Price[1]/ns1:Tax[1]}",
    "ExtraGuestCharge": "${BE RoomDetails#ResponseAsXml#declare namespace ns1='http://iapi.tbotechnology.in/searchrequest/'; //ns1:Response[1]/ns1:GetHotelRoomResult[1]/ns1:HotelRoomsDetails[1]/ns1:e[4]/ns1:Price[1]/ns1:ExtraGuestCharge[1]}",
    "ChildCharge": "${BE RoomDetails#ResponseAsXml#declare namespace ns1='http://iapi.tbotechnology.in/searchrequest/'; //ns1:Response[1]/ns1:GetHotelRoomResult[1]/ns1:HotelRoomsDetails[1]/ns1:e[4]/ns1:Price[1]/ns1:ChildCharge[1]}",
    "OtherCharges": "${BE RoomDetails#ResponseAsXml#declare namespace ns1='http://iapi.tbotechnology.in/searchrequest/'; //ns1:Response[1]/ns1:GetHotelRoomResult[1]/ns1:HotelRoomsDetails[1]/ns1:e[4]/ns1:Price[1]/ns1:OtherCharges[1]}",
    "Discount": "${BE RoomDetails#ResponseAsXml#declare namespace ns1='http://iapi.tbotechnology.in/searchrequest/'; //ns1:Response[1]/ns1:GetHotelRoomResult[1]/ns1:HotelRoomsDetails[1]/ns1:e[4]/ns1:Price[1]/ns1:Discount[1]}",
    "PublishedPrice": "${BE RoomDetails#ResponseAsXml#declare namespace ns1='http://iapi.tbotechnology.in/searchrequest/'; //ns1:Response[1]/ns1:GetHotelRoomResult[1]/ns1:HotelRoomsDetails[1]/ns1:e[4]/ns1:Price[1]/ns1:PublishedPrice[1]}",
    "PublishedPriceRoundedOff": "${BE RoomDetails#ResponseAsXml#declare namespace ns1='http://iapi.tbotechnology.in/searchrequest/'; //ns1:Response[1]/ns1:GetHotelRoomResult[1]/ns1:HotelRoomsDetails[1]/ns1:e[4]/ns1:Price[1]/ns1:OfferedPriceRoundedOff[1]}",
    "OfferedPrice": "${BE RoomDetails#ResponseAsXml#declare namespace ns1='http://iapi.tbotechnology.in/searchrequest/'; //ns1:Response[1]/ns1:GetHotelRoomResult[1]/ns1:HotelRoomsDetails[1]/ns1:e[4]/ns1:Price[1]/ns1:OfferedPrice[1]}",
    "OfferedPriceRoundedOff": "${BE RoomDetails#ResponseAsXml#declare namespace ns1='http://iapi.tbotechnology.in/searchrequest/'; //ns1:Response[1]/ns1:GetHotelRoomResult[1]/ns1:HotelRoomsDetails[1]/ns1:e[4]/ns1:Price[1]/ns1:OfferedPriceRoundedOff[1]}",
    "AgentCommission": "${BE RoomDetails#ResponseAsXml#declare namespace ns1='http://iapi.tbotechnology.in/searchrequest/'; //ns1:Response[1]/ns1:GetHotelRoomResult[1]/ns1:HotelRoomsDetails[1]/ns1:e[4]/ns1:Price[1]/ns1:AgentCommission[1]}",
    "AgentMarkUp": "${BE RoomDetails#ResponseAsXml#declare namespace ns1='http://iapi.tbotechnology.in/searchrequest/'; //ns1:Response[1]/ns1:GetHotelRoomResult[1]/ns1:HotelRoomsDetails[1]/ns1:e[4]/ns1:Price[1]/ns1:AgentMarkUp[1]}",
    "ServiceTax": "${BE RoomDetails#ResponseAsXml#declare namespace ns1='http://iapi.tbotechnology.in/searchrequest/'; //ns1:Response[1]/ns1:GetHotelRoomResult[1]/ns1:HotelRoomsDetails[1]/ns1:e[4]/ns1:Price[1]/ns1:ServiceTax[1]}",
    "TDS": "${BE RoomDetails#ResponseAsXml#declare namespace ns1='http://iapi.tbotechnology.in/searchrequest/'; //ns1:Response[1]/ns1:GetHotelRoomResult[1]/ns1:HotelRoomsDetails[1]/ns1:e[4]/ns1:Price[1]/ns1:TDS[1]}"
    },
    "HotelPassenger": [
    {
    "Title": "mr",
    "Firstname": "Rohit",
    "Middlename": null,
    "Lastname": "Bisariya",
    "Phoneno": null,
    "Email": null,
    "PaxType": 1,
    "LeadPassenger": true,
    "Age": 0,
    "PassportNo": null,
    "PassportIssueDate": null,
    "PassportExpDate": null
    }
    ]
    }
    ],
    "EndUserIp": "123.1.1.1",
    "TokenId": "${LOGIN (Authenticate)#Response#declare namespace a='SharedServices'; declare namespace ns1='http://tempuri.org/'; //ns1:AuthenticateResponse[1]/ns1:AuthenticateResult[1]/a:TokenId[1]}",
    "ClientId": "nishant",
    "TokenAgencyId": 8428,
    "TokenMemberId": 9611,
    "TraceId": "${BE Request#ResponseAsXml#declare namespace ns1='http://iapi.tbotechnology.in/searchrequest/'; //ns1:Response[1]/ns1:HotelSearchResult[1]/ns1:TraceId[1]}"
    }
  • AmitA's avatar
    AmitA
    Occasional Contributor
    11 years ago
    Hi Team

    In Xpath I am using 'count' to count the nodes like in the below example I am counting number of HotelStay.Please tell me how to count the same in jsonpath.I want to count the CancellationPolicies given below

    Xpath:
    def UAPIResultCount = context.expand( '${#TestCase#UAPIXML#declare namespace ns1=\'UniversalAirAPI\';count(//OTA_HotelAvailRS[1]/HotelStays[1]/HotelStay)}' )

    Json path:
    def Cancellationpolicy = context.expand( '${BlockRoomFixedBE#Response#$.BlockRoomResult.HotelRoomsDetails[0].CancellationPolicies[1]}' )
  • SmartBear_Suppo's avatar
    SmartBear_Suppo
    Icon for Alumni rankAlumni
    11 years ago
    Hi,

    Siking has responded to another post which is the same question as this one viewtopic.php?f=2&t=25166. If that answer is sufficient enough then I will mark this and that post as resolved. If not then please let us know.


    Regards,
    Marcus
    SmartBear Support