Making it Cool - Creating a Mashup in Open Web Studio - Part 6 of 6 - Issue 48
Last Post 11/21/2011 1:17 AM by cujo100. 3 Replies.
Author Messages
Lee Sykes
DNN Creative Staff
Nuke Master VI
Nuke Master VI
Posts:4945


--
09/01/2009 12:42 PM
    Lee Sykes
    Site Administrator
    Subscribe to the website : DotNetNuke Video Tutorials : The Skinning Toolkit : DotNetNuke Podcasts

    Twitter: www.twitter.com/DNNCreative

    Lee Sykes's Facebook Profile
    Mark Stouffer
    Nuke Newbie
    Nuke Newbie
    Posts:2


    --
    03/03/2010 5:00 PM
    Lee, I am having trouble finding documentation on how to form the parsing statement in a RESTfull API call. Currently I am using Ebay and I need to pull the fields from the nodes in the data below. I had to use JSON instead of XML but it looks like the path is specified the same way. I will be looking at the findItemsByCategoryResponse>searchResult>item. I will be reading about five fields from the item node. How do I specify the fields in the item node?

    {"findItemsByCategoryResponse":[
    {"ack":["Success"],"version":["1.3.0"],"timestamp":["2010-03-03T23:15:43.117Z"],
    "searchResult":[{"@count":"2","item":[
    {"itemId":["250534186469"],
    " le":["Intermediate level A major Chinese flute\/ xiao\/ Beixiao"],
    "globalId":["EBAY-US"],"primaryCategory":[{"categoryId":["10183"],"categoryName":["Flute"]}],
    "galleryURL":["http:\/\/thumbs2.ebaystatic.com\/pict\/2505341864698080_8.jpg"],
    "viewItemURL":["http:\/\/cgi.ebay.com\/Intermediate-level-A-major-Chinese-flute-xiao-Beixiao_W0QQitemZ250534186469QQcmdZViewItemQQptZLH_DefaultDomain_0?hash=item3a55004de5"],
    "paymentMethod":["PayPal"],
    "autoPay":["false"],
    "location":["Hong Kong"],
    "country":["HK"],
    "shippingInfo":[{"shippingServiceCost":[{"@currencyId":"USD","__value__":"12.0"}],
    "shippingType":["Flat"],"shipToLocations":["Worldwide"]}],
    "sellingStatus":[{"currentPrice":[{"@currencyId":"USD","__value__":"21.0"}],"convertedCurrentPrice":[{"@currencyId":"USD","__value__":"21.0"}],"sellingState":["Active"],"timeLeft":["P17DT2H41M58S"]}],"listingInfo":[{"bestOfferEnabled":["false"],"buyItNowAvailable":["false"],"startTime":["2009-11-21T01:52:41.000Z"],"endTime":["2010-03-21T01:57:41.000Z"],"listingType":["FixedPrice"],"gift":["false"]}]},
    {"itemId":["170451948724"],
    " le":["Wooden tenor recorder Schreiber w\/carry case"],
    "globalId":["EBAY-US"],"primaryCategory":[{"categoryId":["16230"],"categoryName":["Recorder"]}],
    "galleryURL":["http:\/\/thumbs1.ebaystatic.com\/pict\/1704519487248080_1.jpg"],
    "viewItemURL":["http:\/\/cgi.ebay.com\/Wooden-tenor-recorder-Schreiber-w-carry-case_W0QQitemZ170451948724QQcmdZViewItemQQptZLH_DefaultDomain_0?hash=item27afba54b4"],
    "paymentMethod":["PayPal"],"autoPay":["false"],"postalCode":["30359"],"location":["Atlanta,GA,USA"],"country":["US"],"shippingInfo":[{"shippingType":["Calculated"],"shipToLocations":["US"]}],"sellingStatus":[{"currentPrice":[{"@currencyId":"USD","__value__":"52.0"}],"convertedCurrentPrice":[{"@currencyId":"USD","__value__":"52.0"}],"bidCount":["8"],"sellingState":["Active"],"timeLeft":["P0DT0H2M21S"]}],"listingInfo":[{"bestOfferEnabled":["false"],"buyItNowAvailable":["false"],"startTime":["2010-02-26T23:18:04.000Z"],"endTime":["2010-03-03T23:18:04.000Z"],"listingType":["Auction"],"gift":["false"]}]}]}],"paginationOutput":[{"pageNumber":["1"],"entriesPerPage":["2"],"totalPages":["7816"],"totalEntries":["15632"]}]}]}
    cujo100
    Nuke Newbie
    Nuke Newbie
    Posts:2


    --
    11/21/2011 1:01 AM
    Thanks for the OWS Tutorials. They are very helpful.

    I am stuck on Video 3 where you create an Assignment Action for the Query. You mention that you set the Action to concatenate however the current version doesn't have that specific setting. The options I have are Assign, Append, Prepend and Increment. I assume Append and Prepend are just different approaches to Concatenate however they lock up my query (which is only 200 records). Am I missing something?

    Thanks,
    Joe
    cujo100
    Nuke Newbie
    Nuke Newbie
    Posts:2


    --
    11/21/2011 1:17 AM
    Never mind, it was a browser memory issue. The code is fine with Append or Prepend.


    ---