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 ��\c�<�� 5 xl/workbook.xml � (� ����0��&�C����DR8q���{-�4�.ik��H�yۙ��v���"���
[����`���p'�̻�~��Űm���[���E�0�иN����Xn� �x=�(-����@_�=L.����.&ak���x��A#4��^P�[SҘ[�y��8�m]�4˓K�Н��8�~W_PK ��\���� � [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="R30ff8d9699b14e60" /></Relationships>PK ��\�봭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 ��\*i"x� P xl/_rels/workbook.xml.rels � (� ��KN�0@�b͞� �CP�n�a[z�L>jb[�[��Xp$��U$p%l*�4������|�Xmޖ��Ї� e���Ѷ�� ���جW;�ULa�\ � ��#�A���PX�&Mz�S��>�iŘ�>g�5����C�}?i�Z}\��?����C#���F ?�@/�,�S'a�K��������5z3��3�_��:��/U���'��n�meF�{�>�t35��`M+T��NqQ�Ww��PK ��\Ѓ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 ��\#Δ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- ��\c�<�� 5 xl/workbook.xmlPK- ��\���� � [Content_Types].xmlPK-
��\d�ݮ' ' V _rels/.relsPK- ��\�봭U � � xl/worksheets/sheet1.xmlPK- ��\*i"x� P i xl/_rels/workbook.xml.relsPK- ��\Ѓc'2 E
� xl/styles.xmlPK- ��\#Δu� � ( xl/sharedStrings.xmlPK � ]
application/vnd.ms-excel
Sample:
PK ��\~`b� 5 xl/workbook.xml � (� ����0��&�C�����N\�z��"
�'m
>�P�7o;�����j��r�-h��sM��IT��V���}1�u��J7o�ʳ$����^h�za]i�������W��hy<fO��r6���I�b�)`�EPD�ĂV����ۂƔ�\��#��4������45��;���w�PK ��\���� � [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
��\p��' ' _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="R537565db4c134352" /></Relationships>PK ��\�봭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 ��\�G)� P xl/_rels/workbook.xml.rels � (� ��Kn�0@�b;q;$A6ݰ�\�q&�ؖmJ9[=R�P�Jm����h~OO��|����扼���5�$�Z�v�}
��=���n8�'�0ZO��5!�5�^
8K��:v:�fb�zj�:�i��+��g�������F��F�g��0�w�b r���P�O��[`I�ٷ5*����Um.2� �S��:�����2B�R�"BJ|�� �/��K/���ڪ(E���y%�B����_l� PK ��\Ѓ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 ��\#Δ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- ��\���� � [Content_Types].xmlPK-
��\p��' ' V _rels/.relsPK- ��\�봭U � � xl/worksheets/sheet1.xmlPK- ��\�G)� P i xl/_rels/workbook.xml.relsPK- ��\Ѓc'2 E
� xl/styles.xmlPK- ��\#Δu� � * xl/sharedStrings.xmlPK � _