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 b�[�� 5 xl/workbook.xml � (� ����0D�&�C��`T� '.^=x_akhK��|K $��ξ�r2�ӓ��+lE��c��k*p3�;n��}1ùl�1�[���$fq /�vB��.�Xn���^ J�Դ��)�f���2k��$l ��Ta�ETD�6���ܺ����B���<�RH��ԝ�tco�����/PK b�[���� � [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 b�[�R��' ' _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="R3996439690fb4931" /></Relationships>PK b�[�봭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 b�["��� P xl/_rels/workbook.xml.rels � (� ��KN�0@�b͞8Iǭ�vÆm�F�8��ؑ�=�����ĂMW��==i���c��F�B>ζPd90��u��[8G� a��hĘ&���Ҋ -�� �A�0dn&�:�� cJ}�gT'쉗y.�_2�Ɏ���CtZ��:Od�`���)�숾���O)�k(�D�Եph�����"o��^�wS�2R����2u���.��l�]ezꞣO�^:-�5j�TR��Z�*��U�����PK b�[Ѓ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 b�[#Δ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- b�[�� 5 xl/workbook.xmlPK- b�[���� � � [Content_Types].xmlPK- b�[�R��' ' U _rels/.relsPK- b�[�봭U � � xl/worksheets/sheet1.xmlPK- b�["��� P h xl/_rels/workbook.xml.relsPK- b�[Ѓc'2 E � xl/styles.xmlPK- b�[#Δu� � ' xl/sharedStrings.xmlPK � \
application/vnd.ms-excel
Sample:
PK b�[��� 5 xl/workbook.xml � (� ����0D�&�C����()��x���EhK�5��B $��ξ1:�=�����s_�6�!g��ă�N��y#�$�����5T�~����3��Yl��t������T��/(#���~G���=4��d�ug��%�~S"¶���� Z� )��M4���z�����/��$�'tco0����PK b�[���� � [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 b�[�Q�' ' _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="R90098f0e8f7c42a0" /></Relationships>PK b�[�봭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 b�[�?�� P xl/_rels/workbook.xml.rels � (� ��An� E����@��]�d�M�i.@�`[�I��u�#� E��:R�d��<�������:C�����bV�n��ħd�ݬ�0��o�a��'6J<�� �z�Y��y��c\�U�e�W��z +J K�e�����ΘQÓӧl�L^]8� atP��$�O��`E�b��$�ם`e+�N7��"�O��e����]/d*��[S*�D��zuW�A�Sț^:-�Z+�J��Q�8m}U#7�b�PK b�[Ѓ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 b�[#Δ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- b�[��� 5 xl/workbook.xmlPK- b�[���� � [Content_Types].xmlPK- b�[�Q�' ' V _rels/.relsPK- b�[�봭U � � xl/worksheets/sheet1.xmlPK- b�[�?�� P i xl/_rels/workbook.xml.relsPK- b�[Ѓc'2 E � xl/styles.xmlPK- b�[#Δu� � * xl/sharedStrings.xmlPK � _