{"error": "Debe enviar el archivo en el campo 'file' (multipart/form-data)."}
{ "error": "Extensión '.xls' no soportada. Formatos admitidos: .xlsx. Si el archivo es .xls, ábralo en Excel y guárdelo como .xlsx."}
{"msg": "Token inválido o expirado", "success": false}
{"error": "El archivo supera el tamaño máximo de 10 MB."}
Requires an active session. The JWT is read from the access_token_cookie cookie
and the request must carry the X-CSRF-TOKEN header. It is sent as
multipart/form-data. This endpoint only validates: it does not save the file.
Excel .xlsx file with the institutional projects. An .xls is rejected
with a message asking to save it as .xlsx. Only the first sheet is read,
with one row per project. If a project has several researchers or
funding sources, they are separated with ; in the same cell, or the
row is repeated with the same codigo_proyecto.
The first row holds the headers. They are recognized even if the case, accents or spaces change, or if they carry the * with which the format document marks the mandatory ones: Código Proyecto* is codigo_proyecto. A column that is not in the format is ignored with a warning, and a repeated column is an error.
Column
Mandatory
Description
codigo_proyecto
✅
Unique identifier of the project. It must not change in future updates.
titulo
✅
Full name of the project.
fecha_inicio
✅
Start date: a cell with a date format, or the text DD/MM/YYYY.
investigador_principal_id
✅
Document number of the principal investigator, without spaces or separators. It must match the Staff format.
resumen
Recommended
Summary or abstract of the project. If the column or the value is missing, a warning is reported.
objetivos
—
General or specific objectives.
tipo_proyecto
—
One of: investigación, extensión, regalías, innovación, consultoría.
estado
—
One of: propuesta, en ejecución, finalizado, suspendido.
fecha_fin
—
End date, with the same format as fecha_inicio.
investigador_principal_institucion_id
—
ROR code of the principal investigator’s institution: 03bp5hc83 or https://ror.org/03bp5hc83.
investigadores_ids
—
Documents of the co-investigators, separated by ;.
valor_total
—
Total budget in COP: an integer, without currency signs or thousands separators (e.g. 50000000).
valor_especie_total
—
In-kind budget in COP, with the same format.
valor_fresco_total
—
Budget in fresh resources in COP, with the same format.
fuente_financiacion_ids
—
ROR codes or Wikidata IDs (Q12345) of the funding entities, separated by ;.
instituciones_participantes_ids
—
ROR codes or Wikidata IDs of the partner institutions, separated by ;.
codigo_minciencias
—
Code of the project in MinCiencias / CvLAC / GrupLAC.
codigo_bpin
—
BPIN code for royalty or public investment projects.
convocatoria
—
Name or code of the call.
regiones_ejecucion_id
—
GeoNames codes of departments or regions (the number or its URL), separated by ;.
unidad_academica_ids
—
Codes of the responsible academic units, separated by ;. They must match the Staff format.
grupos_id
—
Scienti codes of the research groups, separated by ;.
productos_asociados_ids
—
Identifiers of derived products (DOI, DSpace Handle, MinCiencias code, OpenAlex ID), separated by ;.
Catalogue values are accepted regardless of case, accents or extra spaces; a value outside the catalogue is an error. Blank rows are ignored.
Project finalizado without fecha_fin (if the column exists)
Warning
Project of regalías without codigo_bpin
Warning
The principal investigator is also in investigadores_ids
Warning
valor_total different from valor_especie_total + valor_fresco_total (if all three have a value)
Warning
A repeated value in a list column
Warning
A project repeated over several rows can vary in the list columns. In the other columns, a value different from that of the project’s first row with that field filled in is an error.
Number of unique projects (by codigo_proyecto). null if there are
structural errors, such as a missing mandatory column: in that case the
rows are not validated.
Code of the problem type. For example, missing_column,
unknown_column, required, recommended_missing, invalid_date,
invalid_money, invalid_enum, invalid_date_range or
conflicting_values.
{"error": "Debe enviar el archivo en el campo 'file' (multipart/form-data)."}
{ "error": "Extensión '.xls' no soportada. Formatos admitidos: .xlsx. Si el archivo es .xls, ábralo en Excel y guárdelo como .xlsx."}
{"msg": "Token inválido o expirado", "success": false}
{"error": "El archivo supera el tamaño máximo de 10 MB."}
{"docsConfig":{"theme":"mint","$schema":"https://mintlify.com/docs.json","name":"ImpactU","colors":{"primary":"#46B3B3","light":"#62C7C7","dark":"#39658C"},"logo":{"light":"https://mintcdn.com/co-la-v/BlcLkPiBd3QcCUsw/images/quyca-logo.svg?fit=max\u0026auto=format\u0026n=BlcLkPiBd3QcCUsw\u0026q=85\u0026s=27d9cf857a2bfd279f5b35574a676f58","dark":"https://mintcdn.com/co-la-v/BlcLkPiBd3QcCUsw/images/quyca-logo-dark.svg?fit=max\u0026auto=format\u0026n=BlcLkPiBd3QcCUsw\u0026q=85\u0026s=f896b3ed36d81d4d5fd800486a5b1069"},"favicon":"https://mintcdn.com/co-la-v/BlcLkPiBd3QcCUsw/images/favicon.ico?fit=max\u0026auto=format\u0026n=BlcLkPiBd3QcCUsw\u0026q=85\u0026s=f39c627a5c069304a3f228637905683d","styling":{"latex":false},"navigation":{"languages":[{"language":"es","href":""},{"language":"en","href":"en"}]}},"deployment":{"deploymentMetadataValue":{"subdomain":"co-la-v","hasAudioNarration":false,"actualSubdomain":"co-la-v","customDomains":["help.impactu.colav.co"],"gitSource":{"type":"github","owner":"colav","repo":"quipu","deployBranch":"main","contentDirectory":"","isPrivate":false,"mountPath":"","label":"","_id":"6adbb73769dc05fec9ac3800"},"chroma":{"latestBuiltDeploymentHistoryId":"6aea64ac3ba6ef9b4346f881","collectionId":"0d5d9cd1-d161-4854-b082-ca2b31699be9","liveDeploymentHistoryId":"6aea64ac3ba6ef9b4346f881","schemaVersion":"v3"},"entitlements":{"AI_CHAT":{"status":"ENABLED"},"WEB_MCP":{"status":"ENABLED"},"NARRATION":{"status":"ENABLED"}},"buildId":"6aea656c01465c40fb228481","clientVersion":"0.0.4054","searchFilterCounts":[{"language":"es","tag":"API Referencia","count":119},{"language":"en","tag":"API Reference","count":119},{"language":"es","tag":"Indicadores","count":50},{"language":"en","tag":"Indicators","count":50},{"language":"es","tag":"Affiliation","count":40},{"language":"en","tag":"Affiliation","count":40},{"language":"es","tag":"Person","count":25},{"language":"en","tag":"Person","count":25},{"language":"es","tag":"Search","count":10},{"language":"en","tag":"Search","count":10},{"language":"es","tag":"Usuarios","count":9},{"language":"en","tag":"Users","count":9},{"language":"es","tag":"Source","count":7},{"language":"en","tag":"Source","count":7},{"language":"es","tag":"Submit","count":4},{"language":"en","tag":"Submit","count":4},{"language":"es","tag":"APC","count":3},{"language":"es","tag":"Autenticación","count":3},{"language":"en","tag":"APC","count":3},{"language":"en","tag":"Authentication","count":3}]},"assistantConfig":{"enableAskAiButton":false,"enableStarterQuestions":false,"enableContextualStarterQuestions":false,"enableAskAiSearchBar":true},"basePath":"","hasChatPermissions":true,"hasWebMcpPermissions":true,"toggles":[{"name":"kill-isr","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"agent-mintlify-slack","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"agent-integrations-settings","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"rbac-expansion","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"automations-pr-grouping","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"custom-prefix","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"analytics-v7","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"user-flows-analytics","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"no-publish-flow","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"workos-onboarding","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"llms-txt-v2","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"snapshot-serving-live","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"stripTemperatureMiddleware","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"support-platform-pylon-zendesk","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"snapshot-serving","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"instant-rollback","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"granular-notifications-server","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"granular-notifications","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"automations-fable","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"fixed-ai-action-pricing","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"automation-resolve-merge-conflict","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"scoped-publishing","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"mintql","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"page-level-analytics","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"editor-version-history-v2","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"billing-page-v2","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"full-page-search","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"workspace-projects","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"assistant-v5","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"byok-sep-25","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"fork-pr-previews","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"revalidation-jwt","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"vite-origin","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"billing-updated-9-15","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"workos-sso-scim","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"hobby-abuse-scan","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"dashboard-inbox","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"workos-signup","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"turbopuffer-dual-write","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"workos-enabled","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"approve-review-flow","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"sso-setup-deadline-banner","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"turbopuffer-serve","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false}],"googleFontsInlined":false},"customCss":[],"page":{"pagePath":"en/api-reference/submit/project","slug":"/en/api-reference/submit/project","pageMetadata":{"title":"Validate projects file","api":"POST https://api.dev.impactu.colav.co/submit/project","description":"Validates an Excel file of institutional projects (format v1.0) and returns a detailed report of errors and warnings.","href":"/en/api-reference/submit/project"},"description":{"compiledSource":"\"use strict\";\nconst {jsx: _jsx} = arguments[0];\nconst {useMDXComponents: _provideComponents} = arguments[0];\nfunction _createMdxContent(props) {\n const _components = {\n p: \"p\",\n ..._provideComponents(),\n ...props.components\n };\n return _jsx(_components.p, {\n children: \"Validates an Excel file of institutional projects (format v1.0) and returns a detailed report of errors and warnings.\"\n });\n}\nfunction MDXContent(props = {}) {\n const {wrapper: MDXLayout} = {\n ..._provideComponents(),\n ...props.components\n };\n return MDXLayout ? _jsx(MDXLayout, {\n ...props,\n children: _jsx(_createMdxContent, {\n ...props\n })\n }) : _createMdxContent(props);\n}\nreturn {\n default: MDXContent\n};\n","frontmatter":{},"scope":{}},"pageType":"default","mdx":{"mdxSource":{"compiledSource":"\"use strict\";const{Fragment:_Fragment,jsx:_jsx,jsxs:_jsxs}=arguments[0];const{useMDXComponents:_provideComponents}=arguments[0];function _createMdxContent(props){const _components={code:`code`,p:`p`,tbody:`tbody`,td:`td`,th:`th`,thead:`thead`,tr:`tr`,..._provideComponents(),...props.components},{Expandable,Heading,Note,ParamField,ResponseField,Table}=_components;if(!Expandable)_missingMdxReference(`Expandable`,true);if(!Heading)_missingMdxReference(`Heading`,true);if(!Note)_missingMdxReference(`Note`,true);if(!ParamField)_missingMdxReference(`ParamField`,true);if(!ResponseField)_missingMdxReference(`ResponseField`,true);if(!Table)_missingMdxReference(`Table`,true);return _jsxs(_Fragment,{children:[_jsx(Note,{children:_jsxs(_components.p,{children:[`Requires an active session. The JWT is read from the `,_jsx(_components.code,{children:`access_token_cookie`}),` cookie\nand the request must carry the `,_jsx(_components.code,{children:`X-CSRF-TOKEN`}),` header. It is sent as\n`,_jsx(_components.code,{children:`multipart/form-data`}),`. This endpoint only validates: it does not save the file.`]})}),`\n`,_jsx(Heading,{level:`2`,id:`request-body`,children:`Request body`}),`\n`,_jsx(ParamField,{body:`file`,type:`file`,required:true,id:`param-file`,children:_jsxs(_components.p,{children:[`Excel `,_jsx(_components.code,{children:`.xlsx`}),` file with the institutional projects. An `,_jsx(_components.code,{children:`.xls`}),` is rejected\nwith a message asking to save it as `,_jsx(_components.code,{children:`.xlsx`}),`. Only the first sheet is read,\nwith one row per project. If a project has several researchers or\nfunding sources, they are separated with `,_jsx(_components.code,{children:`;`}),` in the same cell, or the\nrow is repeated with the same `,_jsx(_components.code,{children:`codigo_proyecto`}),`.`]})}),`\n`,_jsx(Heading,{level:`2`,id:`limits`,children:`Limits`}),`\n`,_jsxs(Table,{children:[_jsx(_components.thead,{children:_jsxs(_components.tr,{children:[_jsx(_components.th,{children:`Limit`}),_jsx(_components.th,{children:`Value`}),_jsx(_components.th,{children:`Response`})]})}),_jsxs(_components.tbody,{children:[_jsxs(_components.tr,{children:[_jsx(_components.td,{children:`File size`}),_jsx(_components.td,{\"data-numeric\":`true`,children:`10 MB`}),_jsxs(_components.td,{children:[_jsx(_components.code,{children:`413`}),`, without reading the file`]})]}),_jsxs(_components.tr,{children:[_jsxs(_components.td,{children:[`Uncompressed content (an `,_jsx(_components.code,{children:`.xlsx`}),` is a zip)`]}),_jsx(_components.td,{\"data-numeric\":`true`,children:`100 MB`}),_jsx(_components.td,{\"data-numeric\":`true`,children:_jsx(_components.code,{children:`400`})})]}),_jsxs(_components.tr,{children:[_jsx(_components.td,{children:`Rows with data`}),_jsx(_components.td,{\"data-numeric\":`true`,children:`20,000`}),_jsx(_components.td,{\"data-numeric\":`true`,children:_jsx(_components.code,{children:`400`})})]}),_jsxs(_components.tr,{children:[_jsxs(_components.td,{children:[`Problems listed in `,_jsx(_components.code,{children:`issues`})]}),_jsx(_components.td,{\"data-numeric\":`true`,children:`500`}),_jsxs(_components.td,{children:[_jsx(_components.code,{children:`200`}),`, with `,_jsx(_components.code,{children:`issues_truncated: true`}),` and the full counts`]})]})]})]}),`\n`,_jsxs(_components.p,{children:[`An empty or damaged file, or one that is not an Excel file, returns `,_jsx(_components.code,{children:`400`}),` with the reason.`]}),`\n`,_jsx(Heading,{level:`2`,id:`file-format`,children:`File format`}),`\n`,_jsxs(_components.p,{children:[`The first row holds the headers. They are recognized even if the case, accents or spaces change, or if they carry the `,_jsx(_components.code,{children:`*`}),` with which the format document marks the mandatory ones: `,_jsx(_components.code,{children:`Código Proyecto*`}),` is `,_jsx(_components.code,{children:`codigo_proyecto`}),`. A column that is not in the format is ignored with a warning, and a repeated column is an error.`]}),`\n`,_jsxs(Table,{children:[_jsx(_components.thead,{children:_jsxs(_components.tr,{children:[_jsx(_components.th,{children:`Column`}),_jsx(_components.th,{children:`Mandatory`}),_jsx(_components.th,{children:`Description`})]})}),_jsxs(_components.tbody,{children:[_jsxs(_components.tr,{children:[_jsx(_components.td,{children:_jsx(_components.code,{children:`codigo_proyecto`})}),_jsx(_components.td,{children:`✅`}),_jsx(_components.td,{children:`Unique identifier of the project. It must not change in future updates.`})]}),_jsxs(_components.tr,{children:[_jsx(_components.td,{children:_jsx(_components.code,{children:`titulo`})}),_jsx(_components.td,{children:`✅`}),_jsx(_components.td,{children:`Full name of the project.`})]}),_jsxs(_components.tr,{children:[_jsx(_components.td,{children:_jsx(_components.code,{children:`fecha_inicio`})}),_jsx(_components.td,{children:`✅`}),_jsxs(_components.td,{children:[`Start date: a cell with a date format, or the text `,_jsx(_components.code,{children:`DD/MM/YYYY`}),`.`]})]}),_jsxs(_components.tr,{children:[_jsx(_components.td,{children:_jsx(_components.code,{children:`investigador_principal_id`})}),_jsx(_components.td,{children:`✅`}),_jsx(_components.td,{children:`Document number of the principal investigator, without spaces or separators. It must match the Staff format.`})]}),_jsxs(_components.tr,{children:[_jsx(_components.td,{children:_jsx(_components.code,{children:`resumen`})}),_jsx(_components.td,{children:`Recommended`}),_jsx(_components.td,{children:`Summary or abstract of the project. If the column or the value is missing, a warning is reported.`})]}),_jsxs(_components.tr,{children:[_jsx(_components.td,{children:_jsx(_components.code,{children:`objetivos`})}),_jsx(_components.td,{children:`—`}),_jsx(_components.td,{children:`General or specific objectives.`})]}),_jsxs(_components.tr,{children:[_jsx(_components.td,{children:_jsx(_components.code,{children:`tipo_proyecto`})}),_jsx(_components.td,{children:`—`}),_jsxs(_components.td,{children:[`One of: `,_jsx(_components.code,{children:`investigación`}),`, `,_jsx(_components.code,{children:`extensión`}),`, `,_jsx(_components.code,{children:`regalías`}),`, `,_jsx(_components.code,{children:`innovación`}),`, `,_jsx(_components.code,{children:`consultoría`}),`.`]})]}),_jsxs(_components.tr,{children:[_jsx(_components.td,{children:_jsx(_components.code,{children:`estado`})}),_jsx(_components.td,{children:`—`}),_jsxs(_components.td,{children:[`One of: `,_jsx(_components.code,{children:`propuesta`}),`, `,_jsx(_components.code,{children:`en ejecución`}),`, `,_jsx(_components.code,{children:`finalizado`}),`, `,_jsx(_components.code,{children:`suspendido`}),`.`]})]}),_jsxs(_components.tr,{children:[_jsx(_components.td,{children:_jsx(_components.code,{children:`fecha_fin`})}),_jsx(_components.td,{children:`—`}),_jsxs(_components.td,{children:[`End date, with the same format as `,_jsx(_components.code,{children:`fecha_inicio`}),`.`]})]}),_jsxs(_components.tr,{children:[_jsx(_components.td,{children:_jsx(_components.code,{children:`investigador_principal_institucion_id`})}),_jsx(_components.td,{children:`—`}),_jsxs(_components.td,{children:[`ROR code of the principal investigator’s institution: `,_jsx(_components.code,{children:`03bp5hc83`}),` or `,_jsx(_components.code,{children:`https://ror.org/03bp5hc83`}),`.`]})]}),_jsxs(_components.tr,{children:[_jsx(_components.td,{children:_jsx(_components.code,{children:`investigadores_ids`})}),_jsx(_components.td,{children:`—`}),_jsxs(_components.td,{children:[`Documents of the co-investigators, separated by `,_jsx(_components.code,{children:`;`}),`.`]})]}),_jsxs(_components.tr,{children:[_jsx(_components.td,{children:_jsx(_components.code,{children:`valor_total`})}),_jsx(_components.td,{children:`—`}),_jsxs(_components.td,{children:[`Total budget in COP: an integer, without currency signs or thousands separators (e.g. `,_jsx(_components.code,{children:`50000000`}),`).`]})]}),_jsxs(_components.tr,{children:[_jsx(_components.td,{children:_jsx(_components.code,{children:`valor_especie_total`})}),_jsx(_components.td,{children:`—`}),_jsx(_components.td,{children:`In-kind budget in COP, with the same format.`})]}),_jsxs(_components.tr,{children:[_jsx(_components.td,{children:_jsx(_components.code,{children:`valor_fresco_total`})}),_jsx(_components.td,{children:`—`}),_jsx(_components.td,{children:`Budget in fresh resources in COP, with the same format.`})]}),_jsxs(_components.tr,{children:[_jsx(_components.td,{children:_jsx(_components.code,{children:`fuente_financiacion_ids`})}),_jsx(_components.td,{children:`—`}),_jsxs(_components.td,{children:[`ROR codes or Wikidata IDs (`,_jsx(_components.code,{children:`Q12345`}),`) of the funding entities, separated by `,_jsx(_components.code,{children:`;`}),`.`]})]}),_jsxs(_components.tr,{children:[_jsx(_components.td,{children:_jsx(_components.code,{children:`instituciones_participantes_ids`})}),_jsx(_components.td,{children:`—`}),_jsxs(_components.td,{children:[`ROR codes or Wikidata IDs of the partner institutions, separated by `,_jsx(_components.code,{children:`;`}),`.`]})]}),_jsxs(_components.tr,{children:[_jsx(_components.td,{children:_jsx(_components.code,{children:`codigo_minciencias`})}),_jsx(_components.td,{children:`—`}),_jsx(_components.td,{children:`Code of the project in MinCiencias / CvLAC / GrupLAC.`})]}),_jsxs(_components.tr,{children:[_jsx(_components.td,{children:_jsx(_components.code,{children:`codigo_bpin`})}),_jsx(_components.td,{children:`—`}),_jsx(_components.td,{children:`BPIN code for royalty or public investment projects.`})]}),_jsxs(_components.tr,{children:[_jsx(_components.td,{children:_jsx(_components.code,{children:`convocatoria`})}),_jsx(_components.td,{children:`—`}),_jsx(_components.td,{children:`Name or code of the call.`})]}),_jsxs(_components.tr,{children:[_jsx(_components.td,{children:_jsx(_components.code,{children:`regiones_ejecucion_id`})}),_jsx(_components.td,{children:`—`}),_jsxs(_components.td,{children:[`GeoNames codes of departments or regions (the number or its URL), separated by `,_jsx(_components.code,{children:`;`}),`.`]})]}),_jsxs(_components.tr,{children:[_jsx(_components.td,{children:_jsx(_components.code,{children:`unidad_academica_ids`})}),_jsx(_components.td,{children:`—`}),_jsxs(_components.td,{children:[`Codes of the responsible academic units, separated by `,_jsx(_components.code,{children:`;`}),`. They must match the Staff format.`]})]}),_jsxs(_components.tr,{children:[_jsx(_components.td,{children:_jsx(_components.code,{children:`grupos_id`})}),_jsx(_components.td,{children:`—`}),_jsxs(_components.td,{children:[`Scienti codes of the research groups, separated by `,_jsx(_components.code,{children:`;`}),`.`]})]}),_jsxs(_components.tr,{children:[_jsx(_components.td,{children:_jsx(_components.code,{children:`productos_asociados_ids`})}),_jsx(_components.td,{children:`—`}),_jsxs(_components.td,{children:[`Identifiers of derived products (DOI, DSpace Handle, MinCiencias code, OpenAlex ID), separated by `,_jsx(_components.code,{children:`;`}),`.`]})]})]})]}),`\n`,_jsx(_components.p,{children:`Catalogue values are accepted regardless of case, accents or extra spaces; a value outside the catalogue is an error. Blank rows are ignored.`}),`\n`,_jsx(Heading,{level:`3`,id:`rules-between-fields`,children:`Rules between fields`}),`\n`,_jsxs(Table,{children:[_jsx(_components.thead,{children:_jsxs(_components.tr,{children:[_jsx(_components.th,{children:`Rule`}),_jsx(_components.th,{children:`Severity`})]})}),_jsxs(_components.tbody,{children:[_jsxs(_components.tr,{children:[_jsxs(_components.td,{children:[_jsx(_components.code,{children:`fecha_fin`}),` earlier than `,_jsx(_components.code,{children:`fecha_inicio`})]}),_jsx(_components.td,{children:`Error`})]}),_jsxs(_components.tr,{children:[_jsxs(_components.td,{children:[`Project `,_jsx(_components.code,{children:`finalizado`}),` without `,_jsx(_components.code,{children:`fecha_fin`}),` (if the column exists)`]}),_jsx(_components.td,{children:`Warning`})]}),_jsxs(_components.tr,{children:[_jsxs(_components.td,{children:[`Project of `,_jsx(_components.code,{children:`regalías`}),` without `,_jsx(_components.code,{children:`codigo_bpin`})]}),_jsx(_components.td,{children:`Warning`})]}),_jsxs(_components.tr,{children:[_jsxs(_components.td,{children:[`The principal investigator is also in `,_jsx(_components.code,{children:`investigadores_ids`})]}),_jsx(_components.td,{children:`Warning`})]}),_jsxs(_components.tr,{children:[_jsxs(_components.td,{children:[_jsx(_components.code,{children:`valor_total`}),` different from `,_jsx(_components.code,{children:`valor_especie_total`}),` + `,_jsx(_components.code,{children:`valor_fresco_total`}),` (if all three have a value)`]}),_jsx(_components.td,{children:`Warning`})]}),_jsxs(_components.tr,{children:[_jsx(_components.td,{children:`A repeated value in a list column`}),_jsx(_components.td,{children:`Warning`})]})]})]}),`\n`,_jsx(_components.p,{children:`A project repeated over several rows can vary in the list columns. In the other columns, a value different from that of the project’s first row with that field filled in is an error.`}),`\n`,_jsx(Heading,{level:`2`,id:`response`,children:`Response`}),`\n`,_jsxs(ResponseField,{name:`data`,type:`object`,id:`param-data`,children:[_jsx(_components.p,{children:`Validation report.`}),_jsxs(Expandable,{title:`properties`,children:[_jsx(ResponseField,{name:`schema_version`,type:`string`,id:`param-schema-version`,children:_jsx(_components.p,{children:`Version of the validation schema used.`})}),_jsx(ResponseField,{name:`valid`,type:`boolean`,id:`param-valid`,children:_jsxs(_components.p,{children:[_jsx(_components.code,{children:`true`}),` if the file has no errors (it may have warnings).`]})}),_jsx(ResponseField,{name:`total_rows`,type:`integer`,id:`param-total-rows`,children:_jsx(_components.p,{children:`Number of rows with data.`})}),_jsx(ResponseField,{name:`total_projects`,type:`integer | null`,id:`param-total-projects`,children:_jsxs(_components.p,{children:[`Number of unique projects (by `,_jsx(_components.code,{children:`codigo_proyecto`}),`). `,_jsx(_components.code,{children:`null`}),` if there are\nstructural errors, such as a missing mandatory column: in that case the\nrows are not validated.`]})}),_jsx(ResponseField,{name:`errors_count`,type:`integer`,id:`param-errors-count`,children:_jsx(_components.p,{children:`Number of errors found.`})}),_jsx(ResponseField,{name:`warnings_count`,type:`integer`,id:`param-warnings-count`,children:_jsx(_components.p,{children:`Number of warnings found.`})}),_jsx(ResponseField,{name:`issues_truncated`,type:`boolean`,id:`param-issues-truncated`,children:_jsxs(_components.p,{children:[_jsx(_components.code,{children:`true`}),` if there are more than 500 problems: `,_jsx(_components.code,{children:`issues`}),` lists the first 500 and the\ncounts include all of them.`]})}),_jsxs(ResponseField,{name:`issues`,type:`object[]`,id:`param-issues`,children:[_jsx(_components.p,{children:`List of problems, sorted by row (first those of the file, without a row)\nand then by column.`}),_jsxs(Expandable,{title:`properties of each problem`,children:[_jsx(ResponseField,{name:`severity`,type:`string`,id:`param-severity`,children:_jsxs(_components.p,{children:[_jsx(_components.code,{children:`error`}),` or `,_jsx(_components.code,{children:`warning`}),`.`]})}),_jsx(ResponseField,{name:`code`,type:`string`,id:`param-code`,children:_jsxs(_components.p,{children:[`Code of the problem type. For example, `,_jsx(_components.code,{children:`missing_column`}),`,\n`,_jsx(_components.code,{children:`unknown_column`}),`, `,_jsx(_components.code,{children:`required`}),`, `,_jsx(_components.code,{children:`recommended_missing`}),`, `,_jsx(_components.code,{children:`invalid_date`}),`,\n`,_jsx(_components.code,{children:`invalid_money`}),`, `,_jsx(_components.code,{children:`invalid_enum`}),`, `,_jsx(_components.code,{children:`invalid_date_range`}),` or\n`,_jsx(_components.code,{children:`conflicting_values`}),`.`]})}),_jsx(ResponseField,{name:`message`,type:`string`,id:`param-message`,children:_jsx(_components.p,{children:`Description of the problem.`})}),_jsx(ResponseField,{name:`row`,type:`integer | null`,id:`param-row`,children:_jsxs(_components.p,{children:[`Row number in Excel. `,_jsx(_components.code,{children:`null`}),` for problems of the file\n(missing columns, extra sheets).`]})}),_jsx(ResponseField,{name:`column`,type:`string | null`,id:`param-column`,children:_jsx(_components.p,{children:`Name of the affected column, if any.`})}),_jsx(ResponseField,{name:`value`,type:`string | null`,id:`param-value`,children:_jsx(_components.p,{children:`Value that caused the problem, if any.`})})]})]})]})]})]})}function MDXContent(props={}){const{wrapper:MDXLayout}={..._provideComponents(),...props.components};return MDXLayout?_jsx(MDXLayout,{...props,children:_jsx(_createMdxContent,{...props})}):_createMdxContent(props)}return{default:MDXContent};function _missingMdxReference(id,component){throw new Error(`Expected `+(component?`component`:`object`)+\" `\"+id+\"` to be defined: you likely forgot to import, pass, or provide it.\")}","frontmatter":{},"scope":{"config":{},"pageMetadata":{"title":"Validate projects file","api":"POST https://api.dev.impactu.colav.co/submit/project","description":"Validates an Excel file of institutional projects (format v1.0) and returns a detailed report of errors and warnings.","href":"/en/api-reference/submit/project"}}},"mdxSourceWithNoJs":{"compiledSource":"\"use strict\";const{Fragment:_Fragment,jsx:_jsx,jsxs:_jsxs}=arguments[0];const{useMDXComponents:_provideComponents}=arguments[0];function _createMdxContent(props){const _components={code:`code`,p:`p`,pre:`pre`,span:`span`,tbody:`tbody`,td:`td`,th:`th`,thead:`thead`,tr:`tr`,..._provideComponents(),...props.components},{CodeBlock,Expandable,Heading,Note,ParamField,ResponseExample,ResponseField,Table}=_components;if(!CodeBlock)_missingMdxReference(`CodeBlock`,true);if(!Expandable)_missingMdxReference(`Expandable`,true);if(!Heading)_missingMdxReference(`Heading`,true);if(!Note)_missingMdxReference(`Note`,true);if(!ParamField)_missingMdxReference(`ParamField`,true);if(!ResponseExample)_missingMdxReference(`ResponseExample`,true);if(!ResponseField)_missingMdxReference(`ResponseField`,true);if(!Table)_missingMdxReference(`Table`,true);return _jsxs(_Fragment,{children:[_jsx(Note,{children:_jsxs(_components.p,{children:[`Requires an active session. The JWT is read from the `,_jsx(_components.code,{children:`access_token_cookie`}),` cookie\nand the request must carry the `,_jsx(_components.code,{children:`X-CSRF-TOKEN`}),` header. It is sent as\n`,_jsx(_components.code,{children:`multipart/form-data`}),`. This endpoint only validates: it does not save the file.`]})}),`\n`,_jsx(Heading,{level:`2`,id:`request-body`,children:`Request body`}),`\n`,_jsx(ParamField,{body:`file`,type:`file`,required:true,id:`param-file`,children:_jsxs(_components.p,{children:[`Excel `,_jsx(_components.code,{children:`.xlsx`}),` file with the institutional projects. An `,_jsx(_components.code,{children:`.xls`}),` is rejected\nwith a message asking to save it as `,_jsx(_components.code,{children:`.xlsx`}),`. Only the first sheet is read,\nwith one row per project. If a project has several researchers or\nfunding sources, they are separated with `,_jsx(_components.code,{children:`;`}),` in the same cell, or the\nrow is repeated with the same `,_jsx(_components.code,{children:`codigo_proyecto`}),`.`]})}),`\n`,_jsx(Heading,{level:`2`,id:`limits`,children:`Limits`}),`\n`,_jsxs(Table,{children:[_jsx(_components.thead,{children:_jsxs(_components.tr,{children:[_jsx(_components.th,{children:`Limit`}),_jsx(_components.th,{children:`Value`}),_jsx(_components.th,{children:`Response`})]})}),_jsxs(_components.tbody,{children:[_jsxs(_components.tr,{children:[_jsx(_components.td,{children:`File size`}),_jsx(_components.td,{\"data-numeric\":`true`,children:`10 MB`}),_jsxs(_components.td,{children:[_jsx(_components.code,{children:`413`}),`, without reading the file`]})]}),_jsxs(_components.tr,{children:[_jsxs(_components.td,{children:[`Uncompressed content (an `,_jsx(_components.code,{children:`.xlsx`}),` is a zip)`]}),_jsx(_components.td,{\"data-numeric\":`true`,children:`100 MB`}),_jsx(_components.td,{\"data-numeric\":`true`,children:_jsx(_components.code,{children:`400`})})]}),_jsxs(_components.tr,{children:[_jsx(_components.td,{children:`Rows with data`}),_jsx(_components.td,{\"data-numeric\":`true`,children:`20,000`}),_jsx(_components.td,{\"data-numeric\":`true`,children:_jsx(_components.code,{children:`400`})})]}),_jsxs(_components.tr,{children:[_jsxs(_components.td,{children:[`Problems listed in `,_jsx(_components.code,{children:`issues`})]}),_jsx(_components.td,{\"data-numeric\":`true`,children:`500`}),_jsxs(_components.td,{children:[_jsx(_components.code,{children:`200`}),`, with `,_jsx(_components.code,{children:`issues_truncated: true`}),` and the full counts`]})]})]})]}),`\n`,_jsxs(_components.p,{children:[`An empty or damaged file, or one that is not an Excel file, returns `,_jsx(_components.code,{children:`400`}),` with the reason.`]}),`\n`,_jsx(Heading,{level:`2`,id:`file-format`,children:`File format`}),`\n`,_jsxs(_components.p,{children:[`The first row holds the headers. They are recognized even if the case, accents or spaces change, or if they carry the `,_jsx(_components.code,{children:`*`}),` with which the format document marks the mandatory ones: `,_jsx(_components.code,{children:`Código Proyecto*`}),` is `,_jsx(_components.code,{children:`codigo_proyecto`}),`. A column that is not in the format is ignored with a warning, and a repeated column is an error.`]}),`\n`,_jsxs(Table,{children:[_jsx(_components.thead,{children:_jsxs(_components.tr,{children:[_jsx(_components.th,{children:`Column`}),_jsx(_components.th,{children:`Mandatory`}),_jsx(_components.th,{children:`Description`})]})}),_jsxs(_components.tbody,{children:[_jsxs(_components.tr,{children:[_jsx(_components.td,{children:_jsx(_components.code,{children:`codigo_proyecto`})}),_jsx(_components.td,{children:`✅`}),_jsx(_components.td,{children:`Unique identifier of the project. It must not change in future updates.`})]}),_jsxs(_components.tr,{children:[_jsx(_components.td,{children:_jsx(_components.code,{children:`titulo`})}),_jsx(_components.td,{children:`✅`}),_jsx(_components.td,{children:`Full name of the project.`})]}),_jsxs(_components.tr,{children:[_jsx(_components.td,{children:_jsx(_components.code,{children:`fecha_inicio`})}),_jsx(_components.td,{children:`✅`}),_jsxs(_components.td,{children:[`Start date: a cell with a date format, or the text `,_jsx(_components.code,{children:`DD/MM/YYYY`}),`.`]})]}),_jsxs(_components.tr,{children:[_jsx(_components.td,{children:_jsx(_components.code,{children:`investigador_principal_id`})}),_jsx(_components.td,{children:`✅`}),_jsx(_components.td,{children:`Document number of the principal investigator, without spaces or separators. It must match the Staff format.`})]}),_jsxs(_components.tr,{children:[_jsx(_components.td,{children:_jsx(_components.code,{children:`resumen`})}),_jsx(_components.td,{children:`Recommended`}),_jsx(_components.td,{children:`Summary or abstract of the project. If the column or the value is missing, a warning is reported.`})]}),_jsxs(_components.tr,{children:[_jsx(_components.td,{children:_jsx(_components.code,{children:`objetivos`})}),_jsx(_components.td,{children:`—`}),_jsx(_components.td,{children:`General or specific objectives.`})]}),_jsxs(_components.tr,{children:[_jsx(_components.td,{children:_jsx(_components.code,{children:`tipo_proyecto`})}),_jsx(_components.td,{children:`—`}),_jsxs(_components.td,{children:[`One of: `,_jsx(_components.code,{children:`investigación`}),`, `,_jsx(_components.code,{children:`extensión`}),`, `,_jsx(_components.code,{children:`regalías`}),`, `,_jsx(_components.code,{children:`innovación`}),`, `,_jsx(_components.code,{children:`consultoría`}),`.`]})]}),_jsxs(_components.tr,{children:[_jsx(_components.td,{children:_jsx(_components.code,{children:`estado`})}),_jsx(_components.td,{children:`—`}),_jsxs(_components.td,{children:[`One of: `,_jsx(_components.code,{children:`propuesta`}),`, `,_jsx(_components.code,{children:`en ejecución`}),`, `,_jsx(_components.code,{children:`finalizado`}),`, `,_jsx(_components.code,{children:`suspendido`}),`.`]})]}),_jsxs(_components.tr,{children:[_jsx(_components.td,{children:_jsx(_components.code,{children:`fecha_fin`})}),_jsx(_components.td,{children:`—`}),_jsxs(_components.td,{children:[`End date, with the same format as `,_jsx(_components.code,{children:`fecha_inicio`}),`.`]})]}),_jsxs(_components.tr,{children:[_jsx(_components.td,{children:_jsx(_components.code,{children:`investigador_principal_institucion_id`})}),_jsx(_components.td,{children:`—`}),_jsxs(_components.td,{children:[`ROR code of the principal investigator’s institution: `,_jsx(_components.code,{children:`03bp5hc83`}),` or `,_jsx(_components.code,{children:`https://ror.org/03bp5hc83`}),`.`]})]}),_jsxs(_components.tr,{children:[_jsx(_components.td,{children:_jsx(_components.code,{children:`investigadores_ids`})}),_jsx(_components.td,{children:`—`}),_jsxs(_components.td,{children:[`Documents of the co-investigators, separated by `,_jsx(_components.code,{children:`;`}),`.`]})]}),_jsxs(_components.tr,{children:[_jsx(_components.td,{children:_jsx(_components.code,{children:`valor_total`})}),_jsx(_components.td,{children:`—`}),_jsxs(_components.td,{children:[`Total budget in COP: an integer, without currency signs or thousands separators (e.g. `,_jsx(_components.code,{children:`50000000`}),`).`]})]}),_jsxs(_components.tr,{children:[_jsx(_components.td,{children:_jsx(_components.code,{children:`valor_especie_total`})}),_jsx(_components.td,{children:`—`}),_jsx(_components.td,{children:`In-kind budget in COP, with the same format.`})]}),_jsxs(_components.tr,{children:[_jsx(_components.td,{children:_jsx(_components.code,{children:`valor_fresco_total`})}),_jsx(_components.td,{children:`—`}),_jsx(_components.td,{children:`Budget in fresh resources in COP, with the same format.`})]}),_jsxs(_components.tr,{children:[_jsx(_components.td,{children:_jsx(_components.code,{children:`fuente_financiacion_ids`})}),_jsx(_components.td,{children:`—`}),_jsxs(_components.td,{children:[`ROR codes or Wikidata IDs (`,_jsx(_components.code,{children:`Q12345`}),`) of the funding entities, separated by `,_jsx(_components.code,{children:`;`}),`.`]})]}),_jsxs(_components.tr,{children:[_jsx(_components.td,{children:_jsx(_components.code,{children:`instituciones_participantes_ids`})}),_jsx(_components.td,{children:`—`}),_jsxs(_components.td,{children:[`ROR codes or Wikidata IDs of the partner institutions, separated by `,_jsx(_components.code,{children:`;`}),`.`]})]}),_jsxs(_components.tr,{children:[_jsx(_components.td,{children:_jsx(_components.code,{children:`codigo_minciencias`})}),_jsx(_components.td,{children:`—`}),_jsx(_components.td,{children:`Code of the project in MinCiencias / CvLAC / GrupLAC.`})]}),_jsxs(_components.tr,{children:[_jsx(_components.td,{children:_jsx(_components.code,{children:`codigo_bpin`})}),_jsx(_components.td,{children:`—`}),_jsx(_components.td,{children:`BPIN code for royalty or public investment projects.`})]}),_jsxs(_components.tr,{children:[_jsx(_components.td,{children:_jsx(_components.code,{children:`convocatoria`})}),_jsx(_components.td,{children:`—`}),_jsx(_components.td,{children:`Name or code of the call.`})]}),_jsxs(_components.tr,{children:[_jsx(_components.td,{children:_jsx(_components.code,{children:`regiones_ejecucion_id`})}),_jsx(_components.td,{children:`—`}),_jsxs(_components.td,{children:[`GeoNames codes of departments or regions (the number or its URL), separated by `,_jsx(_components.code,{children:`;`}),`.`]})]}),_jsxs(_components.tr,{children:[_jsx(_components.td,{children:_jsx(_components.code,{children:`unidad_academica_ids`})}),_jsx(_components.td,{children:`—`}),_jsxs(_components.td,{children:[`Codes of the responsible academic units, separated by `,_jsx(_components.code,{children:`;`}),`. They must match the Staff format.`]})]}),_jsxs(_components.tr,{children:[_jsx(_components.td,{children:_jsx(_components.code,{children:`grupos_id`})}),_jsx(_components.td,{children:`—`}),_jsxs(_components.td,{children:[`Scienti codes of the research groups, separated by `,_jsx(_components.code,{children:`;`}),`.`]})]}),_jsxs(_components.tr,{children:[_jsx(_components.td,{children:_jsx(_components.code,{children:`productos_asociados_ids`})}),_jsx(_components.td,{children:`—`}),_jsxs(_components.td,{children:[`Identifiers of derived products (DOI, DSpace Handle, MinCiencias code, OpenAlex ID), separated by `,_jsx(_components.code,{children:`;`}),`.`]})]})]})]}),`\n`,_jsx(_components.p,{children:`Catalogue values are accepted regardless of case, accents or extra spaces; a value outside the catalogue is an error. Blank rows are ignored.`}),`\n`,_jsx(Heading,{level:`3`,id:`rules-between-fields`,children:`Rules between fields`}),`\n`,_jsxs(Table,{children:[_jsx(_components.thead,{children:_jsxs(_components.tr,{children:[_jsx(_components.th,{children:`Rule`}),_jsx(_components.th,{children:`Severity`})]})}),_jsxs(_components.tbody,{children:[_jsxs(_components.tr,{children:[_jsxs(_components.td,{children:[_jsx(_components.code,{children:`fecha_fin`}),` earlier than `,_jsx(_components.code,{children:`fecha_inicio`})]}),_jsx(_components.td,{children:`Error`})]}),_jsxs(_components.tr,{children:[_jsxs(_components.td,{children:[`Project `,_jsx(_components.code,{children:`finalizado`}),` without `,_jsx(_components.code,{children:`fecha_fin`}),` (if the column exists)`]}),_jsx(_components.td,{children:`Warning`})]}),_jsxs(_components.tr,{children:[_jsxs(_components.td,{children:[`Project of `,_jsx(_components.code,{children:`regalías`}),` without `,_jsx(_components.code,{children:`codigo_bpin`})]}),_jsx(_components.td,{children:`Warning`})]}),_jsxs(_components.tr,{children:[_jsxs(_components.td,{children:[`The principal investigator is also in `,_jsx(_components.code,{children:`investigadores_ids`})]}),_jsx(_components.td,{children:`Warning`})]}),_jsxs(_components.tr,{children:[_jsxs(_components.td,{children:[_jsx(_components.code,{children:`valor_total`}),` different from `,_jsx(_components.code,{children:`valor_especie_total`}),` + `,_jsx(_components.code,{children:`valor_fresco_total`}),` (if all three have a value)`]}),_jsx(_components.td,{children:`Warning`})]}),_jsxs(_components.tr,{children:[_jsx(_components.td,{children:`A repeated value in a list column`}),_jsx(_components.td,{children:`Warning`})]})]})]}),`\n`,_jsx(_components.p,{children:`A project repeated over several rows can vary in the list columns. In the other columns, a value different from that of the project’s first row with that field filled in is an error.`}),`\n`,_jsx(Heading,{level:`2`,id:`response`,children:`Response`}),`\n`,_jsxs(ResponseField,{name:`data`,type:`object`,id:`param-data`,children:[_jsx(_components.p,{children:`Validation report.`}),_jsxs(Expandable,{title:`properties`,children:[_jsx(ResponseField,{name:`schema_version`,type:`string`,id:`param-schema-version`,children:_jsx(_components.p,{children:`Version of the validation schema used.`})}),_jsx(ResponseField,{name:`valid`,type:`boolean`,id:`param-valid`,children:_jsxs(_components.p,{children:[_jsx(_components.code,{children:`true`}),` if the file has no errors (it may have warnings).`]})}),_jsx(ResponseField,{name:`total_rows`,type:`integer`,id:`param-total-rows`,children:_jsx(_components.p,{children:`Number of rows with data.`})}),_jsx(ResponseField,{name:`total_projects`,type:`integer | null`,id:`param-total-projects`,children:_jsxs(_components.p,{children:[`Number of unique projects (by `,_jsx(_components.code,{children:`codigo_proyecto`}),`). `,_jsx(_components.code,{children:`null`}),` if there are\nstructural errors, such as a missing mandatory column: in that case the\nrows are not validated.`]})}),_jsx(ResponseField,{name:`errors_count`,type:`integer`,id:`param-errors-count`,children:_jsx(_components.p,{children:`Number of errors found.`})}),_jsx(ResponseField,{name:`warnings_count`,type:`integer`,id:`param-warnings-count`,children:_jsx(_components.p,{children:`Number of warnings found.`})}),_jsx(ResponseField,{name:`issues_truncated`,type:`boolean`,id:`param-issues-truncated`,children:_jsxs(_components.p,{children:[_jsx(_components.code,{children:`true`}),` if there are more than 500 problems: `,_jsx(_components.code,{children:`issues`}),` lists the first 500 and the\ncounts include all of them.`]})}),_jsxs(ResponseField,{name:`issues`,type:`object[]`,id:`param-issues`,children:[_jsx(_components.p,{children:`List of problems, sorted by row (first those of the file, without a row)\nand then by column.`}),_jsxs(Expandable,{title:`properties of each problem`,children:[_jsx(ResponseField,{name:`severity`,type:`string`,id:`param-severity`,children:_jsxs(_components.p,{children:[_jsx(_components.code,{children:`error`}),` or `,_jsx(_components.code,{children:`warning`}),`.`]})}),_jsx(ResponseField,{name:`code`,type:`string`,id:`param-code`,children:_jsxs(_components.p,{children:[`Code of the problem type. For example, `,_jsx(_components.code,{children:`missing_column`}),`,\n`,_jsx(_components.code,{children:`unknown_column`}),`, `,_jsx(_components.code,{children:`required`}),`, `,_jsx(_components.code,{children:`recommended_missing`}),`, `,_jsx(_components.code,{children:`invalid_date`}),`,\n`,_jsx(_components.code,{children:`invalid_money`}),`, `,_jsx(_components.code,{children:`invalid_enum`}),`, `,_jsx(_components.code,{children:`invalid_date_range`}),` or\n`,_jsx(_components.code,{children:`conflicting_values`}),`.`]})}),_jsx(ResponseField,{name:`message`,type:`string`,id:`param-message`,children:_jsx(_components.p,{children:`Description of the problem.`})}),_jsx(ResponseField,{name:`row`,type:`integer | null`,id:`param-row`,children:_jsxs(_components.p,{children:[`Row number in Excel. `,_jsx(_components.code,{children:`null`}),` for problems of the file\n(missing columns, extra sheets).`]})}),_jsx(ResponseField,{name:`column`,type:`string | null`,id:`param-column`,children:_jsx(_components.p,{children:`Name of the affected column, if any.`})}),_jsx(ResponseField,{name:`value`,type:`string | null`,id:`param-value`,children:_jsx(_components.p,{children:`Value that caused the problem, if any.`})})]})]})]})]}),`\n`,_jsxs(ResponseExample,{children:[_jsx(CodeBlock,{filename:`200 — valid file`,numberOfLines:`21`,language:`json`,children:_jsx(_components.pre,{className:`shiki shiki-themes github-light-default dark-plus`,style:{backgroundColor:`#ffffff`,\"--shiki-dark-bg\":`#0B0C0E`,color:`#1f2328`,\"--shiki-dark\":`#D4D4D4`},language:`json`,children:_jsxs(_components.code,{language:`json`,numberOfLines:`21`,children:[_jsx(_components.span,{className:`line`,children:_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:`{`})}),`\n`,_jsxs(_components.span,{className:`line`,children:[_jsx(_components.span,{style:{color:`#116329`,\"--shiki-dark\":`#9CDCFE`},children:` \"data\"`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:`: {`})]}),`\n`,_jsxs(_components.span,{className:`line`,children:[_jsx(_components.span,{style:{color:`#116329`,\"--shiki-dark\":`#9CDCFE`},children:` \"schema_version\"`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:`: `}),_jsx(_components.span,{style:{color:`#0A3069`,\"--shiki-dark\":`#CE9178`},children:`\"1.0\"`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:`,`})]}),`\n`,_jsxs(_components.span,{className:`line`,children:[_jsx(_components.span,{style:{color:`#116329`,\"--shiki-dark\":`#9CDCFE`},children:` \"valid\"`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:`: `}),_jsx(_components.span,{style:{color:`#0550AE`,\"--shiki-dark\":`#569CD6`},children:`true`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:`,`})]}),`\n`,_jsxs(_components.span,{className:`line`,children:[_jsx(_components.span,{style:{color:`#116329`,\"--shiki-dark\":`#9CDCFE`},children:` \"total_rows\"`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:`: `}),_jsx(_components.span,{style:{color:`#0550AE`,\"--shiki-dark\":`#B5CEA8`},children:`12`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:`,`})]}),`\n`,_jsxs(_components.span,{className:`line`,children:[_jsx(_components.span,{style:{color:`#116329`,\"--shiki-dark\":`#9CDCFE`},children:` \"total_projects\"`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:`: `}),_jsx(_components.span,{style:{color:`#0550AE`,\"--shiki-dark\":`#B5CEA8`},children:`10`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:`,`})]}),`\n`,_jsxs(_components.span,{className:`line`,children:[_jsx(_components.span,{style:{color:`#116329`,\"--shiki-dark\":`#9CDCFE`},children:` \"errors_count\"`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:`: `}),_jsx(_components.span,{style:{color:`#0550AE`,\"--shiki-dark\":`#B5CEA8`},children:`0`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:`,`})]}),`\n`,_jsxs(_components.span,{className:`line`,children:[_jsx(_components.span,{style:{color:`#116329`,\"--shiki-dark\":`#9CDCFE`},children:` \"warnings_count\"`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:`: `}),_jsx(_components.span,{style:{color:`#0550AE`,\"--shiki-dark\":`#B5CEA8`},children:`1`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:`,`})]}),`\n`,_jsxs(_components.span,{className:`line`,children:[_jsx(_components.span,{style:{color:`#116329`,\"--shiki-dark\":`#9CDCFE`},children:` \"issues_truncated\"`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:`: `}),_jsx(_components.span,{style:{color:`#0550AE`,\"--shiki-dark\":`#569CD6`},children:`false`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:`,`})]}),`\n`,_jsxs(_components.span,{className:`line`,children:[_jsx(_components.span,{style:{color:`#116329`,\"--shiki-dark\":`#9CDCFE`},children:` \"issues\"`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:`: [`})]}),`\n`,_jsx(_components.span,{className:`line`,children:_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:` {`})}),`\n`,_jsxs(_components.span,{className:`line`,children:[_jsx(_components.span,{style:{color:`#116329`,\"--shiki-dark\":`#9CDCFE`},children:` \"severity\"`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:`: `}),_jsx(_components.span,{style:{color:`#0A3069`,\"--shiki-dark\":`#CE9178`},children:`\"warning\"`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:`,`})]}),`\n`,_jsxs(_components.span,{className:`line`,children:[_jsx(_components.span,{style:{color:`#116329`,\"--shiki-dark\":`#9CDCFE`},children:` \"code\"`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:`: `}),_jsx(_components.span,{style:{color:`#0A3069`,\"--shiki-dark\":`#CE9178`},children:`\"recommended_missing\"`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:`,`})]}),`\n`,_jsxs(_components.span,{className:`line`,children:[_jsx(_components.span,{style:{color:`#116329`,\"--shiki-dark\":`#9CDCFE`},children:` \"message\"`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:`: `}),_jsx(_components.span,{style:{color:`#0A3069`,\"--shiki-dark\":`#CE9178`},children:`\"Se recomienda diligenciar 'resumen'.\"`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:`,`})]}),`\n`,_jsxs(_components.span,{className:`line`,children:[_jsx(_components.span,{style:{color:`#116329`,\"--shiki-dark\":`#9CDCFE`},children:` \"row\"`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:`: `}),_jsx(_components.span,{style:{color:`#0550AE`,\"--shiki-dark\":`#B5CEA8`},children:`3`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:`,`})]}),`\n`,_jsxs(_components.span,{className:`line`,children:[_jsx(_components.span,{style:{color:`#116329`,\"--shiki-dark\":`#9CDCFE`},children:` \"column\"`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:`: `}),_jsx(_components.span,{style:{color:`#0A3069`,\"--shiki-dark\":`#CE9178`},children:`\"resumen\"`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:`,`})]}),`\n`,_jsxs(_components.span,{className:`line`,children:[_jsx(_components.span,{style:{color:`#116329`,\"--shiki-dark\":`#9CDCFE`},children:` \"value\"`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:`: `}),_jsx(_components.span,{style:{color:`#0550AE`,\"--shiki-dark\":`#569CD6`},children:`null`})]}),`\n`,_jsx(_components.span,{className:`line`,children:_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:` }`})}),`\n`,_jsx(_components.span,{className:`line`,children:_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:` ]`})}),`\n`,_jsx(_components.span,{className:`line`,children:_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:` }`})}),`\n`,_jsx(_components.span,{className:`line`,children:_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:`}`})}),`\n`]})})}),_jsx(CodeBlock,{filename:`200 — file with errors`,numberOfLines:`29`,language:`json`,children:_jsx(_components.pre,{className:`shiki shiki-themes github-light-default dark-plus`,style:{backgroundColor:`#ffffff`,\"--shiki-dark-bg\":`#0B0C0E`,color:`#1f2328`,\"--shiki-dark\":`#D4D4D4`},language:`json`,children:_jsxs(_components.code,{language:`json`,numberOfLines:`29`,children:[_jsx(_components.span,{className:`line`,children:_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:`{`})}),`\n`,_jsxs(_components.span,{className:`line`,children:[_jsx(_components.span,{style:{color:`#116329`,\"--shiki-dark\":`#9CDCFE`},children:` \"data\"`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:`: {`})]}),`\n`,_jsxs(_components.span,{className:`line`,children:[_jsx(_components.span,{style:{color:`#116329`,\"--shiki-dark\":`#9CDCFE`},children:` \"schema_version\"`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:`: `}),_jsx(_components.span,{style:{color:`#0A3069`,\"--shiki-dark\":`#CE9178`},children:`\"1.0\"`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:`,`})]}),`\n`,_jsxs(_components.span,{className:`line`,children:[_jsx(_components.span,{style:{color:`#116329`,\"--shiki-dark\":`#9CDCFE`},children:` \"valid\"`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:`: `}),_jsx(_components.span,{style:{color:`#0550AE`,\"--shiki-dark\":`#569CD6`},children:`false`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:`,`})]}),`\n`,_jsxs(_components.span,{className:`line`,children:[_jsx(_components.span,{style:{color:`#116329`,\"--shiki-dark\":`#9CDCFE`},children:` \"total_rows\"`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:`: `}),_jsx(_components.span,{style:{color:`#0550AE`,\"--shiki-dark\":`#B5CEA8`},children:`5`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:`,`})]}),`\n`,_jsxs(_components.span,{className:`line`,children:[_jsx(_components.span,{style:{color:`#116329`,\"--shiki-dark\":`#9CDCFE`},children:` \"total_projects\"`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:`: `}),_jsx(_components.span,{style:{color:`#0550AE`,\"--shiki-dark\":`#B5CEA8`},children:`5`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:`,`})]}),`\n`,_jsxs(_components.span,{className:`line`,children:[_jsx(_components.span,{style:{color:`#116329`,\"--shiki-dark\":`#9CDCFE`},children:` \"errors_count\"`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:`: `}),_jsx(_components.span,{style:{color:`#0550AE`,\"--shiki-dark\":`#B5CEA8`},children:`2`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:`,`})]}),`\n`,_jsxs(_components.span,{className:`line`,children:[_jsx(_components.span,{style:{color:`#116329`,\"--shiki-dark\":`#9CDCFE`},children:` \"warnings_count\"`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:`: `}),_jsx(_components.span,{style:{color:`#0550AE`,\"--shiki-dark\":`#B5CEA8`},children:`0`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:`,`})]}),`\n`,_jsxs(_components.span,{className:`line`,children:[_jsx(_components.span,{style:{color:`#116329`,\"--shiki-dark\":`#9CDCFE`},children:` \"issues_truncated\"`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:`: `}),_jsx(_components.span,{style:{color:`#0550AE`,\"--shiki-dark\":`#569CD6`},children:`false`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:`,`})]}),`\n`,_jsxs(_components.span,{className:`line`,children:[_jsx(_components.span,{style:{color:`#116329`,\"--shiki-dark\":`#9CDCFE`},children:` \"issues\"`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:`: [`})]}),`\n`,_jsx(_components.span,{className:`line`,children:_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:` {`})}),`\n`,_jsxs(_components.span,{className:`line`,children:[_jsx(_components.span,{style:{color:`#116329`,\"--shiki-dark\":`#9CDCFE`},children:` \"severity\"`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:`: `}),_jsx(_components.span,{style:{color:`#0A3069`,\"--shiki-dark\":`#CE9178`},children:`\"error\"`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:`,`})]}),`\n`,_jsxs(_components.span,{className:`line`,children:[_jsx(_components.span,{style:{color:`#116329`,\"--shiki-dark\":`#9CDCFE`},children:` \"code\"`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:`: `}),_jsx(_components.span,{style:{color:`#0A3069`,\"--shiki-dark\":`#CE9178`},children:`\"required\"`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:`,`})]}),`\n`,_jsxs(_components.span,{className:`line`,children:[_jsx(_components.span,{style:{color:`#116329`,\"--shiki-dark\":`#9CDCFE`},children:` \"message\"`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:`: `}),_jsx(_components.span,{style:{color:`#0A3069`,\"--shiki-dark\":`#CE9178`},children:`\"El campo 'titulo' es obligatorio.\"`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:`,`})]}),`\n`,_jsxs(_components.span,{className:`line`,children:[_jsx(_components.span,{style:{color:`#116329`,\"--shiki-dark\":`#9CDCFE`},children:` \"row\"`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:`: `}),_jsx(_components.span,{style:{color:`#0550AE`,\"--shiki-dark\":`#B5CEA8`},children:`2`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:`,`})]}),`\n`,_jsxs(_components.span,{className:`line`,children:[_jsx(_components.span,{style:{color:`#116329`,\"--shiki-dark\":`#9CDCFE`},children:` \"column\"`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:`: `}),_jsx(_components.span,{style:{color:`#0A3069`,\"--shiki-dark\":`#CE9178`},children:`\"titulo\"`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:`,`})]}),`\n`,_jsxs(_components.span,{className:`line`,children:[_jsx(_components.span,{style:{color:`#116329`,\"--shiki-dark\":`#9CDCFE`},children:` \"value\"`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:`: `}),_jsx(_components.span,{style:{color:`#0550AE`,\"--shiki-dark\":`#569CD6`},children:`null`})]}),`\n`,_jsx(_components.span,{className:`line`,children:_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:` },`})}),`\n`,_jsx(_components.span,{className:`line`,children:_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:` {`})}),`\n`,_jsxs(_components.span,{className:`line`,children:[_jsx(_components.span,{style:{color:`#116329`,\"--shiki-dark\":`#9CDCFE`},children:` \"severity\"`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:`: `}),_jsx(_components.span,{style:{color:`#0A3069`,\"--shiki-dark\":`#CE9178`},children:`\"error\"`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:`,`})]}),`\n`,_jsxs(_components.span,{className:`line`,children:[_jsx(_components.span,{style:{color:`#116329`,\"--shiki-dark\":`#9CDCFE`},children:` \"code\"`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:`: `}),_jsx(_components.span,{style:{color:`#0A3069`,\"--shiki-dark\":`#CE9178`},children:`\"invalid_money\"`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:`,`})]}),`\n`,_jsxs(_components.span,{className:`line`,children:[_jsx(_components.span,{style:{color:`#116329`,\"--shiki-dark\":`#9CDCFE`},children:` \"message\"`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:`: `}),_jsx(_components.span,{style:{color:`#0A3069`,\"--shiki-dark\":`#CE9178`},children:`\"Debe contener solo números, sin signos de moneda ni separadores de miles (ej. 50000000).\"`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:`,`})]}),`\n`,_jsxs(_components.span,{className:`line`,children:[_jsx(_components.span,{style:{color:`#116329`,\"--shiki-dark\":`#9CDCFE`},children:` \"row\"`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:`: `}),_jsx(_components.span,{style:{color:`#0550AE`,\"--shiki-dark\":`#B5CEA8`},children:`4`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:`,`})]}),`\n`,_jsxs(_components.span,{className:`line`,children:[_jsx(_components.span,{style:{color:`#116329`,\"--shiki-dark\":`#9CDCFE`},children:` \"column\"`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:`: `}),_jsx(_components.span,{style:{color:`#0A3069`,\"--shiki-dark\":`#CE9178`},children:`\"valor_total\"`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:`,`})]}),`\n`,_jsxs(_components.span,{className:`line`,children:[_jsx(_components.span,{style:{color:`#116329`,\"--shiki-dark\":`#9CDCFE`},children:` \"value\"`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:`: `}),_jsx(_components.span,{style:{color:`#0A3069`,\"--shiki-dark\":`#CE9178`},children:`\"$ 5.000.000\"`})]}),`\n`,_jsx(_components.span,{className:`line`,children:_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:` }`})}),`\n`,_jsx(_components.span,{className:`line`,children:_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:` ]`})}),`\n`,_jsx(_components.span,{className:`line`,children:_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:` }`})}),`\n`,_jsx(_components.span,{className:`line`,children:_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:`}`})}),`\n`]})})}),_jsx(CodeBlock,{filename:`200 — missing column`,numberOfLines:`21`,language:`json`,children:_jsx(_components.pre,{className:`shiki shiki-themes github-light-default dark-plus`,style:{backgroundColor:`#ffffff`,\"--shiki-dark-bg\":`#0B0C0E`,color:`#1f2328`,\"--shiki-dark\":`#D4D4D4`},language:`json`,children:_jsxs(_components.code,{language:`json`,numberOfLines:`21`,children:[_jsx(_components.span,{className:`line`,children:_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:`{`})}),`\n`,_jsxs(_components.span,{className:`line`,children:[_jsx(_components.span,{style:{color:`#116329`,\"--shiki-dark\":`#9CDCFE`},children:` \"data\"`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:`: {`})]}),`\n`,_jsxs(_components.span,{className:`line`,children:[_jsx(_components.span,{style:{color:`#116329`,\"--shiki-dark\":`#9CDCFE`},children:` \"schema_version\"`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:`: `}),_jsx(_components.span,{style:{color:`#0A3069`,\"--shiki-dark\":`#CE9178`},children:`\"1.0\"`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:`,`})]}),`\n`,_jsxs(_components.span,{className:`line`,children:[_jsx(_components.span,{style:{color:`#116329`,\"--shiki-dark\":`#9CDCFE`},children:` \"valid\"`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:`: `}),_jsx(_components.span,{style:{color:`#0550AE`,\"--shiki-dark\":`#569CD6`},children:`false`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:`,`})]}),`\n`,_jsxs(_components.span,{className:`line`,children:[_jsx(_components.span,{style:{color:`#116329`,\"--shiki-dark\":`#9CDCFE`},children:` \"total_rows\"`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:`: `}),_jsx(_components.span,{style:{color:`#0550AE`,\"--shiki-dark\":`#B5CEA8`},children:`5`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:`,`})]}),`\n`,_jsxs(_components.span,{className:`line`,children:[_jsx(_components.span,{style:{color:`#116329`,\"--shiki-dark\":`#9CDCFE`},children:` \"total_projects\"`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:`: `}),_jsx(_components.span,{style:{color:`#0550AE`,\"--shiki-dark\":`#569CD6`},children:`null`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:`,`})]}),`\n`,_jsxs(_components.span,{className:`line`,children:[_jsx(_components.span,{style:{color:`#116329`,\"--shiki-dark\":`#9CDCFE`},children:` \"errors_count\"`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:`: `}),_jsx(_components.span,{style:{color:`#0550AE`,\"--shiki-dark\":`#B5CEA8`},children:`1`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:`,`})]}),`\n`,_jsxs(_components.span,{className:`line`,children:[_jsx(_components.span,{style:{color:`#116329`,\"--shiki-dark\":`#9CDCFE`},children:` \"warnings_count\"`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:`: `}),_jsx(_components.span,{style:{color:`#0550AE`,\"--shiki-dark\":`#B5CEA8`},children:`0`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:`,`})]}),`\n`,_jsxs(_components.span,{className:`line`,children:[_jsx(_components.span,{style:{color:`#116329`,\"--shiki-dark\":`#9CDCFE`},children:` \"issues_truncated\"`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:`: `}),_jsx(_components.span,{style:{color:`#0550AE`,\"--shiki-dark\":`#569CD6`},children:`false`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:`,`})]}),`\n`,_jsxs(_components.span,{className:`line`,children:[_jsx(_components.span,{style:{color:`#116329`,\"--shiki-dark\":`#9CDCFE`},children:` \"issues\"`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:`: [`})]}),`\n`,_jsx(_components.span,{className:`line`,children:_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:` {`})}),`\n`,_jsxs(_components.span,{className:`line`,children:[_jsx(_components.span,{style:{color:`#116329`,\"--shiki-dark\":`#9CDCFE`},children:` \"severity\"`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:`: `}),_jsx(_components.span,{style:{color:`#0A3069`,\"--shiki-dark\":`#CE9178`},children:`\"error\"`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:`,`})]}),`\n`,_jsxs(_components.span,{className:`line`,children:[_jsx(_components.span,{style:{color:`#116329`,\"--shiki-dark\":`#9CDCFE`},children:` \"code\"`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:`: `}),_jsx(_components.span,{style:{color:`#0A3069`,\"--shiki-dark\":`#CE9178`},children:`\"missing_column\"`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:`,`})]}),`\n`,_jsxs(_components.span,{className:`line`,children:[_jsx(_components.span,{style:{color:`#116329`,\"--shiki-dark\":`#9CDCFE`},children:` \"message\"`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:`: `}),_jsx(_components.span,{style:{color:`#0A3069`,\"--shiki-dark\":`#CE9178`},children:`\"Falta la columna obligatoria 'codigo_proyecto'.\"`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:`,`})]}),`\n`,_jsxs(_components.span,{className:`line`,children:[_jsx(_components.span,{style:{color:`#116329`,\"--shiki-dark\":`#9CDCFE`},children:` \"row\"`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:`: `}),_jsx(_components.span,{style:{color:`#0550AE`,\"--shiki-dark\":`#569CD6`},children:`null`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:`,`})]}),`\n`,_jsxs(_components.span,{className:`line`,children:[_jsx(_components.span,{style:{color:`#116329`,\"--shiki-dark\":`#9CDCFE`},children:` \"column\"`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:`: `}),_jsx(_components.span,{style:{color:`#0A3069`,\"--shiki-dark\":`#CE9178`},children:`\"codigo_proyecto\"`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:`,`})]}),`\n`,_jsxs(_components.span,{className:`line`,children:[_jsx(_components.span,{style:{color:`#116329`,\"--shiki-dark\":`#9CDCFE`},children:` \"value\"`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:`: `}),_jsx(_components.span,{style:{color:`#0550AE`,\"--shiki-dark\":`#569CD6`},children:`null`})]}),`\n`,_jsx(_components.span,{className:`line`,children:_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:` }`})}),`\n`,_jsx(_components.span,{className:`line`,children:_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:` ]`})}),`\n`,_jsx(_components.span,{className:`line`,children:_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:` }`})}),`\n`,_jsx(_components.span,{className:`line`,children:_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:`}`})}),`\n`]})})}),_jsx(CodeBlock,{filename:`400`,numberOfLines:`1`,language:`json`,children:_jsx(_components.pre,{className:`shiki shiki-themes github-light-default dark-plus`,style:{backgroundColor:`#ffffff`,\"--shiki-dark-bg\":`#0B0C0E`,color:`#1f2328`,\"--shiki-dark\":`#D4D4D4`},language:`json`,children:_jsxs(_components.code,{language:`json`,numberOfLines:`1`,children:[_jsxs(_components.span,{className:`line`,children:[_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:`{`}),_jsx(_components.span,{style:{color:`#116329`,\"--shiki-dark\":`#9CDCFE`},children:`\"error\"`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:`: `}),_jsx(_components.span,{style:{color:`#0A3069`,\"--shiki-dark\":`#CE9178`},children:`\"Debe enviar el archivo en el campo 'file' (multipart/form-data).\"`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:`}`})]}),`\n`]})})}),_jsx(CodeBlock,{filename:`400 — unsupported format`,numberOfLines:`3`,language:`json`,children:_jsx(_components.pre,{className:`shiki shiki-themes github-light-default dark-plus`,style:{backgroundColor:`#ffffff`,\"--shiki-dark-bg\":`#0B0C0E`,color:`#1f2328`,\"--shiki-dark\":`#D4D4D4`},language:`json`,children:_jsxs(_components.code,{language:`json`,numberOfLines:`3`,children:[_jsx(_components.span,{className:`line`,children:_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:`{`})}),`\n`,_jsxs(_components.span,{className:`line`,children:[_jsx(_components.span,{style:{color:`#116329`,\"--shiki-dark\":`#9CDCFE`},children:` \"error\"`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:`: `}),_jsx(_components.span,{style:{color:`#0A3069`,\"--shiki-dark\":`#CE9178`},children:`\"Extensión '.xls' no soportada. Formatos admitidos: .xlsx. Si el archivo es .xls, ábralo en Excel y guárdelo como .xlsx.\"`})]}),`\n`,_jsx(_components.span,{className:`line`,children:_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:`}`})}),`\n`]})})}),_jsx(CodeBlock,{filename:`401`,numberOfLines:`1`,language:`json`,children:_jsx(_components.pre,{className:`shiki shiki-themes github-light-default dark-plus`,style:{backgroundColor:`#ffffff`,\"--shiki-dark-bg\":`#0B0C0E`,color:`#1f2328`,\"--shiki-dark\":`#D4D4D4`},language:`json`,children:_jsxs(_components.code,{language:`json`,numberOfLines:`1`,children:[_jsxs(_components.span,{className:`line`,children:[_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:`{`}),_jsx(_components.span,{style:{color:`#116329`,\"--shiki-dark\":`#9CDCFE`},children:`\"msg\"`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:`: `}),_jsx(_components.span,{style:{color:`#0A3069`,\"--shiki-dark\":`#CE9178`},children:`\"Token inválido o expirado\"`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:`, `}),_jsx(_components.span,{style:{color:`#116329`,\"--shiki-dark\":`#9CDCFE`},children:`\"success\"`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:`: `}),_jsx(_components.span,{style:{color:`#0550AE`,\"--shiki-dark\":`#569CD6`},children:`false`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:`}`})]}),`\n`]})})}),_jsx(CodeBlock,{filename:`413`,numberOfLines:`1`,language:`json`,children:_jsx(_components.pre,{className:`shiki shiki-themes github-light-default dark-plus`,style:{backgroundColor:`#ffffff`,\"--shiki-dark-bg\":`#0B0C0E`,color:`#1f2328`,\"--shiki-dark\":`#D4D4D4`},language:`json`,children:_jsxs(_components.code,{language:`json`,numberOfLines:`1`,children:[_jsxs(_components.span,{className:`line`,children:[_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:`{`}),_jsx(_components.span,{style:{color:`#116329`,\"--shiki-dark\":`#9CDCFE`},children:`\"error\"`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:`: `}),_jsx(_components.span,{style:{color:`#0A3069`,\"--shiki-dark\":`#CE9178`},children:`\"El archivo supera el tamaño máximo de 10 MB.\"`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:`}`})]}),`\n`]})})})]})]})}function MDXContent(props={}){const{wrapper:MDXLayout}={..._provideComponents(),...props.components};return MDXLayout?_jsx(MDXLayout,{...props,children:_jsx(_createMdxContent,{...props})}):_createMdxContent(props)}return{default:MDXContent};function _missingMdxReference(id,component){throw new Error(`Expected `+(component?`component`:`object`)+\" `\"+id+\"` to be defined: you likely forgot to import, pass, or provide it.\")}","frontmatter":{},"scope":{"config":{},"pageMetadata":{"title":"Validate projects file","api":"POST https://api.dev.impactu.colav.co/submit/project","description":"Validates an Excel file of institutional projects (format v1.0) and returns a detailed report of errors and warnings.","href":"/en/api-reference/submit/project"}}}},"mdxExtracts":{"tableOfContents":[{"title":"Request body","slug":"request-body","depth":2,"children":[]},{"title":"Limits","slug":"limits","depth":2,"children":[]},{"title":"File format","slug":"file-format","depth":2,"children":[{"title":"Rules between fields","slug":"rules-between-fields","depth":3,"children":[]}]},{"title":"Response","slug":"response","depth":2,"children":[]}],"codeExamples":{"response":{"type":"ResponseExample","children":[{"filename":"200 — valid file","html":"\u003cpre class=\"shiki shiki-themes github-light-default dark-plus\" style=\"background-color:#ffffff;--shiki-dark-bg:#0B0C0E;color:#1f2328;--shiki-dark:#D4D4D4\" language=\"json\">\u003ccode language=\"json\" numberOfLines=\"21\">\u003cspan class=\"line\">\u003cspan style=\"color:#1F2328;--shiki-dark:#D4D4D4\">{\u003c/span>\u003c/span>\n\u003cspan class=\"line\">\u003cspan style=\"color:#116329;--shiki-dark:#9CDCFE\"> \"data\"\u003c/span>\u003cspan style=\"color:#1F2328;--shiki-dark:#D4D4D4\">: {\u003c/span>\u003c/span>\n\u003cspan class=\"line\">\u003cspan style=\"color:#116329;--shiki-dark:#9CDCFE\"> \"schema_version\"\u003c/span>\u003cspan style=\"color:#1F2328;--shiki-dark:#D4D4D4\">: \u003c/span>\u003cspan style=\"color:#0A3069;--shiki-dark:#CE9178\">\"1.0\"\u003c/span>\u003cspan style=\"color:#1F2328;--shiki-dark:#D4D4D4\">,\u003c/span>\u003c/span>\n\u003cspan class=\"line\">\u003cspan style=\"color:#116329;--shiki-dark:#9CDCFE\"> \"valid\"\u003c/span>\u003cspan style=\"color:#1F2328;--shiki-dark:#D4D4D4\">: \u003c/span>\u003cspan style=\"color:#0550AE;--shiki-dark:#569CD6\">true\u003c/span>\u003cspan style=\"color:#1F2328;--shiki-dark:#D4D4D4\">,\u003c/span>\u003c/span>\n\u003cspan class=\"line\">\u003cspan style=\"color:#116329;--shiki-dark:#9CDCFE\"> \"total_rows\"\u003c/span>\u003cspan style=\"color:#1F2328;--shiki-dark:#D4D4D4\">: \u003c/span>\u003cspan style=\"color:#0550AE;--shiki-dark:#B5CEA8\">12\u003c/span>\u003cspan style=\"color:#1F2328;--shiki-dark:#D4D4D4\">,\u003c/span>\u003c/span>\n\u003cspan class=\"line\">\u003cspan style=\"color:#116329;--shiki-dark:#9CDCFE\"> \"total_projects\"\u003c/span>\u003cspan style=\"color:#1F2328;--shiki-dark:#D4D4D4\">: \u003c/span>\u003cspan style=\"color:#0550AE;--shiki-dark:#B5CEA8\">10\u003c/span>\u003cspan style=\"color:#1F2328;--shiki-dark:#D4D4D4\">,\u003c/span>\u003c/span>\n\u003cspan class=\"line\">\u003cspan style=\"color:#116329;--shiki-dark:#9CDCFE\"> \"errors_count\"\u003c/span>\u003cspan style=\"color:#1F2328;--shiki-dark:#D4D4D4\">: \u003c/span>\u003cspan style=\"color:#0550AE;--shiki-dark:#B5CEA8\">0\u003c/span>\u003cspan style=\"color:#1F2328;--shiki-dark:#D4D4D4\">,\u003c/span>\u003c/span>\n\u003cspan class=\"line\">\u003cspan style=\"color:#116329;--shiki-dark:#9CDCFE\"> \"warnings_count\"\u003c/span>\u003cspan style=\"color:#1F2328;--shiki-dark:#D4D4D4\">: \u003c/span>\u003cspan style=\"color:#0550AE;--shiki-dark:#B5CEA8\">1\u003c/span>\u003cspan style=\"color:#1F2328;--shiki-dark:#D4D4D4\">,\u003c/span>\u003c/span>\n\u003cspan class=\"line\">\u003cspan style=\"color:#116329;--shiki-dark:#9CDCFE\"> \"issues_truncated\"\u003c/span>\u003cspan style=\"color:#1F2328;--shiki-dark:#D4D4D4\">: \u003c/span>\u003cspan style=\"color:#0550AE;--shiki-dark:#569CD6\">false\u003c/span>\u003cspan style=\"color:#1F2328;--shiki-dark:#D4D4D4\">,\u003c/span>\u003c/span>\n\u003cspan class=\"line\">\u003cspan style=\"color:#116329;--shiki-dark:#9CDCFE\"> \"issues\"\u003c/span>\u003cspan style=\"color:#1F2328;--shiki-dark:#D4D4D4\">: [\u003c/span>\u003c/span>\n\u003cspan class=\"line\">\u003cspan style=\"color:#1F2328;--shiki-dark:#D4D4D4\"> {\u003c/span>\u003c/span>\n\u003cspan class=\"line\">\u003cspan style=\"color:#116329;--shiki-dark:#9CDCFE\"> \"severity\"\u003c/span>\u003cspan style=\"color:#1F2328;--shiki-dark:#D4D4D4\">: \u003c/span>\u003cspan style=\"color:#0A3069;--shiki-dark:#CE9178\">\"warning\"\u003c/span>\u003cspan style=\"color:#1F2328;--shiki-dark:#D4D4D4\">,\u003c/span>\u003c/span>\n\u003cspan class=\"line\">\u003cspan style=\"color:#116329;--shiki-dark:#9CDCFE\"> \"code\"\u003c/span>\u003cspan style=\"color:#1F2328;--shiki-dark:#D4D4D4\">: \u003c/span>\u003cspan style=\"color:#0A3069;--shiki-dark:#CE9178\">\"recommended_missing\"\u003c/span>\u003cspan style=\"color:#1F2328;--shiki-dark:#D4D4D4\">,\u003c/span>\u003c/span>\n\u003cspan class=\"line\">\u003cspan style=\"color:#116329;--shiki-dark:#9CDCFE\"> \"message\"\u003c/span>\u003cspan style=\"color:#1F2328;--shiki-dark:#D4D4D4\">: \u003c/span>\u003cspan style=\"color:#0A3069;--shiki-dark:#CE9178\">\"Se recomienda diligenciar 'resumen'.\"\u003c/span>\u003cspan style=\"color:#1F2328;--shiki-dark:#D4D4D4\">,\u003c/span>\u003c/span>\n\u003cspan class=\"line\">\u003cspan style=\"color:#116329;--shiki-dark:#9CDCFE\"> \"row\"\u003c/span>\u003cspan style=\"color:#1F2328;--shiki-dark:#D4D4D4\">: \u003c/span>\u003cspan style=\"color:#0550AE;--shiki-dark:#B5CEA8\">3\u003c/span>\u003cspan style=\"color:#1F2328;--shiki-dark:#D4D4D4\">,\u003c/span>\u003c/span>\n\u003cspan class=\"line\">\u003cspan style=\"color:#116329;--shiki-dark:#9CDCFE\"> \"column\"\u003c/span>\u003cspan style=\"color:#1F2328;--shiki-dark:#D4D4D4\">: \u003c/span>\u003cspan style=\"color:#0A3069;--shiki-dark:#CE9178\">\"resumen\"\u003c/span>\u003cspan style=\"color:#1F2328;--shiki-dark:#D4D4D4\">,\u003c/span>\u003c/span>\n\u003cspan class=\"line\">\u003cspan style=\"color:#116329;--shiki-dark:#9CDCFE\"> \"value\"\u003c/span>\u003cspan style=\"color:#1F2328;--shiki-dark:#D4D4D4\">: \u003c/span>\u003cspan style=\"color:#0550AE;--shiki-dark:#569CD6\">null\u003c/span>\u003c/span>\n\u003cspan class=\"line\">\u003cspan style=\"color:#1F2328;--shiki-dark:#D4D4D4\"> }\u003c/span>\u003c/span>\n\u003cspan class=\"line\">\u003cspan style=\"color:#1F2328;--shiki-dark:#D4D4D4\"> ]\u003c/span>\u003c/span>\n\u003cspan class=\"line\">\u003cspan style=\"color:#1F2328;--shiki-dark:#D4D4D4\"> }\u003c/span>\u003c/span>\n\u003cspan class=\"line\">\u003cspan style=\"color:#1F2328;--shiki-dark:#D4D4D4\">}\u003c/span>\u003c/span>\n\u003c/code>\u003c/pre>"},{"filename":"200 — file with errors","html":"\u003cpre class=\"shiki shiki-themes github-light-default dark-plus\" style=\"background-color:#ffffff;--shiki-dark-bg:#0B0C0E;color:#1f2328;--shiki-dark:#D4D4D4\" language=\"json\">\u003ccode language=\"json\" numberOfLines=\"29\">\u003cspan class=\"line\">\u003cspan style=\"color:#1F2328;--shiki-dark:#D4D4D4\">{\u003c/span>\u003c/span>\n\u003cspan class=\"line\">\u003cspan style=\"color:#116329;--shiki-dark:#9CDCFE\"> \"data\"\u003c/span>\u003cspan style=\"color:#1F2328;--shiki-dark:#D4D4D4\">: {\u003c/span>\u003c/span>\n\u003cspan class=\"line\">\u003cspan style=\"color:#116329;--shiki-dark:#9CDCFE\"> \"schema_version\"\u003c/span>\u003cspan style=\"color:#1F2328;--shiki-dark:#D4D4D4\">: \u003c/span>\u003cspan style=\"color:#0A3069;--shiki-dark:#CE9178\">\"1.0\"\u003c/span>\u003cspan style=\"color:#1F2328;--shiki-dark:#D4D4D4\">,\u003c/span>\u003c/span>\n\u003cspan class=\"line\">\u003cspan style=\"color:#116329;--shiki-dark:#9CDCFE\"> \"valid\"\u003c/span>\u003cspan style=\"color:#1F2328;--shiki-dark:#D4D4D4\">: \u003c/span>\u003cspan style=\"color:#0550AE;--shiki-dark:#569CD6\">false\u003c/span>\u003cspan style=\"color:#1F2328;--shiki-dark:#D4D4D4\">,\u003c/span>\u003c/span>\n\u003cspan class=\"line\">\u003cspan style=\"color:#116329;--shiki-dark:#9CDCFE\"> \"total_rows\"\u003c/span>\u003cspan style=\"color:#1F2328;--shiki-dark:#D4D4D4\">: \u003c/span>\u003cspan style=\"color:#0550AE;--shiki-dark:#B5CEA8\">5\u003c/span>\u003cspan style=\"color:#1F2328;--shiki-dark:#D4D4D4\">,\u003c/span>\u003c/span>\n\u003cspan class=\"line\">\u003cspan style=\"color:#116329;--shiki-dark:#9CDCFE\"> \"total_projects\"\u003c/span>\u003cspan style=\"color:#1F2328;--shiki-dark:#D4D4D4\">: \u003c/span>\u003cspan style=\"color:#0550AE;--shiki-dark:#B5CEA8\">5\u003c/span>\u003cspan style=\"color:#1F2328;--shiki-dark:#D4D4D4\">,\u003c/span>\u003c/span>\n\u003cspan class=\"line\">\u003cspan style=\"color:#116329;--shiki-dark:#9CDCFE\"> \"errors_count\"\u003c/span>\u003cspan style=\"color:#1F2328;--shiki-dark:#D4D4D4\">: \u003c/span>\u003cspan style=\"color:#0550AE;--shiki-dark:#B5CEA8\">2\u003c/span>\u003cspan style=\"color:#1F2328;--shiki-dark:#D4D4D4\">,\u003c/span>\u003c/span>\n\u003cspan class=\"line\">\u003cspan style=\"color:#116329;--shiki-dark:#9CDCFE\"> \"warnings_count\"\u003c/span>\u003cspan style=\"color:#1F2328;--shiki-dark:#D4D4D4\">: \u003c/span>\u003cspan style=\"color:#0550AE;--shiki-dark:#B5CEA8\">0\u003c/span>\u003cspan style=\"color:#1F2328;--shiki-dark:#D4D4D4\">,\u003c/span>\u003c/span>\n\u003cspan class=\"line\">\u003cspan style=\"color:#116329;--shiki-dark:#9CDCFE\"> \"issues_truncated\"\u003c/span>\u003cspan style=\"color:#1F2328;--shiki-dark:#D4D4D4\">: \u003c/span>\u003cspan style=\"color:#0550AE;--shiki-dark:#569CD6\">false\u003c/span>\u003cspan style=\"color:#1F2328;--shiki-dark:#D4D4D4\">,\u003c/span>\u003c/span>\n\u003cspan class=\"line\">\u003cspan style=\"color:#116329;--shiki-dark:#9CDCFE\"> \"issues\"\u003c/span>\u003cspan style=\"color:#1F2328;--shiki-dark:#D4D4D4\">: [\u003c/span>\u003c/span>\n\u003cspan class=\"line\">\u003cspan style=\"color:#1F2328;--shiki-dark:#D4D4D4\"> {\u003c/span>\u003c/span>\n\u003cspan class=\"line\">\u003cspan style=\"color:#116329;--shiki-dark:#9CDCFE\"> \"severity\"\u003c/span>\u003cspan style=\"color:#1F2328;--shiki-dark:#D4D4D4\">: \u003c/span>\u003cspan style=\"color:#0A3069;--shiki-dark:#CE9178\">\"error\"\u003c/span>\u003cspan style=\"color:#1F2328;--shiki-dark:#D4D4D4\">,\u003c/span>\u003c/span>\n\u003cspan class=\"line\">\u003cspan style=\"color:#116329;--shiki-dark:#9CDCFE\"> \"code\"\u003c/span>\u003cspan style=\"color:#1F2328;--shiki-dark:#D4D4D4\">: \u003c/span>\u003cspan style=\"color:#0A3069;--shiki-dark:#CE9178\">\"required\"\u003c/span>\u003cspan style=\"color:#1F2328;--shiki-dark:#D4D4D4\">,\u003c/span>\u003c/span>\n\u003cspan class=\"line\">\u003cspan style=\"color:#116329;--shiki-dark:#9CDCFE\"> \"message\"\u003c/span>\u003cspan style=\"color:#1F2328;--shiki-dark:#D4D4D4\">: \u003c/span>\u003cspan style=\"color:#0A3069;--shiki-dark:#CE9178\">\"El campo 'titulo' es obligatorio.\"\u003c/span>\u003cspan style=\"color:#1F2328;--shiki-dark:#D4D4D4\">,\u003c/span>\u003c/span>\n\u003cspan class=\"line\">\u003cspan style=\"color:#116329;--shiki-dark:#9CDCFE\"> \"row\"\u003c/span>\u003cspan style=\"color:#1F2328;--shiki-dark:#D4D4D4\">: \u003c/span>\u003cspan style=\"color:#0550AE;--shiki-dark:#B5CEA8\">2\u003c/span>\u003cspan style=\"color:#1F2328;--shiki-dark:#D4D4D4\">,\u003c/span>\u003c/span>\n\u003cspan class=\"line\">\u003cspan style=\"color:#116329;--shiki-dark:#9CDCFE\"> \"column\"\u003c/span>\u003cspan style=\"color:#1F2328;--shiki-dark:#D4D4D4\">: \u003c/span>\u003cspan style=\"color:#0A3069;--shiki-dark:#CE9178\">\"titulo\"\u003c/span>\u003cspan style=\"color:#1F2328;--shiki-dark:#D4D4D4\">,\u003c/span>\u003c/span>\n\u003cspan class=\"line\">\u003cspan style=\"color:#116329;--shiki-dark:#9CDCFE\"> \"value\"\u003c/span>\u003cspan style=\"color:#1F2328;--shiki-dark:#D4D4D4\">: \u003c/span>\u003cspan style=\"color:#0550AE;--shiki-dark:#569CD6\">null\u003c/span>\u003c/span>\n\u003cspan class=\"line\">\u003cspan style=\"color:#1F2328;--shiki-dark:#D4D4D4\"> },\u003c/span>\u003c/span>\n\u003cspan class=\"line\">\u003cspan style=\"color:#1F2328;--shiki-dark:#D4D4D4\"> {\u003c/span>\u003c/span>\n\u003cspan class=\"line\">\u003cspan style=\"color:#116329;--shiki-dark:#9CDCFE\"> \"severity\"\u003c/span>\u003cspan style=\"color:#1F2328;--shiki-dark:#D4D4D4\">: \u003c/span>\u003cspan style=\"color:#0A3069;--shiki-dark:#CE9178\">\"error\"\u003c/span>\u003cspan style=\"color:#1F2328;--shiki-dark:#D4D4D4\">,\u003c/span>\u003c/span>\n\u003cspan class=\"line\">\u003cspan style=\"color:#116329;--shiki-dark:#9CDCFE\"> \"code\"\u003c/span>\u003cspan style=\"color:#1F2328;--shiki-dark:#D4D4D4\">: \u003c/span>\u003cspan style=\"color:#0A3069;--shiki-dark:#CE9178\">\"invalid_money\"\u003c/span>\u003cspan style=\"color:#1F2328;--shiki-dark:#D4D4D4\">,\u003c/span>\u003c/span>\n\u003cspan class=\"line\">\u003cspan style=\"color:#116329;--shiki-dark:#9CDCFE\"> \"message\"\u003c/span>\u003cspan style=\"color:#1F2328;--shiki-dark:#D4D4D4\">: \u003c/span>\u003cspan style=\"color:#0A3069;--shiki-dark:#CE9178\">\"Debe contener solo números, sin signos de moneda ni separadores de miles (ej. 50000000).\"\u003c/span>\u003cspan style=\"color:#1F2328;--shiki-dark:#D4D4D4\">,\u003c/span>\u003c/span>\n\u003cspan class=\"line\">\u003cspan style=\"color:#116329;--shiki-dark:#9CDCFE\"> \"row\"\u003c/span>\u003cspan style=\"color:#1F2328;--shiki-dark:#D4D4D4\">: \u003c/span>\u003cspan style=\"color:#0550AE;--shiki-dark:#B5CEA8\">4\u003c/span>\u003cspan style=\"color:#1F2328;--shiki-dark:#D4D4D4\">,\u003c/span>\u003c/span>\n\u003cspan class=\"line\">\u003cspan style=\"color:#116329;--shiki-dark:#9CDCFE\"> \"column\"\u003c/span>\u003cspan style=\"color:#1F2328;--shiki-dark:#D4D4D4\">: \u003c/span>\u003cspan style=\"color:#0A3069;--shiki-dark:#CE9178\">\"valor_total\"\u003c/span>\u003cspan style=\"color:#1F2328;--shiki-dark:#D4D4D4\">,\u003c/span>\u003c/span>\n\u003cspan class=\"line\">\u003cspan style=\"color:#116329;--shiki-dark:#9CDCFE\"> \"value\"\u003c/span>\u003cspan style=\"color:#1F2328;--shiki-dark:#D4D4D4\">: \u003c/span>\u003cspan style=\"color:#0A3069;--shiki-dark:#CE9178\">\"$ 5.000.000\"\u003c/span>\u003c/span>\n\u003cspan class=\"line\">\u003cspan style=\"color:#1F2328;--shiki-dark:#D4D4D4\"> }\u003c/span>\u003c/span>\n\u003cspan class=\"line\">\u003cspan style=\"color:#1F2328;--shiki-dark:#D4D4D4\"> ]\u003c/span>\u003c/span>\n\u003cspan class=\"line\">\u003cspan style=\"color:#1F2328;--shiki-dark:#D4D4D4\"> }\u003c/span>\u003c/span>\n\u003cspan class=\"line\">\u003cspan style=\"color:#1F2328;--shiki-dark:#D4D4D4\">}\u003c/span>\u003c/span>\n\u003c/code>\u003c/pre>"},{"filename":"200 — missing column","html":"\u003cpre class=\"shiki shiki-themes github-light-default dark-plus\" style=\"background-color:#ffffff;--shiki-dark-bg:#0B0C0E;color:#1f2328;--shiki-dark:#D4D4D4\" language=\"json\">\u003ccode language=\"json\" numberOfLines=\"21\">\u003cspan class=\"line\">\u003cspan style=\"color:#1F2328;--shiki-dark:#D4D4D4\">{\u003c/span>\u003c/span>\n\u003cspan class=\"line\">\u003cspan style=\"color:#116329;--shiki-dark:#9CDCFE\"> \"data\"\u003c/span>\u003cspan style=\"color:#1F2328;--shiki-dark:#D4D4D4\">: {\u003c/span>\u003c/span>\n\u003cspan class=\"line\">\u003cspan style=\"color:#116329;--shiki-dark:#9CDCFE\"> \"schema_version\"\u003c/span>\u003cspan style=\"color:#1F2328;--shiki-dark:#D4D4D4\">: \u003c/span>\u003cspan style=\"color:#0A3069;--shiki-dark:#CE9178\">\"1.0\"\u003c/span>\u003cspan style=\"color:#1F2328;--shiki-dark:#D4D4D4\">,\u003c/span>\u003c/span>\n\u003cspan class=\"line\">\u003cspan style=\"color:#116329;--shiki-dark:#9CDCFE\"> \"valid\"\u003c/span>\u003cspan style=\"color:#1F2328;--shiki-dark:#D4D4D4\">: \u003c/span>\u003cspan style=\"color:#0550AE;--shiki-dark:#569CD6\">false\u003c/span>\u003cspan style=\"color:#1F2328;--shiki-dark:#D4D4D4\">,\u003c/span>\u003c/span>\n\u003cspan class=\"line\">\u003cspan style=\"color:#116329;--shiki-dark:#9CDCFE\"> \"total_rows\"\u003c/span>\u003cspan style=\"color:#1F2328;--shiki-dark:#D4D4D4\">: \u003c/span>\u003cspan style=\"color:#0550AE;--shiki-dark:#B5CEA8\">5\u003c/span>\u003cspan style=\"color:#1F2328;--shiki-dark:#D4D4D4\">,\u003c/span>\u003c/span>\n\u003cspan class=\"line\">\u003cspan style=\"color:#116329;--shiki-dark:#9CDCFE\"> \"total_projects\"\u003c/span>\u003cspan style=\"color:#1F2328;--shiki-dark:#D4D4D4\">: \u003c/span>\u003cspan style=\"color:#0550AE;--shiki-dark:#569CD6\">null\u003c/span>\u003cspan style=\"color:#1F2328;--shiki-dark:#D4D4D4\">,\u003c/span>\u003c/span>\n\u003cspan class=\"line\">\u003cspan style=\"color:#116329;--shiki-dark:#9CDCFE\"> \"errors_count\"\u003c/span>\u003cspan style=\"color:#1F2328;--shiki-dark:#D4D4D4\">: \u003c/span>\u003cspan style=\"color:#0550AE;--shiki-dark:#B5CEA8\">1\u003c/span>\u003cspan style=\"color:#1F2328;--shiki-dark:#D4D4D4\">,\u003c/span>\u003c/span>\n\u003cspan class=\"line\">\u003cspan style=\"color:#116329;--shiki-dark:#9CDCFE\"> \"warnings_count\"\u003c/span>\u003cspan style=\"color:#1F2328;--shiki-dark:#D4D4D4\">: \u003c/span>\u003cspan style=\"color:#0550AE;--shiki-dark:#B5CEA8\">0\u003c/span>\u003cspan style=\"color:#1F2328;--shiki-dark:#D4D4D4\">,\u003c/span>\u003c/span>\n\u003cspan class=\"line\">\u003cspan style=\"color:#116329;--shiki-dark:#9CDCFE\"> \"issues_truncated\"\u003c/span>\u003cspan style=\"color:#1F2328;--shiki-dark:#D4D4D4\">: \u003c/span>\u003cspan style=\"color:#0550AE;--shiki-dark:#569CD6\">false\u003c/span>\u003cspan style=\"color:#1F2328;--shiki-dark:#D4D4D4\">,\u003c/span>\u003c/span>\n\u003cspan class=\"line\">\u003cspan style=\"color:#116329;--shiki-dark:#9CDCFE\"> \"issues\"\u003c/span>\u003cspan style=\"color:#1F2328;--shiki-dark:#D4D4D4\">: [\u003c/span>\u003c/span>\n\u003cspan class=\"line\">\u003cspan style=\"color:#1F2328;--shiki-dark:#D4D4D4\"> {\u003c/span>\u003c/span>\n\u003cspan class=\"line\">\u003cspan style=\"color:#116329;--shiki-dark:#9CDCFE\"> \"severity\"\u003c/span>\u003cspan style=\"color:#1F2328;--shiki-dark:#D4D4D4\">: \u003c/span>\u003cspan style=\"color:#0A3069;--shiki-dark:#CE9178\">\"error\"\u003c/span>\u003cspan style=\"color:#1F2328;--shiki-dark:#D4D4D4\">,\u003c/span>\u003c/span>\n\u003cspan class=\"line\">\u003cspan style=\"color:#116329;--shiki-dark:#9CDCFE\"> \"code\"\u003c/span>\u003cspan style=\"color:#1F2328;--shiki-dark:#D4D4D4\">: \u003c/span>\u003cspan style=\"color:#0A3069;--shiki-dark:#CE9178\">\"missing_column\"\u003c/span>\u003cspan style=\"color:#1F2328;--shiki-dark:#D4D4D4\">,\u003c/span>\u003c/span>\n\u003cspan class=\"line\">\u003cspan style=\"color:#116329;--shiki-dark:#9CDCFE\"> \"message\"\u003c/span>\u003cspan style=\"color:#1F2328;--shiki-dark:#D4D4D4\">: \u003c/span>\u003cspan style=\"color:#0A3069;--shiki-dark:#CE9178\">\"Falta la columna obligatoria 'codigo_proyecto'.\"\u003c/span>\u003cspan style=\"color:#1F2328;--shiki-dark:#D4D4D4\">,\u003c/span>\u003c/span>\n\u003cspan class=\"line\">\u003cspan style=\"color:#116329;--shiki-dark:#9CDCFE\"> \"row\"\u003c/span>\u003cspan style=\"color:#1F2328;--shiki-dark:#D4D4D4\">: \u003c/span>\u003cspan style=\"color:#0550AE;--shiki-dark:#569CD6\">null\u003c/span>\u003cspan style=\"color:#1F2328;--shiki-dark:#D4D4D4\">,\u003c/span>\u003c/span>\n\u003cspan class=\"line\">\u003cspan style=\"color:#116329;--shiki-dark:#9CDCFE\"> \"column\"\u003c/span>\u003cspan style=\"color:#1F2328;--shiki-dark:#D4D4D4\">: \u003c/span>\u003cspan style=\"color:#0A3069;--shiki-dark:#CE9178\">\"codigo_proyecto\"\u003c/span>\u003cspan style=\"color:#1F2328;--shiki-dark:#D4D4D4\">,\u003c/span>\u003c/span>\n\u003cspan class=\"line\">\u003cspan style=\"color:#116329;--shiki-dark:#9CDCFE\"> \"value\"\u003c/span>\u003cspan style=\"color:#1F2328;--shiki-dark:#D4D4D4\">: \u003c/span>\u003cspan style=\"color:#0550AE;--shiki-dark:#569CD6\">null\u003c/span>\u003c/span>\n\u003cspan class=\"line\">\u003cspan style=\"color:#1F2328;--shiki-dark:#D4D4D4\"> }\u003c/span>\u003c/span>\n\u003cspan class=\"line\">\u003cspan style=\"color:#1F2328;--shiki-dark:#D4D4D4\"> ]\u003c/span>\u003c/span>\n\u003cspan class=\"line\">\u003cspan style=\"color:#1F2328;--shiki-dark:#D4D4D4\"> }\u003c/span>\u003c/span>\n\u003cspan class=\"line\">\u003cspan style=\"color:#1F2328;--shiki-dark:#D4D4D4\">}\u003c/span>\u003c/span>\n\u003c/code>\u003c/pre>"},{"filename":"400","html":"\u003cpre class=\"shiki shiki-themes github-light-default dark-plus\" style=\"background-color:#ffffff;--shiki-dark-bg:#0B0C0E;color:#1f2328;--shiki-dark:#D4D4D4\" language=\"json\">\u003ccode language=\"json\" numberOfLines=\"1\">\u003cspan class=\"line\">\u003cspan style=\"color:#1F2328;--shiki-dark:#D4D4D4\">{\u003c/span>\u003cspan style=\"color:#116329;--shiki-dark:#9CDCFE\">\"error\"\u003c/span>\u003cspan style=\"color:#1F2328;--shiki-dark:#D4D4D4\">: \u003c/span>\u003cspan style=\"color:#0A3069;--shiki-dark:#CE9178\">\"Debe enviar el archivo en el campo 'file' (multipart/form-data).\"\u003c/span>\u003cspan style=\"color:#1F2328;--shiki-dark:#D4D4D4\">}\u003c/span>\u003c/span>\n\u003c/code>\u003c/pre>"},{"filename":"400 — unsupported format","html":"\u003cpre class=\"shiki shiki-themes github-light-default dark-plus\" style=\"background-color:#ffffff;--shiki-dark-bg:#0B0C0E;color:#1f2328;--shiki-dark:#D4D4D4\" language=\"json\">\u003ccode language=\"json\" numberOfLines=\"3\">\u003cspan class=\"line\">\u003cspan style=\"color:#1F2328;--shiki-dark:#D4D4D4\">{\u003c/span>\u003c/span>\n\u003cspan class=\"line\">\u003cspan style=\"color:#116329;--shiki-dark:#9CDCFE\"> \"error\"\u003c/span>\u003cspan style=\"color:#1F2328;--shiki-dark:#D4D4D4\">: \u003c/span>\u003cspan style=\"color:#0A3069;--shiki-dark:#CE9178\">\"Extensión '.xls' no soportada. Formatos admitidos: .xlsx. Si el archivo es .xls, ábralo en Excel y guárdelo como .xlsx.\"\u003c/span>\u003c/span>\n\u003cspan class=\"line\">\u003cspan style=\"color:#1F2328;--shiki-dark:#D4D4D4\">}\u003c/span>\u003c/span>\n\u003c/code>\u003c/pre>"},{"filename":"401","html":"\u003cpre class=\"shiki shiki-themes github-light-default dark-plus\" style=\"background-color:#ffffff;--shiki-dark-bg:#0B0C0E;color:#1f2328;--shiki-dark:#D4D4D4\" language=\"json\">\u003ccode language=\"json\" numberOfLines=\"1\">\u003cspan class=\"line\">\u003cspan style=\"color:#1F2328;--shiki-dark:#D4D4D4\">{\u003c/span>\u003cspan style=\"color:#116329;--shiki-dark:#9CDCFE\">\"msg\"\u003c/span>\u003cspan style=\"color:#1F2328;--shiki-dark:#D4D4D4\">: \u003c/span>\u003cspan style=\"color:#0A3069;--shiki-dark:#CE9178\">\"Token inválido o expirado\"\u003c/span>\u003cspan style=\"color:#1F2328;--shiki-dark:#D4D4D4\">, \u003c/span>\u003cspan style=\"color:#116329;--shiki-dark:#9CDCFE\">\"success\"\u003c/span>\u003cspan style=\"color:#1F2328;--shiki-dark:#D4D4D4\">: \u003c/span>\u003cspan style=\"color:#0550AE;--shiki-dark:#569CD6\">false\u003c/span>\u003cspan style=\"color:#1F2328;--shiki-dark:#D4D4D4\">}\u003c/span>\u003c/span>\n\u003c/code>\u003c/pre>"},{"filename":"413","html":"\u003cpre class=\"shiki shiki-themes github-light-default dark-plus\" style=\"background-color:#ffffff;--shiki-dark-bg:#0B0C0E;color:#1f2328;--shiki-dark:#D4D4D4\" language=\"json\">\u003ccode language=\"json\" numberOfLines=\"1\">\u003cspan class=\"line\">\u003cspan style=\"color:#1F2328;--shiki-dark:#D4D4D4\">{\u003c/span>\u003cspan style=\"color:#116329;--shiki-dark:#9CDCFE\">\"error\"\u003c/span>\u003cspan style=\"color:#1F2328;--shiki-dark:#D4D4D4\">: \u003c/span>\u003cspan style=\"color:#0A3069;--shiki-dark:#CE9178\">\"El archivo supera el tamaño máximo de 10 MB.\"\u003c/span>\u003cspan style=\"color:#1F2328;--shiki-dark:#D4D4D4\">}\u003c/span>\u003c/span>\n\u003c/code>\u003c/pre>"}],"attributes":[]}},"endpoint":{"title":"Validate projects file","path":"/submit/project","servers":[{"url":"https://api.dev.impactu.colav.co"}],"method":"post","request":{"security":[],"parameters":{"query":{},"header":{},"cookie":{},"path":{}},"body":{"application/json":{"schemaArray":[{"type":"object","properties":{"file":[{"type":"file","description":"Excel `.xlsx` file with the institutional projects. An `.xls` is rejected with a message asking to save it as `.xlsx` . Only the first sheet is read, with one row per project. If a project has several researchers or funding sources, they are separated with `;` in the same cell, or the row is repeated with the same `codigo_proyecto` .","required":true}]}}],"examples":{"example":{"value":{}}}}}},"response":{"200":{"application/json":{"schemaArray":[{"type":"object","properties":{"data":[{"type":"object","properties":{"schema_version":[{"type":"string","description":"Version of the validation schema used."}],"valid":[{"type":"boolean","description":"`true` if the file has no errors (it may have warnings)."}],"total_rows":[{"type":"integer","description":"Number of rows with data."}],"total_projects":[{"type":"object","properties":{},"description":"Number of unique projects (by `codigo_proyecto` ). `null` if there are structural errors, such as a missing mandatory column: in that case the rows are not validated."}],"errors_count":[{"type":"integer","description":"Number of errors found."}],"warnings_count":[{"type":"integer","description":"Number of warnings found."}],"issues_truncated":[{"type":"boolean","description":"`true` if there are more than 500 problems: `issues` lists the first 500 and the counts include all of them."}],"issues":[{"type":"array","items":[{"type":"object","properties":{"severity":[{"type":"string","description":"`error` or `warning` ."}],"code":[{"type":"string","description":"Code of the problem type. For example, `missing_column` , `unknown_column` , `required` , `recommended_missing` , `invalid_date` , `invalid_money` , `invalid_enum` , `invalid_date_range` or `conflicting_values` ."}],"message":[{"type":"string","description":"Description of the problem."}],"row":[{"type":"object","properties":{},"description":"Row number in Excel. `null` for problems of the file (missing columns, extra sheets)."}],"column":[{"type":"object","properties":{},"description":"Name of the affected column, if any."}],"value":[{"type":"object","properties":{},"description":"Value that caused the problem, if any."}]}}],"description":"List of problems, sorted by row (first those of the file, without a row) and then by column."}]},"description":"Validation report."}]}}],"examples":{"example":{"value":{"data":{"schema_version":"\u003cstring>","valid":true,"total_rows":123,"total_projects":{},"errors_count":123,"warnings_count":123,"issues_truncated":true,"issues":[{"severity":"\u003cstring>","code":"\u003cstring>","message":"\u003cstring>","row":{},"column":{},"value":{}}]}}}}}}},"deprecated":false}},"jsLinks":[],"subdomain":"co-la-v","siteName":"ImpactU","title":"Validate projects file - ImpactU","navMaps":{"firstHrefInVersion":{},"firstHrefInLanguage":{"es":{"href":"/api-reference/submit/project","matchLevel":1},"en":{"href":"/en/api-reference/submit/project","matchLevel":0}}},"lastModified":"2026-11-03T22:48:46.166Z","originalFileLocation":"en/api-reference/submit/project.mdx","locale":"en"},"headHtml":"\u003cscript data-mint-head>(function(){var d=document.documentElement,p=null;if(!p){try{p=localStorage.getItem(\"isDarkMode\")}catch(e){}if(p==='true')p='dark';else if(p==='false')p='light';if(p!=='light'\u0026\u0026p!=='dark'\u0026\u0026p!=='system')p=\"system\"}var r=p==='system'?(matchMedia(\"(prefers-color-scheme: dark)\").matches?'dark':'light'):p;d.classList.remove(r==='dark'?'light':'dark');d.classList.add(r);d.setAttribute(\"data-theme-preference\",p)})();\u003c/script>\u003cmeta data-mint-head name=\"description\" content=\"Validates an Excel file of institutional projects (format v1.0) and returns a detailed report of errors and warnings.\">\u003cmeta data-mint-head name=\"application-name\" content=\"ImpactU\">\u003cmeta data-mint-head name=\"generator\" content=\"Mintlify\">\u003clink data-mint-head rel=\"icon\" type=\"image/png\" sizes=\"192x192\" href=\"/mintlify-assets/_mintlify/favicons/co-la-v/J6HYYUF1xV6uYGUM/_generated/favicon/android-chrome-192x192.png\" media=\"(prefers-color-scheme: light)\">\u003clink data-mint-head rel=\"apple-touch-icon\" type=\"image/png\" sizes=\"180x180\" href=\"/mintlify-assets/_mintlify/favicons/co-la-v/J6HYYUF1xV6uYGUM/_generated/favicon/apple-touch-icon.png\">\u003clink data-mint-head rel=\"icon\" type=\"image/png\" sizes=\"16x16\" href=\"/mintlify-assets/_mintlify/favicons/co-la-v/J6HYYUF1xV6uYGUM/_generated/favicon/favicon-16x16.png\" media=\"(prefers-color-scheme: light)\">\u003clink data-mint-head rel=\"icon\" type=\"image/png\" sizes=\"32x32\" href=\"/mintlify-assets/_mintlify/favicons/co-la-v/J6HYYUF1xV6uYGUM/_generated/favicon/favicon-32x32.png\" media=\"(prefers-color-scheme: light)\">\u003clink data-mint-head rel=\"shortcut icon\" type=\"image/x-icon\" href=\"/mintlify-assets/_mintlify/favicons/co-la-v/J6HYYUF1xV6uYGUM/_generated/favicon/favicon.ico\" media=\"(prefers-color-scheme: light)\">\u003clink data-mint-head rel=\"icon\" type=\"image/png\" sizes=\"192x192\" href=\"/mintlify-assets/_mintlify/favicons/co-la-v/J6HYYUF1xV6uYGUM/_generated/favicon-dark/android-chrome-192x192.png\" media=\"(prefers-color-scheme: dark)\">\u003clink data-mint-head rel=\"icon\" type=\"image/png\" sizes=\"16x16\" href=\"/mintlify-assets/_mintlify/favicons/co-la-v/J6HYYUF1xV6uYGUM/_generated/favicon-dark/favicon-16x16.png\" media=\"(prefers-color-scheme: dark)\">\u003clink data-mint-head rel=\"icon\" type=\"image/png\" sizes=\"32x32\" href=\"/mintlify-assets/_mintlify/favicons/co-la-v/J6HYYUF1xV6uYGUM/_generated/favicon-dark/favicon-32x32.png\" media=\"(prefers-color-scheme: dark)\">\u003clink data-mint-head rel=\"shortcut icon\" type=\"image/x-icon\" href=\"/mintlify-assets/_mintlify/favicons/co-la-v/J6HYYUF1xV6uYGUM/_generated/favicon-dark/favicon.ico\" media=\"(prefers-color-scheme: dark)\">\u003cmeta data-mint-head property=\"og:title\" content=\"Validate projects file - ImpactU\">\u003cmeta data-mint-head property=\"og:description\" content=\"Validates an Excel file of institutional projects (format v1.0) and returns a detailed report of errors and warnings.\">\u003cmeta data-mint-head property=\"og:site_name\" content=\"ImpactU\">\u003cmeta data-mint-head property=\"og:url\" content=\"https://help.impactu.colav.co/en/api-reference/submit/project\">\u003cmeta data-mint-head property=\"og:type\" content=\"website\">\u003cmeta data-mint-head property=\"og:image\" content=\"https://co-la-v.mintlify.app/_mintlify/api/og/v2?division=Submit\u0026amp;title=Validate+projects+file\u0026amp;description=Validates+an+Excel+file+of+institutional+projects+%28format+v1.0%29+and+returns+a+detailed+report+of+errors+and+warnings.\u0026amp;theme=d07118364c74a0b1f25aacda\u0026amp;signature=5e9579e24a1e1f5c2d1a31c2b6827ccd5f1cd72e6ee13781c5b2e39958123153\">\u003cmeta data-mint-head property=\"og:image:width\" content=\"1200\">\u003cmeta data-mint-head property=\"og:image:height\" content=\"630\">\u003cmeta data-mint-head name=\"twitter:card\" content=\"summary_large_image\">\u003cmeta data-mint-head name=\"twitter:title\" content=\"Validate projects file - ImpactU\">\u003cmeta data-mint-head name=\"twitter:description\" content=\"Validates an Excel file of institutional projects (format v1.0) and returns a detailed report of errors and warnings.\">\u003cmeta data-mint-head name=\"twitter:image\" content=\"https://co-la-v.mintlify.app/_mintlify/api/og/v2?division=Submit\u0026amp;title=Validate+projects+file\u0026amp;description=Validates+an+Excel+file+of+institutional+projects+%28format+v1.0%29+and+returns+a+detailed+report+of+errors+and+warnings.\u0026amp;theme=d07118364c74a0b1f25aacda\u0026amp;signature=5e9579e24a1e1f5c2d1a31c2b6827ccd5f1cd72e6ee13781c5b2e39958123153\">\u003cmeta data-mint-head name=\"twitter:image:width\" content=\"1200\">\u003cmeta data-mint-head name=\"twitter:image:height\" content=\"630\">\u003cmeta data-mint-head name=\"msapplication-config\" content=\"/mintlify-assets/_mintlify/favicons/co-la-v/J6HYYUF1xV6uYGUM/_generated/favicon/browserconfig.xml\">\u003cmeta data-mint-head name=\"apple-mobile-web-app-title\" content=\"ImpactU\">\u003cmeta data-mint-head name=\"msapplication-TileColor\" content=\"#46B3B3\">\u003clink data-mint-head rel=\"canonical\" href=\"https://help.impactu.colav.co/en/api-reference/submit/project\">\u003clink data-mint-head rel=\"alternate\" type=\"application/xml\" href=\"/sitemap.xml\">\u003clink data-mint-head rel=\"alternate\" type=\"text/markdown\" href=\"/en/api-reference/submit/project.md\">\u003clink data-mint-head rel=\"alternate\" hreflang=\"en\" href=\"https://help.impactu.colav.co/en/api-reference/submit/project\">\u003clink data-mint-head rel=\"alternate\" hreflang=\"es\" href=\"https://help.impactu.colav.co/api-reference/submit/project\">\u003clink data-mint-head rel=\"alternate\" hreflang=\"x-default\" href=\"https://help.impactu.colav.co/api-reference/submit/project\">\u003cscript data-mint-head type=\"application/ld+json\">{\"@context\":\"https://schema.org\",\"@graph\":[{\"@type\":\"Organization\",\"@id\":\"https://help.impactu.colav.co/#organization\",\"name\":\"ImpactU\",\"url\":\"https://help.impactu.colav.co\",\"logo\":{\"@type\":\"ImageObject\",\"url\":\"https://mintcdn.com/co-la-v/BlcLkPiBd3QcCUsw/images/quyca-logo.svg?fit=max\u0026auto=format\u0026n=BlcLkPiBd3QcCUsw\u0026q=85\u0026s=27d9cf857a2bfd279f5b35574a676f58\"}},{\"@type\":\"WebSite\",\"@id\":\"https://help.impactu.colav.co#website\",\"name\":\"ImpactU\",\"url\":\"https://help.impactu.colav.co\",\"publisher\":{\"@id\":\"https://help.impactu.colav.co/#organization\"}},{\"@type\":\"WebPage\",\"@id\":\"https://help.impactu.colav.co/en/api-reference/submit/project#webpage\",\"url\":\"https://help.impactu.colav.co/en/api-reference/submit/project\",\"name\":\"Validate projects file\",\"description\":\"Validates an Excel file of institutional projects (format v1.0) and returns a detailed report of errors and warnings.\",\"dateModified\":\"2026-11-03T22:48:46.166Z\",\"isPartOf\":{\"@id\":\"https://help.impactu.colav.co#website\"},\"breadcrumb\":{\"@id\":\"https://help.impactu.colav.co/en/api-reference/submit/project#breadcrumb\"}},{\"@type\":\"BreadcrumbList\",\"@id\":\"https://help.impactu.colav.co/en/api-reference/submit/project#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Submit\",\"item\":\"https://help.impactu.colav.co/en/api-reference/submit/staff\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Validate projects file\",\"item\":\"https://help.impactu.colav.co/en/api-reference/submit/project\"}]},{\"@type\":[\"TechArticle\",\"APIReference\"],\"@id\":\"https://help.impactu.colav.co/en/api-reference/submit/project#apireference\",\"headline\":\"Validate projects file\",\"name\":\"Validate projects file\",\"description\":\"Validates an Excel file of institutional projects (format v1.0) and returns a detailed report of errors and warnings.\",\"url\":\"https://help.impactu.colav.co/en/api-reference/submit/project\",\"mainEntityOfPage\":{\"@id\":\"https://help.impactu.colav.co/en/api-reference/submit/project#webpage\"},\"dateModified\":\"2026-11-03T22:48:46.166Z\",\"publisher\":{\"@id\":\"https://help.impactu.colav.co/#organization\"},\"isPartOf\":{\"@id\":\"https://help.impactu.colav.co#website\"}}]}\u003c/script>\u003cscript data-mint-head type=\"application/ld+json\">{\"@context\":\"https://schema.org\",\"@type\":\"WebSite\",\"name\":\"ImpactU\",\"creator\":{\"@type\":\"Organization\",\"name\":\"Mintlify\",\"url\":\"https://mintlify.com\"}}\u003c/script>","siteName":"ImpactU","nav":{"global":null,"languages":[{"language":"es","pages":[{"title":"es","href":"/api-reference/submit/project"}]},{"language":"en","tabs":[{"tab":"Documentation","pages":[{"title":"Documentation","href":"/en"}]},{"tab":"API Reference","groups":[{"group":"Introduction","pages":[{"title":"Introduction","sidebarTitle":"Endpoints home","href":"/en/api-reference/introduction"},{"title":"Quick reference for LLMs","sidebarTitle":"Reference for LLMs","href":"/en/api-reference/llm-quick-reference"}]},{"group":"Search","pages":[{"title":"Search persons","api":"GET https://api.dev.impactu.colav.co/search/person","href":"/en/api-reference/search/persons"},{"title":"Search products","api":"GET https://api.dev.impactu.colav.co/search/works","href":"/en/api-reference/search/works"},{"title":"Available product filters","api":"GET https://api.dev.impactu.colav.co/search/works/filters","href":"/en/api-reference/search/works-filters"},{"title":"Search affiliations","api":"GET https://api.dev.impactu.colav.co/search/affiliations/{affiliation_type}","href":"/en/api-reference/search/affiliations"},{"title":"Available affiliation filters","api":"GET https://api.dev.impactu.colav.co/search/affiliations/{affiliation_type}/filters","href":"/en/api-reference/search/affiliations-filters"},{"title":"Search sources","api":"GET https://api.dev.impactu.colav.co/search/sources","href":"/en/api-reference/search/sources"},{"title":"Available source filters","api":"GET https://api.dev.impactu.colav.co/search/sources/filters","href":"/en/api-reference/search/sources-filters"},{"title":"Search patents","api":"GET https://api.dev.impactu.colav.co/search/patents","href":"/en/api-reference/search/patents"},{"title":"Search projects","api":"GET https://api.dev.impactu.colav.co/search/projects","href":"/en/api-reference/search/projects"},{"title":"Search geographic entities","api":"GET https://api.dev.impactu.colav.co/search/geo/{geo_type}","href":"/en/api-reference/search/geo"}]},{"group":"Person","pages":[{"title":"Get an author","api":"GET https://api.dev.impactu.colav.co/person/{person_id}","href":"/en/api-reference/person/get-person"},{"title":"Author products","api":"GET https://api.dev.impactu.colav.co/person/{person_id}/research/products","href":"/en/api-reference/person/get-research-products"},{"title":"Author product filters","api":"GET https://api.dev.impactu.colav.co/person/{person_id}/research/products/filters","href":"/en/api-reference/person/get-research-products-filters"},{"title":"Export products to CSV","api":"GET https://api.dev.impactu.colav.co/person/{person_id}/research/products/csv","href":"/en/api-reference/person/get-research-products-csv"},{"title":"Export products to Excel","api":"GET https://api.dev.impactu.colav.co/person/{person_id}/research/products/excel","href":"/en/api-reference/person/get-research-products-excel"},{"title":"Author patents","api":"GET https://api.dev.impactu.colav.co/person/{person_id}/research/patents","href":"/en/api-reference/person/get-research-patents"},{"title":"Author projects","api":"GET https://api.dev.impactu.colav.co/person/{person_id}/research/projects","href":"/en/api-reference/person/get-research-projects"},{"title":"Author news","api":"GET https://api.dev.impactu.colav.co/person/{person_id}/research/news","href":"/en/api-reference/person/get-research-news"},{"group":"Indicators","pages":[{"title":"Indicators of an author","sidebarTitle":"Catalogue","href":"/en/api-reference/person/plots/overview"},{"title":"Annual evolution by ImpactU classification","api":"GET https://api.dev.impactu.colav.co/person/{person_id}/research/products","sidebarTitle":"Annual evolution by ImpactU classification","href":"/en/api-reference/person/plots/annual-evolution-by-impactu-classification"},{"title":"Citations per year","api":"GET https://api.dev.impactu.colav.co/person/{person_id}/research/products","sidebarTitle":"Citations per year","href":"/en/api-reference/person/plots/annual-citation-count"},{"title":"Annual APC expenses","api":"GET https://api.dev.impactu.colav.co/person/{person_id}/research/products","sidebarTitle":"Annual APC expenses","href":"/en/api-reference/person/plots/annual-apc-expenses"},{"title":"Open access articles per year","api":"GET https://api.dev.impactu.colav.co/person/{person_id}/research/products","sidebarTitle":"Open access articles per year","href":"/en/api-reference/person/plots/annual-articles-open-access"},{"title":"Articles per year from the top publishers","api":"GET https://api.dev.impactu.colav.co/person/{person_id}/research/products","sidebarTitle":"Articles per year from the top publishers","href":"/en/api-reference/person/plots/annual-articles-by-top-publishers"},{"title":"Most used words in titles","api":"GET https://api.dev.impactu.colav.co/person/{person_id}/research/products","sidebarTitle":"Most used words in titles","href":"/en/api-reference/person/plots/most-used-title-words"},{"title":"Articles by publisher","api":"GET https://api.dev.impactu.colav.co/person/{person_id}/research/products","sidebarTitle":"Articles by publisher","href":"/en/api-reference/person/plots/articles-by-publisher"},{"title":"Products by subject area","api":"GET https://api.dev.impactu.colav.co/person/{person_id}/research/products","sidebarTitle":"Products by subject area","href":"/en/api-reference/person/plots/products-by-subject"},{"title":"Products by database","api":"GET https://api.dev.impactu.colav.co/person/{person_id}/research/products","sidebarTitle":"Products by database","href":"/en/api-reference/person/plots/products-by-database"},{"title":"Articles by access route","api":"GET https://api.dev.impactu.colav.co/person/{person_id}/research/products","sidebarTitle":"Articles by access route","href":"/en/api-reference/person/plots/articles-by-access-route"},{"title":"Articles by Scienti category","api":"GET https://api.dev.impactu.colav.co/person/{person_id}/research/products","sidebarTitle":"Articles by Scienti category","href":"/en/api-reference/person/plots/articles-by-scienti-category"},{"title":"Articles by Scimago quartile","api":"GET https://api.dev.impactu.colav.co/person/{person_id}/research/products","sidebarTitle":"Articles by Scimago quartile","href":"/en/api-reference/person/plots/articles-by-scimago-quartile"},{"title":"Articles by publishing institution","api":"GET https://api.dev.impactu.colav.co/person/{person_id}/research/products","sidebarTitle":"Articles by publishing institution","href":"/en/api-reference/person/plots/articles-by-publishing-institution"},{"title":"Co-authorship by country","api":"GET https://api.dev.impactu.colav.co/person/{person_id}/research/products","sidebarTitle":"Co-authorship by country","href":"/en/api-reference/person/plots/coauthorship-by-country-map"},{"title":"Co-authorship by Colombian department","api":"GET https://api.dev.impactu.colav.co/person/{person_id}/research/products","sidebarTitle":"Co-authorship by Colombian department","href":"/en/api-reference/person/plots/coauthorship-by-colombian-department-map"},{"title":"Author co-authorship network","api":"GET https://api.dev.impactu.colav.co/person/{person_id}/research/products","sidebarTitle":"Author co-authorship network","href":"/en/api-reference/person/plots/author-coauthorship-network"}]}]},{"group":"Source","pages":[{"title":"Get a source","api":"GET https://api.dev.impactu.colav.co/source/{source_id}","href":"/en/api-reference/source/get-source"},{"title":"Source products","api":"GET https://api.dev.impactu.colav.co/source/{source_id}/products","href":"/en/api-reference/source/get-products"},{"title":"Source product filters","api":"GET https://api.dev.impactu.colav.co/source/{source_id}/products/filters","href":"/en/api-reference/source/get-products-filters"},{"title":"Export products to CSV","api":"GET https://api.dev.impactu.colav.co/source/{source_id}/products/csv","href":"/en/api-reference/source/get-products-csv"},{"title":"Export products to Excel","api":"GET https://api.dev.impactu.colav.co/source/{source_id}/products/excel","href":"/en/api-reference/source/get-products-excel"},{"group":"Indicators","pages":[{"title":"Indicators of a source","sidebarTitle":"Catalogue","href":"/en/api-reference/source/plots/overview"},{"title":"Scimago quartile per year","api":"GET https://api.dev.impactu.colav.co/source/{source_id}/products","sidebarTitle":"Scimago quartile per year","href":"/en/api-reference/source/plots/annual-scimago-quartile"}]}]},{"group":"Work","pages":[{"title":"Get a product","api":"GET https://api.dev.impactu.colav.co/work/{work_id}","href":"/en/api-reference/work/get-work"},{"title":"Find a product by DOI","api":"GET https://api.dev.impactu.colav.co/work","href":"/en/api-reference/work/get-work-by-doi"},{"title":"Product authors","api":"GET https://api.dev.impactu.colav.co/work/{work_id}/authors","href":"/en/api-reference/work/get-work-authors"}]},{"group":"Patent","pages":[{"title":"Get a patent","api":"GET https://api.dev.impactu.colav.co/patent/{patent_id}","href":"/en/api-reference/patent/get-patent"},{"title":"Patent authors","api":"GET https://api.dev.impactu.colav.co/patent/{patent_id}/authors","href":"/en/api-reference/patent/get-patent-authors"}]},{"group":"Project","pages":[{"title":"Get a project","api":"GET https://api.dev.impactu.colav.co/project/{project_id}","href":"/en/api-reference/project/get-project"},{"title":"Project authors","api":"GET https://api.dev.impactu.colav.co/project/{project_id}/authors","href":"/en/api-reference/project/get-project-authors"}]},{"group":"Geo","pages":[{"title":"Get a geographic entity","api":"GET https://api.dev.impactu.colav.co/geo/{geo_type}/{geo_id}","href":"/en/api-reference/geo/get-geo"},{"title":"Affiliations of a geographic entity","api":"GET https://api.dev.impactu.colav.co/geo/{geo_type}/{geo_id}/affiliations","href":"/en/api-reference/geo/get-geo-affiliations"},{"title":"Products of a geographic entity","api":"GET https://api.dev.impactu.colav.co/geo/{geo_type}/{geo_id}/research/products","href":"/en/api-reference/geo/get-geo-products"}]},{"group":"APC","pages":[{"title":"Search APC","api":"GET https://api.dev.impactu.colav.co/apc/search","href":"/en/api-reference/apc/search"},{"title":"APC by author","api":"GET https://api.dev.impactu.colav.co/apc/person/{person_id}","href":"/en/api-reference/apc/person"},{"title":"APC by affiliation","api":"GET https://api.dev.impactu.colav.co/apc/affiliation/{affiliation_id}","href":"/en/api-reference/apc/affiliation"}]},{"group":"Completer","pages":[{"title":"Autocomplete authors","api":"GET https://api.dev.impactu.colav.co/completer/person/{text}","href":"/en/api-reference/completer/get-person"},{"title":"Autocomplete affiliations","api":"GET https://api.dev.impactu.colav.co/completer/affiliations/{aff_type}/{text}","href":"/en/api-reference/completer/get-affiliations"},{"title":"Autocomplete sources","api":"GET https://api.dev.impactu.colav.co/completer/sources/{text}","href":"/en/api-reference/completer/get-sources"}]},{"group":"Authentication","pages":[{"title":"Log in","api":"POST https://api.dev.impactu.colav.co/login","href":"/en/api-reference/auth/login"},{"title":"Log out","api":"POST https://api.dev.impactu.colav.co/logout","href":"/en/api-reference/auth/logout"},{"title":"Session status","api":"GET https://api.dev.impactu.colav.co/me","href":"/en/api-reference/auth/me"}]},{"group":"Users","pages":[{"title":"List users","api":"GET https://api.dev.impactu.colav.co/admin/users","href":"/en/api-reference/users/list-users"},{"title":"Create user","api":"POST https://api.dev.impactu.colav.co/admin/users/{email}","href":"/en/api-reference/users/create-user"},{"title":"Edit user","api":"PUT https://api.dev.impactu.colav.co/admin/users/{email}","href":"/en/api-reference/users/edit-user"},{"title":"Reset password","api":"PATCH https://api.dev.impactu.colav.co/admin/users/{email}","href":"/en/api-reference/users/reset-password"},{"title":"Deactivate user","api":"DELETE https://api.dev.impactu.colav.co/admin/users/{email}","href":"/en/api-reference/users/deactivate-user"},{"title":"Activate user","api":"PATCH https://api.dev.impactu.colav.co/admin/users/{email}/restore","href":"/en/api-reference/users/activate-user"},{"title":"Generate API key","api":"POST https://api.dev.impactu.colav.co/users/{email}/apikey","href":"/en/api-reference/users/create-apikey"},{"title":"Update API key expiration","api":"PATCH https://api.dev.impactu.colav.co/users/{email}/apikey","href":"/en/api-reference/users/update-apikey"},{"title":"Delete API key","api":"DELETE https://api.dev.impactu.colav.co/users/{email}/apikey","href":"/en/api-reference/users/delete-apikey"}]},{"group":"Submit","pages":[{"title":"Send Staff file","api":"POST https://api.dev.impactu.colav.co/submit/staff","href":"/en/api-reference/submit/staff"},{"title":"Send CIARP file","api":"POST https://api.dev.impactu.colav.co/submit/ciarp","href":"/en/api-reference/submit/ciarp"},{"title":"Send SCIENTI file","api":"POST https://api.dev.impactu.colav.co/submit/scienti","description":"Uploads a compressed SCIENTI export file for processing.","href":"/en/api-reference/submit/scienti"},{"title":"Validate projects file","api":"POST https://api.dev.impactu.colav.co/submit/project","href":"/en/api-reference/submit/project"}]},{"group":"System","pages":[{"title":"General information","api":"GET https://api.dev.impactu.colav.co/info","description":"Returns the total counts of entities in the database and the date of the last update.","href":"/en/api-reference/system/get-info"},{"title":"Quality metrics","api":"GET https://api.dev.impactu.colav.co/info/quality","href":"/en/api-reference/system/get-quality"},{"title":"Ping","api":"GET https://api.dev.impactu.colav.co/ping","href":"/en/api-reference/system/ping"}]},{"group":"Affiliation","pages":[{"title":"Get an affiliation","api":"GET https://api.dev.impactu.colav.co/affiliation/{affiliation_type}/{affiliation_id}","href":"/en/api-reference/affiliation/get-affiliation"},{"title":"Related affiliations","api":"GET https://api.dev.impactu.colav.co/affiliation/{affiliation_type}/{affiliation_id}/affiliations","href":"/en/api-reference/affiliation/get-related-affiliations"},{"title":"Affiliation products","api":"GET https://api.dev.impactu.colav.co/affiliation/{affiliation_type}/{affiliation_id}/research/products","href":"/en/api-reference/affiliation/get-research-products"},{"title":"Affiliation product filters","api":"GET https://api.dev.impactu.colav.co/affiliation/{affiliation_type}/{affiliation_id}/research/products/filters","href":"/en/api-reference/affiliation/get-research-products-filters"},{"title":"Export products to CSV","api":"GET https://api.dev.impactu.colav.co/affiliation/{affiliation_type}/{affiliation_id}/research/products/csv","href":"/en/api-reference/affiliation/get-research-products-csv"},{"title":"Export products to Excel","api":"GET https://api.dev.impactu.colav.co/affiliation/{affiliation_type}/{affiliation_id}/research/products/excel","href":"/en/api-reference/affiliation/get-research-products-excel"},{"title":"Affiliation patents","api":"GET https://api.dev.impactu.colav.co/affiliation/{affiliation_type}/{affiliation_id}/research/patents","href":"/en/api-reference/affiliation/get-research-patents"},{"title":"Affiliation projects","api":"GET https://api.dev.impactu.colav.co/affiliation/{affiliation_type}/{affiliation_id}/research/projects","href":"/en/api-reference/affiliation/get-research-projects"},{"title":"Affiliation news","api":"GET https://api.dev.impactu.colav.co/affiliation/{affiliation_type}/{affiliation_id}/research/news","href":"/en/api-reference/affiliation/get-research-news"},{"group":"Indicators","pages":[{"title":"Indicators of an affiliation","sidebarTitle":"Catalogue","href":"/en/api-reference/affiliation/plots/overview"},{"title":"Number of products by product type for faculties","api":"GET https://api.dev.impactu.colav.co/affiliation/{affiliation_type}/{affiliation_id}/research/products","sidebarTitle":"Number of products by product type for faculties","href":"/en/api-reference/affiliation/plots/faculties-by-product-type"},{"title":"Number of products by product type for departments","api":"GET https://api.dev.impactu.colav.co/affiliation/{affiliation_type}/{affiliation_id}/research/products","sidebarTitle":"Number of products by product type for departments","href":"/en/api-reference/affiliation/plots/departments-by-product-type"},{"title":"Number of products by product type for research groups","api":"GET https://api.dev.impactu.colav.co/affiliation/{affiliation_type}/{affiliation_id}/research/products","sidebarTitle":"Number of products by product type for research groups","href":"/en/api-reference/affiliation/plots/research-groups-by-product-type"},{"title":"Distribution of citations among faculties","api":"GET https://api.dev.impactu.colav.co/affiliation/{affiliation_type}/{affiliation_id}/research/products","sidebarTitle":"Distribution of citations among faculties","href":"/en/api-reference/affiliation/plots/citations-by-faculty"},{"title":"Distribution of citations among departments","api":"GET https://api.dev.impactu.colav.co/affiliation/{affiliation_type}/{affiliation_id}/research/products","sidebarTitle":"Distribution of citations among departments","href":"/en/api-reference/affiliation/plots/citations-by-department"},{"title":"Distribution of citations among research groups","api":"GET https://api.dev.impactu.colav.co/affiliation/{affiliation_type}/{affiliation_id}/research/products","sidebarTitle":"Distribution of citations among research groups","href":"/en/api-reference/affiliation/plots/citations-by-research-group"},{"title":"Distribution of APC expenses among faculties","api":"GET https://api.dev.impactu.colav.co/affiliation/{affiliation_type}/{affiliation_id}/research/products","sidebarTitle":"Distribution of APC expenses among faculties","href":"/en/api-reference/affiliation/plots/apc-expenses-by-faculty"},{"title":"Distribution of APC expenses among departments","api":"GET https://api.dev.impactu.colav.co/affiliation/{affiliation_type}/{affiliation_id}/research/products","sidebarTitle":"Distribution of APC expenses among departments","href":"/en/api-reference/affiliation/plots/apc-expenses-by-department"},{"title":"Distribution of APC expenses among research groups","api":"GET https://api.dev.impactu.colav.co/affiliation/{affiliation_type}/{affiliation_id}/research/products","sidebarTitle":"Distribution of APC expenses among research groups","href":"/en/api-reference/affiliation/plots/apc-expenses-by-group"},{"title":"H-index of faculties","api":"GET https://api.dev.impactu.colav.co/affiliation/{affiliation_type}/{affiliation_id}/research/products","sidebarTitle":"H-index of faculties","href":"/en/api-reference/affiliation/plots/h-index-by-faculty"},{"title":"H-index of departments","api":"GET https://api.dev.impactu.colav.co/affiliation/{affiliation_type}/{affiliation_id}/research/products","sidebarTitle":"H-index of departments","href":"/en/api-reference/affiliation/plots/h-index-by-department"},{"title":"H-index of research groups","api":"GET https://api.dev.impactu.colav.co/affiliation/{affiliation_type}/{affiliation_id}/research/products","sidebarTitle":"H-index of research groups","href":"/en/api-reference/affiliation/plots/h-index-by-research-group"},{"title":"Annual evolution by ImpactU classification","api":"GET https://api.dev.impactu.colav.co/affiliation/{affiliation_type}/{affiliation_id}/research/products","sidebarTitle":"Annual evolution by ImpactU classification","href":"/en/api-reference/affiliation/plots/annual-evolution-by-impactu-classification"},{"title":"Citations per year","api":"GET https://api.dev.impactu.colav.co/affiliation/{affiliation_type}/{affiliation_id}/research/products","sidebarTitle":"Citations per year","href":"/en/api-reference/affiliation/plots/annual-citation-count"},{"title":"Open access articles per year","api":"GET https://api.dev.impactu.colav.co/affiliation/{affiliation_type}/{affiliation_id}/research/products","sidebarTitle":"Open access articles per year","href":"/en/api-reference/affiliation/plots/annual-articles-open-access"},{"title":"Articles per year from the top publishers","api":"GET https://api.dev.impactu.colav.co/affiliation/{affiliation_type}/{affiliation_id}/research/products","sidebarTitle":"Articles per year from the top publishers","href":"/en/api-reference/affiliation/plots/annual-articles-by-top-publishers"},{"title":"Annual APC expenses","api":"GET https://api.dev.impactu.colav.co/affiliation/{affiliation_type}/{affiliation_id}/research/products","sidebarTitle":"Annual APC expenses","href":"/en/api-reference/affiliation/plots/annual-apc-expenses"},{"title":"Most used words in titles","api":"GET https://api.dev.impactu.colav.co/affiliation/{affiliation_type}/{affiliation_id}/research/products","sidebarTitle":"Most used words in titles","href":"/en/api-reference/affiliation/plots/most-used-title-words"},{"title":"Articles by publisher","api":"GET https://api.dev.impactu.colav.co/affiliation/{affiliation_type}/{affiliation_id}/research/products","sidebarTitle":"Articles by publisher","href":"/en/api-reference/affiliation/plots/articles-by-publisher"},{"title":"Products by subject area","api":"GET https://api.dev.impactu.colav.co/affiliation/{affiliation_type}/{affiliation_id}/research/products","sidebarTitle":"Products by subject area","href":"/en/api-reference/affiliation/plots/products-by-subject"},{"title":"Articles by access route","api":"GET https://api.dev.impactu.colav.co/affiliation/{affiliation_type}/{affiliation_id}/research/products","sidebarTitle":"Articles by access route","href":"/en/api-reference/affiliation/plots/articles-by-access-route"},{"title":"Active authors by sex","api":"GET https://api.dev.impactu.colav.co/affiliation/{affiliation_type}/{affiliation_id}/research/products","sidebarTitle":"Active authors by sex","href":"/en/api-reference/affiliation/plots/active-authors-by-sex"},{"title":"Active authors by age range","api":"GET https://api.dev.impactu.colav.co/affiliation/{affiliation_type}/{affiliation_id}/research/products","sidebarTitle":"Active authors by age range","href":"/en/api-reference/affiliation/plots/active-authors-by-age-range"},{"title":"Articles by Scienti category","api":"GET https://api.dev.impactu.colav.co/affiliation/{affiliation_type}/{affiliation_id}/research/products","sidebarTitle":"Articles by Scienti category","href":"/en/api-reference/affiliation/plots/articles-by-scienti-category"},{"title":"Articles by Scimago quartile","api":"GET https://api.dev.impactu.colav.co/affiliation/{affiliation_type}/{affiliation_id}/research/products","sidebarTitle":"Articles by Scimago quartile","href":"/en/api-reference/affiliation/plots/articles-by-scimago-quartile"},{"title":"Articles by publishing institution","api":"GET https://api.dev.impactu.colav.co/affiliation/{affiliation_type}/{affiliation_id}/research/products","sidebarTitle":"Articles by publishing institution","href":"/en/api-reference/affiliation/plots/articles-by-publishing-institution"},{"title":"Products by database","api":"GET https://api.dev.impactu.colav.co/affiliation/{affiliation_type}/{affiliation_id}/research/products","sidebarTitle":"Products by database","href":"/en/api-reference/affiliation/plots/products-by-database"},{"title":"Co-authorship by country","api":"GET https://api.dev.impactu.colav.co/affiliation/{affiliation_type}/{affiliation_id}/research/products","sidebarTitle":"Co-authorship by country","href":"/en/api-reference/affiliation/plots/coauthorship-by-country-map"},{"title":"Co-authorship by Colombian department","api":"GET https://api.dev.impactu.colav.co/affiliation/{affiliation_type}/{affiliation_id}/research/products","sidebarTitle":"Co-authorship by Colombian department","href":"/en/api-reference/affiliation/plots/coauthorship-by-colombian-department-map"},{"title":"Institutional co-authorship network","api":"GET https://api.dev.impactu.colav.co/affiliation/{affiliation_type}/{affiliation_id}/research/products","sidebarTitle":"Institutional co-authorship network","href":"/en/api-reference/affiliation/plots/institutional-coauthorship-network"}]}]}]}]}]},"basePath":"","title":"Validate projects file - ImpactU","buildId":"dpl_345ReqzYaAjzS9QpeJemsKdb7KDj","deploymentId":"dpl_345ReqzYaAjzS9QpeJemsKdb7KDj","dynamics":["c2aa737661","2b790eda92","b0f84f53ff"],"chunks":["OpenApiReferenceProvider-C8RPHPxo.js","utils-0BK-9q6z.js","cloneDeep-izs3Hzxb.js","_Uint8Array-BVIqJ90l.js","isObjectLike-C8vmzPEN.js","isArray-Dcu1dQ5t.js","utils-DfjzsUJT.js","toString-BX-iyh8G.js","isSymbol-CSH9U2Gm.js","addUniqueKeysToSchema-B4v9psJ4.js","snippetPresets-CpTQv-Ez.js","style-to-object-BY3JEAdk.js","v4-DIgz8zy6.js","ApiExamples-BNP-Fvr0.js","isEqual-BfaiBbcl.js","usePlaygroundInputsStore-BSgu6h1D.js","shallow-Biv1i9Gs.js","getApiPlaygroundDisplay-BoGOXhtF.js","CodeSnippet-DvQoT18_.js","CodeSnippets-Dnpa15xT.js","Page-Buji1S4J.js","getPastedJson-xAIyhUFE.js","icon-S6FBih11.js","MethodPill-SaYeUZyk.js","DuplicateIcon-Cs-p3v2Q.js","createIcon-DjCFEoHq.js","DynamicMarkdown-BcnBltEQ.js","SectionHeading-BUBl0eEF.js","axios-vUo_bRtp.js"]}