select statement for JSON in SQL Server 2016

  • Hi All,

             My JSON data is

    { "resultCount":50, "results": [ {"isGameCenterEnabled":false, "ipadScreenshotUrls":["http://a5.mzstatic.com/eu/r30/Purple62/v4/bf/8a/6d/bf8a6d49-e8bd-78dc-97e2-cb4201d89581/sc552x414.jpeg", "http://a1.mzstatic.com/eu/r30/Purple62/v4/fe/31/ae/fe31aef9-2bd5-025f-7a3c-c72bc4337c0d/sc552x414.jpeg", "http://a5.mzstatic.com/eu/r30/Purple71/v4/8f/ee/cc/8feecc13-a3d7-dbbf-594a-411928cb2a0d/sc552x414.jpeg", "http://a1.mzstatic.com/eu/r30/Purple71/v4/c1/4a/d6/c14ad6b7-bc6a-c1db-d1c0-9930a644e1c6/sc552x414.jpeg"], "appletvScreenshotUrls":[], "artworkUrl60":"http://is3.mzstatic.com/image/thumb/Purple122/v4/01/e5/0c/01e50c2d-9ac1-1fc5-a106-686a13f23a60/source/60x60bb.jpg", "artworkUrl512":"http://is3.mzstatic.com/image/thumb/Purple122/v4/01/e5/0c/01e50c2d-9ac1-1fc5-a106-686a13f23a60/source/512x512bb.jpg", "artworkUrl100":"http://is3.mzstatic.com/image/thumb/Purple122/v4/01/e5/0c/01e50c2d-9ac1-1fc5-a106-686a13f23a60/source/100x100bb.jpg", "artistViewUrl":"https://itunes.apple.com/gb/developer/playdemic/id505151958?uo=4", "kind":"software", "features":["iosUniversal"], "supportedDevices":["iPhone4-iPhone4", "iPad2Wifi-iPad2Wifi", "iPad23G-iPad23G", "iPhone4S-iPhone4S", "iPadThirdGen-iPadThirdGen", "iPadThirdGen4G-iPadThirdGen4G", "iPhone5-iPhone5", "iPodTouchFifthGen-iPodTouchFifthGen", "iPadFourthGen-iPadFourthGen", "iPadFourthGen4G-iPadFourthGen4G", "iPadMini-iPadMini", "iPadMini4G-iPadMini4G", "iPhone5c-iPhone5c", "iPhone5s-iPhone5s", "iPadAir-iPadAir", "iPadAirCellular-iPadAirCellular", "iPadMiniRetina-iPadMiniRetina", "iPadMiniRetinaCellular-iPadMiniRetinaCellular", "iPhone6-iPhone6", "iPhone6Plus-iPhone6Plus", "iPadAir2-iPadAir2", "iPadAir2Cellular-iPadAir2Cellular", "iPadMini3-iPadMini3", "iPadMini3Cellular-iPadMini3Cellular", "iPodTouchSixthGen-iPodTouchSixthGen", "iPhone6s-iPhone6s", "iPhone6sPlus-iPhone6sPlus", "iPadMini4-iPadMini4", "iPadMini4Cellular-iPadMini4Cellular", "iPadPro-iPadPro", "iPadProCellular-iPadProCellular", "iPadPro97-iPadPro97", "iPadPro97Cellular-iPadPro97Cellular", "iPhoneSE-iPhoneSE", "iPhone7-iPhone7", "iPhone7Plus-iPhone7Plus"], "screenshotUrls":["http://a5.mzstatic.com/eu/r30/Purple62/v4/0a/69/12/0a69121c-eeeb-964f-f800-96461e95005b/screen406x722.jpeg", "http://a4.mzstatic.com/eu/r30/Purple71/v4/16/c1/1e/16c11ed3-bbd5-91fe-c3bf-b5fdb28aae75/screen406x722.jpeg", "http://a3.mzstatic.com/eu/r30/Purple62/v4/8f/62/f7/8f62f78a-7ef7-7ba4-fa6d-03778316c4f9/screen406x722.jpeg"], "advisories":[], "averageUserRatingForCurrentVersion":4.5, "trackCensoredName":"Village Life: Love, Marriage and Babies", "languageCodesISO2A":["EN", "FR", "DE", "IT", "JA", "PT", "ES", "TR"], "fileSizeBytes":"502828032", "sellerUrl":"http://www.playdemic.com/", "contentAdvisoryRating":"4+", "userRatingCountForCurrentVersion":559, "trackViewUrl":"https://itunes.apple.com/gb/app/village-life-love-marriage-and-babies/id616655687?mt=8&uo=4", "trackContentRating":"4+", "minimumOsVersion":"7.0", "currency":"GBP", "wrapperType":"software", "version":"2.6.9", "description":"START YOUR FAMILY TODAY!\n\nPlay the smash hit game played by over 15 million people!\n\nGuide your villagers through life from babies to adulthood helping them fall in love, date, get married and grow old with families of their own. Find food, craft tools, toys and buildings to create a thriving, happy village then expand to exciting new lands!\n\nAND THERE’S MORE! - Enjoy specially crafted one-off stories regularly added to the game that bring continued fresh twists and turns to the lives of your villagers.\n\nFEATURES:\n• Find LOVE and set up dates with your friends’ villagers.\n• Watch your villagers get MARRIED.\n• Have lots of BABIES and name them!\n• Raise FAMILIES and track relationships using the family tree.\n• Add Collectable villagers to your Villager. There are hundreds of unique villagers for you to collect, each offering bonus skills and attributes.\n• Form a new tribe and JOURNEY to exciting new lands.\n• Impress your friends and DECORATE a beautiful village.\n• Pass SKILLS to future generations of villagers and add more.\n• Keep your villagers fed by FARMING, FISHING and GATHERING food.\n• CRAFT toys and activities then watch your villagers use them in hilariously different ways.\n• Enjoy specially crafted STORIES regularly added by the game creators.\n• Chat with friends and the community, in our chat feature\n \nPlease note that Village Life is completely free to play, but some items such as gems can be purchased for real money. If you don’t want to use this feature, you can disable in-app purchases in your device’s settings. A network connection is required to play.\n\n** This game is compatible with devices on iOS 7.0 and above. Play across all supported devices – iPhone 4S, iPhone 5, iPhone 5C, iPhone 5S, iPhone SE, iPhone 6, iPhone 6 plus, iPhone 7, iPhone 7 plus, iPad 2, iPad 3, iPad 4, iPad Mini, iPad Air, iPad Air 2, iPad Pro and iPod 5. **", "artistId":505151958, "artistName":"Playdemic", "genres":["Games", "Adventure", "Entertainment", "Simulation"], "price":0.00, "trackId":616655687, "trackName":"Village Life: Love, Marriage and Babies", "bundleId":"com.playdemic.village", "primaryGenreName":"Games", "isVppDeviceBasedLicensingEnabled":true, "releaseDate":"2013-10-01T07:00:00Z", "primaryGenreId":6014, "sellerName":"Playdemic Ltd", "genreIds":["6014", "7002", "6016", "7015"], "currentVersionReleaseDate":"2017-03-02T08:55:49Z", "releaseNotes":"Our latest update introduces the all new Villager Compendium, making Village Life even more fun and addictive to play! Will you manage to complete your collection? \n\nWhat’s new:\n• All new Villager Compendium, with over 145 Villagers to collect!\n• Villager Shop, allowing you to get the villagers missing from your collection. \n• Villagers awarded from completing stories now have the correct star rating, attributes and also contribute to your Villager Compendium! *\n\nWe’ve also been busy fixing many more bugs!\n\n* Villagers awarded prior to the update will be collected in the Villager Compendium. However, they will not have their star rating or attributes updated.", "formattedPrice":"Free", "averageUserRating":4.5, "userRatingCount":32864}, {"isGameCenterEnabled":false, "ipadScreenshotUrls":["http://a4.mzstatic.com/eu/r30/Purple22/v4/a5/dc/bd/a5dcbd7b-702b-d9f3-b2e3-3491d042d2f3/sc552x414.jpeg"], "appletvScreenshotUrls":[], "artworkUrl60":"http://is4.mzstatic.com/image/thumb/Purple91/v4/6b/4c/51/6b4c51f5-fee1-3998-f047-360bee309f71/source/60x60bb.jpg", "artworkUrl512":"http://is4.mzstatic.com/image/thumb/Purple91/v4/6b/4c/51/6b4c51f5-fee1-3998-f047-360bee309f71/source/512x512bb.jpg", "artworkUrl100":"http://is4.mzstatic.com/image/thumb/Purple91/v4/6b/4c/51/6b4c51f5-fee1-3998-f047-360bee309f71/source/100x100bb.jpg", "artistViewUrl":"https://itunes.apple.com/gb/developer/finderly/id557153161?uo=4", "kind":"software", "features":["iosUniversal"], "supportedDevices":["iPad2Wifi-iPad2Wifi", "iPad23G-iPad23G", "iPhone4S-iPhone4S", "iPadThirdGen-iPadThirdGen", "iPadThirdGen4G-iPadThirdGen4G", "iPhone5-iPhone5", "iPodTouchFifthGen-iPodTouchFifthGen", "iPadFourthGen-iPadFourthGen", "iPadFourthGen4G-iPadFourthGen4G", "iPadMini-iPadMini", "iPadMini4G-iPadMini4G", "iPhone5c-iPhone5c", "iPhone5s-iPhone5s", "iPadAir-iPadAir", "iPadAirCellular-iPadAirCellular", "iPadMiniRetina-iPadMiniRetina", "iPadMiniRetinaCellular-iPadMiniRetinaCellular", "iPhone6-iPhone6", "iPhone6Plus-iPhone6Plus", "iPadAir2-iPadAir2", "iPadAir2Cellular-iPadAir2Cellular", "iPadMini3-iPadMini3", "iPadMini3Cellular-iPadMini3Cellular", "iPodTouchSixthGen-iPodTouchSixthGen", "iPhone6s-iPhone6s", "iPhone6sPlus-iPhone6sPlus", "iPadMini4-iPadMini4", "iPadMini4Cellular-iPadMini4Cellular", "iPadPro-iPadPro", "iPadProCellular-iPadProCellular", "iPadPro97-iPadPro97", "iPadPro97Cellular-iPadPro97Cellular", "iPhoneSE-iPhoneSE", "iPhone7-iPhone7", "iPhone7Plus-iPhone7Plus"], "screenshotUrls":["http://a3.mzstatic.com/eu/r30/Purple62/v4/93/69/76/936976dd-1949-94ea-057a-94e5356c18e6/screen696x696.jpeg", "http://a2.mzstatic.com/eu/r30/Purple71/v4/66/10/69/66106991-53e0-0a06-2117-fe1b64ac4e19/screen696x696.jpeg", "http://a4.mzstatic.com/eu/r30/Purple71/v4/9b/80/87/9b8087a8-b3ef-f461-a8d3-0bd46d8d39dc/screen696x696.jpeg", "http://a1.mzstatic.com/eu/r30/Purple71/v4/0a/dc/e5/0adce561-71d3-5c70-d058-5ab6aacff509/screen696x696.jpeg", "http://a2.mzstatic.com/eu/r30/Purple71/v4/01/ed/14/01ed14d0-ee63-e155-ce1f-daea9be0ea36/screen696x696.jpeg"], "advisories":["Infrequent/Mild Mature/Suggestive Themes", "Infrequent/Mild Sexual Content and Nudity", "Infrequent/Mild Cartoon or Fantasy Violence"], "averageUserRatingForCurrentVersion":4.5, "trackCensoredName":"Shpock Boot Sale & Classifieds App. Buy & Sell", "languageCodesISO2A":["EN", "FR", "DE", "IT", "NB", "SV"], "fileSizeBytes":"85765120", "sellerUrl":"http://www.shpock.com/en/", "contentAdvisoryRating":"12+", "userRatingCountForCurrentVersion":29, "trackViewUrl":"https://itunes.apple.com/gb/app/shpock-boot-sale-classifieds-app-buy-sell/id557153158?mt=8&uo=4", "trackContentRating":"12+", "minimumOsVersion":"8.0", "currency":"GBP", "wrapperType":"software", "version":"3.9.2", "description":"If you like strolling around flea markets and boot sales on weekends or spending hours browsing through classifieds, you will love Shpock. With Shpock you'll find the most beautiful things in your neighbourhood and sell your things quickly to other people around you. Whether second hand, used, antique or simply beautiful, Shpock is always there as the SHop in your POCKet. \n\nShpock is a 24/7 market, full of pictures of the most beautiful classifieds around you. It is the second hand shop on your smartphone and makes buying and selling extremely simple and fun. \n\nWHY USE SHPOCK: \n\n▶ A BOOT SALE FULL OF TREASURES: start Shpock and immediately discover beautiful things from friends and neighbours around you - sorted by distance or one of your favourite categories (Fashion and Accessories; Home and Garden; Electronics; Movies, Books and Music; Baby and Child; Sport, Leisure and Games; Cars and Motors) \n\n▶ POST YOUR OFFER IN 30 SECONDS: take a photo, add a title, description and price, and instantly everyone around you will find your local treasure.\n\n▶ IT’S FREE, NO FEES ATTACHED: sell and buy for free, no listing fees, no transaction fees. And if you want to promote your item even more prominently, you can buy some additional premium features.\n\n▶ A PICTURE IS WORTH A ...: Classifieds with lots of text are boring! Add or take a nice picture in seconds and let Shpock do the rest. \n\n▶ SPREAD THE BEAUTY: Share your offers or great items from others easily with Facebook, Twitter, SMS and email. Your friends (and their friends) are surely looking for beautiful things. \n\n▶ EASY REGISTRATION: A few simple taps on the screen and you are registered via Facebook or E-mail. Why Facebook? Because we believe that it helps to stop annoying spammers and scammers. This is also the reason why we ask for a SMS-confirmation if you register via e-mail. Your data will not be shared with third parties. \n\n▶ YOUR PRIVACY IS SACRED: \n- We only ask for data we really need for a great experience. \n- We transparently explain the purpose for which your data is processed in our Privacy Policy. \n- Item locations are always offset from their real location. \n- Still not sure? Contact us at support@shpock.com \n\nShpock is a young flea market, boot sale and classifieds app - name it however you like. We look forward to your feedback and your questions, comments, requests at support@shpock.com via email or @shpock via twitter. \nIf you like apps like ebay, gumtree or craigslist you should definitely give Shpock (the boot sale and classifieds app for beautiful things) a try!\n\n“Amazing App!! I can finally hunt for treasures whilst in my pjs on the sofa! Love this app. I’m really addicted to it :)”\nby Faye_HTD, 5 Stars\n\n“Love this app. Well this is a rare gem but I don’t think it will stay hidden for long. What a great way to buy and sell, silly simple and really good bargains. I have bought and sold and transactions have all gone smoothly. Love it.”\nby WitchyWench, 5 Stars\n\nShould you choose to upgrade to a Premium Membership, payment will be charged to your iTunes account at confirmation of purchase. We offer three types of subscription intervals (the price may vary by location): monthly subscription = £8.49, 6-month subscription = £42.99, and yearly subscription = £60.99.\n\nYour Shpock subscription automatically renews unless auto-renew is turned off at least 24 hours prior to the end of the current period. Auto-renewal may be turned off in your Account Settings in iTunes after purchase. No cancellation of the current subscription is allowed during an active subscription period. You can also manage your subscriptions in Account Settings after purchase.\n\nTerms of service: http://shpock.com/int/terms/\nPrivacy policy: http://shpock.com/int/privacy/", "artistId":557153161, "artistName":"finderly", "genres":["Shopping", "Lifestyle"], "price":0.00, "trackId":557153158, "trackName":"Shpock Boot Sale & Classifieds App. Buy & Sell", "bundleId":"com.finderly.shpock", "primaryGenreName":"Shopping", "isVppDeviceBasedLicensingEnabled":true, "releaseDate":"2012-09-18T12:44:05Z", "primaryGenreId":6024, "sellerName":"finderly GmbH", "genreIds":["6024", "6012"], "currentVersionReleaseDate":"2017-03-20T17:40:38Z", "releaseNotes":"We are always listening to your feedback! In this update, we have made some bug fixes, design improvements, and performance enhancements. \n\nHappy Shpocking!\n\n<3 Shpock Team", "formattedPrice":"Free", "averageUserRating":4.5, "userRatingCount":7799}, {"isGameCenterEnabled":false, "ipadScreenshotUrls":[], "appletvScreenshotUrls":[], "artworkUrl60":"http://is4.mzstatic.com/image/thumb/Purple2/v4/1a/70/b6/1a70b696-0cb7-7bb9-a193-9999178239eb/source/60x60bb.jpg", "artworkUrl512":"http://is4.mzstatic.com/image/thumb/Purple2/v4/1a/70/b6/1a70b696-0cb7-7bb9-a193-9999178239eb/source/512x512bb.jpg", "artworkUrl100":"http://is4.mzstatic.com/image/thumb/Purple2/v4/1a/70/b6/1a70b696-0cb7-7bb9-a193-9999178239eb/source/100x100bb.jpg", "artistViewUrl":"https://itunes.apple.com/gb/developer/app-minis-llc/id383120516?uo=4", "kind":"software", "features":[], "supportedDevices":["iPhone3GS-iPhone-3GS", "iPadWifi-iPadWifi", "iPad3G-iPad3G", "iPodTouchThirdGen-iPodTouchThirdGen", "iPhone4-iPhone4", "iPodTouchFourthGen-iPodTouchFourthGen", "iPad2Wifi-iPad2Wifi", "iPad23G-iPad23G", "iPhone4S-iPhone4S", "iPadThirdGen-iPadThirdGen", "iPadThirdGen4G-iPadThirdGen4G", "iPhone5-iPhone5", "iPodTouchFifthGen-iPodTouchFifthGen", "iPadFourthGen-iPadFourthGen", "iPadFourthGen4G-iPadFourthGen4G", "iPadMini-iPadMini", "iPadMini4G-iPadMini4G", "iPhone5c-iPhone5c", "iPhone5s-iPhone5s", "iPadAir-iPadAir", "iPadAirCellular-iPadAirCellular", "iPadMiniRetina-iPadMiniRetina", "iPadMiniRetinaCellular-iPadMiniRetinaCellular", "iPhone6-iPhone6", "iPhone6Plus-iPhone6Plus", "iPadAir2-iPadAir2", "iPadAir2Cellular-iPadAir2Cellular", "iPadMini3-iPadMini3", "iPadMini3Cellular-iPadMini3Cellular", "iPodTouchSixthGen-iPodTouchSixthGen", "iPhone6s-iPhone6s", "iPhone6sPlus-iPhone6sPlus", "iPadMini4-iPadMini4", "iPadMini4Cellular-iPadMini4Cellular", "iPadPro-iPadPro", "iPadProCellular-iPadProCellular", "iPadPro97-iPadPro97", "iPadPro97Cellular-iPadPro97Cellular", "iPhoneSE-iPhoneSE", "iPhone7-iPhone7", "iPhone7Plus-iPhone7Plus"], "screenshotUrls":["http://a5.mzstatic.com/eu/r30/Purple/v4/e7/05/d9/e705d965-9ac3-6ec3-1b9a-f01647fd241e/screen320x480.jpeg", "http://a1.mzstatic.com/eu/r30/Purple/v4/29/83/57/29835700-6153-91c9-5ae9-551141823a87/screen320x480.jpeg", "http://a3.mzstatic.com/eu/r30/Purple/v4/82/ca/da/82cadaaf-769e-7dd4-0663-5610de699894/screen320x480.jpeg", "http://a3.mzstatic.com/eu/r30/Purple/v4/78/7f/8a/787f8ad3-7184-c8d3-5406-1c97a4f482ed/screen320x480.jpeg"], "advisories":[], "averageUserRatingForCurrentVersion":3.0, "trackCensoredName":"Talking Babies", "languageCodesISO2A":["EN"], "fileSizeBytes":"35743059", "sellerUrl":"http://www.appminis.com", "contentAdvisoryRating":"4+", "userRatingCountForCurrentVersion":12, "trackViewUrl":"https://itunes.apple.com/gb/app/talking-babies/id406331646?mt=8&uo=4", "trackContentRating":"4+", "minimumOsVersion":"4.3", "currency":"GBP", "wrapperType":"software", "version":"1.6.0", "description":"They dance! They repeat whatever you say in the cutest voice! Choose either a baby boy or baby girl!\n\nTalking Babies is fun for the whole family.\n\n\"The babies were so cute! Their dances were adorable and we couldn't stop laughing when it talked back to us!\"\n\nDances:\n\n- Breakdancing\n- Folk dance\n- Disco\n- Rock dance\n\n- Tickle Baby's stomach to make them giggle\n\nTalk into the microphone for Baby to repeat. Try using it on your favorite songs or videos!\n\n* 1G, 2G, 3G iPod Touch users must have earphones with a microphone for Baby to talk back to you *\n\nThis app is intended only for those age 13 and up and parents.\n\nPlease review our Privacy Policy and Terms of Service before playing:\nPrivacy Policy: http://www.appminis.com/privacy.htm\nTerms of Service: http://www.appminis.com/tos.htm", "artistId":383120516, "artistName":"App Minis LLC", "genres":["Entertainment", "Family", "Games"], "price":0.00, "trackId":406331646, "trackName":"Talking Babies", "bundleId":"com.appminis.talkingbabies", "primaryGenreName":"Entertainment", "isVppDeviceBasedLicensingEnabled":true, "releaseDate":"2011-01-15T20:01:29Z", "primaryGenreId":6016, "sellerName":"App Minis LLC", "genreIds":["6016", "7009", "6014"], "currentVersionReleaseDate":"2013-04-18T00:24:36Z", "releaseNotes":"General improvements and minor bugs fixing", "formattedPrice":"Free", "averageUserRating":2.5, "userRatingCount":2176}, {"isGameCenterEnabled":false, "ipadScreenshotUrls":["http://a5.mzstatic.com/eu/r30/Purple122/v4/1b/c8/64/1bc86420-ca1b-e4a1-f7a1-63fdaa375454/sc1024x768.jpeg", "http://a5.mzstatic.com/eu/r30/Purple122/v4/5a/5e/3b/5a5e3b96-0bf7-540d-3d2f-8a6e99894296/sc1024x768.jpeg", "http://a1.mzstatic.com/eu/r30/Purple122/v4/df/34/e3/df34e30e-535b-2159-b207-e1953248bb53/sc1024x768.jpeg", "http://a1.mzstatic.com/eu/r30/Purple122/v4/a9/74/8a/a9748ae0-ff43-0f37-f0d5-71f4183a89aa/sc1024x768.jpeg", "http://a2.mzstatic.com/eu/r30/Purple111/v4/26/9e/65/269e650c-176f-d941-7e87-d614393c7e72/sc1024x768.jpeg"], "appletvScreenshotUrls":[], "artworkUrl60":"http://is4.mzstatic.com/image/thumb/Purple111/v4/a3/80/65/a380659c-50d3-9661-97e5-6657360f6b00/source/60x60bb.jpg", "artworkUrl512":"http://is4.mzstatic.com/image/thumb/Purple111/v4/a3/80/65/a380659c-50d3-9661-97e5-6657360f6b00/source/512x512bb.jpg", "artworkUrl100":"http://is4.mzstatic.com/image/thumb/Purple111/v4/a3/80/65/a380659c-50d3-9661-97e5-6657360f6b00/source/100x100bb.jpg", "artistViewUrl":"https://itunes.apple.com/gb/developer/outfit7-limited/id351110111?uo=4", "kind":"software", "features":["iosUniversal"], "supportedDevices":["iPhone4-iPhone4", "iPad2Wifi-iPad2Wifi", "iPad23G-iPad23G", "iPhone4S-iPhone4S", "iPadThirdGen-iPadThirdGen", "iPadThirdGen4G-iPadThirdGen4G", "iPhone5-iPhone5", "iPodTouchFifthGen-iPodTouchFifthGen", "iPadFourthGen-iPadFourthGen", "iPadFourthGen4G-iPadFourthGen4G", "iPadMini-iPadMini", "iPadMini4G-iPadMini4G", "iPhone5c-iPhone5c", "iPhone5s-iPhone5s", "iPadAir-iPadAir", "iPadAirCellular-iPadAirCellular", "iPadMiniRetina-iPadMiniRetina", "iPadMiniRetinaCellular-iPadMiniRetinaCellular", "iPhone6-iPhone6", "iPhone6Plus-iPhone6Plus", "iPadAir2-iPadAir2", "iPadAir2Cellular-iPadAir2Cellular", "iPadMini3-iPadMini3", "iPadMini3Cellular-iPadMini3Cellular", "iPodTouchSixthGen-iPodTouchSixthGen", "iPhone6s-iPhone6s", "iPhone6sPlus-iPhone6sPlus", "iPadMini4-iPadMini4", "iPadMini4Cellular-iPadMini4Cellular", "iPadPro-iPadPro", "iPadProCellular-iPadProCellular", "iPadPro97-iPadPro97", "iPadPro97Cellular-iPadPro97Cellular", "iPhoneSE-iPhoneSE", "iPhone7-iPhone7", "iPhone7Plus-iPhone7Plus"], "screenshotUrls":["http://a3.mzstatic.com/eu/r30/Purple111/v4/d7/77/ed/d777edcb-4016-be5e-45c6-e53e7e412a33/screen696x696.jpeg", "http://a4.mzstatic.com/eu/r30/Purple111/v4/4b/d7/b3/4bd7b3ac-8802-60d4-074f-e26d034fbe19/screen696x696.jpeg", "http://a5.mzstatic.com/eu/r30/Purple111/v4/e6/af/dc/e6afdcfd-8d6e-e2c9-b3d7-0b2ea0ad1e99/screen696x696.jpeg", "http://a4.mzstatic.com/eu/r30/Purple111/v4/7d/69/20/7d692044-22ce-0835-dffb-565b7cecd82d/screen696x696.jpeg", "http://a2.mzstatic.com/eu/r30/Purple122/v4/1a/8c/f5/1a8cf589-a17f-7d72-71fe-f2a3dcdf2cc9/screen696x696.jpeg"], "advisories":[], "trackCensoredName":"My Talking Tom", "languageCodesISO2A":["AR", "EN", "FR", "DE", "IT", "JA", "KO", "PT", "RU", "ZH", "ES", "ZH", "TR"], "fileSizeBytes":"249842688", "sellerUrl":"http://outfit7.com/", "contentAdvisoryRating":"4+", "trackViewUrl":"https://itunes.apple.com/gb/app/my-talking-tom/id657500465?mt=8&uo=4", "trackContentRating":"4+", "minimumOsVersion":"7.0", "currency":"GBP", "wrapperType":"software", "version":"4.0.4", "description":"Discover the #1 games app in 135 countries! Adopt your very own baby kitten and help him grow into a fully grown cat. Name him and make him part of your daily life by feeding him, playing with him and nurturing him as he grows.\n\nDress him up any way you like and pick from a wide selection of fur colors and other accessories. Decorate his home and travel the world to meet other Toms. Play mini-games and watch as Talking Tom becomes part of your everyday life.\n\nFEATURES: \n- Play over 10 mini-games: Happy Connect, Bubble Shooter, Planet Hop and more! Earn gold coins and have fun! \n- Record & watch videos: Record and share your own My Talking Tom videos and watch other videos too.\n- Nurture your very own Tom: Play games with him, feed him his favorite foods, tuck him into bed. \n-Collect flight tickets and travel around the world to meet other Toms. Fill your album with postcards from different places and unlock clothes fit for a true adventurer.\n- Enjoy life-like emotions: Tom can be happy, hungry, sleepy, bored... his emotions change according to how you play with him. \n- Unleash your creativity: Create your very own Tom by choosing from 1000’s of combinations of furs, clothing and furniture. \n- Get rewards as you progress: Help Tom grow through 9 different stages and 999 levels unlocking new items and coins as you go! \n- Interact with Tom: Talk and Tom still repeats everything you say. Poke, stroke and tickle him, and watch how he responds. \n\nThis app is PRIVO certified. The PRIVO safe harbor seal indicates Outfit7 has established COPPA compliant privacy practices to protect your child’s personal information. Our apps do not allow younger children to share their information.\n\nThis app contains:\n- Promotion of Outfit7's products and advertising\n- Links that direct customers to our websites and other Outfit7 apps\n- Personalization of content to entice users to play the app again\n- The possibility to connect with friends via social networks\n- Watching videos of Outfit7's animated characters via You Tube integration\n- The option to make in-app purchases\n- Items are available for different prices in virtual currency, depending on the current level reached by the player\n- Alternative options to access all functionalities of the app without making any in-app purchases using real money\n\nTerms of use: http://outfit7.com/eula/\nPrivacy policy: http://outfit7.com/privacy-policy/", "artistId":351110111, "artistName":"Outfit7 Limited", "genres":["Games", "Entertainment", "Simulation", "Role-Playing"], "price":0.00, "trackId":657500465, "trackName":"My Talking Tom", "bundleId":"com.outfit7.mytalkingtom", "primaryGenreName":"Games", "isVppDeviceBasedLicensingEnabled":true, "releaseDate":"2013-11-13T07:52:07Z", "primaryGenreId":6014, "sellerName":"Outfit7 Limited", "genreIds":["6014", "6016", "7015", "7014"], "currentVersionReleaseDate":"2017-03-23T11:56:37Z", "releaseNotes":"DIAMOND FRENZY: Watching videos can get you DIAMONDS!\nNEW FURNITURE: Get comfortable in the new interiors.\nGREEN SPARKLE DIAMOND: Tom found the World’s greenest diamond.", "formattedPrice":"Free", "averageUserRating":4.5, "userRatingCount":27583}, {"isGameCenterEnabled":false, "ipadScreenshotUrls":["http://a2.mzstatic.com/eu/r30/Purple71/v4/c3/68/58/c3685842-a3cc-ad38-e9f9-8313afd8ac5b/sc1024x768.jpeg", "http://a4.mzstatic.com/eu/r30/Purple69/v4/d7/e9/e5/d7e9e52a-d860-0d6e-b9bc-f4f9f4f0f473/sc1024x768.jpeg", "http://a5.mzstatic.com/eu/r30/Purple69/v4/a9/c0/49/a9c04962-41ff-3216-a930-a5109c8401da/sc1024x768.jpeg", "http://a3.mzstatic.com/eu/r30/Purple49/v4/c9/54/f9/c954f9e1-c1d0-2c0b-08f3-19ad2c7e9bcc/sc1024x768.jpeg", "http://a2.mzstatic.com/eu/r30/Purple69/v4/5b/06/f4/5b06f4e0-f4e6-0e84-415f-6dda40a6bba5/sc1024x768.jpeg"], "appletvScreenshotUrls":[], "artworkUrl60":"http://is5.mzstatic.com/image/thumb/Purple62/v4/dc/ec/85/dcec85ca-96d2-20ed-efe9-3d8bc0ff264e/source/60x60bb.jpg", "artworkUrl512":"http://is5.mzstatic.com/image/thumb/Purple62/v4/dc/ec/85/dcec85ca-96d2-20ed-efe9-3d8bc0ff264e/source/512x512bb.jpg", "artworkUrl100":"http://is5.mzstatic.com/image/thumb/Purple62/v4/dc/ec/85/dcec85ca-96d2-20ed-efe9-3d8bc0ff264e/source/100x100bb.jpg", "artistViewUrl":"https://itunes.apple.com/gb/developer/open-solutions/id418509664?uo=4", "kind":"software", "features":["iosUniversal"], "supportedDevices":["iPad2Wifi-iPad2Wifi", "iPad23G-iPad23G", "iPhone4S-iPhone4S", "iPadThirdGen-iPadThirdGen", "iPadThirdGen4G-iPadThirdGen4G", "iPhone5-iPhone5", "iPodTouchFifthGen-iPodTouchFifthGen", "iPadFourthGen-iPadFourthGen", "iPadFourthGen4G-iPadFourthGen4G", "iPadMini-iPadMini", "iPadMini4G-iPadMini4G", "iPhone5c-iPhone5c", "iPhone5s-iPhone5s", "iPadAir-iPadAir", "iPadAirCellular-iPadAirCellular", "iPadMiniRetina-iPadMiniRetina", "iPadMiniRetinaCellular-iPadMiniRetinaCellular", "iPhone6-iPhone6", "iPhone6Plus-iPhone6Plus", "iPadAir2-iPadAir2", "iPadAir2Cellular-iPadAir2Cellular", "iPadMini3-iPadMini3", "iPadMini3Cellular-iPadMini3Cellular", "iPodTouchSixthGen-iPodTouchSixthGen", "iPhone6s-iPhone6s", "iPhone6sPlus-iPhone6sPlus", "iPadMini4-iPadMini4", "iPadMini4Cellular-iPadMini4Cellular", "iPadPro-iPadPro", "iPadProCellular-iPadProCellular", "iPadPro97-iPadPro97", "iPadPro97Cellular-iPadPro97Cellular", "iPhoneSE-iPhoneSE", "iPhone7-iPhone7", "iPhone7Plus-iPhone7Plus"], "screenshotUrls":["http://a3.mzstatic.com/eu/r30/Purple71/v4/37/c9/53/37c953ef-2345-7a47-bb45-2bf1303232a9/screen696x696.jpeg", "http://a4.mzstatic.com/eu/r30/Purple49/v4/22/18/28/22182866-2113-ff3b-d866-8903dba8cb53/screen696x696.jpeg", "http://a5.mzstatic.com/eu/r30/Purple69/v4/7a/6c/aa/7a6caae3-0d01-c432-f3cf-1b89aac8dacc/screen696x696.jpeg", "http://a5.mzstatic.com/eu/r30/Purple49/v4/17/2d/09/172d093d-feb5-0aff-e468-5a597d3ef9e1/screen696x696.jpeg", "http://a5.mzstatic.com/eu/r30/Purple69/v4/ce/0c/e1/ce0ce1d4-06d4-2d0e-1278-ef791786b5b1/screen696x696.jpeg"], "advisories":[], "averageUserRatingForCurrentVersion":4.0, "trackCensoredName":"Animal and Tool Flashcards for Babies or Toddlers", "languageCodesISO2A":["DA", "EN", "FR", "DE", "IT", "JA", "KO", "NB", "PT", "RU", "ES"], "fileSizeBytes":"44604416", "sellerUrl":"https://www.facebook.com/BabyKidsZoneGamesForKids", "contentAdvisoryRating":"4+", "userRatingCountForCurrentVersion":9, "trackViewUrl":"https://itunes.apple.com/gb/app/animal-and-tool-flashcards-for-babies-or-toddlers/id427540962?mt=8&uo=4", "trackContentRating":"4+", "minimumOsVersion":"8.0", "currency":"GBP", "wrapperType":"software", "version":"3.0.0", "description":"MANY DIFFERENT IMAGES, SOUNDS OF ANIMALS AND TOOLS, VERBAL AND TEXT DESCRIPTION. 15 DIFFERENT LANGUAGES. EASY TO USE. 5 DIFFERENT CATEGORIES, SLIDESHOW FEATURE.\n\nShow your child what animal makes what sound, what is the correct pronunciation of its name, how to say its name in foreign language, how to write the name.\n\nSimplicity is the key to a successful app for children. Touch the animal to see its magnified image and hear its voice, name and written form. Touch the arrow or swipe your finger to get to next or previous page with more animals. Run simple slideshow for the youngest where no children cooperation is needed. You can also pick your favourite animals for your personalised slideshow.\n\nFEATURES\n---------\n\n* 5 different categories:\n--- Animals (photos of 78 different animals)\n--- Cartoon Animals (the same animals portrayed in cartoon form)\n--- Things around us (photos of 28 tools, vehicles and gadgets)\n--- Cartoon Things around us (the same tools, vehicles and gadgets portrayed in cartoon form)\n--- 3D Bonus (39 animals and creatures in 3D form)\n Note: See In-App Purchase section\n--- Custom: you can put your favourite images into special custom category\n\n* Sounds of animals and tools\n--- You can turn off the sounds and listen just to verbal description.\n\n* Verbal description\n--- Hear name of animal or tool in American English, British English, German, Spanish, Russian, Chinese, Norwegian, Danish, French, Italian, Japanese, Korean, Slovak, Filipino or Brazilian Portuguese.\n--- Your child can even hear the name of animal or tool pronounced in two or three languages.\n--- You can also turn off verbal description completely and listen just to sounds of animals and tools.\n\n* Text description\n--- See name of animal or tool under the image in your preferred language or in more languages simultaneously.\n--- You can also turn off the text description completely.\n\n* In-App Purchase\n--- You get 9 images in every category for free. Rest of images is available after in-app purchase. \n\n* Simple slideshow feature for the youngest\n\n* Different thumbnails count for page\n--- You can configure to have 4 larger or 9 smaller images on every page.\n\n* Automatic horizontal or vertical adjustment (i.e. works both in landscape and portrait orientation)\n\n* HD photos/sounds.\n\n* Bright colorful images.\n\n* No internet connection required.\n\n* No Ads.\n\nAnimals in game:\nFrog,Pig,Bee,Rooster,Penguin,Dog,Monkey,Snake,Cat,Bear,Hen,Horse,Lizard,Fish,Mouse,Cow,Lion,Ant,Butterfly,Crocodile\n,Dinosaur,Dragon,Fox,Chameleon,Ladybug,Lobster,Mosquito,Owl,Turtle,Goat,Turkey,Eagle,Puppy,Leopard,Panda,Parrot,Koa\nla,Tapir,Camel,Cuckoo,Squirrel,Zebra,Rabbit,Wolf,Whale,Chicken,Seal,Sheep,Lemur,Pigeon,Hippopotamus,Gorilla,Dolphin\n,Tiger,Guinea \npig,Seagull,Hamster,Beaver,Bird,Bison,Duck,Crow,Crab,Cobra,Swan,Antelope,Skunk,Giraffe,Hedgehog,Moose,Flamingo,Peli\ncan,Bull,Elephant,Ostrich,Rhino,Coyote,Vulture,Hyena,Donkey,Fly,Polar \nBear,Bat,Woodpecker,Drake,Kangaroo,Shark,Shrimp,Snail,Toucan\n\nTools in game:\nPiano,Airplane,Bus,Door,Drill,Washing machine,Phone,Alarm \nclock,Police,Fighter,Ambulance,Bicycle,Motorcycle,Blender,Car,Cash,Coin,Fire,Fire truck,Cell \nphone,Ocean,Train,Tram,Truck,Vacuum cleaner,Violin,Volcano,Keyboard", "artistId":418509664, "artistName":"Open Solutions", "genres":["Education", "Educational", "Games", "Family"], "price":0.00, "trackId":427540962, "trackName":"Animal and Tool Flashcards for Babies or Toddlers", "bundleId":"com.opensolutionsdev.babytouchandhearlite", "primaryGenreName":"Education", "isVppDeviceBasedLicensingEnabled":true, "releaseDate":"2011-06-08T02:58:34Z", "primaryGenreId":6017, "sellerName":"Open Solutions s.r.o.", "genreIds":["6017", "7008", "6014", "7009"], "currentVersionReleaseDate":"2016-12-02T07:25:16Z", "releaseNotes":"Brand new cartoon images.\nTwo more languages added.\nImproved Settings window.", "formattedPrice":"Free", "averageUserRating":4.5, "userRatingCount":956}, {"isGameCenterEnabled":false, "ipadScreenshotUrls":["http://a4.mzstatic.com/eu/r30/Purple122/v4/98/31/4d/98314de0-2ea3-c81d-9427-3dcfdf0c56be/sc552x414.jpeg", "http://a3.mzstatic.com/eu/r30/Purple122/v4/d5/1c/45/d51c454f-ff91-794e-9e7e-901169c51161/sc552x414.jpeg", "http://a2.mzstatic.com/eu/r30/Purple122/v4/33/27/ec/3327ecfb-3d9c-bee5-d6db-5fa8d09e503e/sc552x414.jpeg", "http://a5.mzstatic.com/eu/r30/Purple122/v4/4d/a5/5e/4da55e62-52fa-fd10-1ca2-cf113eab01ab/sc552x414.jpeg", "http://a2.mzstatic.com/eu/r30/Purple111/v4/1f/75/42/1f75421e-7bfc-2db9-03d2-fcd0d01b3c52/sc552x414.jpeg"], "appletvScreenshotUrls":[], "artworkUrl60":"http://is1.mzstatic.com/image/thumb/Purple111/v4/d8/d7/02/d8d70252-672c-fc67-fda4-796664ac7e6e/source/60x60bb.jpg", "artworkUrl512":"http://is1.mzstatic.com/image/thumb/Purple111/v4/d8/d7/02/d8d70252-672c-fc67-fda4-796664ac7e6e/source/512x512bb.jpg", "artworkUrl100":"http://is1.mzstatic.com/image/thumb/Purple111/v4/d8/d7/02/d8d70252-672c-fc67-fda4-796664ac7e6e/source/100x100bb.jpg", "artistViewUrl":"https://itunes.apple.com/gb/developer/storm8-studios/id967465771?uo=4", "kind":"software", "features":["iosUniversal"], "supportedDevices":["iPhone4-iPhone4", "iPad2Wifi-iPad2Wifi", "iPad23G-iPad23G", "iPhone4S-iPhone4S", "iPadThirdGen-iPadThirdGen", "iPadThirdGen4G-iPadThirdGen4G", "iPhone5-iPhone5", "iPodTouchFifthGen-iPodTouchFifthGen", "iPadFourthGen-iPadFourthGen", "iPadFourthGen4G-iPadFourthGen4G", "iPadMini-iPadMini", "iPadMini4G-iPadMini4G", "iPhone5c-iPhone5c", "iPhone5s-iPhone5s", "iPadAir-iPadAir", "iPadAirCellular-iPadAirCellular", "iPadMiniRetina-iPadMiniRetina", "iPadMiniRetinaCellular-iPadMiniRetinaCellular", "iPhone6-iPhone6", "iPhone6Plus-iPhone6Plus", "iPadAir2-iPadAir2", "iPadAir2Cellular-iPadAir2Cellular", "iPadMini3-iPadMini3", "iPadMini3Cellular-iPadMini3Cellular", "iPodTouchSixthGen-iPodTouchSixthGen", "iPhone6s-iPhone6s", "iPhone6sPlus-iPhone6sPlus", "iPadMini4-iPadMini4", "iPadMini4Cellular-iPadMini4Cellular", "iPadPro-iPadPro", "iPadProCellular-iPadProCellular", "iPadPro97-iPadPro97", "iPadPro97Cellular-iPadPro97Cellular", "iPhoneSE-iPhoneSE", "iPhone7-iPhone7", "iPhone7Plus-iPhone7Plus"], "screenshotUrls":["http://a5.mzstatic.com/eu/r30/Purple122/v4/d5/8b/e0/d58be021-71c9-dd60-81d7-d1bf07e0a51c/screen696x696.jpeg", "http://a3.mzstatic.com/eu/r30/Purple111/v4/9c/70/65/9c7065b5-c44f-08d7-272a-73e9d5af90f4/screen696x696.jpeg", "http://a1.mzstatic.com/eu/r30/Purple111/v4/1f/e1/89/1fe1894c-70ba-bb4d-4906-4637f00409b5/screen696x696.jpeg", "http://a4.mzstatic.com/eu/r30/Purple122/v4/92/bc/e3/92bce3e0-fdb3-9631-721a-8f18ca1d309c/screen696x696.jpeg", "http://a2.mzstatic.com/eu/r30/Purple111/v4/7c/13/ee/7c13ee45-22df-ba45-8d38-a89d5e45820f/screen696x696.jpeg"], "advisories":[], "averageUserRatingForCurrentVersion":4.5, "trackCensoredName":"Hungry Babies Mania", "languageCodesISO2A":["EN"], "fileSizeBytes":"200185856", "sellerUrl":"http://storm8-studios.com/", "contentAdvisoryRating":"4+", "userRatingCountForCurrentVersion":14, "trackViewUrl":"https://itunes.apple.com/gb/app/hungry-babies-mania/id1008519817?mt=8&uo=4", "trackContentRating":"4+", "minimumOsVersion":"7.0", "currency":"GBP", "wrapperType":"software", "version":"2.2.71", "description":"Throw on your sunglasses and head to puzzle paradise on a sunny saga to rescue baby animals around the world! Match tasty treats and collect adorable bouncing babies to win big, and play with your friends to share in the fun!\n\nFrom the sun-baked savannah to the thrilling Thunder Coast, explore this new game from the makers of Candy Blast Mania and Jewel Mania!\n\nHungry Babies Mania Features:\n\n1000+ puzzles of match-3 gameplay means there are plenty of Animal Babies to feed!\n- Go on a massive saga across 900+ levels, popping fruit to feed your furry friends! Pop each animal’s favourite fruits and vegetables to fill their tummies and send them scampering off happy. Then, advance to the next world and rescue even more baby animals!\n\nWake up napping Babies for a snack or help them dig for tasty treats in unique game modes!\n- Continue the pet saga across a bunch of unique game modes! Match fruit next to an alarm clock to wake up the napping Babies, scoop up delicious waffles by matching next to them, or dig through fruit by matching. Juice fruit and rescue Babies in tons of fun, free modes!\n\nLook out for that nasty Gopher Gang! They’ll steal the Babies’ food unless you stop them!\n- Games get more intense as the devious Gopher Gang invades! Scramble to save the food, before the Gophers can steal it! They’ll put you in a jam by stealing all the fruit – Match three or more to pop them before the Gopher Gang can get away!\n\nMake friends with Rex the Lion, Zoomer the Turtle, Borus the Wild Boar, and many more! They can’t wait to meet you!\n- Tons of cute animal friends are waiting for you! Blast each animal’s favourite fruits to juice them and raise your score. Nab a high score to feed and collect your new friends!\n\nChallenge your friends on the Leaderboards!\n- Pop fruits and watch your high scores blossom! Beat your friends’ high scores and compare to be the best! Can you match the most fruit?\n\nNEW Treasure games!\n- Play Treasure Key levels to collect Treasure Keys and get prizes! Compare your scores with friends to see who’s the best.\n\nOffline mode means you can hang out with the Babies no matter where you are!\n- Your animal friends can come anywhere with you! Play and match with your cute animal pals no matter where you are, with offline play on tons of levels.\n\nFREE TO PLAY with FREE updates!\n- Hungry Babies Mania is free to play, and is always growing thanks to free updates!\n\nHungry Babies Mania is the most charming and CAT-ivating puzzle game on the iPhone, iPad and iPod touch, and best of all, it’s FREE! Pop and match with the most adorable animals, use special power-ups to blast your way to a high score, and compete with friends to be the best.\n\nDownload Hungry Babies Mania today to feed and rescue your animal friends!\n\nDEVELOPER INFO: Storm8 Studios is the leading developer in mobile puzzle and arcade gaming. Storm8’s top puzzle hits include the successful match-3 games Candy Blast Mania, Jewel Mania, Bubble Mania, Diamond Quest, and so many more! Wherever you are, pick up and play puzzles today!\n\nPlease note that Hungry Babies Mania is free to play, but you can purchase in-app items with real money. To delete this feature, on your device go to Settings Menu -> General -> Restrictions option. You can then simply turn off In-App Purchases under “Allowed Content”. In addition, Hungry Babies Mania may link to social media services such as Facebook, and Storm8 Studios will have access to your information through such services.\n\nFollow Storm8 Studios!\nwww.storm8-studios.com\nfacebook.com/storm8 \ntwitter.com/storm8", "artistId":967465771, "artistName":"Storm8 Studios", "genres":["Games", "Arcade", "Puzzle", "Entertainment"], "price":0.00, "trackId":1008519817, "trackName":"Hungry Babies Mania", "bundleId":"com.storm8studios.hungrybabies", "primaryGenreName":"Games", "isVppDeviceBasedLicensingEnabled":true, "releaseDate":"2015-08-12T21:21:33Z", "primaryGenreId":6014, "sellerName":"Storm8 Studios LLC", "genreIds":["6014", "7003", "7012", "6016"], "currentVersionReleaseDate":"2017-03-10T17:40:26Z", "releaseNotes":"- Bug fixes\n- Performance improvements", "formattedPrice":"Free", "averageUserRating":4.5, "userRatingCount":1585}, {"isGameCenterEnabled":false, "ipadScreenshotUrls":["http://a2.mzstatic.com/eu/r30/Purple22/v4/42/c7/81/42c78120-81c6-912a-2339-4a9cace09850/sc1024x768.jpeg", "http://a1.mzstatic.com/eu/r30/Purple62/v4/92/ff/e5/92ffe51c-a5ef-9b44-7fdf-6deafbb8d8bf/sc1024x768.jpeg", "http://a1.mzstatic.com/eu/r30/Purple41/v4/bc/8a/0e/bc8a0e4d-620f-60fc-ca58-2576c14d8ec1/sc1024x768.jpeg"], "appletvScreenshotUrls":[], "artworkUrl60":"http://is4.mzstatic.com/image/thumb/Purple91/v4/5b/18/02/5b180260-f2a7-1634-826f-d1090b3c46c5/source/60x60bb.jpg", "artworkUrl512":"http://is4.mzstatic.com/image/thumb/Purple91/v4/5b/18/02/5b180260-f2a7-1634-826f-d1090b3c46c5/source/512x512bb.jpg", "artworkUrl100":"http://is4.mzstatic.com/image/thumb/Purple91/v4/5b/18/02/5b180260-f2a7-1634-826f-d1090b3c46c5/source/100x100bb.jpg", "artistViewUrl":"https://itunes.apple.com/gb/developer/mediaflex-games/id631207235?uo=4", "kind":"software", "features":["iosUniversal"], "supportedDevices":["iPhone3GS-iPhone-3GS", "iPhone4-iPhone4", "iPodTouchFourthGen-iPodTouchFourthGen", "iPad2Wifi-iPad2Wifi", "iPad23G-iPad23G", "iPhone4S-iPhone4S", "iPadThirdGen-iPadThirdGen", "iPadThirdGen4G-iPadThirdGen4G", "iPhone5-iPhone5", "iPodTouchFifthGen-iPodTouchFifthGen", "iPadFourthGen-iPadFourthGen", "iPadFourthGen4G-iPadFourthGen4G", "iPadMini-iPadMini", "iPadMini4G-iPadMini4G", "iPhone5c-iPhone5c", "iPhone5s-iPhone5s", "iPadAir-iPadAir", "iPadAirCellular-iPadAirCellular", "iPadMiniRetina-iPadMiniRetina", "iPadMiniRetinaCellular-iPadMiniRetinaCellular", "iPhone6-iPhone6", "iPhone6Plus-iPhone6Plus", "iPadAir2-iPadAir2", "iPadAir2Cellular-iPadAir2Cellular", "iPadMini3-iPadMini3", "iPadMini3Cellular-iPadMini3Cellular", "iPodTouchSixthGen-iPodTouchSixthGen", "iPhone6s-iPhone6s", "iPhone6sPlus-iPhone6sPlus", "iPadMini4-iPadMini4", "iPadMini4Cellular-iPadMini4Cellular", "iPadPro-iPadPro", "iPadProCellular-iPadProCellular", "iPadPro97-iPadPro97", "iPadPro97Cellular-iPadPro97Cellular", "iPhoneSE-iPhoneSE", "iPhone7-iPhone7", "iPhone7Plus-iPhone7Plus"], "screenshotUrls":["http://a4.mzstatic.com/eu/r30/Purple71/v4/0b/30/a0/0b30a034-a69e-6eb4-0be5-6822a73414ca/screen696x696.jpeg", "http://a3.mzstatic.com/eu/r30/Purple62/v4/42/06/d8/4206d8c2-0168-431e-4e0a-58ad0c7d4f88/screen696x696.jpeg", "http://a5.mzstatic.com/eu/r30/Purple62/v4/86/2d/64/862d648e-3394-87db-561f-436eaa5584e5/screen696x696.jpeg"], "advisories":[], "averageUserRatingForCurrentVersion":4.0, "trackCensoredName":"Close Up Pics - Fun Kids Games for Girls & Boys", "languageCodesISO2A":["EN"], "fileSizeBytes":"95661056", "sellerUrl":"http://gamewise.co/games/46375/Close-Up-Pics", "contentAdvisoryRating":"4+", "userRatingCountForCurrentVersion":59, "trackViewUrl":"https://itunes.apple.com/gb/app/close-up-pics-fun-kids-games-for-girls-boys/id632311326?mt=8&uo=4", "trackContentRating":"4+", "minimumOsVersion":"6.0", "currency":"GBP", "wrapperType":"software", "version":"3.9.2", "description":"Guess the object from the zoomed in photo as fast as you can... simple!\n\nJoin more than 15 million Close Ups users in the most addictive and challenging game yet!\n\n\nSIMPLE, FUN AND ADDICTIVE GAMEPLAY\n\n- No complicated rules, just start playing and having fun!\n- A huge selection of levels ranging from easy to fiendishly difficult!\n\n\nREVIEWS\n\n\"Good fun! - Really gets the old brain working!\" - 5/5\n\n\"Great game! - Easy and smooth to use, great to play with family and on your own.\" - 5/5\n\n\"Great game - Very fun keeping me amused for hours on end so far x\" - 5/5\n\n\"Love it! - Love it! So additive and I love the brain workout! It makes you think and it's fun too!\" - 5/5\n\n\"Better than Flappy Bird, Candy Crush, 2048, Piano Tiles, The Line and Guess the Emoji - my new fave game of 2014!\" - 5/5\n\n\nABOUT MEDIAFLEX GAMES\nWith over 20 million downloads and growing, Mediaflex Games has established itself as leading a creator of puzzle and trivia games for kids and adults.\n\nVisit us: http://www.mediaflex.co\nLike us: http://www.facebook.com/MediaflexGames\n\n\nCONTACT US\nLet us know what you think! Questions? Suggestions? Technical Support? Contact us at: apps@mediaflex.co\n\n\nIMPORTANT MESSAGE FOR PARENTS\n\nOur games are free to play but certain in-game items may be purchased for real money. You may restrict in-app purchases by disabling them on your device.\n\nPLAY FOR FREE NOW!", "artistId":631207235, "artistName":"Mediaflex Games", "genres":["Games", "Trivia", "Lifestyle", "Word"], "price":0.00, "trackId":6

    Finaly i want display the result like

    PositionTrackViewUrlTrackNameArtistViewUrlArtistNamePrimaryGenreNameTrackPrice
    1https://itunes.apple.com/gb/album/le-nozze-di-figaro-k-492-overture/id623730849?i=623730891&uo=4Le nozze di Figaro, K. 492: Overturehttps://itunes.apple.com/gb/artist/radio-symphonie-orchester-berlin/id14239631?uo=4Radio-Symphonie-Orchester Berlin & Ferenc FricsayClassical0.99
    2https://itunes.apple.com/gb/album/missa-brevis-in-c-major-k-220-spatzenmesse-vi-agnus-dei/id560404298?i=560404475&uo=4Missa brevis in C Major, K. 220 "Spatzenmesse": VI. Agnus Deihttps://itunes.apple.com/gb/artist/edith-mathis/id710307?uo=4Edith Mathis, Tatiana Troyanos, Horst Laubenthal, Kieth Engen, Bavarian Radio Symphony Orchestra, Rafael Kubelik, Regensburger Domchor & Hans SchremsClassical0.99
    3https://itunes.apple.com/gb/album/the-journey/id594981117?i=594981371&uo=4The Journeyhttps://itunes.apple.com/gb/artist/fm-radio/id480224830?uo=4Fm RadioSoundtrack0.99
    4https://itunes.apple.com/gb/album/carte-blanche-fm-radio-edit/id457877887?i=457877965&uo=4Carte Blanche (FM Radio Edit)https://itunes.apple.com/gb/artist/veracocha/id203412740?uo=4VeracochaDance0.99
    5https://itunes.apple.com/gb/album/crisantemi/id596615431?i=596616313&uo=4Crisantemihttps://itunes.apple.com/gb/artist/radio-symphonie-orchester-berlin/id14239631?uo=4Radio-Symphonie-Orchester Berlin & Riccardo ChaillyClassical0.99
    6https://itunes.apple.com/gb/album/les-contes-dhoffmann-act-ii-belle-nuit-%C3%B4-nuit-damour/id642839155?i=642839298&uo=4Les contes d'Hoffmann, Act II: Belle nuit, ô nuit d'amourhttps://itunes.apple.com/gb/artist/dame-joan-sutherland/id5595412?uo=4Dame Joan Sutherland, Huguette Tourangeau, Chorus Pro Arte Lausanne Du Brassus, Radio Suisse Romande Chorus, L'Orchestre de la Suisse Romande & Richard BonyngeClassical0.99
    7https://itunes.apple.com/gb/album/lullaby-feat-tori-kelly-capital-fm-radio-session/id918248336?i=918248358&uo=4Lullaby (feat. Tori Kelly)https://itunes.apple.com/gb/artist/professor-green/id206364415?uo=4Professor GreenHip-Hop/Rap-1
    8https://itunes.apple.com/gb/album/les-contes-dhoffmann-act-ii-belle-nuit-%C3%B4-nuit-damour/id669071965?i=669072395&uo=4Les Contes d'Hoffmann, Act II: Belle nuit, ô nuit d'amourhttps://itunes.apple.com/gb/artist/dame-joan-sutherland/id5595412?uo=4Dame Joan Sutherland, Huguette Tourangeau, Chorus Pro Arte Lausanne Du Brassus, Radio Suisse Romande Chorus, L'Orchestre de la Suisse Romande & Richard BonyngeClassical0.99
    9https://itunes.apple.com/gb/album/adeste-fideles-live-version/id269515550?i=269515556&uo=4Adeste Fideleshttps://itunes.apple.com/gb/artist/andrea-bocelli/id217015?uo=4Andrea Bocelli, Vladimir Fedoseyev, Moscow Radio Symphony Orchestra, Academy Of Choir Art Of Russia & Victor PopovChristmas0.79
    10https://itunes.apple.com/gb/album/bell-sound-falling-like-snow/id937240380?i=937240432&uo=4Bell Sound Falling Like Snowhttps://itunes.apple.com/gb/artist/sven-helbig/id52662362?uo=4Sven Helbig, Fauré Quartett, MDR Leipzig Radio Symphony & Kristjan JärviClassical0.99
    11https://itunes.apple.com/gb/album/take-me-away-feat-rae-radio-edit/id1050218699?i=1050223133&uo=4Take Me Away (feat. Rae)https://itunes.apple.com/gb/artist/dj-s-k-t/id437721042?uo=4DJ S.K.TDance0.99
    12https://itunes.apple.com/gb/album/house-every-weekend-radio-edit/id1050218699?i=1050223129&uo=4House Every Weekendhttps://itunes.apple.com/gb/artist/david-zowie/id980599923?uo=4David ZowieDance-1
    13https://itunes.apple.com/gb/album/pony-jump-on-it-feat-ginuwine-radio-mix/id1050218699?i=1050224235&uo=4Pony (Jump on It) [feat. Ginuwine]https://itunes.apple.com/gb/artist/tough-love/id293487938?uo=4Tough LoveDance-1
    14https://itunes.apple.com/gb/album/chunky-radio-edit/id1050218699?i=1050221380&uo=4Chunkyhttps://itunes.apple.com/gb/artist/format-b/id265715622?uo=4Format:BDance-1
    15https://itunes.apple.com/gb/album/intoxicated-radio-edit/id1050218699?i=1050223704&uo=4Intoxicatedhttps://itunes.apple.com/gb/artist/martin-solveig/id15201848?uo=4Martin Solveig & GTADance-1
    16https://itunes.apple.com/gb/album/carmina-burana-o-fortuna-old-spice/id721076981?i=721077002&uo=4Carmina Burana: "O Fortuna"https://itunes.apple.com/gb/artist/rundfunkchor-berlin/id14236129?uo=4Rundfunkchor Berlin, Radio-Symphonie-Orchester Berlin & Riccardo ChaillyClassical0.99
    17https://itunes.apple.com/gb/album/les-contes-dhoffmann-act-ii-belle-nuit-%C3%B4-nuit-damour/id721076981?i=721076990&uo=4Les Contes d'Hoffmann, Act II: Belle nuit, ô nuit d'amourhttps://itunes.apple.com/gb/artist/dame-joan-sutherland/id5595412?uo=4Dame Joan Sutherland, Huguette Tourangeau, Chorus Pro Arte Lausanne Du Brassus, Radio Suisse Romande Chorus, L'Orchestre de la Suisse Romande & Richard BonyngeClassical0.99
    18https://itunes.apple.com/gb/album/le-nozze-di-figaro-k-492-overture-british-gas/id721076981?i=721077023&uo=4Le nozze di Figaro, K. 492: Overturehttps://itunes.apple.com/gb/artist/radio-symphonie-orchester-berlin/id14239631?uo=4Radio-Symphonie-Orchester Berlin & Ferenc FricsayClassical0.99
    19https://itunes.apple.com/gb/album/city-zen-radio-1990-2000-fm/id292672031?i=292672039&uo=4City Zen Radio 1990/2000 FMhttps://itunes.apple.com/gb/artist/pop-will-eat-itself/id1017574?uo=4Pop Will Eat ItselfRock0.99
    20https://itunes.apple.com/gb/album/carmina-burana-o-fortuna-fortune-plango-vulnera/id938807983?i=938808099&uo=4Carmina Burana: O Fortuna - Fortune plango vulnerahttps://itunes.apple.com/gb/artist/rundfunkchor-berlin/id14236129?uo=4Rundfunkchor Berlin, Radio-Symphonie-Orchester Berlin & Riccardo ChaillyClassical0.99
    21https://itunes.apple.com/gb/album/piano-concerto-in-a-minor-op-16-2-adagio/id830608807?i=830611903&uo=4Piano Concerto in A Minor, Op. 16: 2. Adagiohttps://itunes.apple.com/gb/artist/jorge-bolet/id276980?uo=4Jorge Bolet, Radio-Symphonie-Orchester Berlin & Riccardo ChaillyClassical0.99
    22https://itunes.apple.com/gb/album/st-luke-passion-bwv-246-pt-2-erat-autem-in-te-domine-speravi/id700531597?i=700531669&uo=4St. Luke Passion, BWV 246, Pt. 2: Erat autem...In Te, Domine, speravihttps://itunes.apple.com/gb/artist/sigune-von-osten/id92010954?uo=4Sigune von Osten, Stephen Roberts, Kurt Rydl, Edward Lubaszenko, Warsaw National Philharmonic Choir, Krakow Boys Choir, National Radio Symphony Orchestra & Krzysztof PendereckiClassical0.99
    23https://itunes.apple.com/gb/album/el-amor-brujo-ritual-fire-dance/id651493340?i=651493687&uo=4El amor brujo: Ritual Fire Dancehttps://itunes.apple.com/gb/artist/radio-symphonie-orchester-berlin/id14239631?uo=4Radio-Symphonie-Orchester Berlin & Lorin MaazelClassical0.99
    24https://itunes.apple.com/gb/album/my-radio-fm-mix/id337320937?i=337321262&uo=4My Radio (FM Mix)https://itunes.apple.com/gb/artist/stars/id6933398?uo=4StarsRock0.79
    25https://itunes.apple.com/gb/album/more-than-i-wished-for-fm-radio-bonus-track/id480788292?i=480788303&uo=4More Than I Wished For (Fm Radio) [Bonus Track]https://itunes.apple.com/gb/artist/schuyler-fisk/id64818166?uo=4Schuyler FiskChristmas0.79
    26https://itunes.apple.com/gb/album/be-my-only/id517751204?i=517751334&uo=4Be My Onlyhttps://itunes.apple.com/gb/artist/fm-radio/id480224830?uo=4Fm RadioPop0.79
    27https://itunes.apple.com/gb/album/happily-ever-after/id517751204?i=517751330&uo=4Happily Ever Afterhttps://itunes.apple.com/gb/artist/fm-radio/id480224830?uo=4Fm RadioPop0.79
    28https://itunes.apple.com/gb/album/this-love/id517751204?i=517751331&uo=4This Lovehttps://itunes.apple.com/gb/artist/fm-radio/id480224830?uo=4Fm RadioPop0.79
    29https://itunes.apple.com/gb/album/lead-me-home/id517751204?i=517751336&uo=4Lead Me Homehttps://itunes.apple.com/gb/artist/fm-radio/id480224830?uo=4Fm RadioPop0.79
    30https://itunes.apple.com/gb/album/leave-the-light-on/id517751204?i=517751206&uo=4Leave the Light Onhttps://itunes.apple.com/gb/artist/fm-radio/id480224830?uo=4Fm RadioPop0.79
    31https://itunes.apple.com/gb/album/les-contes-dhoffmann-act-ii-belle-nuit-%C3%B4-nuit-damour/id668458272?i=668458756&uo=4Les Contes d'Hoffmann, Act II: Belle nuit, ô nuit d'amourhttps://itunes.apple.com/gb/artist/dame-joan-sutherland/id5595412?uo=4Dame Joan Sutherland, Huguette Tourangeau, Chorus Pro Arte Lausanne Du Brassus, Radio Suisse Romande Chorus, L'Orchestre de la Suisse Romande & Richard BonyngeClassical0.99
    32https://itunes.apple.com/gb/album/fm-john-peel-bbc-radio-1-session-1977/id335329779?i=335330006&uo=4Fmhttps://itunes.apple.com/gb/artist/the-slits/id13129573?uo=4The SlitsRock0.79
    33https://itunes.apple.com/gb/album/everytime-feat-natalie-gauci-disfunktion-radio-edit/id546439607?i=546440419&uo=4Everytime (feat. Natalie Gauci)https://itunes.apple.com/gb/artist/new-york-fm/id520776916?uo=4New York FMDance0.99
    34https://itunes.apple.com/gb/album/carte-blanche-fm-radio-edit/id656187261?i=656187700&uo=4Carte Blanchehttps://itunes.apple.com/gb/artist/veracocha/id203412740?uo=4VeracochaDance0.99
    35https://itunes.apple.com/gb/album/country-grown/id517751204?i=517751333&uo=4Country Grownhttps://itunes.apple.com/gb/artist/fm-radio/id480224830?uo=4Fm RadioPop0.79
    36https://itunes.apple.com/gb/album/all-of-your-heart/id517751204?i=517751207&uo=4All of Your Hearthttps://itunes.apple.com/gb/artist/fm-radio/id480224830?uo=4Fm RadioPop0.79
    37https://itunes.apple.com/gb/album/its-alright-mike-gee-choice-fm-radio-drop-2001/id500745624?i=500746389&uo=4It's Alright (Mike Gee - Choice FM Radio Drop 2001)https://itunes.apple.com/gb/artist/coolys-hot-box/id16439565?uo=4Cooly's Hot-BoxR&B/Soul0.79
    38https://itunes.apple.com/gb/album/city-zen-radio-1990-2000-fm/id474454211?i=474454216&uo=4City Zen Radio 1990/2000 FMhttps://itunes.apple.com/gb/artist/pop-will-eat-itself/id1017574?uo=4Pop Will Eat ItselfRock0.99
    39https://itunes.apple.com/gb/album/i-believe/id517751204?i=517751335&uo=4I Believehttps://itunes.apple.com/gb/artist/fm-radio/id480224830?uo=4Fm RadioPop0.79
    40https://itunes.apple.com/gb/album/the-firebird-suite-lullaby-berceuse/id872780455?i=872780507&uo=4The Firebird Suite: Lullaby (Berceuse)https://itunes.apple.com/gb/artist/radio-symphonie-orchester-berlin/id14239631?uo=4Radio-Symphonie-Orchester Berlin & Lorin MaazelClassical0.99
    41https://itunes.apple.com/gb/album/broke-down-broke-up/id517751204?i=517751329&uo=4Broke Down & Broke Uphttps://itunes.apple.com/gb/artist/fm-radio/id480224830?uo=4Fm RadioPop0.79
    42https://itunes.apple.com/gb/album/fidelio-op-72-act-i-ha-welch-ein-augenblick/id876301292?i=876301456&uo=4Fidelio, Op. 72, Act I: "Ha! Welch ein Augenblick!"https://itunes.apple.com/gb/artist/bryn-terfel/id604784?uo=4Bryn Terfel, Swedish Radio Symphony Orchestra, Paul Daniel, Swedish Radio Choir & Arne LundmarkClassical0.99
    43https://itunes.apple.com/gb/album/out-of-the-blue/id517751204?i=517751208&uo=4Out of the Bluehttps://itunes.apple.com/gb/artist/fm-radio/id480224830?uo=4Fm RadioPop0.79
    44https://itunes.apple.com/gb/album/dangerous/id517751204?i=517751332&uo=4Dangeroushttps://itunes.apple.com/gb/artist/fm-radio/id480224830?uo=4Fm RadioPop0.79
    45https://itunes.apple.com/gb/album/333-d-nox-beckers-remix/id404028314?i=404029805&uo=4333 (D-Nox & Beckers Remix)https://itunes.apple.com/gb/artist/fm-radio-gods/id272674749?uo=4FM Radio GodsDance0.99
    46https://itunes.apple.com/gb/album/the-radio-lavranos-eleftheriou/id111010903?i=111010853&uo=4The Radio (Lavranos / Eleftheriou) Various Artists - FM RecordsWorld0.99
    47https://itunes.apple.com/gb/album/radio-killa-66-6-fm-feat-s%C5%82o%C5%84-ero-dono/id504933048?i=504933247&uo=4Radio Killa (66,6 Fm) (feat. Slon, Ero & Dono)https://itunes.apple.com/gb/artist/pih/id299262621?uo=4PIHHip-Hop/Rap0.79
    48https://itunes.apple.com/gb/album/carmen-pr%C3%A9lude/id690732351?i=690733006&uo=4Carmen: Préludehttps://itunes.apple.com/gb/artist/radio-symphonie-orchester-berlin/id14239631?uo=4Radio-Symphonie-Orchester Berlin & Ferenc FricsayClassical0.99
    49https://itunes.apple.com/gb/album/milakia-fm-radio-gods-remix-feat-martin-gore/id373343906?i=373344529&uo=4Milakia (FM Radio Gods Remix) [feat. Martin Gore]https://itunes.apple.com/gb/artist/bomb-the-bass/id39860972?uo=4Bomb the Bass & FM Radio GodsElectronic0.79
    50https://itunes.apple.com/gb/album/almost-crimes/id256300455?i=256300456&uo=4Almost Crimeshttps://itunes.apple.com/gb/artist/broken-social-scene/id6925799?uo=4Broken Social SceneAlternative0.79

    "language�y�{�

  • Quick question, did you read this?
    😎

  • your paste was huge, and it also appears to be a partial paste, as it's not terminated correctly. huge things like that belong in an attachment, really, and not pasted into the forum.
    if you can get the data into a table or a variable, event he most basic info could help you get started i think.

    https://msdn.microsoft.com/en-us/library/dn921879.aspx

    the url above can help you get started,

    DECLARE @json NVARCHAR(MAX)
    SET @json='{"name":"John","surname":"Doe","age":45,"skills":["SQL","C#","MVC"]}';

    SELECT *FROM OPENJSON(@json);

    i tried pasting your code into a tsql variable, and it showed me it was partial ending at trackid:6

    if you got the above going, you could start digging into the nested objects contained in the json string.

    Lowell


    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply