POST api/genericimport/filefields/{fileDelimiter}/{headerRowIndex}/{fileType}

Get list of fields name(column header) available on uploaded file

Request Information

URI Parameters

NameDescriptionTypeAdditional information
fileDelimiter

ImportFileDelimiter

Required

headerRowIndex

integer

Required

fileType

ImportFileType

Required

Body Parameters

None.

Response Information

Resource Description

Collection of GenericImportFileDetail
NameDescriptionTypeAdditional 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��Z��L�5xl/workbook.xml �(�����0��&�C��b
)��x��}�E�O�5��B	$޼���~;r������G�2��.�	Au��`�i�Z�!Lҿ�m[Uci�F��xL�����:�/�X�<BCb�ÂҠ/�;����p�('c�;�L,!��]D�h�y	8�ν�y™��4<�[SAz���9��o�
&����PK��Z����	�[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
��ZOZ~''_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="Rba86562c47da47f7" /></Relationships>PK��Z�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��Zkb�Pxl/_rels/workbook.xml.rels �(���AN�0E�b͞8vS'BM�aö��=N�&vd�@�Ƃ#q,*A*�`ӕ5짧�lvo��^(���DQ#��\��)ٻv�͞FL�F�9�������{Σ�i�X��\�X&L��Q�#.�R�d�5��3���4=x}�ȥ?��Շc����R?Q�߇(2أia/�j]kS)T����b:��.�B�^���VFIYI[�T��@�)����2^�i�4JQ�T#*).s�W�b�PK��ZЃc'2E
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��Z�~��Cxl/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-��Z��L�5xl/workbook.xmlPK-��Z����	��[Content_Types].xmlPK-
��ZOZ~''U_rels/.relsPK-��Z�f{��xl/worksheets/sheet1.xmlPK-��Zkb�P�xl/_rels/workbook.xml.relsPK-��ZЃc'2E
�xl/styles.xmlPK-��Z�~��CMxl/sharedStrings.xmlPK�p	

application/vnd.ms-excel

Sample:
PK��Zほ�5xl/workbook.xml �(�����0��&�C��؀�8q���{[�H����[J ��mgv��if�_����ɄڷX��jB���Y8Y&�F�5�I�'���V�5�HhQ\���EeM�����a�
AD=�(͔���P�4{(�C����.&"k�����/�B�ihq�"�(;���g�|��p�J.x�
WZ�❽����PK��Z����	�[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
��Z�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="R22b939f7ac194a06" /></Relationships>PK��Z�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��Z����Pxl/_rels/workbook.xml.rels �(���KN�0@�byO�'!U�nذ-��؞�Q;�]�gc���V� �X��j4��'�|�lvo�H^0�����
N	:������Rw�@w��GHy"�a�$���R�Ҽf,j�����r��a���г�zd��%�^3��<������^�&t�0{��-b�����ҟRd��*2��'��})�V�2!������t1�z}���SM�A�5TR�������9�|�Ӳ�P3������B�����PK��ZЃc'2E
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��Z�~��Cxl/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-��Zほ�5xl/workbook.xmlPK-��Z����	��[Content_Types].xmlPK-
��Z�2�''U_rels/.relsPK-��Z�f{��xl/worksheets/sheet1.xmlPK-��Z����P�xl/_rels/workbook.xml.relsPK-��ZЃc'2E
�xl/styles.xmlPK-��Z�~��CMxl/sharedStrings.xmlPK�p