ValleLabs
  1. institution
ValleLabs
  • auth
    • Login
      POST
    • Logout
      GET
    • Refresh Token
      POST
  • pei
    • definition
      • Get PEI definition
      • Update PEI definition
      • Create PEI definition
    • component
      • Administrative Management
        • Save principles fundamentals
        • Save objectives
        • Save school government
        • Save educational costs
        • Save resource evaluation
        • Save administrative organization management evaluation
        • Update principles fundamentals
        • Update objectives
        • Update school government
        • Update educational costs
        • Update resource evaluation
        • Update administrative organization management evaluation
      • Administrative Community Management
        • Save institutional situation analysis
        • Update institutional situation analysis
      • Academic pedagogical
        • Save pedagogical strategy
        • Save curriculum plan and evaluation and promotion criteria - PEI
        • Update pedagogical strategy
        • Update curriculum plan and evaluation and promotion criteria - PEI
      • Administrative Management Academic Pedagogical
        • Save coexistence manual and teacher regulations
        • Update coexistence manual and teacher regulations
      • Community
        • Save relationship social organizations
        • Save articulation cultural expressions
        • Save institutional diagnosis reference
        • Update relationship social organizations
        • Update articulation cultural expressions
        • Update institutional diagnosis reference
    • secretary
      • Get all PEI created
      • Get PEI by ID and aspect ID
      • Revision PEI with observations
      • Revision PEI without observations
    • school governing
      • Create school governing
      • Get school governing
    • institution
      • Save PEI data with a file
      • Send PEI data to revision
      • Get PEI data by aspect's indicator
      • Get PEI components
      • Get PEI status of completed
      • Get PEI History
    • Get total pei
      GET
    • Download PEI
      GET
  • institution
    • Create
      POST
    • Create massive
      POST
    • Update
      PUT
    • Find
      GET
    • Find all
      GET
    • FindByMunicipality
      GET
    • FindByHeadquarter
      GET
    • FindByGagem
      GET
    • Merge institution to institution
      POST
    • Create Merge institution to institution
      POST
    • Find history files
      GET
    • Get history file - role institution
      GET
    • Download all institutions
      POST
  • headquarter
    • Create
      POST
    • Update
      PUT
    • FindByInstitution
      GET
    • Find
      GET
    • Merge headquarters to institution
      POST
    • Find history files
      GET
    • FindByRoleInstitution
      GET
  • draft
    • institution
      • Create
      • Update
    • headquarter
      • Update
      • Create
    • Delete
    • FindByUser
  • change-history
    • FindByInstitution
    • FindByHeadquarter
    • FindByAspectIndicator
  • notification
    • Get by institution
    • Delete
  • user
    • Get institutions
  • indicator
    • Get totals (institutions, headquarters, aulas, students, teachers)
    • Get student-techear ratio
    • Get steam-room-ratio
    • Get totals modelsByInstitution
    • Get absense public-service by headquarter
    • Get steam-room
  • filters
    • List gagem
    • List establishment-type
    • List sector
    • List nature
    • List schedule
    • List area
    • List deparment
    • List municipality by deparment
    • List resolution-type
    • List headquarter-type
    • List state
    • List model
    • List character-due
    • List state-due
    • List specialty-due
    • List detailed-specialty
    • List grade
    • List academic-day
    • List public-service-type
    • List operator by public service
    • List municipality By Gagem
    • List role by institution
    • List zone
    • List modality
    • List labpoint
    • List state-quality
    • List environment
    • List organization
    • List financing-type
    • List document-type
    • List resource-physical-type
    • List resource-technological-type
    • List cultural-activity-type
    • List session-act-type
    • List organization-community-type
    • List model-pedagogical-type
    • List plan-type
    • List area-teacher
    • List project-type
    • List profile-type
    • List process-type
    • List area-knowledge
    • List curriculum-structure-type
    • List investigation-product-type
    • List tools
    • List service-type
    • List initiative-type
    • List curricular-levels
    • List population-group
    • List entrepreneurship-type
    • List area-type
    • List session-acts
  • file
    • Get url file
  1. institution

