Example JSON Import Files
Example 1: A minimal example making an update to just one field
[ { "projectId": "proj1111", "ratingDate": "2020-09-05" } ]
Some things to note from this example:
- All fields are optional except for "projectId".
- The singleton project object is still required to be inside of array brackets.
Example 2: A single JSON file with field data for multiple projects
[ { "projectId": "Proj1111", "nBedrooms": "5", "hasEvReadySpace": true, "orientation": "Southwest", "wallColor": "REFLECTIVE", "roofColor": "LIGHT", "constructionYear": "2013", "floorsOnOrAboveGrade": "3" }, { "projectId": "Proj2222", "constructionYear": "2021", "raterOfRecordRTIN": "0001234", "orientation": "North" } ]
Some things to note from this example:
- One file can contain field data for multiple projects.
- The second project object is not followed by a comma, as this would break JSON syntax.
- The objects for the different projects need not have all the same fields. They are totally independent.
- Numeric values can be double-quoted strings.
- Two objects in one file cannot have the same "projectId" values.
Example 3: A hypothetical real use
[ { "projectId": "proj3333", "constructionYear": 2021, "hasEvReadySpace": true, "hasGarage": true, "orientation": "East", "wallColor": "DARK", "roofColor": "MEDIUM", "aboveGradeWalls": [ { "index": 0, "cavityInsulationGrade": "II", "cavityInsulationR": 12, "continuousInsulationR": 3 }, { "index": 1, "cavityInsulationGrade": "I", "cavityInsulationR": 16, "continuousInsulationR": 5 } ], "ceilingsAndRoofs": [ { "index": 0, "cavityInsulationGrade": "II" } ], "windows": [ { "index": 0, "remove": true }, { "index": 1, "windowArea": 325.5 } ], "mechanicalEquipments": [ { "index": 0, "modelNumber": "MDLNBR-12345678", "percentHeatingLoad": 100, "perentCoolingLoad": 20 }, { "index": 1, "modelNumber": "MDLNBR-23456789", "percentCoolingLoad": 80, "location": "AMBIENT" }, { "index": 2, "modelNumber": "MDLNBR-23456789", "percentHotWaterLoad": 100, "location": "AMBIENT" } ], "hasCeilingFan": true, "ceilingFanCfmPerWatt": 70.123, "infiltrationUnit": "ACH_NATURAL", "infiltrationValue": 3.2, "lighting": { "percentInteriorFluorescent": 25, "percentInteriorLED": 75 }, "mandatoryItems": { "iecc2012MandatoryChecklist": true } } ]
Some things to note from this example:
- Fields are designed to be pick-and-choose to fit a variety of needs.
- Numeric values can be plain numbers and floating point fields do not require a decimal point.
- true/false values can be plain (not surrounded by quotation marks).
Example 4: An example using all available fields
[ { "projectId": "proj4444", "ratingDate": "2021-08-17", "constructionYear": 2021, "raterOfRecord": "0000001", "otherRaterRxIN": [ "1234567", "abc123" ], "floorsOnOrAboveGrade": 3, "nBedrooms": 3, "conditionedFloorArea": 1500, "infiltrationVolume": 14000, "hasEvReadySpace": "true", "hasGarage": "true", "orientation": "West", "wallColor": "MEDIUM", "roofColor": "LIGHT", "foundationWalls": [ { "index": 0, "cavityInsulationGrade": "II", "cavityInsulationR": 20.5, "continuousInsulationR": 3.2, "studDepth": 4.5, "studWidth": 1.5, "studSpacing": 12.5, "studMaterial": "CONCRETE" }, { "index": 1, "continuousInsulationGrade": "I" } ], "aboveGradeWalls": [ { "index": 0, "cavityInsulationGrade": "II", "cavityInsulationR": 20.5, "continuousInsulationR": 3.2, "studDepth": 4.5, "studWidth": 1.5, "studSpacing": 12.5, "studMaterial": "WOOD" }, { "index": 1, "cavityInsulationGrade": "I" } ], "framedFloors": [ { "index": 0, "cavityInsulationGrade": "II", "cavityInsulationR": 20.5, "continuousInsulationR": 3.2, "studDepth": 4.5, "studWidth": 1.5, "studSpacing": 12.5, "studMaterial": "STEEL" }, { "index": 1, "cavityInsulationGrade": "III" } ], "ceilingsAndRoofs": [ { "index": 0, "cavityInsulationGrade": "II", "continuousInsulationR": 3.2, "studDepth": 4.5, "studWidth": 1.5, "studSpacing": 12.5, "studMaterial": "WOOD", "cavityInsulationR": 20.5 }, { "index": 1, "cavityInsulationGrade": "II" } ], "windows": [ { "index": 0, "remove": "true" }, { "index": 1, "windowArea": 325.5 } ], "mechanicalEquipments": [ { "index": 0, "modelNumber": "MDLNBR-12345678", "secondModelNumber": "MDL-2-1234", "thirdModelNumber": "M-3-ABCD", "percentHeatingLoad": 100, "perentCoolingLoad": 25 }, { "index": 1, "modelNumber": "MDN-1A1A1A", "secondModelNumber": "MDL-2-2-2", "perentCoolingLoad": 75, "location": "UNCONDITIONED_ATTIC" }, { "index": 2, "modelNumber": "MDLNBR-23456789", "percentHotWaterLoad": 75, "location": "AMBIENT" } ], "distributionSystems": [ { "index": 0, "leakageToOutside": 4.5, "totalLeakage": 6.5, "leakageUnit": "CFM25" } ], "mechanicalVentilations": [ { "index": 0, "ventilationType": "AIR_CYCLER", "measuredFlowRate": 50.5, "fanWatts": 35.5, "operationalHoursPerDay": 8.5 } ], "hasNaturalVentilation": "true", "hasCeilingFan": "true", "ceilingFanCfmPerWatt": 70.123, "infiltrationUnit": "ACH_NATURAL", "infiltrationValue": 3.2, "lighting": { "percentInteriorFluorescent": 25, "percentInteriorLED": 75, "percentExteriorFluorescent": 50, "percentExteriorLED": 50, "percentGarageFluorescent": 0, "percentGarageLED": 37.5 }, "water": { "waterFixtureType": "STANDARD", "hotWaterPipeLength": 89.7, "atLeastR3PipeInsulation": "true", "hasRecirculationSystem": "true", "branchLength": 30, "pipeLoopLength": 40.5, "recirculationSystemControl": "TEMPERATURE", "pumpPower": 50, "isShared": "false" }, "mandatoryItems": { "iecc2012MandatoryChecklist": "true", "iecc2015MandatoryChecklist": "true", "iecc2018MandatoryChecklist": "true", "energyStarRaterDesignReviewChecklist": "true", "energyStarHvacDesignReport": "false", "energyStarHvacCommissioningChecklist": "true", "energyStarWaterManagementSystemBuilderRequirements": "false" } } ]
Some things to note from this example:
- Not all repeatable sections must have multiple entries.
- true/false values can be double-quoted strings.
- For an explanation of how mechanical equipment model number fields are used, see this article.
Was this article helpful?
That’s Great!
Thank you for your feedback
Sorry! We couldn't be helpful
Thank you for your feedback
Feedback sent
We appreciate your effort and will try to fix the article