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 �D[��M϶ 5 xl/workbook.xml � (� ����0��&�C������x��})�4ҟtk��H�yۙ��v���Wk�}�h��Bp�$�@'��̻�z a��)l�+���o�&�,Ir�q����A9�+�9��р��4(��ぱri�P8Q����]L&�M��_D�h�x8�έ�xʙ/�<ܡMr�&Y�gyIӜ��V��w�PK �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 �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="Rbf3e398f56a04946" /></Relationships>PK �D[�봭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 �D[|�K� P xl/_rels/workbook.xml.rels � (� ��Kn�0@�b;�� ����n)�8��H��6m9[=R�P�J�����h~OO��|���ߦ����5� FF�f0]��>���m4b��f����!�ν�iB�ٙL��Mb�:>�>aG�Bq�2�Ɏ���C�m;hz��<� ���u'�`Gt� ~J�_C�E*�����BQ)��Z�����e$����'2+�(�j�5J�����Q�\�tꔖ�Z��R-k)W����}PK �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 �D[#Δ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- �D[��M϶ 5 xl/workbook.xmlPK- �D[���� � � [Content_Types].xmlPK- �D[ɮ�' ' U _rels/.relsPK- �D[�봭U � � xl/worksheets/sheet1.xmlPK- �D[|�K� P h xl/_rels/workbook.xml.relsPK- �D[Ѓc'2 E � xl/styles.xmlPK- �D[#Δu� � ' xl/sharedStrings.xmlPK � \
application/vnd.ms-excel
Sample:
PK �D[G]��� 5 xl/workbook.xml � (� ����0��&�C�p�R8q����Ri�?ik���'�x�3;�������cݛ����1� Ȗ4��ud�]c��8J��4JRi�[���&�<��5�U.��+8OX��(�~AiT��cbj�T4�Y��Zw2,!�M��]̊Ԕ�#r6;�:�G�|���q��k]�)�$S��7���w�PK �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 �D[�n��' ' _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="Ra6474246b8d940aa" /></Relationships>PK �D[�봭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 �D[���N� P xl/_rels/workbook.xml.rels � (� ��Kn�0@�b;�cD`æ[�&�8�H��6�����W�E�6H]t�j4��'�|�lvoC�.�C�ly&��UNw�����v�́z�i"��XZ���6�q�yP- 27�M���1���#�6ĥ��g��u���1���S�l��_�?��(;�o(V�S ��,Q�=� ˺.��! � R�Z�מ¯�w>��g�X��\�b^��|�L���K���S�iy�V��.Ш\R�75~��/PK �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 �D[#Δ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- �D[G]��� 5 xl/workbook.xmlPK- �D[���� � � [Content_Types].xmlPK- �D[�n��' ' U _rels/.relsPK- �D[�봭U � � xl/worksheets/sheet1.xmlPK- �D[���N� P h xl/_rels/workbook.xml.relsPK- �D[Ѓc'2 E � xl/styles.xmlPK- �D[#Δu� � ' xl/sharedStrings.xmlPK � \