Download all institutions

Developing
POST
/institution/download-excel

Request

Authorization
Provide your bearer token in the
Authorization
header when making requests to protected resources.
Example:
Authorization: Bearer ********************
Body Params application/json
data
array [object {9}] 
required
municipality
string 
required
daneCode
string 
required
institution
string 
required
rector
string 
required
realEstateRegistration
string 
required
area
string 
required
energy
integer 
required
water
integer 
required
state
string 
required
Example
{
    "data": [
        {
            "municipality": "Springfield",
            "daneCode": "001",
            "institution": "Springfield Elementary",
            "rector": "Seymour Skinner",
            "realEstateRegistration": "A-12345",
            "area": "1500",
            "energy": 1,
            "water": 1,
            "state": "Active"
        },
        {
            "municipality": "Shelbyville",
            "daneCode": "002",
            "institution": "Shelbyville High",
            "rector": "Gary Chalmers",
            "realEstateRegistration": "B-67890",
            "area": "2500",
            "energy": 0,
            "water": 1,
            "state": "Inactive"
        },
        {
            "municipality": "Ogdenville",
            "daneCode": "003",
            "institution": "Ogdenville Tech",
            "rector": "Mary Johnson",
            "realEstateRegistration": "C-98765",
            "area": "3000",
            "energy": 1,
            "water": 0,
            "state": "Under Maintenance"
        },
        {
            "municipality": "North Haverbrook",
            "daneCode": "004",
            "institution": "North Haverbrook Academy",
            "rector": "Sarah Lee",
            "realEstateRegistration": "D-54321",
            "area": "1200",
            "energy": 0,
            "water": 1,
            "state": "Active"
        },
        {
            "municipality": "Capital City",
            "daneCode": "005",
            "institution": "Capital City College",
            "rector": "James Carter",
            "realEstateRegistration": "E-11223",
            "area": "5000",
            "energy": 1,
            "water": 1,
            "state": "Closed"
        }
    ]
}

Request samples

Shell
JavaScript
Java
Swift
Go
PHP
Python
HTTP
C
C#
Objective-C
Ruby
OCaml
Dart
R
Request Request Example
Shell
JavaScript
Java
Swift
curl --location --request POST 'https://vallelabs-pei-hvi.talentum.edu.co/institution/download-excel' \
--header 'Content-Type: application/json' \
--data-raw '{
    "data": [
        {
            "municipality": "Springfield",
            "daneCode": "001",
            "institution": "Springfield Elementary",
            "rector": "Seymour Skinner",
            "realEstateRegistration": "A-12345",
            "area": "1500",
            "energy": 1,
            "water": 1,
            "state": "Active"
        },
        {
            "municipality": "Shelbyville",
            "daneCode": "002",
            "institution": "Shelbyville High",
            "rector": "Gary Chalmers",
            "realEstateRegistration": "B-67890",
            "area": "2500",
            "energy": 0,
            "water": 1,
            "state": "Inactive"
        },
        {
            "municipality": "Ogdenville",
            "daneCode": "003",
            "institution": "Ogdenville Tech",
            "rector": "Mary Johnson",
            "realEstateRegistration": "C-98765",
            "area": "3000",
            "energy": 1,
            "water": 0,
            "state": "Under Maintenance"
        },
        {
            "municipality": "North Haverbrook",
            "daneCode": "004",
            "institution": "North Haverbrook Academy",
            "rector": "Sarah Lee",
            "realEstateRegistration": "D-54321",
            "area": "1200",
            "energy": 0,
            "water": 1,
            "state": "Active"
        },
        {
            "municipality": "Capital City",
            "daneCode": "005",
            "institution": "Capital City College",
            "rector": "James Carter",
            "realEstateRegistration": "E-11223",
            "area": "5000",
            "energy": 1,
            "water": 1,
            "state": "Closed"
        }
    ]
}'

