Skip to main content
V
vickyr583585
Known Participant
February 11, 2025
Solved

Converting an XML Response to Appian values

  • February 11, 2025
  • 10 replies
  • 0 views

In integration if the response is in xml format, how to convert it to appian value and save in a record type

Best answer by stefanhelzle0001

The documentation already includes small examples. And then, you will have to learn the xPath basics. In the past, I used these tutorials

www.w3schools.com/.../xpath_intro.asp

10 replies

mathieud0001
mathieud0001
February 11, 2025

You could try using:  [mention:d818ca2af193461781ce152b9f28f040:f7d226abd59f475c9d224a79e3f0ec07] 

Otherwise, you just parse the XML manually and create your Record Type.

V
vickyr583585Author
Known Participant
February 11, 2025

How to do it manually

mathieud0001
mathieud0001
February 11, 2025

Here is a quick example:

a!localVariables(
  local!xml: ri!xml,
  local!device: extract(local!xml, "", ""),
  local!brand: extract(local!xml, "", ""),
  local!price: extract(local!xml, "", ""),
  {
    device: local!device,
    brand: local!brand,
    price: local!price
  }
)

stefanhelzle0001
stefanhelzle0001
February 11, 2025

If the data object is not too large, I use xpathsnippet() to fetch individual values, when mapping to my internal record type.

V
vickyr583585Author
Known Participant
June 12, 2025

