POST api/genericimport/filefields/{fileDelimiter}/{headerRowIndex}/{fileType}
Get list of fields name(column header) available on uploaded file
Request Information
URI Parameters
| Name | Description | Type | Additional information |
|---|---|---|---|
| fileDelimiter | ImportFileDelimiter |
Required |
|
| headerRowIndex | integer |
Required |
|
| fileType | ImportFileType |
Required |
Body Parameters
None.
Response Information
Resource Description
Collection of GenericImportFileDetail| Name | Description | Type | Additional information |
|---|---|---|---|
| Index | integer |
None. |
|
| SheetName | string |
None. |
|
| Columns | Collection of string |
None. |
Response Formats
application/json, text/json
Sample:
[
{
"$id": "1",
"index": 1,
"sheetName": "sample string 2",
"columns": [
"sample string 1",
"sample string 2"
]
},
{
"$ref": "1"
}
]
application/xml, text/xml
Sample:
<ArrayOfGenericImportFileDetail xmlns:i="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://schemas.datacontract.org/2004/07/EziManager.Models.EMC.GenericImport">
<GenericImportFileDetail>
<Columns xmlns:d3p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
<d3p1:string>sample string 1</d3p1:string>
<d3p1:string>sample string 2</d3p1:string>
</Columns>
<Index>1</Index>
<SheetName>sample string 2</SheetName>
</GenericImportFileDetail>
<GenericImportFileDetail>
<Columns xmlns:d3p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
<d3p1:string>sample string 1</d3p1:string>
<d3p1:string>sample string 2</d3p1:string>
</Columns>
<Index>1</Index>
<SheetName>sample string 2</SheetName>
</GenericImportFileDetail>
</ArrayOfGenericImportFileDetail>
text/csv
Sample:
Sample not available.
application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Sample:
PK +2�\��t=� 5 xl/workbook.xml � (� ����0��&�C��`���x�ུ�m�?ik��-%�x�3;��4�q�`̄>j־v-!ؚ�(�/Ƃ���8EC��E�8J�ao:�k�݈��i��z���ay�r/ ��7��R��|B�Y�=%,>�h�uW�-D~SM�I!M����b��;oq���e,ʪ��P�`��쿻/PK +2�\���� � [Content_Types].xml � (� ���J�0�_��*M�D��V�*��d�
�d�k��<�H���V���=
��|�o��|����������+�����7l���e۶~=E�"�zlXO�@Ճ��C�3]HNR~���R��uU�<���������a��36��b7םQ
�1Z�$�8z�R��3
tP��-c�� g����_M��Of���~O�s�T���� ����P<�D��e=1Z��a2�b
��%#H'�2}���e�B)��~j/F�t��PK
+2�\�`}' ' _rels/.rels � (� <?xml version="1.0" encoding="utf-8"?><Relationships xmlns="http://schemas.openxmlformats.org/package/2006/relationships"><Relationship Type="http://schemas.openxmlformats.org/officeDocument/2006/relationships/officeDocument" Target="xl/workbook.xml" Id="R11d9b093685d4e89" /></Relationships>PK +2�\�f{ � xl/worksheets/sheet1.xml � (� ��Ks� ��
þ"`��f�L��tѮ�bd"��6f�n�;��{�xq�8qm����^g*�.�G[<M�"��������f�XZ{�#d��Kfu�;+��̺��!U"��%�-"a8F�W̺(S�������As��d�YI&j�ƹp�m�@�"�K<_SP{�]���X���O����%O`�Y4��>�U���X�7�<s�+���k2UR���@���7"�eg��1qtv4Vɏ�1�Vw:rё^��`2
�G��t:!�����>��d�1uC���u��V7̲4֪�;�v�tK��z6nҧ4�ѩ�^�Ր����� =�\d�K��䢹�"?z�8$����H$�?��m"�1��}�\o��\�7��[�PK +2�\�0"� P xl/_rels/workbook.xml.rels � (� ��Kn�0@�b;qB-H*�n�R.��$�Hl�6�����W�E��H]t�j4��'�|���o�D���,�����UN�v�pJ�C��z��Hy"��G�Wl�`R�O�Fep�rm��.�"�4�u�E]/i(p�$����]ߏ
��:�h�`���1�� ��O)�kh�L�����mǴ�4���B��e������2�ɕV+�,�Uƈ��%�|�ҩ,j��U�,Q*���U�����PK +2�\Ѓc'2 E
xl/styles.xml � (� �S�j�0��&0���0�^�]v��:��d;��H��Kj�vG�Mz�zOHr�iB8v �F��WEG�?s�Oh�lff�uZМ���ށh�R���6�'��2��������ɳ�UŦ`<Қo���x���8��K�6BC ^�کĖ��B���n��f8����9� ����CUk��#��U�ub��WUB;��k���&�
AR>��� ��im��ΑF���YO��%�}� ��LJ\in�,���9oy}��y.�$��6��ųNJ�c��T��rĘ)փBR淶�E3ʟ�\��q��PK +2�\�~�� C xl/sharedStrings.xml � (� eP]K1�+a�M���Hr}((��$�!���͙ݓ�ߛ��Pgfg��>�>�r,�`�;PH�����n@�x|*�NȠֽeլ�F���#fϺLHMٗ��4X���~�Qr2ˮ�6�G�L�`j��>������oi��5�[s&���9��g�6%͙��f����Fm���_܉�n�A��Ơ"�����b����7m��PK- +2�\��t=� 5 xl/workbook.xmlPK- +2�\���� � � [Content_Types].xmlPK-
+2�\�`}' ' U _rels/.relsPK- +2�\�f{ � � xl/worksheets/sheet1.xmlPK- +2�\�0"� P � xl/_rels/workbook.xml.relsPK- +2�\Ѓc'2 E
� xl/styles.xmlPK- +2�\�~�� C K xl/sharedStrings.xmlPK � n
application/vnd.ms-excel
Sample:
PK +2�\A[�F� 5 xl/workbook.xml � (� ����0��&�C���R8q���{-[i�?ik��-%�x�3;�����i�>z4��5�ct!A�y8X&����$��X)��֊�IA�xyTք^���?��<�.� Q�Jsep��!��fS�2k��Dd ��˰�"+d���<r��s�j|��W*
wy�E)N�Ҳ�]
��
�����PK +2�\���� � [Content_Types].xml � (� ���J�0�_��*M�D��V�*��d�
�d�k��<�H���V���=
��|�o��|����������+�����7l���e۶~=E�"�zlXO�@Ճ��C�3]HNR~���R��uU�<���������a��36��b7םQ
�1Z�$�8z�R��3
tP��-c�� g����_M��Of���~O�s�T���� ����P<�D��e=1Z��a2�b
��%#H'�2}���e�B)��~j/F�t��PK
+2�\C��' ' _rels/.rels � (� <?xml version="1.0" encoding="utf-8"?><Relationships xmlns="http://schemas.openxmlformats.org/package/2006/relationships"><Relationship Type="http://schemas.openxmlformats.org/officeDocument/2006/relationships/officeDocument" Target="xl/workbook.xml" Id="Ra91769f8dba642ae" /></Relationships>PK +2�\�f{ � xl/worksheets/sheet1.xml � (� ��Ks� ��
þ"`��f�L��tѮ�bd"��6f�n�;��{�xq�8qm����^g*�.�G[<M�"��������f�XZ{�#d��Kfu�;+��̺��!U"��%�-"a8F�W̺(S�������As��d�YI&j�ƹp�m�@�"�K<_SP{�]���X���O����%O`�Y4��>�U���X�7�<s�+���k2UR���@���7"�eg��1qtv4Vɏ�1�Vw:rё^��`2
�G��t:!�����>��d�1uC���u��V7̲4֪�;�v�tK��z6nҧ4�ѩ�^�Ր����� =�\d�K��䢹�"?z�8$����H$�?��m"�1��}�\o��\�7��[�PK +2�\=!�a� P xl/_rels/workbook.xml.rels � (� ��KN�0@�b͞�q��TM�aö��3N�&�e�@�Ƃ#qL� �X��j4��'�|��ov��D�чњ�A�l7���S�w춛=N2��0�.��bBC�nMiP�2d֡Im�,cJ}O�TG�#匕�/p�$�����֣��N3����Xbr�����O)�KȳD��5���B�8����@���B<O~���/kl�\�:]�o*3H��S���K�ey�v_`U5+�Z�U�_���_l?PK +2�\Ѓc'2 E
xl/styles.xml � (� �S�j�0��&0���0�^�]v��:��d;��H��Kj�vG�Mz�zOHr�iB8v �F��WEG�?s�Oh�lff�uZМ���ށh�R���6�'��2��������ɳ�UŦ`<Қo���x���8��K�6BC ^�کĖ��B���n��f8����9� ����CUk��#��U�ub��WUB;��k���&�
AR>��� ��im��ΑF���YO��%�}� ��LJ\in�,���9oy}��y.�$��6��ųNJ�c��T��rĘ)փBR淶�E3ʟ�\��q��PK +2�\�~�� C xl/sharedStrings.xml � (� eP]K1�+a�M���Hr}((��$�!���͙ݓ�ߛ��Pgfg��>�>�r,�`�;PH�����n@�x|*�NȠֽeլ�F���#fϺLHMٗ��4X���~�Qr2ˮ�6�G�L�`j��>������oi��5�[s&���9��g�6%͙��f����Fm���_܉�n�A��Ơ"�����b����7m��PK- +2�\A[�F� 5 xl/workbook.xmlPK- +2�\���� � [Content_Types].xmlPK-
+2�\C��' ' V _rels/.relsPK- +2�\�f{ � � xl/worksheets/sheet1.xmlPK- +2�\=!�a� P � xl/_rels/workbook.xml.relsPK- +2�\Ѓc'2 E
� xl/styles.xmlPK- +2�\�~�� C O xl/sharedStrings.xmlPK � r