Apr 9, 2016 01:26 PM
(This post was last modified: Apr 26, 2016 08:41 PM by ♠ɪᴄᴇ♠.)
I have a long JSON string with amazon wishlist products that I get from a wishlist api. How can I convert it into a table with the values of "name", "new-price", and the picture in each table ("picture"). An example of how a string could look is like the following (from the api developer's wishlist):
Have been trying to figure this out for a few hours if someone could please help
Code
[{"num":1,"name":"Hanes Men's 12 Pack Ankle Socks, Black, 10-13\/Shoe Size 6-12","link":"http:\/\/www.amazon.com\/dp\/B00IO9H6QU\/ref=wl_it_dp_v_nS_ttl\/176-1765712-6336962?_encoding=UTF8&colid=37XI10RRD17X2&coliid=I2FPYGUEYAL1LI&psc=1","old-price":"N\/A","new-price":"$9.96","date-added":"March 25, 2016","priority":"","rating":"N\/A","total-ratings":"","comment":"","picture":"http:\/\/ecx.images-amazon.com\/images\/I\/41rL6yXNtbL._SL500_SL135_.jpg","page":1,"ASIN":"B00IO9H6QU","large-ssl-image":"https:\/\/images-eu.ssl-images-amazon.com\/images\/I\/41rL6yXNtbL._SL500_SL1350_.jpg","affiliate-url":"http:\/\/www.amazon.com\/dp\/B00IO9H6QU\/ref=nosim?tag="},{"num":2,"name":"Hanes Men`s Full Cushion Ankle Socks 12-Pack, 10-13 Sock\/6-12 Shoe, Black","link":"http:\/\/www.amazon.com\/dp\/B00RN9MM48\/ref=wl_it_dp_v_nS_ttl\/176-1765712-6336962?_encoding=UTF8&colid=37XI10RRD17X2&coliid=I3HZYA61TICQ8Z&psc=1","old-price":"N\/A","new-price":"$15.48","date-added":"March 25, 2016","priority":"","rating":"N\/A","total-ratings":"","comment":"","picture":"http:\/\/ecx.images-amazon.com\/images\/I\/51XjskrZydL._SL500_SL135_.jpg","page":1,"ASIN":"B00RN9MM48","large-ssl-image":"https:\/\/images-eu.ssl-images-amazon.com\/images\/I\/51XjskrZydL._SL500_SL1350_.jpg","affiliate-url":"http:\/\/www.amazon.com\/dp\/B00RN9MM48\/ref=nosim?tag="},{"num":3,"name":"Dickies Men's 6 Pack Dri-Tech Comfort Crew Socks, Black\/Grey, 10-13 Sock\/6-12 Shoe","link":"http:\/\/www.amazon.com\/dp\/B004QF0TFQ\/ref=wl_it_dp_v_nS_ttl\/176-1765712-6336962?_encoding=UTF8&colid=37XI10RRD17X2&coliid=I1T7T1C6R9AMCF&psc=1","old-price":"N\/A","new-price":"$12.99","date-added":"March 25, 2016","priority":"","rating":"N\/A","total-ratings":"","comment":"","picture":"http:\/\/ecx.images-amazon.com\/images\/I\/41X%2BcYzzpRL._SL500_SL135_.jpg","page":1,"ASIN":"B004QF0TFQ","large-ssl-image":"https:\/\/images-eu.ssl-images-amazon.com\/images\/I\/41X%2BcYzzpRL._SL500_SL1350_.jpg","affiliate-url":"http:\/\/www.amazon.com\/dp\/B004QF0TFQ\/ref=nosim?tag="},{"num":4,"name":"James Fiallo Mens 12 Pack Colorful Patterned Dress Socks M5800,\nFits shoe size 6-12 (sock size 10-13)","link":"http:\/\/www.amazon.com\/dp\/B00S9WXAXA\/ref=wl_it_dp_v_nS_ttl\/176-1765712-6336962?_encoding=UTF8&colid=37XI10RRD17X2&coliid=IUXSPN0II60J7&psc=1","old-price":"N\/A","new-price":"$29.99","date-added":"March 25, 2016","priority":"","rating":"N\/A","total-ratings":"","comment":"","picture":"http:\/\/ecx.images-amazon.com\/images\/I\/511DWhNeFSL._SL500_SL135_.jpg","page":1,"ASIN":"B00S9WXAXA","large-ssl-image":"https:\/\/images-eu.ssl-images-amazon.com\/images\/I\/511DWhNeFSL._SL500_SL1350_.jpg","affiliate-url":"http:\/\/www.amazon.com\/dp\/B00S9WXAXA\/ref=nosim?tag="},{"num":5,"name":"Regal Entertainment Gift Card $25","link":"http:\/\/www.amazon.com\/dp\/B00AS527QW\/ref=wl_it_dp_v_nS_ttl\/176-1765712-6336962?_encoding=UTF8&colid=37XI10RRD17X2&coliid=INWRZTBP35ZW3&psc=1","old-price":"N\/A","new-price":"$25.00","date-added":"March 21, 2016","priority":"","rating":"N\/A","total-ratings":"197","comment":"","picture":"http:\/\/ecx.images-amazon.com\/images\/I\/51slBAevBvL._SL500_SL135_.jpg","page":1,"ASIN":"B00AS527QW","large-ssl-image":"https:\/\/images-eu.ssl-images-amazon.com\/images\/I\/51slBAevBvL._SL500_SL1350_.jpg","affiliate-url":"http:\/\/www.amazon.com\/dp\/B00AS527QW\/ref=nosim?tag="},{"num":6,"name":"Songmics 50 Feet Expandable Retractable Garden Hose Set Watering Hose Car Wash 8 Setting Sprayer Anti-Rust Hose Holder Included Lightweight Never Kink UGGH50L","link":"http:\/\/www.amazon.com\/dp\/B01BYANS6W\/ref=wl_it_dp_v_nS_ttl\/176-1765712-6336962?_encoding=UTF8&colid=37XI10RRD17X2&coliid=I1DEBCYP7M037H&psc=1","old-price":"N\/A","new-price":"$25.99","date-added":"March 16, 2016","priority":"","rating":"N\/A","total-ratings":"","comment":"","picture":"http:\/\/ecx.images-amazon.com\/images\/I\/5157XXw44xL._SL500_SL135_.jpg","page":1,"ASIN":"B01BYANS6W","large-ssl-image":"https:\/\/images-eu.ssl-images-amazon.com\/images\/I\/5157XXw44xL._SL500_SL1350_.jpg","affiliate-url":"http:\/\/www.amazon.com\/dp\/B01BYANS6W\/ref=nosim?tag="},{"num":7,"name":"Converse Chuck Taylor All Star Core Low Top Charcoal 1J794 Mens 11","link":"http:\/\/www.amazon.com\/dp\/B00ZQ37NCY\/ref=wl_it_dp_v_S_ttl\/176-1765712-6336962?_encoding=UTF8&colid=37XI10RRD17X2&coliid=I38S0G4QOUKIK9&psc=1","old-price":"N\/A","new-price":"$57.40","date-added":"March 16, 2016","priority":"","rating":"N\/A","total-ratings":"","comment":"","picture":"http:\/\/ecx.images-amazon.com\/images\/I\/41mVTccKvmL._SL500_SL135_.jpg","page":1,"ASIN":"B00ZQ37NCY","large-ssl-image":"https:\/\/images-eu.ssl-images-amazon.com\/images\/I\/41mVTccKvmL._SL500_SL1350_.jpg","affiliate-url":"http:\/\/www.amazon.com\/dp\/B00ZQ37NCY\/ref=nosim?tag="},{"num":8,"name":"Fruit of the Loom Men's Tag Free Boxer Brief (Pack of 7), Assorted, Medium","link":"http:\/\/www.amazon.com\/dp\/B00IPKNIGU\/ref=wl_it_dp_v_nS_ttl\/176-1765712-6336962?_encoding=UTF8&colid=37XI10RRD17X2&coliid=I118BVGAN6LI0D&psc=1","old-price":"N\/A","new-price":"$27.24","date-added":"March 15, 2016","priority":"","rating":"N\/A","total-ratings":"","comment":"","picture":"http:\/\/ecx.images-amazon.com\/images\/I\/41GLFdTedjL._SL500_SL135_.jpg","page":1,"ASIN":"B00IPKNIGU","large-ssl-image":"https:\/\/images-eu.ssl-images-amazon.com\/images\/I\/41GLFdTedjL._SL500_SL1350_.jpg","affiliate-url":"http:\/\/www.amazon.com\/dp\/B00IPKNIGU\/ref=nosim?tag="},{"num":9,"name":"Fruit of the Loom Men's Boxer Brief (Medium, Assorted)(Pack of 7)","link":"http:\/\/www.amazon.com\/dp\/B00817EA82\/ref=wl_it_dp_v_nS_ttl\/176-1765712-6336962?_encoding=UTF8&colid=37XI10RRD17X2&coliid=IOE8MG87CA2B2&psc=1","old-price":"N\/A","new-price":"$24.95","date-added":"March 15, 2016","priority":"","rating":"N\/A","total-ratings":"","comment":"","picture":"http:\/\/ecx.images-amazon.com\/images\/I\/41FgkkVX4XL._SL500_SL135_.jpg","page":1,"ASIN":"B00817EA82","large-ssl-image":"https:\/\/images-eu.ssl-images-amazon.com\/images\/I\/41FgkkVX4XL._SL500_SL1350_.jpg","affiliate-url":"http:\/\/www.amazon.com\/dp\/B00817EA82\/ref=nosim?tag="},{"num":10,"name":"Klymit Insulated Static V Sleeping Pad, Orange\/Char Black","link":"http:\/\/www.amazon.com\/dp\/B00ANRW7DI\/ref=wl_it_dp_v_nS_ttl\/176-1765712-6336962?_encoding=UTF8&colid=37XI10RRD17X2&coliid=I10LO1D3PPG4SR&psc=1","old-price":"N\/A","new-price":"$64.95","date-added":"March 15, 2016","priority":"","rating":"N\/A","total-ratings":"","comment":"","picture":"http:\/\/ecx.images-amazon.com\/images\/I\/41iiIQ1YF1L._SL500_SL135_.jpg","page":1,"ASIN":"B00ANRW7DI","large-ssl-image":"https:\/\/images-eu.ssl-images-amazon.com\/images\/I\/41iiIQ1YF1L._SL500_SL1350_.jpg","affiliate-url":"http:\/\/www.amazon.com\/dp\/B00ANRW7DI\/ref=nosim?tag="}]Have been trying to figure this out for a few hours if someone could please help
![[Image: YolfK0b.jpg]](https://i.imgur.com/YolfK0b.jpg)



![[Image: X1okWX9.png]](https://i.imgur.com/X1okWX9.png)