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 GenericImportFileDetailName | 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 1�D[̴�� 5 xl/workbook.xml � (� ����0��&�C��@� '.^=x_�" �'m >��7o;���N1i;4Z�#G�r[��{�3�x��ITa�i+�i_Lw��Xk���<K�(cG�B+���J���Eh]��帢$E�ぐbn�8�Ec�;���!��*�~�(�@bIk�@���ےƔ�\���yv�ni_�I�ҝ�� ����PK 1�D[���� � [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 1�D[`ψp' ' _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="R43c65af219e842a3" /></Relationships>PK 1�D[�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 1�D[3a=�� P xl/_rels/workbook.xml.rels � (� ��KN�0@�b͞8q��ݰa[zw<N�&vd�@�Ƃ#q�"A*�`��h~OO��|�Xoߦ�����-�,F�l��)������F�D�9��bC}���=M*dn&�:��IŔ��� ��#^�y����L�?���3f@ztx���?����c�"����~J�_��ؓna�X5tP2uY���Z��¯�w��Z�,��J�(uC7��'�}���iY^�iY��A ]��������PK 1�D[Ѓ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 1�D[�~�� 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- 1�D[̴�� 5 xl/workbook.xmlPK- 1�D[���� � � [Content_Types].xmlPK- 1�D[`ψp' ' U _rels/.relsPK- 1�D[�f{ � � xl/worksheets/sheet1.xmlPK- 1�D[3a=�� P � xl/_rels/workbook.xml.relsPK- 1�D[Ѓc'2 E � xl/styles.xmlPK- 1�D[�~�� C M xl/sharedStrings.xmlPK � p
application/vnd.ms-excel
Sample:
PK 1�D[7c�w� 5 xl/workbook.xml � (� ����0��&�C����R8q���{)�m�?ik��-%�x�3;���Ÿ�7fB5k_��lM���cA��h�b!J�"f%���H�e7�`fA텴o�X�:`� A�J1�q{>!D�fO �O2{��Dd��M��")���w,0��s�c�j���j������F����PK 1�D[���� � [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 1�D[��<' ' _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="Rab6276894161484c" /></Relationships>PK 1�D[�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 1�D[��1�� P xl/_rels/workbook.xml.rels � (� ��KN�0@�b͞�NjP�n�a[z��3��&vd�@�Ƃ#q�"A*�`��h~OO��|�Xoߦ��P��w �B #�}7���S2w+�n�{1�h�9���b6����-M?���Ä)���3�#��K!xX2����C���v^�&r�0��-Qv��Sj��%�"S�=u �u-kS��d�Z��7S��<R����2����- ��Me,�Sȗ^:-�����1�E-�Z�������PK 1�D[Ѓ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 1�D[�~�� 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- 1�D[7c�w� 5 xl/workbook.xmlPK- 1�D[���� � [Content_Types].xmlPK- 1�D[��<' ' V _rels/.relsPK- 1�D[�f{ � � xl/worksheets/sheet1.xmlPK- 1�D[��1�� P � xl/_rels/workbook.xml.relsPK- 1�D[Ѓc'2 E � xl/styles.xmlPK- 1�D[�~�� C M xl/sharedStrings.xmlPK � p