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

Brainy

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

"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"