Hello! I have a JSON file in an S3 bucket with sample data from MLS house listings. I am unsure of what settings I need to get this to successfully upload and am getting this error:
A JSONObject text must end with '}' at 1 [character 2 line 1]
For reference, here is a sample of the JSON file:
{
"1984933": {
"ListingKeyNumeric": 1984933,
"ListingStatus": "Active",
"ModificationTimestamp": "2024-03-08T07:32:57Z",
"PropertyType": "Residential",
"PropertySubType": "Single Family Residence",
"CurrentUse": "Single Family",
"Ownership": "",
"ArchitecturalStyle": "Bungalow/Cottage",
"Stories": 1,
"Basement": "None",
"Address": "65 STRATFORD, South Salt Lake UT, 84115",
"ListPrice": 398000.0,
"OriginalListPrice": 398000.0,
"ClosePrice": null,
"CloseDate": null,
"DaysOnMarket": 0,
"CumulativeDaysOnMarket": null,
"LivingAreaSquareFeet": 931.0,
"LotSizeAcres": 0.1,
"YearBuilt": 1925,
"YearBuiltEffective": null,
"BedroomsTotal": 2,
"BathroomsTotal": 1,
"GarageSpaces": null,
"Cooling": true,
"Heating": true,
"ElementarySchool": "Woodstock",
"MiddleOrJuniorSchool": "Granite Park",
"HighSchool": "Cottonwood",
"LeaseAmount": null,
"NumberOfUnitsLeased": null,
"NumberOfUnitsTotal": null,
"ListingAgent": "Christine Sadira",
"ListAgentMlsId": "88753",
"ListingOfficeName": "Unity Group Real Estate LLC",
"ListOfficeMlsId": "71188",
"ExteriorFeatures": "",
"AppliancesIncluded": "Dryer,Refrigerator,Washer",
"TaxAnnualAmount": 1888.0,
"AssociationFeeAnnual": null,
"AssociationAmenities": "",
"Topography": "Fenced: Full, Sidewalks, Sprinkler: Auto-Full",
"LotFeatures": "Fenced: Full,Sidewalks,Sprinkler: Auto-Full",
"Utilities": "",
"Vegetation": "",
"View": "",
"OriginatingSystemName": "UtahRealEstate.com",
"OriginatingSystemID": "M00000628"
},
"1984930": {
"ListingKeyNumeric": 1984930,
"ListingStatus": "Active",
"ModificationTimestamp": "2024-03-08T07:32:57Z",
etc...