In integration if the response is in xml format, how to convert it to appian value and save in a record type
Discussion posts and replies are publicly visible
You could try using: XML Parser
Otherwise, you just parse the XML manually and create your Record Type.
How to do it manually
Here is a quick example:
a!localVariables( local!xml: ri!xml, local!device: extract(local!xml, "<name>", "</name>"), local!brand: extract(local!xml, "<brand>", "</brand>"), local!price: extract(local!xml, "<price>", "</price>"), { device: local!device, brand: local!brand, price: local!price } )
If the data object is not too large, I use xpathsnippet() to fetch individual values, when mapping to my internal record type.
"<Response xmlns:xsi=""http://www.w3.org/2001/XMLSchema-instance"" xmlns:xsd=""http://www.w3.org/2001/XMLSchema""><Count>100</Count><Message>Response returned successfully</Message><Results><Manufacturers><Mfr_ID>955</Mfr_ID><Mfr_Name>TESLA, INC.</Mfr_Name><Mfr_CommonName>Tesla</Mfr_CommonName><Country>UNITED STATES (USA)</Country><VehicleTypes><VehicleType><Name>Passenger Car</Name><IsPrimary>true</IsPrimary></VehicleType><VehicleType><Name>Truck</Name><IsPrimary>false</IsPrimary></VehicleType><VehicleType><Name>Multipurpose Passenger Vehicle (MPV)</Name><IsPrimary>false</IsPrimary></VehicleType></VehicleTypes></Manufacturers><Manufacturers><Mfr_ID>956</Mfr_ID><Mfr_Name>ASTON MARTIN LAGONDA LIMITED</Mfr_Name><Mfr_CommonName>Aston Martin</Mfr_CommonName><Country>UNITED KINGDOM (UK)</Country><VehicleTypes><VehicleType><Name>Passenger Car</Name><IsPrimary>false</IsPrimary></VehicleType><VehicleType><Name>Multipurpose Passenger Vehicle (MPV)</Name><IsPrimary>false</IsPrimary></VehicleType></VehicleTypes></Manufacturers><Manufacturers><Mfr_ID>957</Mfr_ID><Mfr_Name>BMW OF NORTH AMERICA, LLC</Mfr_Name><Mfr_CommonName>BMW</Mfr_CommonName><Country>UNITED STATES (USA)</Country><VehicleTypes /></Manufacturers><Manufacturers><Mfr_ID>958</Mfr_ID><Mfr_Name>JAGUAR LAND ROVER NA, LLC</Mfr_Name><Mfr_CommonName>Jaguar Land Rover</Mfr_CommonName><Country>UNITED STATES (USA)</Country><VehicleTypes><VehicleType><Name>Passenger Car</Name><IsPrimary>true</IsPrimary></VehicleType><VehicleType><Name>Truck</Name><IsPrimary>false</IsPrimary></VehicleType><VehicleType><Name>Multipurpose Passenger Vehicle (MPV)</Name><IsPrimary>false</IsPrimary></VehicleType></VehicleTypes></Manufacturers><Manufacturers><Mfr_ID>959</Mfr_ID><Mfr_Name>MASERATI NORTH AMERICA, INC.</Mfr_Name><Mfr_CommonName>Mesarati</Mfr_CommonName><Country>UNITED STATES (USA)</Country><VehicleTypes><VehicleType><Name>Passenger Car</Name><IsPrimary>false</IsPrimary></VehicleType><VehicleType><Name>Multipurpose Passenger Vehicle (MPV)</Name><IsPrimary>true</IsPrimary></VehicleType></VehicleTypes></Manufacturers><Manufacturers><Mfr_ID>960</Mfr_ID><Mfr_Name>ROLLS ROYCE MOTOR CARS</Mfr_Name><Mfr_CommonName>Rolls Royce</Mfr_CommonName><Country>UNITED STATES (USA)</Country><VehicleTypes /></Manufacturers><Manufacturers><Mfr_ID>961</Mfr_ID><Mfr_Name>BUELL MOTORCYCLE CO.</Mfr_Name><Mfr_CommonName>Buell</Mfr_CommonName><Country>UNITED STATES (USA)</Country><VehicleTypes><VehicleType><Name>Motorcycle</Name><IsPrimary>true</IsPrimary></VehicleType></VehicleTypes></Manufacturers><Manufacturers><Mfr_ID>962</Mfr_ID><Mfr_Name>TOYOTA MOTOR NORTH AMERICA, INC</Mfr_Name><Mfr_CommonName>Toyota</Mfr_CommonName><Country>UNITED STATES (USA)</Country><VehicleTypes /></Manufacturers><Manufacturers><Mfr_ID>964</Mfr_ID><Mfr_Name>MERCEDES-BENZ USA, LLC (SPRINTER)</Mfr_Name><Mfr_CommonName>Mercedes-Benz Sprinter</Mfr_CommonName><Country>UNITED STATES (USA)</Country><VehicleTypes /></Manufacturers><Manufacturers><Mfr_ID>965</Mfr_ID><Mfr_Name>FULMER FABRICATIONS</Mfr_Name><Country>UNITED STATES (USA)</Country><VehicleTypes><VehicleType><Name>Motorcycle</Name><IsPrimary>false</IsPrimary></VehicleType></VehicleTypes></Manufacturers><Manufacturers><Mfr_ID>966</Mfr_ID><Mfr_Name>BMW AG</Mfr_Name><Mfr_CommonName>BMW</Mfr_CommonName><Country>GERMANY</Country><VehicleTypes /></Manufacturers><Manufacturers><Mfr_ID>967</Mfr_ID><Mfr_Name>BMW M GMBH</Mfr_Name><Mfr_CommonName>BMW</Mfr_CommonName><Country>GERMANY</Country><VehicleTypes><VehicleType><Name>Passenger Car</Name><IsPrimary>true</IsPrimary></VehicleType></VehicleTypes></Manufacturers><Manufacturers><Mfr_ID>968</Mfr_ID><Mfr_Name>BMW MANUFACTURER CORPORATION / BMW NORTH AMERICA</Mfr_Name><Mfr_CommonName>BMW</Mfr_CommonName><Country>UNITED STATES (USA)</Country><VehicleTypes><VehicleType><Name>Passenger Car</Name><IsPrimary>true</IsPrimary></VehicleType></VehicleTypes></Manufacturers><Manufacturers><Mfr_ID>969</Mfr_ID><Mfr_Name>MOTORCYCLE MACHINE SHOP SERVICES, LLC</Mfr_Name><Mfr_CommonName>Motorcycle Machine Shop Services</Mfr_CommonName><Country>UNITED STATES (USA)</Country><VehicleTypes /></Manufacturers><Manufacturers><Mfr_ID>970</Mfr_ID><Mfr_Name>BUGATTI AUTOMOBILES S.A.S.</Mfr_Name><Mfr_CommonName>Bugatti</Mfr_CommonName><Country>FRANCE</Country><VehicleTypes><VehicleType><Name>Passenger Car</Name><IsPrimary>true</IsPrimary></VehicleType></VehicleTypes></Manufacturers><Manufacturers><Mfr_ID>971</Mfr_ID><Mfr_Name>HOMBILT TRAILERS INC</Mfr_Name><Mfr_CommonName>Hombilt</Mfr_CommonName><Country>UNITED STATES (USA)</Country><VehicleTypes><VehicleType><Name>Trailer</Name><IsPrimary>false</IsPrimary></VehicleType></VehicleTypes></Manufacturers><Manufacturers><Mfr_ID>972</Mfr_ID><Mfr_Name>BMW AG MOTORCYCLES</Mfr_Name><Mfr_CommonName>BMW Motorrad (Motorcycles)</Mfr_CommonName><Country>GERMANY</Country><VehicleTypes /></Manufacturers><Manufacturers><Mfr_ID>973</Mfr_ID><Mfr_Name>AMERICAN CUSTOM GOLF CARS, INC</Mfr_Name><Mfr_CommonName>ACG</Mfr_CommonName><Country>UNITED STATES (USA)</Country><VehicleTypes><VehicleType><Name>Low Speed Vehicle (LSV)</Name><IsPrimary>true</IsPrimary></VehicleType><VehicleType><Name>Off Road Vehicle</Name><IsPrimary>false</IsPrimary></VehicleType></VehicleTypes></Manufacturers><Manufacturers><Mfr_ID>974</Mfr_ID><Mfr_Name>MOONLIGHT AUTO</Mfr_Name><Country>UNITED STATES (USA)</Country><VehicleTypes><VehicleType><Name>Motorcycle</Name><IsPrimary>false</IsPrimary></VehicleType></VehicleTypes></Manufacturers><Manufacturers><Mfr_ID>975</Mfr_ID><Mfr_Name>COOPER CYCLES</Mfr_Name><Mfr_CommonName>Cooper Cycles</Mfr_CommonName><Country>UNITED STATES (USA)</Country><VehicleTypes /></Manufacturers><Manufacturers><Mfr_ID>976</Mfr_ID><Mfr_Name>FORD MOTOR COMPANY</Mfr_Name><Mfr_CommonName>Ford</Mfr_CommonName><Country>UNITED STATES (USA)</Country><VehicleTypes><VehicleType><Name>Passenger Car</Name><IsPrimary>false</IsPrimary></VehicleType><VehicleType><Name>Truck</Name><IsPrimary>false</IsPrimary></VehicleType><VehicleType><Name>Bus</Name><IsPrimary>false</IsPrimary></VehicleType><VehicleType><Name>Multipurpose Passenger Vehicle (MPV)</Name><IsPrimary>true</IsPrimary></VehicleType><VehicleType><Name>Incomplete Vehicle</Name><IsPrimary>false</IsPrimary></VehicleType></VehicleTypes></Manufacturers><Manufacturers><Mfr_ID>977</Mfr_ID><Mfr_Name>FORD MOTOR COMPANY OF CANADA, LTD.</Mfr_Name><Mfr_CommonName>Ford</Mfr_CommonName><Country>CANADA</Country><VehicleTypes /></Manufacturers><Manufacturers><Mfr_ID>978</Mfr_ID><Mfr_Name>AUTO ALLIANCE INTERNATIONAL, USA</Mfr_Name><Mfr_CommonName>Auto Alliance</Mfr_CommonName><Country>UNITED STATES (USA)</Country><VehicleTypes /></Manufacturers><Manufacturers><Mfr_ID>979</Mfr_ID><Mfr_Name>FORD MOTOR COMPANY, MEXICO</Mfr_Name><Mfr_CommonName>Ford</Mfr_CommonName><Country>MEXICO</Country><VehicleTypes /></Manufacturers><Manufacturers><Mfr_ID>980</Mfr_ID><Mfr_Name>LATITUDE CAMPER COMPANY, LLC</Mfr_Name><Mfr_CommonName>Latitude</Mfr_CommonName><Country>UNITED STATES (USA)</Country><VehicleTypes><VehicleType><Name>Trailer</Name><IsPrimary>false</IsPrimary></VehicleType></VehicleTypes></Manufacturers><Manufacturers><Mfr_ID>981</Mfr_ID><Mfr_Name>COUNTRY COACH CORPORATION</Mfr_Name><Country>UNITED STATES (USA)</Country><VehicleTypes><VehicleType><Name>Multipurpose Passenger Vehicle (MPV)</Name><IsPrimary>false</IsPrimary></VehicleType></VehicleTypes></Manufacturers><Manufacturers><Mfr_ID>982</Mfr_ID><Mfr_Name>WESTWARD INDUSTRIES LTD.</Mfr_Name><Mfr_CommonName>Westward</Mfr_CommonName><Country>CANADA</Country><VehicleTypes><VehicleType><Name>Motorcycle</Name><IsPrimary>false</IsPrimary></VehicleType></VehicleTypes></Manufacturers><Manufacturers><Mfr_ID>983</Mfr_ID><Mfr_Name>LOTUS CARS LIMITED</Mfr_Name><Mfr_CommonName>Lotus</Mfr_CommonName><Country>UNITED KINGDOM (UK)</Country><VehicleTypes><VehicleType><Name>Passenger Car</Name><IsPrimary>true</IsPrimary></VehicleType></VehicleTypes></Manufacturers><Manufacturers><Mfr_ID>984</Mfr_ID><Mfr_Name>GENERAL MOTORS LLC</Mfr_Name><Mfr_CommonName>General Motors</Mfr_CommonName><Country>UNITED STATES (USA)</Country><VehicleTypes><VehicleType><Name>Passenger Car</Name><IsPrimary>false</IsPrimary></VehicleType><VehicleType><Name>Truck</Name><IsPrimary>false</IsPrimary></VehicleType><VehicleType><Name>Bus</Name><IsPrimary>false</IsPrimary></VehicleType><VehicleType><Name>Multipurpose Passenger Vehicle (MPV)</Name><IsPrimary>false</IsPrimary></VehicleType><VehicleType><Name>Incomplete Vehicle</Name><IsPrimary>true</IsPrimary></VehicleType></VehicleTypes></Manufacturers><Manufacturers><Mfr_ID>985</Mfr_ID><Mfr_Name>BLUE DIAMOND TRUCK, S. DE R. L. DE C. V.</Mfr_Name><Mfr_CommonName>Blue Diamond</Mfr_CommonName><Country>MEXICO</Country><VehicleTypes><VehicleType><Name>Incomplete Vehicle</Name><IsPrimary>false</IsPrimary></VehicleType></VehicleTypes></Manufacturers><Manufacturers><Mfr_ID>986</Mfr_ID><Mfr_Name>FORD OTOMOTIV SANAYI A.S., TURKEY</Mfr_Name><Mfr_CommonName>Ford</Mfr_CommonName><Country>TURKEY</Country><VehicleTypes /></Manufacturers><Manufacturers><Mfr_ID>987</Mfr_ID><Mfr_Name>HONDA MOTOR CO., LTD.</Mfr_Name><Mfr_CommonName>Honda</Mfr_CommonName><Country>JAPAN</Country><VehicleTypes><VehicleType><Name>Motorcycle</Name><IsPrimary>false</IsPrimary></VehicleType><VehicleType><Name>Passenger Car</Name><IsPrimary>false</IsPrimary></VehicleType><VehicleType><Name>Multipurpose Passenger Vehicle (MPV)</Name><IsPrimary>false</IsPrimary></VehicleType></VehicleTypes></Manufacturers><Manufacturers><Mfr_ID>988</Mfr_ID><Mfr_Name>AMERICAN HONDA MOTOR CO., INC.</Mfr_Name><Mfr_CommonName>Honda</Mfr_CommonName><Country>UNITED STATES (USA)</Country><VehicleTypes><VehicleType><Name>Passenger Car</Name><IsPrimary>true</IsPrimary></VehicleType><VehicleType><Name>Truck</Name><IsPrimary>false</IsPrimary></VehicleType><VehicleType><Name>Multipurpose Passenger Vehicle (MPV)</Name><IsPrimary>false</IsPrimary></VehicleType></VehicleTypes></Manufacturers><Manufacturers><Mfr_ID>990</Mfr_ID><Mfr_Name>HONDA OF CANADA MFG., A DIVISION OF HONDA CANADA INC.</Mfr_Name><Mfr_CommonName>Honda</Mfr_CommonName><Country>CANADA</Country><VehicleTypes><VehicleType><Name>Passenger Car</Name><IsPrimary>false</IsPrimary></VehicleType><VehicleType><Name>Truck</Name><IsPrimary>false</IsPrimary></VehicleType><VehicleType><Name>Multipurpose Passenger Vehicle (MPV)</Name><IsPrimary>false</IsPrimary></VehicleType></VehicleTypes></Manufacturers><Manufacturers><Mfr_ID>991</Mfr_ID><Mfr_Name>HONDA OF THE U.K. MFG., LTD.</Mfr_Name><Mfr_CommonName>Honda</Mfr_CommonName><Country>UNITED KINGDOM (UK)</Country><VehicleTypes><VehicleType><Name>Passenger Car</Name><IsPrimary>false</IsPrimary></VehicleType><VehicleType><Name>Multipurpose Passenger Vehicle (MPV)</Name><IsPrimary>false</IsPrimary></VehicleType></VehicleTypes></Manufacturers><Manufacturers><Mfr_ID>992</Mfr_ID><Mfr_Name>HONDA DE MEXICO, S.A. DE C.V.</Mfr_Name><Country>MEXICO</Country><VehicleTypes><VehicleType><Name>Motorcycle</Name><IsPrimary>false</IsPrimary></VehicleType><VehicleType><Name>Passenger Car</Name><IsPrimary>false</IsPrimary></VehicleType><VehicleType><Name>Multipurpose Passenger Vehicle (MPV)</Name><IsPrimary>false</IsPrimary></VehicleType></VehicleTypes></Manufacturers><Manufacturers><Mfr_ID>994</Mfr_ID><Mfr_Name>FCA US LLC</Mfr_Name><Mfr_CommonName>Chrysler</Mfr_CommonName><Country>UNITED STATES (USA)</Country><VehicleTypes><VehicleType><Name>Passenger Car</Name><IsPrimary>false</IsPrimary></VehicleType><VehicleType><Name>Multipurpose Passenger Vehicle (MPV)</Name><IsPrimary>true</IsPrimary></VehicleType><VehicleType><Name>Incomplete Vehicle</Name><IsPrimary>false</IsPrimary></VehicleType></VehicleTypes></Manufacturers><Manufacturers><Mfr_ID>995</Mfr_ID><Mfr_Name>FCA CANADA INC.</Mfr_Name><Mfr_CommonName>Chrysler</Mfr_CommonName><Country>CANADA</Country><VehicleTypes /></Manufacturers><Manufacturers><Mfr_ID>996</Mfr_ID><Mfr_Name>NISSAN MOTOR COMPANY, LTD</Mfr_Name><Mfr_CommonName>Nissan</Mfr_CommonName><Country>JAPAN</Country><VehicleTypes><VehicleType><Name>Passenger Car</Name><IsPrimary>false</IsPrimary></VehicleType><VehicleType><Name>Truck</Name><IsPrimary>false</IsPrimary></VehicleType><VehicleType><Name>Multipurpose Passenger Vehicle (MPV)</Name><IsPrimary>false</IsPrimary></VehicleType><VehicleType><Name>Incomplete Vehicle</Name><IsPrimary>false</IsPrimary></VehicleType></VehicleTypes></Manufacturers><Manufacturers><Mfr_ID>997</Mfr_ID><Mfr_Name>NISSAN NORTH AMERICA, INC.</Mfr_Name><Mfr_CommonName>Nissan</Mfr_CommonName><Country>UNITED STATES (USA)</Country><VehicleTypes><VehicleType><Name>Passenger Car</Name><IsPrimary>false</IsPrimary></VehicleType><VehicleType><Name>Truck</Name><IsPrimary>false</IsPrimary></VehicleType><VehicleType><Name>Bus</Name><IsPrimary>false</IsPrimary></VehicleType><VehicleType><Name>Multipurpose Passenger Vehicle (MPV)</Name><IsPrimary>false</IsPrimary></VehicleType></VehicleTypes></Manufacturers><Manufacturers><Mfr_ID>998</Mfr_ID><Mfr_Name>QUEST MANUFACTURING</Mfr_Name><Mfr_CommonName>Quest Manufacturing</Mfr_CommonName><Country>CANADA</Country><VehicleTypes /></Manufacturers><Manufacturers><Mfr_ID>999</Mfr_ID><Mfr_Name>NISSAN MEXICANA, S.A. DE C.V.</Mfr_Name><Mfr_CommonName>Nissan</Mfr_CommonName><Country>MEXICO</Country><VehicleTypes /></Manufacturers><Manufacturers><Mfr_ID>1000</Mfr_ID><Mfr_Name>RENAULT SAMSUNG MOTORS CO., LTD</Mfr_Name><Mfr_CommonName>Renault Samsung</Mfr_CommonName><Country>SOUTH KOREA</Country><VehicleTypes /></Manufacturers><Manufacturers><Mfr_ID>1001</Mfr_ID><Mfr_Name>RENAULT GROUP</Mfr_Name><Mfr_CommonName>Renault</Mfr_CommonName><Country>FRANCE</Country><VehicleTypes /></Manufacturers><Manufacturers><Mfr_ID>1002</Mfr_ID><Mfr_Name>CHRYSLER DE MEXICO TOLUCA</Mfr_Name><Mfr_CommonName>Chrysler</Mfr_CommonName><Country>MEXICO</Country><VehicleTypes /></Manufacturers><Manufacturers><Mfr_ID>1003</Mfr_ID><Mfr_Name>CLUB CAR LLC.</Mfr_Name><Mfr_CommonName>Club Car</Mfr_CommonName><Country>UNITED STATES (USA)</Country><VehicleTypes><VehicleType><Name>Low Speed Vehicle (LSV)</Name><IsPrimary>false</IsPrimary></VehicleType></VehicleTypes></Manufacturers><Manufacturers><Mfr_ID>1006</Mfr_ID><Mfr_Name>VOLVO CAR USA, LLC</Mfr_Name><Mfr_CommonName>Volvo</Mfr_CommonName><Country>UNITED STATES (USA)</Country><VehicleTypes><VehicleType><Name>Passenger Car</Name><IsPrimary>false</IsPrimary></VehicleType><VehicleType><Name>Multipurpose Passenger Vehicle (MPV)</Name><IsPrimary>true</IsPrimary></VehicleType></VehicleTypes></Manufacturers><Manufacturers><Mfr_ID>1011</Mfr_ID><Mfr_Name>ZHEJIANG GEELY HOLDING GROUP CO.,LTD</Mfr_Name><Mfr_CommonName>Geely</Mfr_CommonName><Country>CHINA</Country><VehicleTypes /></Manufacturers><Manufacturers><Mfr_ID>1014</Mfr_ID><Mfr_Name>GOLF CARS OF ARIZONA</Mfr_Name><Mfr_CommonName>Golf Cars of Arizona</Mfr_CommonName><Country>UNITED STATES (USA)</Country><VehicleTypes><VehicleType><Name>Low Speed Vehicle (LSV)</Name><IsPrimary>false</IsPrimary></VehicleType></VehicleTypes></Manufacturers><Manufacturers><Mfr_ID>1015</Mfr_ID><Mfr_Name>VOLVO GROUP NORTH AMERICA, LLC</Mfr_Name><Mfr_CommonName>Volvo (Truck / Bus)</Mfr_CommonName><Country>UNITED STATES (USA)</Country><VehicleTypes><VehicleType><Name>Truck</Name><IsPrimary>true</IsPrimary></VehicleType><VehicleType><Name>Bus</Name><IsPrimary>false</IsPrimary></VehicleType></VehicleTypes></Manufacturers><Manufacturers><Mfr_ID>1023</Mfr_ID><Mfr_Name>MERCEDES-BENZ, AG</Mfr_Name><Mfr_CommonName>Mercedes-Benz</Mfr_CommonName><Country>GERMANY</Country><VehicleTypes><VehicleType><Name>Passenger Car</Name><IsPrimary>true</IsPrimary></VehicleType><VehicleType><Name>Multipurpose Passenger Vehicle (MPV)</Name><IsPrimary>false</IsPrimary></VehicleType></VehicleTypes></Manufacturers><Manufacturers><Mfr_ID>1024</Mfr_ID><Mfr_Name>DAIMLER TRUCK NORTH AMERICA LLC</Mfr_Name><Mfr_CommonName>DTNA</Mfr_CommonName><Country>UNITED STATES (USA)</Country><VehicleTypes><VehicleType><Name>Truck</Name><IsPrimary>true</IsPrimary></VehicleType><VehicleType><Name>Incomplete Vehicle</Name><IsPrimary>false</IsPrimary></VehicleType></VehicleTypes></Manufacturers><Manufacturers><Mfr_ID>1025</Mfr_ID><Mfr_Name>FREIGHTLINER CUSTOM CHASSIS CORP.</Mfr_Name><Country>UNITED STATES (USA)</Country><VehicleTypes><VehicleType><Name>Incomplete Vehicle</Name><IsPrimary>true</IsPrimary></VehicleType></VehicleTypes></Manufacturers><Manufacturers><Mfr_ID>1026</Mfr_ID><Mfr_Name>COACHWORKS HOLDINGS INC</Mfr_Name><Mfr_CommonName>Coachworks</Mfr_CommonName><Country>UNITED STATES (USA)</Country><VehicleTypes /></Manufacturers><Manufacturers><Mfr_ID>1027</Mfr_ID><Mfr_Name>MACK TRUCKS INC.</Mfr_Name><Mfr_CommonName>Mack Trucks</Mfr_CommonName><Country>UNITED STATES (USA)</Country><VehicleTypes><VehicleType><Name>Truck</Name><IsPrimary>true</IsPrimary></VehicleType><VehicleType><Name>Incomplete Vehicle</Name><IsPrimary>false</IsPrimary></VehicleType></VehicleTypes></Manufacturers><Manufacturers><Mfr_ID>1028</Mfr_ID><Mfr_Name>INTERNATIONAL MOTORS, LLC</Mfr_Name><Country>UNITED STATES (USA)</Country><VehicleTypes><VehicleType><Name>Truck</Name><IsPrimary>false</IsPrimary></VehicleType><VehicleType><Name>Incomplete Vehicle</Name><IsPrimary>false</IsPrimary></VehicleType></VehicleTypes></Manufacturers><Manufacturers><Mfr_ID>1029</Mfr_ID><Mfr_Name>FCA ITALY S.P.A.</Mfr_Name><Mfr_CommonName>Fiat</Mfr_CommonName><Country>ITALY</Country><VehicleTypes><VehicleType><Name>Passenger Car</Name><IsPrimary>true</IsPrimary></VehicleType><VehicleType><Name>Truck</Name><IsPrimary>false</IsPrimary></VehicleType><VehicleType><Name>Multipurpose Passenger Vehicle (MPV)</Name><IsPrimary>false</IsPrimary></VehicleType></VehicleTypes></Manufacturers><Manufacturers><Mfr_ID>1030</Mfr_ID><Mfr_Name>CHAIRIOT MOBILITY INC</Mfr_Name><Mfr_CommonName>Chairiot Mobility</Mfr_CommonName><Country>UNITED STATES (USA)</Country><VehicleTypes><VehicleType><Name>Low Speed Vehicle (LSV)</Name><IsPrimary>true</IsPrimary></VehicleType></VehicleTypes></Manufacturers><Manufacturers><Mfr_ID>1031</Mfr_ID><Mfr_Name>PACCAR INC.</Mfr_Name><Mfr_CommonName>PACCAR</Mfr_CommonName><Country>UNITED STATES (USA)</Country><VehicleTypes><VehicleType><Name>Truck</Name><IsPrimary>true</IsPrimary></VehicleType></VehicleTypes></Manufacturers><Manufacturers><Mfr_ID>1032</Mfr_ID><Mfr_Name>KENWORTH TRUCK COMPANY</Mfr_Name><Mfr_CommonName>Kenworth</Mfr_CommonName><Country>UNITED STATES (USA)</Country><VehicleTypes /></Manufacturers><Manufacturers><Mfr_ID>1033</Mfr_ID><Mfr_Name>PETERBILT MOTORS COMPANY</Mfr_Name><Mfr_CommonName>Peterbilt</Mfr_CommonName><Country>UNITED STATES (USA)</Country><VehicleTypes /></Manufacturers><Manufacturers><Mfr_ID>1034</Mfr_ID><Mfr_Name>HYUNDAI-KIA AMERICA TECHNICAL CENTER INC (HATCI)</Mfr_Name><Mfr_CommonName>Hyundai-Kia</Mfr_CommonName><Country>UNITED STATES (USA)</Country><VehicleTypes><VehicleType><Name>Passenger Car</Name><IsPrimary>true</IsPrimary></VehicleType><VehicleType><Name>Truck</Name><IsPrimary>false</IsPrimary></VehicleType><VehicleType><Name>Multipurpose Passenger Vehicle (MPV)</Name><IsPrimary>false</IsPrimary></VehicleType></VehicleTypes></Manufacturers><Manufacturers><Mfr_ID>1035</Mfr_ID><Mfr_Name>MAD DAWG CYCLES AND TRAILERS</Mfr_Name><Country>UNITED STATES (USA)</Country><VehicleTypes><VehicleType><Name>Motorcycle</Name><IsPrimary>false</IsPrimary></VehicleType><VehicleType><Name>Trailer</Name><IsPrimary>false</IsPrimary></VehicleType></VehicleTypes></Manufacturers><Manufacturers><Mfr_ID>1038</Mfr_ID><Mfr_Name>MILLS MANUFACTURING INC</Mfr_Name><Mfr_CommonName>Mills Manufacturing</Mfr_CommonName><Country>UNITED STATES (USA)</Country><VehicleTypes /></Manufacturers><Manufacturers><Mfr_ID>1040</Mfr_ID><Mfr_Name>HAYES WELDING INC</Mfr_Name><Country>UNITED STATES (USA)</Country><VehicleTypes><VehicleType><Name>Trailer</Name><IsPrimary>false</IsPrimary></VehicleType></VehicleTypes></Manufacturers><Manufacturers><Mfr_ID>1041</Mfr_ID><Mfr_Name>MAZDA MOTOR CORPORATION</Mfr_Name><Mfr_CommonName>Mazda</Mfr_CommonName><Country>JAPAN</Country><VehicleTypes><VehicleType><Name>Passenger Car</Name><IsPrimary>false</IsPrimary></VehicleType><VehicleType><Name>Multipurpose Passenger Vehicle (MPV)</Name><IsPrimary>true</IsPrimary></VehicleType></VehicleTypes></Manufacturers><Manufacturers><Mfr_ID>1042</Mfr_ID><Mfr_Name>MERCEDES-BENZ CARS</Mfr_Name><Mfr_CommonName>Mercedes-Benz</Mfr_CommonName><Country>GERMANY</Country><VehicleTypes /></Manufacturers><Manufacturers><Mfr_ID>1043</Mfr_ID><Mfr_Name>MERCEDES-BENZ OF NORTH AMERICA, INC.</Mfr_Name><Mfr_CommonName>Mercedes-Benz</Mfr_CommonName><Country>UNITED STATES (USA)</Country><VehicleTypes><VehicleType><Name>Passenger Car</Name><IsPrimary>false</IsPrimary></VehicleType></VehicleTypes></Manufacturers><Manufacturers><Mfr_ID>1044</Mfr_ID><Mfr_Name>BLUE BIRD BODY COMPANY</Mfr_Name><Country>UNITED STATES (USA)</Country><VehicleTypes><VehicleType><Name>Bus</Name><IsPrimary>true</IsPrimary></VehicleType><VehicleType><Name>Multipurpose Passenger Vehicle (MPV)</Name><IsPrimary>false</IsPrimary></VehicleType></VehicleTypes></Manufacturers><Manufacturers><Mfr_ID>1045</Mfr_ID><Mfr_Name>OPTIMA BUS CORP</Mfr_Name><Mfr_CommonName>Optima</Mfr_CommonName><Country>UNITED STATES (USA)</Country><VehicleTypes /></Manufacturers><Manufacturers><Mfr_ID>1047</Mfr_ID><Mfr_Name>NORTH AMERICAN BUS INDUSTRIES INC., LLC</Mfr_Name><Mfr_CommonName>NABI</Mfr_CommonName><Country>UNITED STATES (USA)</Country><VehicleTypes /></Manufacturers><Manufacturers><Mfr_ID>1048</Mfr_ID><Mfr_Name>SUZUKI MOTOR OF AMERICA, INC</Mfr_Name><Mfr_CommonName>Suzuki</Mfr_CommonName><Country>UNITED STATES (USA)</Country><VehicleTypes><VehicleType><Name>Motorcycle</Name><IsPrimary>true</IsPrimary></VehicleType></VehicleTypes></Manufacturers><Manufacturers><Mfr_ID>1050</Mfr_ID><Mfr_Name>E-ONE, INC.</Mfr_Name><Country>UNITED STATES (USA)</Country><VehicleTypes><VehicleType><Name>Truck</Name><IsPrimary>true</IsPrimary></VehicleType></VehicleTypes></Manufacturers><Manufacturers><Mfr_ID>1052</Mfr_ID><Mfr_Name>MITSUBISHI MOTORS CORPORATION (MMC)</Mfr_Name><Mfr_CommonName>Mitsubishi</Mfr_CommonName><Country>JAPAN</Country><VehicleTypes /></Manufacturers><Manufacturers><Mfr_ID>1053</Mfr_ID><Mfr_Name>PETE’S GOLF CARTS</Mfr_Name><Country>UNITED STATES (USA)</Country><VehicleTypes><VehicleType><Name>Low Speed Vehicle (LSV)</Name><IsPrimary>true</IsPrimary></VehicleType></VehicleTypes></Manufacturers><Manufacturers><Mfr_ID>1054</Mfr_ID><Mfr_Name>MITSUBISHI MOTORS NORTH AMERICA</Mfr_Name><Mfr_CommonName>Mitsubishi</Mfr_CommonName><Country>UNITED STATES (USA)</Country><VehicleTypes /></Manufacturers><Manufacturers><Mfr_ID>1055</Mfr_ID><Mfr_Name>INTERNATIONAL TRUCK AND ENGINE CORPORATION</Mfr_Name><Mfr_CommonName>International</Mfr_CommonName><Country>UNITED STATES (USA)</Country><VehicleTypes><VehicleType><Name>Truck</Name><IsPrimary>true</IsPrimary></VehicleType></VehicleTypes></Manufacturers><Manufacturers><Mfr_ID>1056</Mfr_ID><Mfr_Name>HINO MOTORS MANUFACTURING U.S.A.</Mfr_Name><Mfr_CommonName>Hino</Mfr_CommonName><Country>UNITED STATES (USA)</Country><VehicleTypes><VehicleType><Name>Truck</Name><IsPrimary>false</IsPrimary></VehicleType><VehicleType><Name>Incomplete Vehicle</Name><IsPrimary>true</IsPrimary></VehicleType></VehicleTypes></Manufacturers><Manufacturers><Mfr_ID>1057</Mfr_ID><Mfr_Name>TOYOTA MOTOR CORPORATION</Mfr_Name><Mfr_CommonName>Toyota</Mfr_CommonName><Country>JAPAN</Country><VehicleTypes /></Manufacturers><Manufacturers><Mfr_ID>1058</Mfr_ID><Mfr_Name>OSHKOSH CORPORATION</Mfr_Name><Country>UNITED STATES (USA)</Country><VehicleTypes><VehicleType><Name>Truck</Name><IsPrimary>false</IsPrimary></VehicleType><VehicleType><Name>Trailer</Name><IsPrimary>false</IsPrimary></VehicleType></VehicleTypes></Manufacturers><Manufacturers><Mfr_ID>1059</Mfr_ID><Mfr_Name>TOYOTA MOTOR MFG DE BAJA CALIFORNIA S DE RL DE CV</Mfr_Name><Mfr_CommonName>Toyota</Mfr_CommonName><Country>MEXICO</Country><VehicleTypes /></Manufacturers><Manufacturers><Mfr_ID>1060</Mfr_ID><Mfr_Name>UD TRUCKS CORPORATION (USA)</Mfr_Name><Mfr_CommonName>UD</Mfr_CommonName><Country>UNITED STATES (USA)</Country><VehicleTypes><VehicleType><Name>Truck</Name><IsPrimary>true</IsPrimary></VehicleType></VehicleTypes></Manufacturers><Manufacturers><Mfr_ID>1061</Mfr_ID><Mfr_Name>OWOSSO MOTOR CAR COMPANY</Mfr_Name><Mfr_CommonName>Owosso</Mfr_CommonName><Country>UNITED STATES (USA)</Country><VehicleTypes /></Manufacturers><Manufacturers><Mfr_ID>1062</Mfr_ID><Mfr_Name>NEW UNITED MOTOR MANUFACTURING, INC.</Mfr_Name><Mfr_CommonName>NUMMI</Mfr_CommonName><Country>UNITED STATES (USA)</Country><VehicleTypes /></Manufacturers><Manufacturers><Mfr_ID>1063</Mfr_ID><Mfr_Name>TOYOTA MOTOR MANUFACTURING, CALIFORNIA, INC.</Mfr_Name><Mfr_CommonName>Toyota</Mfr_CommonName><Country>UNITED STATES (USA)</Country><VehicleTypes /></Manufacturers><Manufacturers><Mfr_ID>1064</Mfr_ID><Mfr_Name>IC BUS, LLC</Mfr_Name><Country>UNITED STATES (USA)</Country><VehicleTypes><VehicleType><Name>Truck</Name><IsPrimary>false</IsPrimary></VehicleType><VehicleType><Name>Bus</Name><IsPrimary>true</IsPrimary></VehicleType><VehicleType><Name>Incomplete Vehicle</Name><IsPrimary>false</IsPrimary></VehicleType></VehicleTypes></Manufacturers><Manufacturers><Mfr_ID>1073</Mfr_ID><Mfr_Name>GREAT DANE TRAILERS</Mfr_Name><Mfr_CommonName>Great Dane</Mfr_CommonName><Country>UNITED STATES (USA)</Country><VehicleTypes /></Manufacturers><Manufacturers><Mfr_ID>1074</Mfr_ID><Mfr_Name>NAVISTAR CANADA, INC.</Mfr_Name><Mfr_CommonName>Navistar Canada</Mfr_CommonName><Country>CANADA</Country><VehicleTypes /></Manufacturers><Manufacturers><Mfr_ID>1075</Mfr_ID><Mfr_Name>FUJI HEAVY INDUSTRIES U.S.A., INC. (C/O SUBARU OF AMERICA)</Mfr_Name><Mfr_CommonName>Subaru</Mfr_CommonName><Country>UNITED STATES (USA)</Country><VehicleTypes><VehicleType><Name>Passenger Car</Name><IsPrimary>false</IsPrimary></VehicleType></VehicleTypes></Manufacturers><Manufacturers><Mfr_ID>1078</Mfr_ID><Mfr_Name>WORKHORSE CUSTOM CHASSIS</Mfr_Name><Mfr_CommonName>Workhorse</Mfr_CommonName><Country>UNITED STATES (USA)</Country><VehicleTypes /></Manufacturers><Manufacturers><Mfr_ID>1079</Mfr_ID><Mfr_Name>JAGUAR LAND ROVER LIMITED</Mfr_Name><Mfr_CommonName>Jaguar Land Rover</Mfr_CommonName><Country>UNITED KINGDOM (UK)</Country><VehicleTypes><VehicleType><Name>Passenger Car</Name><IsPrimary>true</IsPrimary></VehicleType><VehicleType><Name>Multipurpose Passenger Vehicle (MPV)</Name><IsPrimary>false</IsPrimary></VehicleType></VehicleTypes></Manufacturers><Manufacturers><Mfr_ID>1080</Mfr_ID><Mfr_Name>ZHEJIANG GEELY MING INDUSTRIAL CO., LTD</Mfr_Name><Country>CHINA</Country><VehicleTypes><VehicleType><Name>Motorcycle</Name><IsPrimary>false</IsPrimary></VehicleType></VehicleTypes></Manufacturers><Manufacturers><Mfr_ID>1081</Mfr_ID><Mfr_Name>MITSUBISHI FUSO TRUCK AND BUS CORPORATION</Mfr_Name><Mfr_CommonName>Mitsubishi Fuso</Mfr_CommonName><Country>JAPAN</Country><VehicleTypes><VehicleType><Name>Truck</Name><IsPrimary>true</IsPrimary></VehicleType><VehicleType><Name>Bus</Name><IsPrimary>false</IsPrimary></VehicleType></VehicleTypes></Manufacturers><Manufacturers><Mfr_ID>1083</Mfr_ID><Mfr_Name>MAZDA MOTOR MANUFACTURING DE MEXICO S.A. DE C.V.</Mfr_Name><Mfr_CommonName>Mazda</Mfr_CommonName><Country>MEXICO</Country><VehicleTypes><VehicleType><Name>Passenger Car</Name><IsPrimary>false</IsPrimary></VehicleType><VehicleType><Name>Multipurpose Passenger Vehicle (MPV)</Name><IsPrimary>true</IsPrimary></VehicleType></VehicleTypes></Manufacturers><Manufacturers><Mfr_ID>1084</Mfr_ID><Mfr_Name>FOREST RIVER, INC.</Mfr_Name><Country>UNITED STATES (USA)</Country><VehicleTypes><VehicleType><Name>Truck</Name><IsPrimary>true</IsPrimary></VehicleType><VehicleType><Name>Bus</Name><IsPrimary>false</IsPrimary></VehicleType><VehicleType><Name>Trailer</Name><IsPrimary>false</IsPrimary></VehicleType><VehicleType><Name>Multipurpose Passenger Vehicle (MPV)</Name><IsPrimary>false</IsPrimary></VehicleType></VehicleTypes></Manufacturers><Manufacturers><Mfr_ID>1085</Mfr_ID><Mfr_Name>TOYOTA MOTOR MANUFACTURING CANADA</Mfr_Name><Mfr_CommonName>Toyota</Mfr_CommonName><Country>CANADA</Country><VehicleTypes /></Manufacturers><Manufacturers><Mfr_ID>1086</Mfr_ID><Mfr_Name>THOMAS BUILT BUSES, INC</Mfr_Name><Mfr_CommonName>Thomas Built</Mfr_CommonName><Country>UNITED STATES (USA)</Country><VehicleTypes /></Manufacturers><Manufacturers><Mfr_ID>1087</Mfr_ID><Mfr_Name>TOYOTA MOTOR MANUFACTURING, INDIANA, INC.</Mfr_Name><Mfr_CommonName>Toyota</Mfr_CommonName><Country>UNITED STATES (USA)</Country><VehicleTypes /></Manufacturers><Manufacturers><Mfr_ID>1088</Mfr_ID><Mfr_Name>TOYOTA MOTOR MANUFACTURING, KENTUCKY, INC.</Mfr_Name><Mfr_CommonName>Toyota</Mfr_CommonName><Country>UNITED STATES (USA)</Country><VehicleTypes /></Manufacturers><Manufacturers><Mfr_ID>1089</Mfr_ID><Mfr_Name>JOHN THOMAS, INC</Mfr_Name><Country>UNITED STATES (USA)</Country><VehicleTypes><VehicleType><Name>Trailer</Name><IsPrimary>true</IsPrimary></VehicleType></VehicleTypes></Manufacturers></Results></Response>"
Without using any plugin how to extract data from this xml response
Without using any plugin how to extract data from the above
xpathsnippet() is a normal Appian function.
docs.appian.com/.../fnc_scripting_xpathsnippet.html
YOu can find smart services in market that convert xml to json.
XML Parser
community.appian.com/.../xml-and-json-conversion
Can you please guide me on how to use xpathsnippet() function for the above xml response
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