GET api/genericimport/details/{importType}/{relations}

Returns list of application fields for supplied import type with its relations

Request Information

URI Parameters

NameDescriptionTypeAdditional information
importType

Import Type - PLU, Supplier or dept

integer

Required

relations

boolean

Default value is False

Body Parameters

None.

Response Information

Resource Description

GenericImportTypeDetail
NameDescriptionTypeAdditional information
Fields

Collection of ApplicationField

None.

Relations

Collection of GenericImportTypeRelation

None.

Response Formats

application/json, text/json

Sample:
{
  "fields": [
    {
      "$id": "2",
      "tableName": "sample string 1",
      "displayName": "sample string 2",
      "columnName": "sample string 3",
      "dataTypeShortName": "sample string 4",
      "additionalDetail": "sample string 5",
      "isPrimaryTable": true
    },
    {
      "$ref": "2"
    }
  ],
  "relations": [
    {
      "$id": "3",
      "tableName": "sample string 1",
      "fields": [
        {
          "$ref": "2"
        },
        {
          "$ref": "2"
        }
      ]
    },
    {
      "$ref": "3"
    }
  ]
}

application/xml, text/xml

Sample:
<GenericImportTypeDetail xmlns:i="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://schemas.datacontract.org/2004/07/EziManager.Models.EMC.GenericImport">
  <Fields>
    <ApplicationField>
      <AdditionalDetail>sample string 5</AdditionalDetail>
      <ColumnName>sample string 3</ColumnName>
      <DataType xmlns:d4p1="http://schemas.datacontract.org/2004/07/System" i:nil="true" />
      <DataTypeShortName>sample string 4</DataTypeShortName>
      <DisplayName>sample string 2</DisplayName>
      <IsPrimaryTable>true</IsPrimaryTable>
      <TableName>sample string 1</TableName>
    </ApplicationField>
    <ApplicationField>
      <AdditionalDetail>sample string 5</AdditionalDetail>
      <ColumnName>sample string 3</ColumnName>
      <DataType xmlns:d4p1="http://schemas.datacontract.org/2004/07/System" i:nil="true" />
      <DataTypeShortName>sample string 4</DataTypeShortName>
      <DisplayName>sample string 2</DisplayName>
      <IsPrimaryTable>true</IsPrimaryTable>
      <TableName>sample string 1</TableName>
    </ApplicationField>
  </Fields>
  <Relations>
    <GenericImportTypeRelation>
      <Fields>
        <ApplicationField>
          <AdditionalDetail>sample string 5</AdditionalDetail>
          <ColumnName>sample string 3</ColumnName>
          <DataType xmlns:d6p1="http://schemas.datacontract.org/2004/07/System" i:nil="true" />
          <DataTypeShortName>sample string 4</DataTypeShortName>
          <DisplayName>sample string 2</DisplayName>
          <IsPrimaryTable>true</IsPrimaryTable>
          <TableName>sample string 1</TableName>
        </ApplicationField>
        <ApplicationField>
          <AdditionalDetail>sample string 5</AdditionalDetail>
          <ColumnName>sample string 3</ColumnName>
          <DataType xmlns:d6p1="http://schemas.datacontract.org/2004/07/System" i:nil="true" />
          <DataTypeShortName>sample string 4</DataTypeShortName>
          <DisplayName>sample string 2</DisplayName>
          <IsPrimaryTable>true</IsPrimaryTable>
          <TableName>sample string 1</TableName>
        </ApplicationField>
      </Fields>
      <TableName>sample string 1</TableName>
    </GenericImportTypeRelation>
    <GenericImportTypeRelation>
      <Fields>
        <ApplicationField>
          <AdditionalDetail>sample string 5</AdditionalDetail>
          <ColumnName>sample string 3</ColumnName>
          <DataType xmlns:d6p1="http://schemas.datacontract.org/2004/07/System" i:nil="true" />
          <DataTypeShortName>sample string 4</DataTypeShortName>
          <DisplayName>sample string 2</DisplayName>
          <IsPrimaryTable>true</IsPrimaryTable>
          <TableName>sample string 1</TableName>
        </ApplicationField>
        <ApplicationField>
          <AdditionalDetail>sample string 5</AdditionalDetail>
          <ColumnName>sample string 3</ColumnName>
          <DataType xmlns:d6p1="http://schemas.datacontract.org/2004/07/System" i:nil="true" />
          <DataTypeShortName>sample string 4</DataTypeShortName>
          <DisplayName>sample string 2</DisplayName>
          <IsPrimaryTable>true</IsPrimaryTable>
          <TableName>sample string 1</TableName>
        </ApplicationField>
      </Fields>
      <TableName>sample string 1</TableName>
    </GenericImportTypeRelation>
  </Relations>
</GenericImportTypeDetail>

application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

