travelport API giving response in this form how to parse this data

Asked Jul 20 '17 at 11:05

Active Mar 18 '20 at 14:05

Viewed 257 times

0

Travelport API giving response in this form how to parse this data from soapxml as it is using namespaces. Travelport API giving response in this form. How to parse this data from soapxml as it is using namespaces. ?

  <?xml version="1.0"?>
  <SOAP:Envelope xmlns:SOAP="http://schemas.xmlsoap.org/soap/envelope/">
  <SOAP:Body>
<air:AvailabilitySearchRsp 
xmlns:air="http://www.travelport.com/schema/air_v29_0" 
xmlns:common_v29_0="http://www.travelport.com/schema/common_v29_0" 
TraceId="trace" TransactionId="5EF374190A076478623DB8BB3DCEE30E" 
ResponseTime="801" DistanceUnits="MI">
<air:FlightDetailsList>
  <air:FlightDetails Key="V7EqB14R2BKADHj4FAAAAA==" Origin="LGW" 
   Destination="EDI" DepartureTime="2017-07-30T19:15:00.000+01:00" 
   ArrivalTime="2017-07-30T20:45:00.000+01:00" FlightTime="90" 
   TravelTime="90" OriginTerminal="North Terminal"/>
   <air:FlightDetails Key="V7EqB14R2BKAGHj4FAAAAA==" Origin="LGW" 
   Destination="EDI" DepartureTime="2017-07-30T20:55:00.000+01:00"  
   ArrivalTime="2017-07-30T22:25:00.000+01:00" FlightTime="90" 
   TravelTime="90" OriginTerminal="North Terminal"/>
   <air:FlightDetails Key="V7EqB14R2BKAJHj4FAAAAA==" Origin="LGW" 
    Destination="EDI" DepartureTime="2017-07-30T13:35:00.000+01:00" 
    ArrivalTime="2017-07-30T15:10:00.000+01:00" FlightTime="95" 
    TravelTime="95" OriginTerminal="North Terminal"/>
    <air:FlightDetails Key="V7EqB14R2BKAMHj4FAAAAA==" Origin="LGW" 
    Destination="EDI" DepartureTime="2017-07-30T15:50:00.000+01:00" 
    ArrivalTime="2017-07-30T17:25:00.000+01:00" FlightTime="95" 
    TravelTime="95" OriginTerminal="North Terminal"/>
  </air:FlightDetailsList>
 </air:AvailabilitySearchRsp>
</SOAP:Body>
</SOAP:Envelope>

edited Mar 18 '20 at 14:05

gavenkoa

45,285
19
251
303

asked Jul 20 '17 at 11:05

Muhammad Ali

1

1

Possible duplicate of [How to parse SOAP XML?](https://stackoverflow.com/questions/4194489/how-to-parse-soap-xml) – toing_toing Jul 20 '17 at 11:16
Hey how did you achieved that? – Durgesh Kumar Feb 20 '23 at 13:36

1 Answers1

1

Hi you can use library to convert xml to array. Below is one such library url. http://www.lalit.org/lab/convert-xml-to-array-in-php-xml2array/

It'll convert you xml to below array format. Which you can parse easily.

Array ( [SOAP:Envelope] => Array ( [SOAP:Body] => Array ( [air:AvailabilitySearchRsp] => Array ( [air:FlightDetailsList] => Array ( [air:FlightDetails] => Array ( [0] => Array ( [@value] => [@attributes] => Array ( [Key] => V7EqB14R2BKADHj4FAAAAA== [Origin] => LGW [Destination] => EDI [DepartureTime] => 2017-07-30T19:15:00.000+01:00 [ArrivalTime] => 2017-07-30T20:45:00.000+01:00 [FlightTime] => 90 [TravelTime] => 90 [OriginTerminal] => North Terminal )

                                            )

                                        [1] => Array
                                            (
                                                [@value] => 
                                                [@attributes] => Array
                                                    (
                                                        [Key] => V7EqB14R2BKAGHj4FAAAAA==
                                                        [Origin] => LGW
                                                        [Destination] => EDI
                                                        [DepartureTime] => 2017-07-30T20:55:00.000+01:00
                                                        [ArrivalTime] => 2017-07-30T22:25:00.000+01:00
                                                        [FlightTime] => 90
                                                        [TravelTime] => 90
                                                        [OriginTerminal] => North Terminal
                                                    )

                                            )

                                        [2] => Array
                                            (
                                                [@value] => 
                                                [@attributes] => Array
                                                    (
                                                        [Key] => V7EqB14R2BKAJHj4FAAAAA==
                                                        [Origin] => LGW
                                                        [Destination] => EDI
                                                        [DepartureTime] => 2017-07-30T13:35:00.000+01:00
                                                        [ArrivalTime] => 2017-07-30T15:10:00.000+01:00
                                                        [FlightTime] => 95
                                                        [TravelTime] => 95
                                                        [OriginTerminal] => North Terminal
                                                    )

                                            )

                                        [3] => Array
                                            (
                                                [@value] => 
                                                [@attributes] => Array
                                                    (
                                                        [Key] => V7EqB14R2BKAMHj4FAAAAA==
                                                        [Origin] => LGW
                                                        [Destination] => EDI
                                                        [DepartureTime] => 2017-07-30T15:50:00.000+01:00
                                                        [ArrivalTime] => 2017-07-30T17:25:00.000+01:00
                                                        [FlightTime] => 95
                                                        [TravelTime] => 95
                                                        [OriginTerminal] => North Terminal
                                                    )

                                            )

                                    )

                            )

                        [@attributes] => Array
                            (
                                [TraceId] => trace
                                [TransactionId] => 5EF374190A076478623DB8BB3DCEE30E
                                [ResponseTime] => 801
                                [DistanceUnits] => MI
                            )

                    )

            )

    )

)

answered Jul 27 '17 at 07:49

Himani

61
5