Hi,

I am using Stata 17 and would need some help in importing JSON into Stata. This is my first time doing it so I would need help in this area. Below is an example of my JSON file:

Code:
[{
 "projects": [
  {
   "id": 1848663364,
   "name": "Drawing a Drawing 365",
   "blurb": "Portrait artist seeks funds to kickstart an exciting year-long project involving YOU and produce a drawing / painting tutorial video",
   "goal": 10000,
   "pledged": 62736.01,
   "state": "successful",
   "slug": "drawing-a-drawing-365",
   "disable_communication": false,
   "country": "US",
   "currency": "USD",
   "currency_symbol": "$",
   "currency_trailing_code": true,
   "deadline": 1335671940,
   "state_changed_at": 1335671940,
   "created_at": 1331325438,
   "launched_at": 1332822807,
   "backers_count": 479,
   "static_usd_rate": "1.0",
   "usd_pledged": "62736.01",
   "photo": {
    "full": "https://ksr-ugc.imgix.net/projects/95735/photo-original.jpg?v=1397773825&w=560&h=420&fit=crop&auto=format&q=92&s=6cbd36c602d0124f63fb79f632ef1e8e",
    "ed": "https://ksr-ugc.imgix.net/projects/95735/photo-original.jpg?v=1397773825&w=338&h=250&fit=crop&auto=format&q=92&s=b32c42f4943722127d9889471d3c918c",
    "med": "https://ksr-ugc.imgix.net/projects/95735/photo-original.jpg?v=1397773825&w=266&h=200&fit=crop&auto=format&q=92&s=2483c039a636bfc6538d9573d71d8b47",
    "little": "https://ksr-ugc.imgix.net/projects/95735/photo-original.jpg?v=1397773825&w=200&h=150&fit=crop&auto=format&q=92&s=3ca2b75a4f2654aa270432d2ee35a094",
    "small": "https://ksr-ugc.imgix.net/projects/95735/photo-original.jpg?v=1397773825&w=160&h=120&fit=crop&auto=format&q=92&s=39fee61fe56c366f9c1f217fa341cdeb",
    "thumb": "https://ksr-ugc.imgix.net/projects/95735/photo-original.jpg?v=1397773825&w=40&h=30&fit=crop&auto=format&q=92&s=f2599f323e7c8e46d8d58bb88cccaba8",
    "1024x768": "https://ksr-ugc.imgix.net/projects/95735/photo-original.jpg?v=1397773825&w=1024&h=768&fit=crop&auto=format&q=92&s=56202045b5f599793245ac8660529b24",
    "1536x1152": "https://ksr-ugc.imgix.net/projects/95735/photo-original.jpg?v=1397773825&w=1536&h=1152&fit=crop&auto=format&q=92&s=7b4aad024a0685165f295c10c3894175"
   },
   "creator": {
    "id": 1537276594,
    "name": "Michael Shapcott",
    "slug": "michaelshapcott",
    "avatar": {
     "thumb": "https://ksr-ugc.imgix.net/avatars/1539487/MichaelShapcott_thumb.original.jpg?v=1331450574&w=40&h=40&fit=crop&auto=format&q=92&s=d26aed7e3dc477dbf6122191b8ef2415",
     "small": "https://ksr-ugc.imgix.net/avatars/1539487/MichaelShapcott_thumb.original.jpg?v=1331450574&w=80&h=80&fit=crop&auto=format&q=92&s=a951a2d5626f41be48003469ccca9576",
     "medium": "https://ksr-ugc.imgix.net/avatars/1539487/MichaelShapcott_thumb.original.jpg?v=1331450574&w=160&h=160&fit=crop&auto=format&q=92&s=a359360352dcb46ab36dbf04866ba352"
    },
    "urls": {
     "web": {
      "user": "https://www.kickstarter.com/profile/michaelshapcott"
     },
     "api": {
      "user": "https://api.kickstarter.com/v1/users/1537276594?signature=1434200014.6d2ca36f0053c57856eff001e8d164658b1ea6b6"
     }
    },
    "user_id": 1539487
   },
   "location": {
    "id": 2458090,
    "name": "New Britain",
    "slug": "new-britain-ct",
    "short_name": "New Britain, CT",
    "displayable_name": "New Britain, CT",
    "country": "US",
    "state": "CT",
    "type": "Town",
    "is_root": false,
    "urls": {
     "web": {
      "discover": "https://www.kickstarter.com/discover/places/new-britain-ct",
      "location": "https://www.kickstarter.com/locations/new-britain-ct"
     },
     "api": {
      "nearby_projects": "https://api.kickstarter.com/v1/discover?signature=1434192693.1e67da952b6693c5eab2398af8884d4ec9c2919a&woe_id=2458090"
     }
    }
   },
   "category": {
    "id": 23,
    "name": "Painting",
    "slug": "art/painting",
    "position": 7,
    "parent_id": 1,
    "urls": {
     "web": {
      "discover": "http://www.kickstarter.com/discover/categories/art/painting"
     }
    }
   },
   "profile": {
    "id": 97976,
    "project_id": 97976,
    "state": "inactive",
    "state_changed_at": 1425915805,
    "name": null,
    "blurb": null,
    "background_color": null,
    "text_color": null,
    "link_background_color": null,
    "link_text_color": null,
    "link_text": null,
    "link_url": null,
    "show_feature_image": false,
    "background_image_opacity": 0.8,
    "should_show_feature_image": true,
    "feature_image_attributes": {
     "image_urls": {
      "default": "https://ksr-ugc.imgix.net/projects/95735/photo-original.jpg?v=1397773825&w=1536&h=1152&fit=crop&auto=format&q=92&s=7b4aad024a0685165f295c10c3894175",
      "baseball_card": "https://ksr-ugc.imgix.net/projects/95735/photo-original.jpg?v=1397773825&w=1536&h=1152&fit=crop&auto=format&q=92&s=7b4aad024a0685165f295c10c3894175"
     }
    }
   },
   "spotlight": true,
   "urls": {
    "web": {
     "project": "https://www.kickstarter.com/projects/michaelshapcott/drawing-a-drawing-365?ref=category",
     "rewards": "https://www.kickstarter.com/projects/michaelshapcott/drawing-a-drawing-365/rewards"
    }
   }
  },

I did not see an option to import JSON file when I tried to import the file. Any help in this area would be appreciated.

Thanks!