"100Response returned successfully955TESLA, INC.TeslaUNITED STATES (USA)Passenger CartrueTruckfalseMultipurpose Passenger Vehicle (MPV)false956ASTON MARTIN LAGONDA LIMITEDAston MartinUNITED KINGDOM (UK)Passenger CarfalseMultipurpose Passenger Vehicle (MPV)false957BMW OF NORTH AMERICA, LLCBMWUNITED STATES (USA)958JAGUAR LAND ROVER NA, LLCJaguar Land RoverUNITED STATES (USA)Passenger CartrueTruckfalseMultipurpose Passenger Vehicle (MPV)false959MASERATI NORTH AMERICA, INC.MesaratiUNITED STATES (USA)Passenger CarfalseMultipurpose Passenger Vehicle (MPV)true960ROLLS ROYCE MOTOR CARSRolls RoyceUNITED STATES (USA)961BUELL MOTORCYCLE CO.BuellUNITED STATES (USA)Motorcycletrue962TOYOTA MOTOR NORTH AMERICA, INCToyotaUNITED STATES (USA)964MERCEDES-BENZ USA, LLC (SPRINTER)Mercedes-Benz SprinterUNITED STATES (USA)965FULMER FABRICATIONSUNITED STATES (USA)Motorcyclefalse966BMW AGBMWGERMANY967BMW M GMBHBMWGERMANYPassenger Cartrue968BMW MANUFACTURER CORPORATION / BMW NORTH AMERICABMWUNITED STATES (USA)Passenger Cartrue969MOTORCYCLE MACHINE SHOP SERVICES, LLCMotorcycle Machine Shop ServicesUNITED STATES (USA)970BUGATTI AUTOMOBILES S.A.S.BugattiFRANCEPassenger Cartrue971HOMBILT TRAILERS INCHombiltUNITED STATES (USA)Trailerfalse972BMW AG MOTORCYCLESBMW Motorrad (Motorcycles)GERMANY973AMERICAN CUSTOM GOLF CARS, INCACGUNITED STATES (USA)Low Speed Vehicle (LSV)trueOff Road Vehiclefalse974MOONLIGHT AUTOUNITED STATES (USA)Motorcyclefalse975COOPER CYCLESCooper CyclesUNITED STATES (USA)976FORD MOTOR COMPANYFordUNITED STATES (USA)Passenger CarfalseTruckfalseBusfalseMultipurpose Passenger Vehicle (MPV)trueIncomplete Vehiclefalse977FORD MOTOR COMPANY OF CANADA, LTD.FordCANADA978AUTO ALLIANCE INTERNATIONAL, USAAuto AllianceUNITED STATES (USA)979FORD MOTOR COMPANY, MEXICOFordMEXICO980LATITUDE CAMPER COMPANY, LLCLatitudeUNITED STATES (USA)Trailerfalse981COUNTRY COACH CORPORATIONUNITED STATES (USA)Multipurpose Passenger Vehicle (MPV)false982WESTWARD INDUSTRIES LTD.WestwardCANADAMotorcyclefalse983LOTUS CARS LIMITEDLotusUNITED KINGDOM (UK)Passenger Cartrue984GENERAL MOTORS LLCGeneral MotorsUNITED STATES (USA)Passenger CarfalseTruckfalseBusfalseMultipurpose Passenger Vehicle (MPV)falseIncomplete Vehicletrue985BLUE DIAMOND TRUCK, S. DE R. L. DE C. V.Blue DiamondMEXICOIncomplete Vehiclefalse986FORD OTOMOTIV SANAYI A.S., TURKEYFordTURKEY987HONDA MOTOR CO., LTD.HondaJAPANMotorcyclefalsePassenger CarfalseMultipurpose Passenger Vehicle (MPV)false988AMERICAN HONDA MOTOR CO., INC.HondaUNITED STATES (USA)Passenger CartrueTruckfalseMultipurpose Passenger Vehicle (MPV)false990HONDA OF CANADA MFG., A DIVISION OF HONDA CANADA INC.HondaCANADAPassenger CarfalseTruckfalseMultipurpose Passenger Vehicle (MPV)false991HONDA OF THE U.K. MFG., LTD.HondaUNITED KINGDOM (UK)Passenger CarfalseMultipurpose Passenger Vehicle (MPV)false992HONDA DE MEXICO, S.A. DE C.V.MEXICOMotorcyclefalsePassenger CarfalseMultipurpose Passenger Vehicle (MPV)false994FCA US LLCChryslerUNITED STATES (USA)Passenger CarfalseMultipurpose Passenger Vehicle (MPV)trueIncomplete Vehiclefalse995FCA CANADA INC.ChryslerCANADA996NISSAN MOTOR COMPANY, LTDNissanJAPANPassenger CarfalseTruckfalseMultipurpose Passenger Vehicle (MPV)falseIncomplete Vehiclefalse997NISSAN NORTH AMERICA, INC.NissanUNITED STATES (USA)Passenger CarfalseTruckfalseBusfalseMultipurpose Passenger Vehicle (MPV)false998QUEST MANUFACTURINGQuest ManufacturingCANADA999NISSAN MEXICANA, S.A. DE C.V.NissanMEXICO1000RENAULT SAMSUNG MOTORS CO., LTDRenault SamsungSOUTH KOREA1001RENAULT GROUPRenaultFRANCE1002CHRYSLER DE MEXICO TOLUCAChryslerMEXICO1003CLUB CAR LLC.Club CarUNITED STATES (USA)Low Speed Vehicle (LSV)false1006VOLVO CAR USA, LLCVolvoUNITED STATES (USA)Passenger CarfalseMultipurpose Passenger Vehicle (MPV)true1011ZHEJIANG GEELY HOLDING GROUP CO.,LTDGeelyCHINA1014GOLF CARS OF ARIZONAGolf Cars of ArizonaUNITED STATES (USA)Low Speed Vehicle (LSV)false1015VOLVO GROUP NORTH AMERICA, LLCVolvo (Truck / Bus)UNITED STATES (USA)TrucktrueBusfalse1023MERCEDES-BENZ, AGMercedes-BenzGERMANYPassenger CartrueMultipurpose Passenger Vehicle (MPV)false1024DAIMLER TRUCK NORTH AMERICA LLCDTNAUNITED STATES (USA)TrucktrueIncomplete Vehiclefalse1025FREIGHTLINER CUSTOM CHASSIS CORP.UNITED STATES (USA)Incomplete Vehicletrue1026COACHWORKS HOLDINGS INCCoachworksUNITED STATES (USA)1027MACK TRUCKS INC.Mack TrucksUNITED STATES (USA)TrucktrueIncomplete Vehiclefalse1028INTERNATIONAL MOTORS, LLCUNITED STATES (USA)TruckfalseIncomplete Vehiclefalse1029FCA ITALY S.P.A.FiatITALYPassenger CartrueTruckfalseMultipurpose Passenger Vehicle (MPV)false1030CHAIRIOT MOBILITY INCChairiot MobilityUNITED STATES (USA)Low Speed Vehicle (LSV)true1031PACCAR INC.PACCARUNITED STATES (USA)Trucktrue1032KENWORTH TRUCK COMPANYKenworthUNITED STATES (USA)1033PETERBILT MOTORS COMPANYPeterbiltUNITED STATES (USA)1034HYUNDAI-KIA AMERICA TECHNICAL CENTER INC (HATCI)Hyundai-KiaUNITED STATES (USA)Passenger CartrueTruckfalseMultipurpose Passenger Vehicle (MPV)false1035MAD DAWG CYCLES AND TRAILERSUNITED STATES (USA)MotorcyclefalseTrailerfalse1038MILLS MANUFACTURING INCMills ManufacturingUNITED STATES (USA)1040HAYES WELDING INCUNITED STATES (USA)Trailerfalse1041MAZDA MOTOR CORPORATIONMazdaJAPANPassenger CarfalseMultipurpose Passenger Vehicle (MPV)true1042MERCEDES-BENZ CARSMercedes-BenzGERMANY1043MERCEDES-BENZ OF NORTH AMERICA, INC.Mercedes-BenzUNITED STATES (USA)Passenger Carfalse1044BLUE BIRD BODY COMPANYUNITED STATES (USA)BustrueMultipurpose Passenger Vehicle (MPV)false1045OPTIMA BUS CORPOptimaUNITED STATES (USA)1047NORTH AMERICAN BUS INDUSTRIES INC., LLCNABIUNITED STATES (USA)1048SUZUKI MOTOR OF AMERICA, INCSuzukiUNITED STATES (USA)Motorcycletrue1050E-ONE, INC.UNITED STATES (USA)Trucktrue1052MITSUBISHI MOTORS CORPORATION (MMC)MitsubishiJAPAN1053PETEâ`™S GOLF CARTSUNITED STATES (USA)Low Speed Vehicle (LSV)true1054MITSUBISHI MOTORS NORTH AMERICAMitsubishiUNITED STATES (USA)1055INTERNATIONAL TRUCK AND ENGINE CORPORATIONInternationalUNITED STATES (USA)Trucktrue1056HINO MOTORS MANUFACTURING U.S.A.HinoUNITED STATES (USA)TruckfalseIncomplete Vehicletrue1057TOYOTA MOTOR CORPORATIONToyotaJAPAN1058OSHKOSH CORPORATIONUNITED STATES (USA)TruckfalseTrailerfalse1059TOYOTA MOTOR MFG DE BAJA CALIFORNIA S DE RL DE CVToyotaMEXICO1060UD TRUCKS CORPORATION (USA)UDUNITED STATES (USA)Trucktrue1061OWOSSO MOTOR CAR COMPANYOwossoUNITED STATES (USA)1062NEW UNITED MOTOR MANUFACTURING, INC.NUMMIUNITED STATES (USA)1063TOYOTA MOTOR MANUFACTURING, CALIFORNIA, INC.ToyotaUNITED STATES (USA)1064IC BUS, LLCUNITED STATES (USA)TruckfalseBustrueIncomplete Vehiclefalse1073GREAT DANE TRAILERSGreat DaneUNITED STATES (USA)1074NAVISTAR CANADA, INC.Navistar CanadaCANADA1075FUJI HEAVY INDUSTRIES U.S.A., INC. (C/O SUBARU OF AMERICA)SubaruUNITED STATES (USA)Passenger Carfalse1078WORKHORSE CUSTOM CHASSISWorkhorseUNITED STATES (USA)1079JAGUAR LAND ROVER LIMITEDJaguar Land RoverUNITED KINGDOM (UK)Passenger CartrueMultipurpose Passenger Vehicle (MPV)false1080ZHEJIANG GEELY MING INDUSTRIAL CO., LTDCHINAMotorcyclefalse1081MITSUBISHI FUSO TRUCK AND BUS CORPORATIONMitsubishi FusoJAPANTrucktrueBusfalse1083MAZDA MOTOR MANUFACTURING DE MEXICO S.A. DE C.V.MazdaMEXICOPassenger CarfalseMultipurpose Passenger Vehicle (MPV)true1084FOREST RIVER, INC.UNITED STATES (USA)TrucktrueBusfalseTrailerfalseMultipurpose Passenger Vehicle (MPV)false1085TOYOTA MOTOR MANUFACTURING CANADAToyotaCANADA1086THOMAS BUILT BUSES, INCThomas BuiltUNITED STATES (USA)1087TOYOTA MOTOR MANUFACTURING, INDIANA, INC.ToyotaUNITED STATES (USA)1088TOYOTA MOTOR MANUFACTURING, KENTUCKY, INC.ToyotaUNITED STATES (USA)1089JOHN THOMAS, INCUNITED STATES (USA)Trailertrue"

Without using any plugin how to extract data from the above

stefanhelzle0001
stefanhelzle0001
June 12, 2025

xpathsnippet() is a normal Appian function.

docs.appian.com/.../fnc_scripting_xpathsnippet.html

davidj137213
davidj137213
June 12, 2025

YOu can find smart services in market that convert xml to json.

 [mention:d818ca2af193461781ce152b9f28f040:f7d226abd59f475c9d224a79e3f0ec07] 

community.appian.com/.../xml-and-json-conversion

Terms & ConditionsAccessibility statement