konklone / json

A free, in-browser JSON to CSV converter.
https://konklone.io/json/
Other
759 stars 211 forks source link

Error parsing some specific JSON #206

Closed michaelhmiller3 closed 5 years ago

michaelhmiller3 commented 6 years ago

I'm having an issue converting this JSON:

{
  "events": {
    "data": [
      {
        "name": "Trilogy Dems & Friends - Deedra Speaking!",
        "place": {
          "name": "4369 E Village Pkwy, Gilbert, AZ 85298-8003, United States"
        },
        "start_time": "2018-05-20T16:00:00-0700",
        "end_time": "2018-05-20T17:30:00-0700",
        "id": "730196227368452"
      },
      {
        "name": "Spring Fling Carnival",
        "description": "Spring Fling Carnival in Ahwatukee!",
        "place": {
          "name": "4526 E Arapahoe St, Phoenix, AZ 85044-3204, United States"
        },
        "start_time": "2018-03-31T11:00:00-0700",
        "end_time": "2018-03-31T16:00:00-0700",
        "id": "1788403801467810"
      },
      {
        "name": "Ahwatukee Kiwanis Club Easter Parade",
        "description": "Come to the Ahwatukee Kiwanis Club Easter Parade and meet Deedra!",
        "place": {
          "name": "12656 S 48th St, Phoenix, AZ 85044, United States"
        },
        "start_time": "2018-03-31T10:00:00-0700",
        "end_time": "2018-03-31T11:00:00-0700",
        "id": "355279321648598"
      },
      {
        "name": "Our Revolution Yuma",
        "place": {
          "name": "2020 S Avenue 8 E, Yuma, AZ 85365-6900, United States"
        },
        "start_time": "2018-03-28T19:00:00-0700",
        "end_time": "2018-03-28T21:00:00-0700",
        "id": "527266617658690"
      },
      {
        "name": "Marana Democrats",
        "place": {
          "name": "8881 N Coachline Rd, Tucson, AZ 85743-1200, United States"
        },
        "start_time": "2018-03-27T15:00:00-0700",
        "end_time": "2018-03-27T16:30:00-0700",
        "id": "233278840550132"
      },
      {
        "name": "Blue Tuesday Luncheon",
        "place": {
          "name": "11500 N Hayden Rd, Scottsdale, AZ 85260-8516, United States"
        },
        "start_time": "2018-03-27T12:00:00-0700",
        "end_time": "2018-03-27T13:30:00-0700",
        "id": "1601437153302794"
      },
      {
        "name": "Meet The Candidates Mixer",
        "place": {
          "name": "10320 N Scottsdale Rd, Paradise Valley, AZ 85253-1427, United States"
        },
        "start_time": "2018-03-26T18:30:00-0700",
        "end_time": "2018-03-26T20:00:00-0700",
        "id": "2266984610195773"
      },
      {
        "name": "Herstory At ASU",
        "place": {
          "name": "424 N Central Ave, Phoenix, AZ 85004-2113, United States"
        },
        "start_time": "2018-03-22T18:00:00-0700",
        "end_time": "2018-03-22T20:00:00-0700",
        "id": "594724157525574"
      },
      {
        "name": "Pierce For Mine Inspector Meet & Greet",
        "place": {
          "name": "Beaver Choice, Polish, Scandinavian and Canadian Restaurant",
          "location": {
            "city": "Mesa",
            "country": "United States",
            "latitude": 33.378126790854,
            "longitude": -111.84774191908,
            "state": "AZ",
            "street": "745 W Baseline Rd",
            "zip": "85210"
          },
          "id": "390410827724501"
        },
        "start_time": "2018-03-21T18:00:00-0700",
        "end_time": "2018-03-21T20:00:00-0700",
        "id": "488616654868337"
      },
      {
        "name": "LD12 Monthly Meeting",
        "place": {
          "name": "15303 S Gilbert Rd, Gilbert, AZ 85295-5261, United States"
        },
        "start_time": "2018-03-19T18:30:00-0700",
        "end_time": "2018-03-19T20:00:00-0700",
        "id": "975128405973605"
      },
      {
        "name": "LD9 & LD10 St. Patrick's Day Party",
        "place": {
          "name": "630 N Alamo Ave, Tucson, AZ 85711-1617, United States"
        },
        "start_time": "2018-03-18T13:00:00-0700",
        "end_time": "2018-03-18T16:00:00-0700",
        "id": "128969471258835"
      },
      {
        "name": "Wickenburg Meet The Candidates",
        "place": {
          "name": "164 E Apache St, Wickenburg, AZ 85390-2457, United States"
        },
        "start_time": "2018-03-17T14:00:00-0700",
        "end_time": "2018-03-17T16:00:00-0700",
        "id": "203119140441806"
      },
      {
        "name": "LD27 Monthly Meeting",
        "place": {
          "name": "212 E Alta Vista Rd, Phoenix, AZ 85042-4219, United States"
        },
        "start_time": "2018-03-14T18:30:00-0700",
        "end_time": "2018-03-14T20:30:00-0700",
        "id": "172296120075628"
      },
      {
        "name": "Saddlebrooke Monthly Meeting",
        "place": {
          "name": "38759 S Mountain View Blvd",
          "location": {
            "city": "Tucson",
            "country": "United States",
            "latitude": 32.5240622,
            "longitude": -110.8958144,
            "state": "AZ",
            "street": "38759 South Mountain View Boulevard",
            "zip": "85739"
          },
          "id": "2154231388135403"
        },
        "start_time": "2018-03-13T15:30:00-0700",
        "end_time": "2018-03-13T17:30:00-0700",
        "id": "336760060169363"
      },
      {
        "name": "Democrats of Oro Valley",
        "place": {
          "name": "1305 W Naranja Dr, Tucson, AZ 85737-9762, United States"
        },
        "start_time": "2018-03-12T18:40:00-0700",
        "end_time": "2018-03-12T20:40:00-0700",
        "id": "190153401582684"
      },
      {
        "name": "Sun City Of Oro Valley Dems",
        "place": {
          "name": "1495 E Rancho Vistoso Blvd, Oro Valley, AZ 85755-9116, United States"
        },
        "start_time": "2018-03-10T13:00:00-0700",
        "end_time": "2018-03-10T15:00:00-0700",
        "id": "163755014280353"
      },
      {
        "name": "Democratic Club Of Fountain Hills",
        "place": {
          "name": "13001 N La Montana Dr, Fountain Hills, AZ 85268-8306, United States"
        },
        "start_time": "2018-03-08T18:15:00-0700",
        "end_time": "2018-03-08T20:30:00-0700",
        "id": "297249177470111"
      },
      {
        "name": "Sun City Democratic Club",
        "place": {
          "name": "10600 W Peoria Ave, Sun City, AZ 85351-4144, United States"
        },
        "start_time": "2018-03-01T18:00:00-0700",
        "end_time": "2018-03-01T20:00:00-0700",
        "id": "410983032679719"
      },
      {
        "name": "Grand Dems Meeting",
        "place": {
          "name": "17100 Clearview Blvd, Surprise, AZ 85387-5500, United States"
        },
        "start_time": "2018-02-28T18:00:00-0700",
        "end_time": "2018-02-28T20:00:00-0700",
        "id": "2151491435091623"
      },
      {
        "name": "LD21 Monthly Meeting",
        "place": {
          "name": "14388 N 79th Ave, Peoria, AZ 85381-4682, United States"
        },
        "start_time": "2018-02-27T18:30:00-0700",
        "end_time": "2018-02-27T20:30:00-0700",
        "id": "192374188185508"
      },
      {
        "name": "Democrats Of Greater Tucson",
        "place": {
          "name": "400 N Bonita Ave, Tucson, AZ 85745-2747, United States"
        },
        "start_time": "2018-02-26T11:55:00-0700",
        "end_time": "2018-02-26T13:00:00-0700",
        "id": "410439366062693"
      },
      {
        "name": "Politics in the Park & Potluck",
        "description": "Join Deedra 2018 for U.S. Senate and Kathy Hoffman for Superintendent for Politics in the Park!

This potluck event will have lots of candidates present from multiple LD’s -- check back for an updated list!

Bring your favorite dishes and get ready to meet like-minded, passionate people who are fighting to make Arizona a better place.

Sunset park is adjacent to the Chandler Sunset Library. Just east of the library parking lot. Parking will be available along the street of the park, or at the library itself.

We'll see you there!",
        "place": {
          "name": "4930 W Ray Rd, Chandler, AZ 85226-6219, United States"
        },
        "start_time": "2018-02-24T13:00:00-0700",
        "end_time": "2018-02-24T16:00:00-0700",
        "id": "303771953361328"
      },
      {
        "name": "Just Be Love Fest",
        "place": {
          "name": "Only Love Studio",
          "location": {
            "city": "Scottsdale",
            "country": "United States",
            "latitude": 33.50095,
            "longitude": -111.91981,
            "state": "AZ",
            "street": "4385 N. 75th St. #103",
            "zip": "85258"
          },
          "id": "1206075252785594"
        },
        "start_time": "2018-02-24T10:00:00-0700",
        "end_time": "2018-02-24T12:00:00-0700",
        "id": "181561789004891"
      },
      {
        "name": "Women on the Ballot - Meet Anita Malik and Deedra Abboud",
        "description": "Join us at the home of Al and Mary Lou Ronca to meet U.S. House candidate Anita Malik (CD06) and U.S. Senate candidate Deedra Abboud. Hear from both women, learn about their positions, ask questions and find out how you can help.  

RSVP here or email: Ryan@anitaforarizona.com 

Light refreshments will be served.",
        "place": {
          "name": "15468 E Greystone Dr, Fountain Hills, AZ 85268-4952, United States"
        },
        "start_time": "2018-02-23T18:00:00-0700",
        "end_time": "2018-02-23T20:00:00-0700",
        "id": "174693949924613"
      },
      {
        "name": "Coconino Community Action Kickoff",
        "description": "Hey, Flagstaff! Join us for the Coconino Community Action Kickoff. We look forward to seeing you there!

Have any questions? Comment below or email us at outreach@Deedra2018.com.",
        "place": {
          "name": "2801 N Izabel St, Flagstaff, AZ 86004-3452, United States"
        },
        "start_time": "2018-02-10T09:30:00-0700",
        "end_time": "2018-02-10T11:30:00-0700",
        "id": "2030980366928622"
      }
    ],
    "paging": {
      "cursors": {
        "before": "QVFIUmIzNHZAHajYtd1JpbDlOQU4zQVhiRzFwbmcxLW56MVUyQ2dwMnBaMG1FM3JjQXB0WERoLUU1Q2V1M2h4aTdfMzhwa3NaN0E0b3poRVg2U0lNOG9aSEVB",
        "after": "QVFIUnkzcHNQcC1qeVdrNUt1QVhUdVkyLS12VTVXSVM0THVLbUxtdnVhZA0FDZAjYyVkphZAHgtWHZAtNnlMUnZAFaUxqN01rblVzZAEpDU3F1c19EU0JvT1U0OFBR"
      },
      "next": "https://graph.facebook.com/v2.12/575168982688479/events?access_token=EAACEdEose0cBAAfH3uQZBaqP9RO01YHEsAaMOFeisfTJfBF7REazv4xisBaUDK9sI8BDDGiMXj8ZCXY6wYSgJZAZBJsT4ZBjDWkoRZAMvrY4Nar34A0fvjHZBpPSqkHwv3W0geGrLv21J92ILJoIBkKGghg5mr082PyCcVhy8BZBRZBMfYdfRw41t2sBL0xHC7BEZD&pretty=0&fields=name%2Cdescription%2Cplace%2Cstart_time%2Cend_time&limit=25&after=QVFIUnkzcHNQcC1qeVdrNUt1QVhUdVkyLS12VTVXSVM0THVLbUxtdnVhZA0FDZAjYyVkphZAHgtWHZAtNnlMUnZAFaUxqN01rblVzZAEpDU3F1c19EU0JvT1U0OFBR"
    }
  },
  "id": "575168982688479"
}