{"id":444460,"date":"2026-04-03T02:43:18","date_gmt":"2026-04-03T00:43:18","guid":{"rendered":"https:\/\/www.kafinea.com\/documentation\/uncategorized\/api-rest-solicitudes-y-consultas\/"},"modified":"2026-04-03T02:43:18","modified_gmt":"2026-04-03T00:43:18","password":"","slug":"api-rest-solicitudes-y-consultas","status":"publish","type":"docs","link":"https:\/\/www.kafinea.com\/es\/documentation\/api\/api-rest-solicitudes-y-consultas\/","title":{"rendered":"API REST &#8211; Solicitudes y consultas"},"content":{"rendered":"<hr>\n<h2>Query \u2014 Consultar la base de datos<\/h2>\n<p>Esta operaci\u00f3n permite ejecutar una consulta SELECT. La consulta debe seguir un formato espec\u00edfico y presenta ciertas limitaciones: <\/p>\n<ul>\n<li>Un solo tipo de entidad por consulta (sin JOIN)<\/li>\n<li>M\u00e1ximo 100 resultados por consulta (utilice <code>LIMIT<\/code> y <code>OFFSET<\/code> para paginar)<\/li>\n<li>Las cl\u00e1usulas <code>WHERE<\/code>, <code>ORDER BY<\/code> y <code>LIMIT<\/code> son opcionales<\/li>\n<li>La consulta debe estar codificada en URL<\/li>\n<\/ul>\n<blockquote>\n<p><strong>GET<\/strong> <code>https:\/\/apps.kafinea.com\/{instance}\/webservice.php<\/code><\/p>\n<\/blockquote>\n<div style=\"overflow-x:auto\">\n<table>\n<thead>\n<tr>\n<th>Par\u00e1metro<\/th>\n<th>Tipo<\/th>\n<th>Obligatorio<\/th>\n<th>Descripci\u00f3n<\/th>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<td><code>operation<\/code><\/td>\n<td>string<\/td>\n<td>s\u00ed<\/td>\n<td>Debe ser  <code>query<\/code><\/td>\n<\/tr>\n<tr>\n<td><code>sessionName<\/code><\/td>\n<td>string<\/td>\n<td>s\u00ed<\/td>\n<td>Identificador de sesi\u00f3n<\/td>\n<\/tr>\n<tr>\n<td><code>query<\/code><\/td>\n<td>string<\/td>\n<td>s\u00ed<\/td>\n<td>Consulta SQL (codificada en URL)<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<p><strong>Ejemplo de curl:<\/strong><\/p>\n<pre><code class=\"language-bash\">curl \"https:\/\/apps.kafinea.com\/YourKafinea\/webservice.php?operation=query&sessionName=YOUR_SESSION_ID&query=SELECT%20*%20FROM%20Contacts%20WHERE%20lastname%3D'Dupont'%20LIMIT%2010%20;\"\n<\/code><\/pre>\n<h3>Formato de la consulta<\/h3>\n<pre><code class=\"language-sql\">SELECT * | ColumnsList | count(*)\nFROM ModuleName\nWHERE Conditions\nORDER BY ColumnsList\nLIMIT Offset, Limit ;\n<\/code><\/pre>\n<blockquote class=\"bq-important\">\n<p><strong>Importante:<\/strong> el punto y coma final es obligatorio.<\/p>\n<\/blockquote>\n<p><strong>Detalles:<\/strong><\/p>\n<div style=\"overflow-x:auto\">\n<table>\n<thead>\n<tr>\n<th>Elemento<\/th>\n<th>Descripci\u00f3n<\/th>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<td><code>ColumnsList<\/code><\/td>\n<td>Lista de nombres de campos separados por comas<\/td>\n<\/tr>\n<tr>\n<td><code>ModuleName<\/code><\/td>\n<td>Nombre del m\u00f3dulo de la entidad<\/td>\n<\/tr>\n<tr>\n<td><code>Conditions<\/code><\/td>\n<td>Separadas por <code>AND<\/code> o <code>OR<\/code>, tratadas de izquierda a derecha. Sin agrupaci\u00f3n con par\u00e9ntesis. <\/td>\n<\/tr>\n<tr>\n<td><code>Offset<\/code><\/td>\n<td>Entero (opcional)<\/td>\n<\/tr>\n<tr>\n<td><code>Limit<\/code><\/td>\n<td>Entero<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<p><strong>Tipos de condiciones disponibles:<\/strong><\/p>\n<div style=\"overflow-x:auto\">\n<table>\n<thead>\n<tr>\n<th>Tipo<\/th>\n<th>Sintaxis<\/th>\n<th>Ejemplo<\/th>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<td>Operador<\/td>\n<td><code>&lt;<\/code>, <code>&gt;<\/code>, <code>&lt;=<\/code>, <code>&gt;=<\/code>, <code>!=<\/code>,  <code>=<\/code><\/td>\n<td><code>lastname = 'Dupont'<\/code><\/td>\n<\/tr>\n<tr>\n<td>IN<\/td>\n<td><code>IN(val1, val2, ...)<\/code><\/td>\n<td><code>industry IN('Tech', 'Finance')<\/code><\/td>\n<\/tr>\n<tr>\n<td>LIKE<\/td>\n<td><code>LIKE 'pattern'<\/code><\/td>\n<td><code>lastname LIKE '%dup%'<\/code><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<hr>\n<h2>Query Related \u2014 Consultar las listas relacionadas<\/h2>\n<p>Esta operaci\u00f3n permite obtener las entidades de las listas relacionadas de una entidad espec\u00edfica. La consulta sigue el mismo formato que <code>query<\/code>, pero <strong>sin punto y coma final<\/strong>. <\/p>\n<blockquote>\n<p><strong>GET<\/strong> <code>https:\/\/apps.kafinea.com\/{instance}\/webservice.php<\/code><\/p>\n<\/blockquote>\n<div style=\"overflow-x:auto\">\n<table>\n<thead>\n<tr>\n<th>Par\u00e1metro<\/th>\n<th>Tipo<\/th>\n<th>Obligatorio<\/th>\n<th>Descripci\u00f3n<\/th>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<td><code>operation<\/code><\/td>\n<td>string<\/td>\n<td>s\u00ed<\/td>\n<td>Debe ser  <code>query_related<\/code><\/td>\n<\/tr>\n<tr>\n<td><code>sessionName<\/code><\/td>\n<td>string<\/td>\n<td>s\u00ed<\/td>\n<td>Identificador de sesi\u00f3n<\/td>\n<\/tr>\n<tr>\n<td><code>id<\/code><\/td>\n<td>string<\/td>\n<td>s\u00ed<\/td>\n<td>ID de Webservice de la entidad principal<\/td>\n<\/tr>\n<tr>\n<td><code>relatedLabel<\/code><\/td>\n<td>string<\/td>\n<td>s\u00ed<\/td>\n<td>Nombre del m\u00f3dulo relacionado<\/td>\n<\/tr>\n<tr>\n<td><code>query<\/code><\/td>\n<td>string<\/td>\n<td>s\u00ed<\/td>\n<td>Consulta SQL (codificada en URL, sin <code>;<\/code> final)<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<p><strong>Ejemplo de curl:<\/strong><\/p>\n<pre><code class=\"language-bash\">curl \"https:\/\/apps.kafinea.com\/YourKafinea\/webservice.php?operation=query_related&sessionName=YOUR_SESSION_ID&id=21x3456&relatedLabel=Documents&query=SELECT%20*%20FROM%20Documents%20WHERE%20filesize%20%3E%2010000\"\n<\/code><\/pre>\n<p><strong>Ejemplo de consulta:<\/strong><\/p>\n<pre><code class=\"language-sql\">SELECT * FROM Documents WHERE filesize &gt; 10000\n<\/code><\/pre>\n<hr>\n<h2>Referencias asociadas \ud83d\udd17<\/h2>\n<ul>\n<li><a href=\"https:\/\/www.kafinea.com\/es\/documentation\/api\/api-rest-operaciones-crud\/\">Operaciones CRUD<\/a><\/li>\n<li><a href=\"https:\/\/www.kafinea.com\/es\/documentation\/api\/api-rest-introduccion\/\">Introducci\u00f3n a la API<\/a><\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>Query \u2014 Consultar la base de datos Esta operaci\u00f3n permite ejecutar una consulta SELECT. La consulta debe seguir un formato espec\u00edfico y presenta ciertas limitaciones: Un solo tipo de entidad por consulta (sin JOIN) M\u00e1ximo 100 resultados por consulta (utilice LIMIT y OFFSET para paginar) Las cl\u00e1usulas WHERE, ORDER BY y LIMIT son opcionales La&#8230;<\/p>\n","protected":false},"author":4,"featured_media":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"_uag_custom_page_level_css":"","_kad_post_transparent":"","_kad_post_title":"","_kad_post_layout":"","_kad_post_sidebar_id":"","_kad_post_content_style":"","_kad_post_vertical_padding":"","_kad_post_feature":"","_kad_post_feature_position":"","_kad_post_header":false,"_kad_post_footer":false,"_kad_post_classname":"","footnotes":""},"doc_category":[758],"doc_tag":[],"class_list":["post-444460","docs","type-docs","status-publish","hentry","doc_category-api"],"year_month":"2026-07","word_count":360,"total_views":0,"reactions":{"happy":0,"normal":0,"sad":0},"author_info":{"name":"David Valminos","author_nicename":"david","author_url":"https:\/\/www.kafinea.com\/es\/author\/david\/"},"doc_category_info":[{"term_name":"API","term_url":"https:\/\/www.kafinea.com\/es\/documentation\/api\/"}],"doc_tag_info":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v28.0 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Documentation - API REST - Solicitudes y consultas &#8226; Kafinea<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.kafinea.com\/es\/documentation\/api\/api-rest-solicitudes-y-consultas\/\" \/>\n<meta property=\"og:locale\" content=\"es_ES\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Documentation - API REST - Solicitudes y consultas &#8226; Kafinea\" \/>\n<meta property=\"og:description\" content=\"Query \u2014 Consultar la base de datos Esta operaci\u00f3n permite ejecutar una consulta SELECT. La consulta debe seguir un formato espec\u00edfico y presenta ciertas limitaciones: Un solo tipo de entidad por consulta (sin JOIN) M\u00e1ximo 100 resultados por consulta (utilice LIMIT y OFFSET para paginar) Las cl\u00e1usulas WHERE, ORDER BY y LIMIT son opcionales La...\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.kafinea.com\/es\/documentation\/api\/api-rest-solicitudes-y-consultas\/\" \/>\n<meta property=\"og:site_name\" content=\"Kafinea\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Tiempo de lectura\" \/>\n\t<meta name=\"twitter:data1\" content=\"2 minutos\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.kafinea.com\\\/es\\\/documentation\\\/api\\\/api-rest-solicitudes-y-consultas\\\/\",\"url\":\"https:\\\/\\\/www.kafinea.com\\\/es\\\/documentation\\\/api\\\/api-rest-solicitudes-y-consultas\\\/\",\"name\":\"Documentation - API REST - Solicitudes y consultas &#8226; Kafinea\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.kafinea.com\\\/es\\\/#website\"},\"datePublished\":\"2026-04-03T00:43:18+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.kafinea.com\\\/es\\\/documentation\\\/api\\\/api-rest-solicitudes-y-consultas\\\/#breadcrumb\"},\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.kafinea.com\\\/es\\\/documentation\\\/api\\\/api-rest-solicitudes-y-consultas\\\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.kafinea.com\\\/es\\\/documentation\\\/api\\\/api-rest-solicitudes-y-consultas\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\\\/\\\/www.kafinea.com\\\/es\\\/inicio\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Documentation\",\"item\":\"https:\\\/\\\/www.kafinea.com\\\/es\\\/documentation\\\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"API REST &#8211; Solicitudes y consultas\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.kafinea.com\\\/es\\\/#website\",\"url\":\"https:\\\/\\\/www.kafinea.com\\\/es\\\/\",\"name\":\"Kafinea\",\"description\":\"Une solution unique pour toutes vos ambitions\",\"publisher\":{\"@id\":\"https:\\\/\\\/www.kafinea.com\\\/es\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.kafinea.com\\\/es\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"es\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/www.kafinea.com\\\/es\\\/#organization\",\"name\":\"Kafinea\",\"url\":\"https:\\\/\\\/www.kafinea.com\\\/es\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\\\/\\\/www.kafinea.com\\\/es\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/www.kafinea.com\\\/wp-content\\\/uploads\\\/2024\\\/10\\\/Logo-Kafinea-SVG-orange-bleu.svg\",\"contentUrl\":\"https:\\\/\\\/www.kafinea.com\\\/wp-content\\\/uploads\\\/2024\\\/10\\\/Logo-Kafinea-SVG-orange-bleu.svg\",\"width\":296.31,\"height\":66.48,\"caption\":\"Kafinea\"},\"image\":{\"@id\":\"https:\\\/\\\/www.kafinea.com\\\/es\\\/#\\\/schema\\\/logo\\\/image\\\/\"},\"sameAs\":[\"https:\\\/\\\/www.linkedin.com\\\/company\\\/kafinea\\\/\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Documentation - API REST - Solicitudes y consultas &#8226; Kafinea","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.kafinea.com\/es\/documentation\/api\/api-rest-solicitudes-y-consultas\/","og_locale":"es_ES","og_type":"article","og_title":"Documentation - API REST - Solicitudes y consultas &#8226; Kafinea","og_description":"Query \u2014 Consultar la base de datos Esta operaci\u00f3n permite ejecutar una consulta SELECT. La consulta debe seguir un formato espec\u00edfico y presenta ciertas limitaciones: Un solo tipo de entidad por consulta (sin JOIN) M\u00e1ximo 100 resultados por consulta (utilice LIMIT y OFFSET para paginar) Las cl\u00e1usulas WHERE, ORDER BY y LIMIT son opcionales La...","og_url":"https:\/\/www.kafinea.com\/es\/documentation\/api\/api-rest-solicitudes-y-consultas\/","og_site_name":"Kafinea","twitter_card":"summary_large_image","twitter_misc":{"Tiempo de lectura":"2 minutos"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.kafinea.com\/es\/documentation\/api\/api-rest-solicitudes-y-consultas\/","url":"https:\/\/www.kafinea.com\/es\/documentation\/api\/api-rest-solicitudes-y-consultas\/","name":"Documentation - API REST - Solicitudes y consultas &#8226; Kafinea","isPartOf":{"@id":"https:\/\/www.kafinea.com\/es\/#website"},"datePublished":"2026-04-03T00:43:18+00:00","breadcrumb":{"@id":"https:\/\/www.kafinea.com\/es\/documentation\/api\/api-rest-solicitudes-y-consultas\/#breadcrumb"},"inLanguage":"es","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.kafinea.com\/es\/documentation\/api\/api-rest-solicitudes-y-consultas\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.kafinea.com\/es\/documentation\/api\/api-rest-solicitudes-y-consultas\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/www.kafinea.com\/es\/inicio\/"},{"@type":"ListItem","position":2,"name":"Documentation","item":"https:\/\/www.kafinea.com\/es\/documentation\/"},{"@type":"ListItem","position":3,"name":"API REST &#8211; Solicitudes y consultas"}]},{"@type":"WebSite","@id":"https:\/\/www.kafinea.com\/es\/#website","url":"https:\/\/www.kafinea.com\/es\/","name":"Kafinea","description":"Une solution unique pour toutes vos ambitions","publisher":{"@id":"https:\/\/www.kafinea.com\/es\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.kafinea.com\/es\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"es"},{"@type":"Organization","@id":"https:\/\/www.kafinea.com\/es\/#organization","name":"Kafinea","url":"https:\/\/www.kafinea.com\/es\/","logo":{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/www.kafinea.com\/es\/#\/schema\/logo\/image\/","url":"https:\/\/www.kafinea.com\/wp-content\/uploads\/2024\/10\/Logo-Kafinea-SVG-orange-bleu.svg","contentUrl":"https:\/\/www.kafinea.com\/wp-content\/uploads\/2024\/10\/Logo-Kafinea-SVG-orange-bleu.svg","width":296.31,"height":66.48,"caption":"Kafinea"},"image":{"@id":"https:\/\/www.kafinea.com\/es\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.linkedin.com\/company\/kafinea\/"]}]}},"uagb_featured_image_src":{"full":false,"thumbnail":false,"medium":false,"medium_large":false,"large":false,"1536x1536":false,"2048x2048":false},"uagb_author_info":{"display_name":"David Valminos","author_link":"https:\/\/www.kafinea.com\/es\/author\/david\/"},"uagb_comment_info":0,"uagb_excerpt":"Query \u2014 Consultar la base de datos Esta operaci\u00f3n permite ejecutar una consulta SELECT. La consulta debe seguir un formato espec\u00edfico y presenta ciertas limitaciones: Un solo tipo de entidad por consulta (sin JOIN) M\u00e1ximo 100 resultados por consulta (utilice LIMIT y OFFSET para paginar) Las cl\u00e1usulas WHERE, ORDER BY y LIMIT son opcionales La...","_links":{"self":[{"href":"https:\/\/www.kafinea.com\/es\/wp-json\/wp\/v2\/docs\/444460","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.kafinea.com\/es\/wp-json\/wp\/v2\/docs"}],"about":[{"href":"https:\/\/www.kafinea.com\/es\/wp-json\/wp\/v2\/types\/docs"}],"author":[{"embeddable":true,"href":"https:\/\/www.kafinea.com\/es\/wp-json\/wp\/v2\/users\/4"}],"replies":[{"embeddable":true,"href":"https:\/\/www.kafinea.com\/es\/wp-json\/wp\/v2\/comments?post=444460"}],"version-history":[{"count":0,"href":"https:\/\/www.kafinea.com\/es\/wp-json\/wp\/v2\/docs\/444460\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.kafinea.com\/es\/wp-json\/wp\/v2\/media?parent=444460"}],"wp:term":[{"taxonomy":"doc_category","embeddable":true,"href":"https:\/\/www.kafinea.com\/es\/wp-json\/wp\/v2\/doc_category?post=444460"},{"taxonomy":"doc_tag","embeddable":true,"href":"https:\/\/www.kafinea.com\/es\/wp-json\/wp\/v2\/doc_tag?post=444460"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}