Xml to Json
Options
![Dmitry](https://us.v-cdn.net/6037124/user_avatars/4262521.jpg)
Dmitry
Member ✭
Hey!
The external API returns the response to the request in xml format.
Is it possible in Xano to convert xml to Json or parse xml? The xml_decoder filter could not solve the problem.
Returned xml example:
<?xml version="1.0"?> <ReservationAbodeTable xmlns="urn:schemas-som-ru:tws-reservationAbodeTable" CurrencyISOCode="RUR" SearchToken="OQd8N6zdvEeINqfoFmezodZ9ftnTBodCnHYccOuBM5M="><OfferList><Offer TourID="TU8" RoomCategoryID="RC130327" RoomPlacingID="RP1" PacketID="AP26035" HotelOptionID="HO39193"><VisitList><Visit Line="GLeXLwoC5gcFCQsPCAAAAAQAAQAHABQAFAABALJjAQAAAAAAF/0BAAsAAACXrgAAna4AALNlAAA=" Amount="7" Begin="2022-05-16T14:00:00" End="2022-05-23T12:00:00" Confirm="true" Quantity="1" Cost="11200.0000"/></VisitList></Offer><Offer TourID="TU8" RoomCategoryID="RC130329" RoomPlacingID="RP1" PacketID="AP26035" HotelOptionID="HO39193"><VisitList><Visit Line="+LeXLwoC5gcFCQsPCAAAAAQAAQAHABQAFAABALJjAQAAAAAAGf0BAAsAAACXrgAAna4AALNlAAA=" Amount="7" Begin="2022-05-16T14:00:00" End="2022-05-23T12:00:00" Confirm="true" Quantity="1" Cost="14000.0000"/></VisitList></Offer><Offer TourID="TU8" RoomCategoryID="RC130334" RoomPlacingID="RP1" PacketID="AP26035" HotelOptionID="HO39193"><VisitList><Visit Line="iLeXLwoC5gcFCQsPCAAAAAQAAQAHABQAFAABALJjAQAAAAAAHv0BAAsAAACXrgAAna4AALNlAAA=" Amount="7" Begin="2022-05-16T14:00:00" End="2022-05-23T12:00:00" Confirm="true" Quantity="2" Cost="15400.0000"/></VisitList></Offer><Offer TourID="TU8" RoomCategoryID="RC130336" RoomPlacingID="RP2" PacketID="AP26035" HotelOptionID="HO39193"><VisitList><Visit Line="aLQ3KQoC5gcFCQsPCAAAAAQAAQAHABQAFAABALJjAQAAAAAAIP0BAGEAAACXrgAAna4AALNlAAA=" Amount="7" Begin="2022-05-16T14:00:00" End="2022-05-23T12:00:00" Confirm="true" Quantity="2" Cost="14699.9300"/></VisitList></Offer><Offer TourID="TU8" RoomCategoryID="RC130337" RoomPlacingID="RP2" PacketID="AP26035" HotelOptionID="HO39193"><VisitList><Visit Line="eLQ3KQoC5gcFCQsPCAAAAAQAAQAHABQAFAABALJjAQAAAAAAIf0BAGEAAACXrgAAna4AALNlAAA=" Amount="7" Begin="2022-05-16T14:00:00" End="2022-05-23T12:00:00" Confirm="true" Quantity="6" Cost="16100.0000"/></VisitList></Offer></OfferList><TourList><Tour TourID="TU8" ShortName="Геленджик" Name="Геленджик"/></TourList><HotelList><Hotel HotelID="H38169" ShortName="Афины" Name="Афины"/></HotelList><HotelOptionList><HotelOption HotelOptionID="HO39193" InitialAge="0"/></HotelOptionList><RoomCategoryList><RoomCategory RoomCategoryID="RC130327" HotelID="H38169" RoomCategory="130327" RoomTypeShortName="Стандарт" RoomTypeName="Стандарт" ShortName="4-местный без балкона" Name="4-местный без балкона"/><RoomCategory RoomCategoryID="RC130329" HotelID="H38169" RoomCategory="130329" RoomTypeShortName="Стандарт" RoomTypeName="Стандарт" ShortName="4-местный общ.балк" Name="4-местный с выходом на общий балкон"/><RoomCategory RoomCategoryID="RC130334" HotelID="H38169" RoomCategory="130334" RoomTypeShortName="Стандарт" RoomTypeName="Стандарт" ShortName="4-местный 2-комнатный" Name="4-местный 2-комнатный с балконом и мини-кухней"/><RoomCategory RoomCategoryID="RC130336" HotelID="H38169" RoomCategory="130336" RoomTypeShortName="Стандарт" RoomTypeName="Стандарт" ShortName="3-местный с балк ВнГ" Name="3-местный с балконом и видом на горы и город"/><RoomCategory RoomCategoryID="RC130337" HotelID="H38169" RoomCategory="130337" RoomTypeShortName="Стандарт" RoomTypeName="Стандарт" ShortName="3-местный с балк ВнМ" Name="3-местный с балконом и видом на море"/></RoomCategoryList><RoomPlacingList><RoomPlacing RoomPlacingID="RP1" RoomPlacingName="4взрослых" RoomPlacing="11"><RoomTouristPlacing TouristTypeID="TT1" PlaceKind="BASE" Quantity="4"/></RoomPlacing><RoomPlacing RoomPlacingID="RP2" RoomPlacingName="3 взрослых+1 взрослый на дополнительное место" RoomPlacing="97"><RoomTouristPlacing TouristTypeID="TT1" PlaceKind="BASE" Quantity="3"/><RoomTouristPlacing TouristTypeID="TT1" PlaceKind="EXT" Quantity="1"/></RoomPlacing></RoomPlacingList><PacketList><Packet PacketID="AP26035" Packet="26035" Name="Афины (проживание)"/></PacketList><TouristTypeList><TouristType TouristTypeID="TT1" TouristType="1" TouristTypeName="Взрослый"/></TouristTypeList></ReservationAbodeTable>
Comments
-
- would probably need you to show us why it's not solving your problem in Office hours. Please sign up for an upcoming one if you are available - https://calendly.com/xano/officehours
-
Categories
- All Categories
- 53 ? Announcements
- 47 ? Releases
- 37 ? Welcome
- 983 ? Help! I'm a Noob
- 125 ? No-Code Front-Ends
- 633 ? Working with APIs
- 439 ? Transforming data
- 126 ? Connect Xano to ...
- 50 ?? Find an Expert
- 348 ❓Other questions
- 35 ? Security
- 22 ✂️ Snippets
- 19 ? Showcase
- 7 ?️ Xano Chatter
- 62 ? Video Tutorials
- 171 ? Request a feature
- 229 ? Report a Bug
- 19 ? Templates & Extensions
- 7 ? Feedback