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
GenericImportTypeDetail| Name | 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 3�\D5� 5 xl/workbook.xml � (� ����0D�&�C����N\�z�^`��m��|o�vfg���5�@>j�.��79c��A wB:�:�J� �a��*l�
�g�(J��Qx����8���a9cA���j\QJHM��>7{J��"��՝M���M��_,�h������Ź�=Sbs�G��Y�A���-�fa��wg���PK 3�\���� � [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
3�\��' ' _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="Rc59a8be6dfc3499d" /></Relationships>PK 3�\�봭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 3�\=��T� P xl/_rels/workbook.xml.rels � (� ��KN�0@�b͞8��Ġ�ݰ���3N�&�e����G�
XE�Tb�������4����ڼM#9c���
���V�v�]�d$l֫�*��>��bc}J��Ҩ{�T,�G�;ƅI����z���C�(ˊ�9n�d���3f����iB�� �W��GL@�*t��)Ez
��T ۶�]] YK4��.���ZL���w>�a��k�U-��˻��*`��B���i^��=2�*�8��@W5z��/PK 3�\Ѓ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 3�\#Δ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- 3�\D5� 5 xl/workbook.xmlPK- 3�\���� � [Content_Types].xmlPK-
3�\��' ' V _rels/.relsPK- 3�\�봭U � � xl/worksheets/sheet1.xmlPK- 3�\=��T� P i xl/_rels/workbook.xml.relsPK- 3�\Ѓc'2 E
� xl/styles.xmlPK- 3�\#Δu� � ( xl/sharedStrings.xmlPK � ]
application/vnd.ms-excel
Sample:
PK 3�\���� 5 xl/workbook.xml � (� ����0��&�C�� )��x�ཅE�O�||K $���~;t�v�ZO�#g�*[��{S�$sm@�ݠ�d>H�"zD����'i���̼�ʍ�8���a9c��n�r�P� ��� !�6{
X\����&"[���h�Q!�$Ըe�a�{_�+F�ax�YV�9�E���S|�%���PK 3�\���� � [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
3�\�NA�' ' _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="Rcfb00bc26fe94e68" /></Relationships>PK 3�\�봭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 3�\�z��� P xl/_rels/workbook.xml.rels � (� ��KN�0@�b͞8qR'��ݰ���L⨉�n�gc���V� �X��j4��'�|���o�H����lE�A��l��)v
l7�=�"��`�9��bC&���ҠN"dnF�:��)�=��:�)�sN���Lr�����A�S� m�L_�?����1��S
��,Q��t��,y���k�*�b@���B��~�������f
⢹���K���K�ey�֨�(s�\�ꑉ�����PK 3�\Ѓ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 3�\#Δ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- 3�\���� 5 xl/workbook.xmlPK- 3�\���� � [Content_Types].xmlPK-
3�\�NA�' ' V _rels/.relsPK- 3�\�봭U � � xl/worksheets/sheet1.xmlPK- 3�\�z��� P i xl/_rels/workbook.xml.relsPK- 3�\Ѓc'2 E
� xl/styles.xmlPK- 3�\#Δu� � ( xl/sharedStrings.xmlPK � ]