本文介绍了格式化Amazon XML的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧! 问题描述 29岁程序员,3月因学历无情被辞! 如何使用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>推荐答案 这篇关于格式化Amazon XML的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持! 上岸,阿里云!
08-20 18:45