{"help": "https://datosabiertos.navarra.es/es/api/3/action/help_show?name=datastore_search_sql", "success": true, "result": {"sql": "SELECT * from \"0e2e3204-c0e3-418d-87bb-a2949b676f5f\" WHERE \"CodEdificio\" LIKE '%{ value }%'", "records": [], "fields": [{"id": "_id", "type": "int4"}, {"id": "_full_text", "type": "tsvector"}, {"id": "CodEdificio", "type": "text"}, {"id": "Tipo", "type": "text"}, {"id": "CodRegistroComAutonoma", "type": "text"}, {"id": "Direccion", "type": "text"}, {"id": "Localidad", "type": "text"}, {"id": "CP", "type": "text"}, {"id": "Provincia", "type": "text"}, {"id": "Zona", "type": "text"}, {"id": "AnioConstruccion", "type": "text"}, {"id": "NormativaVigente", "type": "text"}, {"id": "ReferenciaCatastral", "type": "text"}, {"id": "TipoDeEdificio", "type": "text"}, {"id": "Procedimiento", "type": "text"}, {"id": "Fecha", "type": "text"}, {"id": "SuperficieHabitable", "type": "text"}, {"id": "PorcentajeSuperficieHabitableCalefactada", "type": "text"}, {"id": "PorcentajeSuperficieHabitableRefrigerada", "type": "text"}, {"id": "PorcentajeSuperficieHabitableAcristalada", "type": "text"}, {"id": "DemandaDiariaACS", "type": "text"}, {"id": "GeneradoresCalefaccion", "type": "text"}, {"id": "GeneradoresRefrigeracion", "type": "text"}, {"id": "InstalacionesACS", "type": "text"}, {"id": "SistemasTermicos", "type": "text"}, {"id": "SistemasElectricos", "type": "text"}, {"id": "PotenciaTotalInstalada", "type": "text"}, {"id": "Nombre", "type": "text"}, {"id": "ConsumoFinalCalefaccion", "type": "text"}, {"id": "ConsumoFinalRefrigeracion", "type": "text"}, {"id": "ConsumoFinalACS", "type": "text"}, {"id": "DemandaACS", "type": "text"}, {"id": "Nombre1", "type": "text"}, {"id": "EnergiaGeneradaAutoconsumida", "type": "text"}, {"id": "ReduccionGlobalEnergiaPrimariaNoRenovable", "type": "text"}, {"id": "Global", "type": "text"}, {"id": "Calefaccion", "type": "text"}, {"id": "Refrigeracion", "type": "text"}, {"id": "ACS", "type": "text"}, {"id": "GasNatural", "type": "text"}, {"id": "GasoleoC", "type": "text"}, {"id": "GLP", "type": "text"}, {"id": "Carbon", "type": "text"}, {"id": "BiomasaPellet", "type": "text"}, {"id": "BiomasaOtros", "type": "text"}, {"id": "ElectricidadPeninsular", "type": "text"}, {"id": "ElectricidadBaleares", "type": "text"}, {"id": "ElectricidadCanarias", "type": "text"}, {"id": "ElectricidadCeutayMelilla", "type": "text"}, {"id": "Biocarburante", "type": "text"}, {"id": "EnergiaPrimNoRenovable", "type": "text"}, {"id": "EmisionesCO2", "type": "text"}, {"id": "CalificacionDemandaEscalaCalefaccion", "type": "text"}, {"id": "CalificacionDemandaEscalaRefrigeracion", "type": "text"}, {"id": "CalificacionDemandaCalefaccion", "type": "text"}, {"id": "CalificacionDemandaRefrigeracion", "type": "text"}, {"id": "CalificacionEnePrinNoRenovEscalaGlobal", "type": "text"}, {"id": "CalificacionEnePrinNoRenovGlobal", "type": "text"}, {"id": "CalificacionEnePrinNoRenovCalefaccion", "type": "text"}, {"id": "CalificacionEnePrinNoRenovRefrigeracion", "type": "text"}, {"id": "CalificacionEnePrinNoRenovACS", "type": "text"}, {"id": "CalificacionEnePrinNoRenovIluminacion", "type": "text"}, {"id": "CalificacionEmiCO2EscalaGlobal", "type": "text"}, {"id": "CalificacionEmiCO2Global", "type": "text"}, {"id": "CalificacionEmiCO2Calefaccion", "type": "text"}, {"id": "CalificacionEmiCO2Refrigeracion", "type": "text"}, {"id": "CalificacionEmiCO2ACS", "type": "text"}, {"id": "CalificacionEmiCO2Iluminacion", "type": "text"}]}}