GET api/genericimport/details/{importType}/{relations}
Returns list of application fields for supplied import type with its relations
Request Information
URI Parameters
Name | Description | Type | Additional information |
---|---|---|---|
importType |
Import Type - PLU, Supplier or dept |
integer |
Required |
relations | boolean |
Default value is False |
Body Parameters
None.
Response Information
Resource Description
GenericImportTypeDetailName | Description | Type | Additional 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��� 5 xl/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 KZC J�ޖ�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��� P xl/_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'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�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��� 5 xl/workbook.xmlPK- �1�Z���� � [Content_Types].xmlPK- �1�ZxM' ' V _rels/.relsPK- �1�Z�봭U � � xl/worksheets/sheet1.xmlPK- �1�Z�d��� P i xl/_rels/workbook.xml.relsPK- �1�ZЃc'2 E � xl/styles.xmlPK- �1�Z#Δu� � ) xl/sharedStrings.xmlPK � ^
application/vnd.ms-excel
Sample:
PK �1�Z�b�� 5 xl/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� P xl/_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'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�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�� 5 xl/workbook.xmlPK- �1�Z���� � � [Content_Types].xmlPK- �1�ZԺ��' ' U _rels/.relsPK- �1�Z�봭U � � xl/worksheets/sheet1.xmlPK- �1�Z��z� P h xl/_rels/workbook.xml.relsPK- �1�ZЃc'2 E � xl/styles.xmlPK- �1�Z#Δu� � ' xl/sharedStrings.xmlPK � \