Sample:
PK�1�Z���5xl/workbook.xml �(�����0��&�C�����x��})�4П�5��$޼���~;�d��3����]I�lΘ=*�'cQ�]g���{1�uR`m�[����s8B�F�^ZOW�?,oB�{Ġ��@jZ�s����/2[��$l
��T����E
KZCJ�ޖ�B��eO�,��U�&iRNw�+����PK�1�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
�1�ZxM''_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="R07b8da3468184a36" /></Relationships>PK�1�Z�봭U�xl/worksheets/sheet1.xml �(����n�0D���&	!%���V�О]X���mB>�Ƥ4*=�k����B���]A����bM�
ќS���)ƻ,镾�
�"'o�V�����b�
$7�j�q�Riɭ;�3Qe)r8����XR
5��*S�����i5��G����\48K
��Cz��L�m!F$K��]@oj4L��e8�)�^Kf⓿�U�J���M�� ΕuKZyO�j�H�auI~��^�Jq̂�R�dl�Թ��X%?�6������'���x�7Q-�e����1|�#�<K���mG��+��ԅ7ne׌&�:x��\�&q���PÙ'�E�+���!w�>0�R��l��/PK�1�Z�d���Pxl/_rels/workbook.xml.rels �(���KN�0@�b͞�	N��ݰa[z��3N�&vd�@�Ƃ#q�"A*�`��h~OO��|�Xoߦ�����
�FV�v�]�h�j�n�;1���s`iņ��΃�i��l��'�)��Q�#^Qq�d�5���3���4=:}���?����c�"�=��b?��/!��S���*��J�W�8�CY�7S�<R����2-��ύ�B)Y+��L�����ӥ�N��BMh-J�jk#r�J]���_l�PK�1�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�1�Z#Δu��xl/sharedStrings.xml �(���MK�0��J�ݤ+""m)�"؋�'���I�̊��+ų��cxf�޾/� ���ȍ���qp86��?�����`|Dh�$Ŷ��X�Q�FN��Rk�C*&�����GM)�h���iU��`Ja���gRѽ�[u���v��Tknk��|�w�
����31�E��.
u
�Yu눟7���4#d��<�]߭���bfu��wv!,�����R�9�z��.n?PK-�1�Z���5xl/workbook.xmlPK-�1�Z����	�[Content_Types].xmlPK-
�1�ZxM''V_rels/.relsPK-�1�Z�봭U��xl/worksheets/sheet1.xmlPK-�1�Z�d���Pixl/_rels/workbook.xml.relsPK-�1�ZЃc'2E
�xl/styles.xmlPK-�1�Z#Δu��)xl/sharedStrings.xmlPK�^	

application/vnd.ms-excel

Sample:
PK�1�Z�b��5xl/workbook.xml �(�����0D�&�C����	)��x��}-�m�-ik��-H�yۙ�};|��Zۓ��/]Eecɘ5����]g���{1�uJ`c�[�	�$s8@P�x�FOW�?,?:��KĠ��AZ���C�����l���o�/��bQĀƊ6��Ź�M)q������p)2�"����������PK�1�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
�1�ZԺ��''_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="R7ffda5f4f71548f4" /></Relationships>PK�1�Z�봭U�xl/worksheets/sheet1.xml �(����n�0D���&	!%���V�О]X���mB>�Ƥ4*=�k����B���]A����bM�
ќS���)ƻ,镾�
�"'o�V�����b�
$7�j�q�Riɭ;�3Qe)r8����XR
5��*S�����i5��G����\48K
��Cz��L�m!F$K��]@oj4L��e8�)�^Kf⓿�U�J���M�� ΕuKZyO�j�H�auI~��^�Jq̂�R�dl�Թ��X%?�6������'���x�7Q-�e����1|�#�<K���mG��+��ԅ7ne׌&�:x��\�&q���PÙ'�E�+���!w�>0�R��l��/PK�1�Z��z�Pxl/_rels/workbook.xml.rels �(���KN�0@�b͞8v7Eu�aö��'Q;�]�gc���V� �X��j4��'�|�lvo�H^0��;�(��3�\���]��f��Ny"��I^qQA��|Oi4=N:~F�;ևI������u�����aɀk&9�g��[;|��4�K����#& :L
~J�^+2�c�`�b���0�%z3���#�_��|!���4-�%o����L��O)�K/����ZԨe��y�E�^���PK�1�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�1�Z#Δu��xl/sharedStrings.xml �(���MK�0��J�ݤ+""m)�"؋�'���I�̊��+ų��cxf�޾/� ���ȍ���qp86��?�����`|Dh�$Ŷ��X�Q�FN��Rk�C*&�����GM)�h���iU��`Ja���gRѽ�[u���v��Tknk��|�w�
����31�E��.
u
�Yu눟7���4#d��<�]߭���bfu��wv!,�����R�9�z��.n?PK-�1�Z�b��5xl/workbook.xmlPK-�1�Z����	��[Content_Types].xmlPK-
�1�ZԺ��''U_rels/.relsPK-�1�Z�봭U��xl/worksheets/sheet1.xmlPK-�1�Z��z�Phxl/_rels/workbook.xml.relsPK-�1�ZЃc'2E
�xl/styles.xmlPK-�1�Z#Δu��'xl/sharedStrings.xmlPK�\