{"help": "https://datosabiertos.navarra.es/eu/api/3/action/help_show?name=datastore_search_sql", "success": true, "result": {"sql": "SELECT * from \"649826f8-20ae-46ba-87f8-b77320402cf6\" WHERE \"NUMERO REGISTRO\" LIKE '%{ value }%'", "records": [], "fields": [{"id": "_id", "type": "int4"}, {"id": "_full_text", "type": "tsvector"}, {"id": "NUMERO REGISTRO", "type": "text"}, {"id": "Nombre Establecimiento", "type": "text"}, {"id": "Tipo Establecimiento", "type": "text"}, {"id": "Subtipo Establecimiento", "type": "text"}, {"id": "Superficie por Tipo", "type": "text"}, {"id": "Superficie Global", "type": "text"}, {"id": "Aforo por Tipo", "type": "text"}, {"id": "Aforo Global", "type": "text"}, {"id": "Observaciones", "type": "text"}, {"id": "Domicilio", "type": "text"}, {"id": "Portal", "type": "text"}, {"id": "Codigo Postal", "type": "text"}, {"id": "Localidad", "type": "text"}, {"id": "Fecha Inscripcion", "type": "text"}, {"id": "Fecha Modificacion", "type": "text"}, {"id": "Fecha Baja", "type": "text"}, {"id": "Motivo Cancelacion", "type": "text"}, {"id": "Fecha Licencia Actividad", "type": "text"}, {"id": "Fecha Licencia Apertura", "type": "text"}, {"id": "Hora Apertura", "type": "text"}, {"id": "Hora Cierre", "type": "text"}, {"id": "Nivel  Sonoro", "type": "text"}, {"id": "NIF/CIF Titular IAE", "type": "text"}, {"id": "Apellido1 / Razon Social Titular IAE", "type": "text"}, {"id": "Apellido2 Titular IAE", "type": "text"}, {"id": "Nombre Titular IAE", "type": "text"}, {"id": "Tipo Titular IAE", "type": "text"}, {"id": "NIF/CIF Titular Licencia", "type": "text"}, {"id": "Apellido1 / Razon Social Titular Licencia", "type": "text"}, {"id": "Apellido2 Titular Licencia", "type": "text"}, {"id": "Nombre Titular Licencia", "type": "text"}, {"id": "Tipo Titular Licencia", "type": "text"}]}}