Responses

🟢200OK
application/octet-stream
Body
object {0}
Example
PK
ؓsY���	Y�[Content_Types].xml��Mn�0��=E�-J]TUE¢�����xB,�����w(�* �`+�7�{��O��I�H;��Q6	��)m������"�V�qs�C��n<�y���-墎�?IIe�
P�<Z�T.4�6,��r	�����,��hc[Q��X����eˏ�A��^زr�]B��\[���wv����<Ih+���w�L�
���
���ȍ�/���e�)]U��+W
�d���16&�֬m��NL�[F7r����}��z}�ΦHqg�n=�δ�\C@�����}��]_I��i�
S�m����<�
��]����;�l�!�ˣ=����b;+��[v?��PK
ؓsY_rels/PK
ؓsY��I��K_rels/.rels���N�0@�|E���nH��� ��&4>�$n���ă�@�i�q��g���<���R�,��·����iq*�#2p���f�L#J�ɽ�YH�z���u�=M�+��O�iB)����v������t�ɀ愩��@ں%��1�5ln[o���a� gZ��(dL��y�W��*P��]V׻�=��HС���hS�N��Z�u�]	�όKB������#wY	c�2�'7�|PK
ؓsYxl/PK
ؓsY	xl/_rels/PK
ؓsY�$�V��xl/_rels/workbook.xml.rels���j�0D��
��ZvZJ)�s)�\[����LlIh7m��UH��Ĭؙ�H���8�OL���*J�M���|4��g��[=�
&$��w�74�r}$�M<)p��EJ2GME���MҨ9��ɨ�^w(We�$���O��
��V �)��C��_�9���J�$���/�:dG]d���WK�s��s��<�[�V�tB��)?��������0_!��!��4�E�ǩy���PK
ؓsYxl/worksheets/PK
ؓsY�7K"`xl/worksheets/sheet1.xml�V]o�0|�_��B
"T-�ҝt��������$�l���ۄY�B�a��؞�:;~��R����"�H��%�c���6"^��Q�����E��)�4�6>
��v�ir�����uU�cUQ��DȌjʭ�
���
�R��vnFyNN
#�
�$<f3�3�듈d)հ}���:�e�W�2*���C,�$�x��g%J�,�����-�c�|���AK>��J$�r�F�g����x�����dID�{�����q�]T{�)�
K�>տ�q��v�!Eq�^�<g�ف�E����"�檍�6�3�b�+"AP.�TU�N�ˤ�a�GD<��F�`�����z�;����%��o�u�]!���u��̀a0�������`]�=�UeeF5���8:�rM����Qh����Hs\r�Kr���ä;v�z�xi3z�1m3<̘�}̘�>f,ڌ3�m�3Vm�3�m��������{\�z��o��Oh�>C�a����F/=[�W��5
�N��q��4���@#sS>V!����	zF4����*fշZ��<�U�=V�MA#�/42<E�QE3�#����F���V�6�H(�[�cU�|y���ۆ@�YC���!�|�h�c��V�[|��X5h��,@��@�h`��D�Y�뭲ή��Y�n�;Z�-�A����IYR9�`yjs��Z�?��Mh�2�G;h��,GP���<pO��������zÈBjI��`��'Hg����p0�BЅFX��(��6�ׅ�*��U\z���ҝU=å9��PK
ؓsYt Nz��xl/sharedStrings.xml��Mn�0��=��"J��S�
R�m�-P'K�5TIʨ�U����A�4N�ԼG���嗿;-�h�2���3	��Ԋ�e�p�5^D�y��!\Ft�e�)w΋p��2j��?'��Z����)(��v�ãm�[�ڵ���I&�<�@Q$*3�_F�i$R�,�&Q�;U����R�2y��<y-���K�#��p���y��J_h����;�n���s5hk��NiV��v�V��9>so3poȲf�l{�~T���$e��[�4vH쁹�Й��퓢���4�Lg�r:��Y+��,�m�zw�+��$e��[ܨ���B�lAwa���x~��`\�	�5�I�M����}��NJ�n^YoMKΰ�*������:���j�b��#U�컱�7�sg�y����W������Cv�u<�N26ri��K��-J����d���҄pv�-t�D	���]�i�e�[�N$[j���&%�gU�PK
ؓsY	xl/theme/PK
ؓsYv�0�!xl/theme/theme1.xml�YMo�6��W����R'�SĎ�nm� q;�HK�Ć�N����
��m�a[�إ�5�:lп�Wև)�j�&�P 98"�<���%i_�q2tH��<�X��5������u8�Ҷ�T8�0��XS"��]�* !A@���X�R��mK����c��1!V0��	|bCf7j�5;�4�P�C�zo<�.A�D���r�}�����}w�S��h��>�/���:Ĭc�.�
ɱ��R���U��Y6��9��*�F��rjN�)U���[�֯mϵ42-h�����s�)�.�]_���z�����g��^ͩ�(���2e���:�eJS���)��Zk�Q��4�c����뭕)�FY[�����(),`4:X&$�=_�9h��-3�
�v�!��R0��ʌ�#.�H�+!5������p$(�i�k��9W.�%
�t�U��$�P>s̛�?�y��y������ǿ�<yr����|����/���3����_?��� u�?��o_U ��|�ͳ?_<{����Ԅ�x���4$�%Gh����I�3R��%
jB�UPBޝbfvI9��#���Q���@L5!oa	��9�ra��v�N�i���D�a|hT�[X��$�ܦF����L�e���'Q(y�1�RZ��u�|��C����3�#efݢ!,��h#�z)B;P�3��mrX�B�`fJX)�7�D��l5���U`4t*�RूE�	���)��{bZ2�6�6e΀6
�P���zs�C��A/�al��F��X@�b�˕�^��d����@�:c�ߧ~`N���Dk��r�N��(�ʽ<��[;;���/;�Bg߂��XQ�����v�m<�v	T�e�l��M�m�>Z�֬m�ȞJ
��c�ؾ�2rG��^���f�ьW��s�e�/�l�W�R�8]�T�/s��D1�pe���Wc
��&��2x�v���7K��BR:�eI]3�����󫬧ؕu֝
��i:m=�P['_k����E�/Y�LH�X�{��5}��Ӽ�k������і��{�w�P{,Z�����4�8�Xc8��c�L�4(���c�*�u��]�~�"��5�����XH��e�g��/z"͑��J�rQ��Ъ�4����{i��xL\U5����|����#4b����V�z��m4����oeYY.����N�+�8�YA���H	頰#�F�U>��O��ɹ�)��]87�ٳ�Q���ph]q@݁��E��CP:�i�%_�'6�C�ݥR���j��HPh�*���������]7�����2�F䐰aR�kI0,��'�J�\ZH�X�#��Z/�յζ����C�T��o�j����Q�~�y�N����p�A��T�L;'�d*�r�J;+�br��u?a����]�	~z��߬���J��~���ۆ����R:\�q����p	��lJ�0̞vE���{���ɴ�d�)6��1��q��Q�~���2=I(
nsn��6���X�_p6��i���<�2��?ed0o��ر��Q\ɓ�(��|�(����Eu|j�����$�J�^�����%���PK
ؓsY���`
xl/styles.xml�U�o�0~�_a��h`ITKS�J�4���WLb�?�q:�i���@Q�u�^b�����;�Ir�J���i�V)�|��*t��.�_6�7Ǩ�T�Th�R|d
���%�=
��g�"`PM����KB�b�$m�t�X*m$�p4;�ԆѲqAR���c")W�gX��_H$5O��+����[.�=v\�by�S�Э�m0�j�؄��"���э���]U�`/�.Ȃ�bdڷ1�þ�,���
*�A�;�N��I�o*w&���+K
-�AR1���∞�p�tBXH����=t1��n��[�H���v��b"��n�2�r8�a�9֠N������+�;C�AM��n�)a6O�]/z(K�,�ۻ���8����,)9�iE��<E�-��n��V�m��A��ޗ)����?mAа�i��㟲����M������^�F����
�00dP7i�E�(rc��O���	������7�gَuwV�^�e�(YE�n���������>�gm�q��n=�]�ڇ�v+:��w����]zs5�f�,��j�E���z�/�п�9�$��ax�@�lx���A�㈥xr��w��S��0�?D����~��b:���u��Q����.ʣ��荟 ��(>ZZ.���]��LQ�$8��r�	2�7d�PK
ؓsY	docProps/PK
ؓsY]�N��*docProps/app.xml�R�n�0��+�9mQ��bH[���Hڞ9���ʒ!2F���� �����#����Hu�o\�a$|!��\d�M(���e�p�]d��Kp�c!H�VS�Z�l�����5s���L�
�,�}�T!6���[���fנgy��7�������Qq���������ush��V?��Y�>�����B���ޠSr:TIh�f-t���Tk�IXW���h�G�>��HZu���p��?)�K����N!:�<�#�Xص�Q���N5"��cs�S��k=	��h$�s���W����p<�:<���'OlygRd�����OO,CӂO9�=��-������^�M��S��M��!b�v3.bl���8�����o�<q���x=�������<���S����_PK
ؓsY�`_�docProps/core.xml�R�n�0��+"߃@�B�ڊS�*Ԫ7�^�%�-{i���y��ʩ�����>�.NE��uR�9�G	@q-����f�g$pȔ`�V0'8���Rn�-�Zm��x#�n�d�hJ�C���+�'��=�;j?��q���	��ֆ��Ig)xoi�6o��C
�G1��p7�BYH�ܔ��^}r��e9*'���ӏ��[3j(U�*$KO���fuP�T)���<J�!k�]�#w���m�>ต��Z�*��q���V8�^��Ra�m�R� gW��[	��z�K��n�@~'I��3�>yz^/I6���0���aϒI�Lg�u�W��a�=�odzA7�տ�~PK
ؓsYh�^xxl/workbook.xml��Ko�0���Q��l-ҴM�e��v�K#�R����s[:i��%;��o;��E+r�5ͦ)%`��
�����P"3�)k��WtS>�����	ƛP�&F�'I�
h�ցAOm�f���灉�D��Y�.ͤ�!��0l]KL ��>4҅���#8���un�C�^*�=����`�g{�U_�瑌�;����`�8E�M�]�Y�d�Pr��������9��t�EQ�X�BFŜʞ����
/��tN��o[OԬUq��F:�t�H��L�o�<1~Es۫���k%:1��ʄ(c��s�>BD�I�mA1��׾���4�G5���VY:[�/F��/PK
ؓsY���	Y�[Content_Types].xmlPK
ؓsY�_rels/PK
ؓsY��I��K�_rels/.relsPK
ؓsY�xl/PK
ؓsY	�xl/_rels/PK
ؓsY�$�V��xl/_rels/workbook.xml.relsPK
ؓsY)xl/worksheets/PK
ؓsY�7K"`Uxl/worksheets/sheet1.xmlPK
ؓsYt Nz���xl/sharedStrings.xmlPK
ؓsY	�	xl/theme/PK
ؓsYv�0�!�	xl/theme/theme1.xmlPK
ؓsY���`
0xl/styles.xmlPK
ؓsY	�docProps/PK
ؓsY]�N��*docProps/app.xmlPK
ؓsY�`_��docProps/core.xmlPK
ؓsYh�^xSxl/workbook.xmlPK��
🟠401ValidationToken
🟠403ValidationRole
Modified at 2024-11-19 18:32:43
Previous
Get history file - role institution
Next
Create
Built with