Skip to main content
POST
Validate projects file
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.

Request body

file
required
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.

Limits

An empty or damaged file, or one that is not an Excel file, returns 400 with the reason.

File format

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. Catalogue values are accepted regardless of case, accents or extra spaces; a value outside the catalogue is an error. Blank rows are ignored.

Rules between fields

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.

Response

object
Validation report.