格式化Amazon XML [英] Formatting Amazon XML

问题描述

如何使用xslt或sql查询表输出规范化这个amazon xml？

How to normalize this amazon xml with xslt or with sql query table output?

<?xml version="1.0"?><ItemLookupResponse xmlns="http://webservices.amazon.com/AWSECommerceService/2011-08-01"><OperationRequest><HTTPHeaders><Header Name="UserAgent" Value="#"></Header></HTTPHeaders><RequestId>#</RequestId><Arguments><Argument Name="Service" Value="AWSECommerceService"></Argument><Argument Name="Operation" Value="ItemLookup"></Argument><Argument Name="AssociateTag" Value="#"></Argument><Argument Name="Version" Value="2011-08-01"></Argument><Argument Name="SignatureMethod" Value="#"></Argument><Argument Name="SignatureVersion" Value="2"></Argument><Argument Name="Signature" Value="#"></Argument><Argument Name="MerchantId" Value="All"></Argument><Argument Name="ItemId" Value="#"></Argument><Argument Name="IdType" Value="ASIN"></Argument><Argument Name="AWSAccessKeyId" Value="#"></Argument><Argument Name="Timestamp" Value="2013-02-17T13:28:56.894Z"></Argument><Argument Name="ResponseGroup" Value="Offers"></Argument></Arguments><RequestProcessingTime>0.0260140000000000</RequestProcessingTime></OperationRequest><Items><Request><IsValid>True</IsValid><ItemLookupRequest><IdType>ASIN</IdType><MerchantId>Deprecated</MerchantId><ItemId>#</ItemId><ResponseGroup>Offers</ResponseGroup><VariationPage>All</VariationPage></ItemLookupRequest></Request><Item><ASIN>#</ASIN><OfferSummary><LowestNewPrice><Amount>3804</Amount><CurrencyCode>USD</CurrencyCode><FormattedPrice>$38.04</FormattedPrice></LowestNewPrice><TotalNew>1</TotalNew><TotalUsed>0</TotalUsed><TotalCollectible>0</TotalCollectible><TotalRefurbished>0</TotalRefurbished></OfferSummary><Offers><TotalOffers>1</TotalOffers><TotalOfferPages>1</TotalOfferPages><MoreOffersUrl>#</MoreOffersUrl><Offer><OfferAttributes><Condition>New</Condition></OfferAttributes><OfferListing><OfferListingId>#</OfferListingId><Price><Amount>3804</Amount><CurrencyCode>USD</CurrencyCode><FormattedPrice>$38.04</FormattedPrice></Price><AmountSaved><Amount>1596</Amount><CurrencyCode>USD</CurrencyCode><FormattedPrice>$15.96</FormattedPrice></AmountSaved><PercentageSaved>30</PercentageSaved><Availability>Usually ships in 10 to 13 weeks</Availability><AvailabilityAttributes><AvailabilityType>now</AvailabilityType><MinimumHours>1824</MinimumHours><MaximumHours>2088</MaximumHours></AvailabilityAttributes><IsEligibleForSuperSaverShipping>1</IsEligibleForSuperSaverShipping></OfferListing></Offer></Offers></Item></Items></ItemLookupResponse>

推荐答案

38.04 < / FormattedPrice > < / LowestNewPrice > < TotalNew > 1 < / TotalNew > < TotalUsed > 0 < / TotalUsed > < TotalCollectible > 0 < / TotalCollectible > < TotalRefurbished > 0 < / TotalRefurbished > < / OfferSummary > < 优惠 > < TotalOffers > 1 < / TotalOffers > < TotalOfferPages > 1 < / TotalOfferPages > < MoreOffersUrl > ＃< / MoreOffersUrl > < 优惠 > < OfferAttributes > < span class =code-keyword>< 条件 > 新< /条件 > < / OfferAttributes > < 商品列表 > < OfferListingId > ＃< / OfferListingId > < 价格 > < 金额 > 3804 < / Amount > < CurrencyCode > USD < / CurrencyCode > < FormattedPrice >

38.04</FormattedPrice></LowestNewPrice><TotalNew>1</TotalNew><TotalUsed>0</TotalUsed><TotalCollectible>0</TotalCollectible><TotalRefurbished>0</TotalRefurbished></OfferSummary><Offers><TotalOffers>1</TotalOffers><TotalOfferPages>1</TotalOfferPages><MoreOffersUrl>#</MoreOffersUrl><Offer><OfferAttributes><Condition>New</Condition></OfferAttributes><OfferListing><OfferListingId>#</OfferListingId><Price><Amount>3804</Amount><CurrencyCode>USD</CurrencyCode><FormattedPrice>

38.04 < / FormattedPrice > < / Price > < AmountSaved > < 金额 > 1596 < / Amount > < CurrencyCode > USD < / CurrencyCode > < FormattedPrice >

38.04</FormattedPrice></Price><AmountSaved><Amount>1596</Amount><CurrencyCode>USD</CurrencyCode><FormattedPrice>

15.96 < / FormattedPrice > < / AmountSaved > < PercentageSaved > 30 < / PercentageSaved > ; < 可用性 > 通常在10到13周内发货< /可用性 > < AvailabilityAttributes > < 可用性类型 > 现在< / AvailabilityType > < MinimumHours > 1824 < / MinimumHours > < ; MaximumHours > 2088 < / MaximumHours > < / AvailabilityAttributes > < < span class =code-leadattribute> IsEligibleForSuperSaverShipping > 1 < / IsEligibleForSuperSaverShipping > < / OfferListing > < / Offer > < /优惠 > < / Item > < / Items > < / ItemLookupResponse < span class =code-keyword>>

15.96</FormattedPrice></AmountSaved><PercentageSaved>30</PercentageSaved><Availability>Usually ships in 10 to 13 weeks</Availability><AvailabilityAttributes><AvailabilityType>now</AvailabilityType><MinimumHours>1824</MinimumHours><MaximumHours>2088</MaximumHours></AvailabilityAttributes><IsEligibleForSuperSaverShipping>1</IsEligibleForSuperSaverShipping></OfferListing></Offer></Offers></Item></Items></ItemLookupResponse>

这篇关于格式化Amazon XML的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！