GET api/genericimport/mappingconfigurations
Returns list of available mapping configurations with its child data - file fields and application fields mapping
Request Information
URI Parameters
None.
Body Parameters
None.
Response Information
Resource Description
List of mapping configurations
Collection of GenericImportMappingConfiguration| Name | Description | Type | Additional information |
|---|---|---|---|
| Id | integer |
None. |
|
| MappingName | string |
None. |
|
| ImportType | GenericImportType |
None. |
|
| ExcludeAPNWithSpecificLength | string |
None. |
|
| ExcludeBarcodeIfStartsWith | string |
None. |
|
| IgnoreQuotes | boolean |
None. |
|
| CostDecimals | integer |
None. |
|
| PriceDecimals | integer |
None. |
|
| HeaderRowIndex | integer |
None. |
|
| FieldDelimiter | ImportFileDelimiter |
None. |
|
| AddNewRecordIfNoMatch | boolean |
None. |
|
| GenericImportMappingDetails | Collection of GenericImportMappingDetails |
Relation. This field may not always be loaded or used for updates. |
Response Formats
application/json, text/json
Sample:
[
{
"$id": "1",
"id": 1,
"mappingName": "sample string 2",
"importType": 0,
"excludeAPNWithSpecificLength": "sample string 3",
"excludeBarcodeIfStartsWith": "sample string 4",
"ignoreQuotes": true,
"costDecimals": 1,
"priceDecimals": 1,
"headerRowIndex": 5,
"fieldDelimiter": 0,
"addNewRecordIfNoMatch": true,
"genericImportMappingDetails": [
{
"$id": "2",
"id": 1,
"mappingConfigId": 2,
"fileFieldName": "sample string 3",
"applicationFieldName": "sample string 4",
"overrideValue": "sample string 5",
"isKeyColumn": true,
"ignoreWhileUpdating": true,
"removeSpecificCharacters": "sample string 6",
"valueMappings": "sample string 7",
"relationMappings": "sample string 8",
"isEnum": true,
"otherApplicationFieldNames": "sample string 9",
"otherApplicationIgnoreRelationMapping": true,
"gstFieldToAdd": "sample string 11",
"tableName": "sample string 12",
"dateTimeFormat": "sample string 13",
"calculateValueMapping": "sample string 14",
"prefixValue": "sample string 15",
"suffixValue": "sample string 16"
},
{
"$ref": "2"
}
]
},
{
"$ref": "1"
}
]
application/xml, text/xml
Sample:
<ArrayOfGenericImportMappingConfiguration xmlns:i="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://schemas.datacontract.org/2004/07/EziManager.Models.EMC.GenericImport">
<GenericImportMappingConfiguration>
<AddNewRecordIfNoMatch>true</AddNewRecordIfNoMatch>
<CostDecimals>1</CostDecimals>
<ExcludeAPNWithSpecificLength>sample string 3</ExcludeAPNWithSpecificLength>
<ExcludeBarcodeIfStartsWith>sample string 4</ExcludeBarcodeIfStartsWith>
<FieldDelimiter>Comma</FieldDelimiter>
<GenericImportMappingDetails>
<GenericImportMappingDetails>
<ApplicationFieldName>sample string 4</ApplicationFieldName>
<CalculateValueMapping>sample string 14</CalculateValueMapping>
<DateTimeFormat>sample string 13</DateTimeFormat>
<FileFieldName>sample string 3</FileFieldName>
<GSTFieldToAdd>sample string 11</GSTFieldToAdd>
<Id>1</Id>
<IgnoreWhileUpdating>true</IgnoreWhileUpdating>
<IsEnum>true</IsEnum>
<IsKeyColumn>true</IsKeyColumn>
<MappingConfigId>2</MappingConfigId>
<OtherApplicationFieldNames>sample string 9</OtherApplicationFieldNames>
<OtherApplicationIgnoreRelationMapping>true</OtherApplicationIgnoreRelationMapping>
<OverrideValue>sample string 5</OverrideValue>
<PrefixValue>sample string 15</PrefixValue>
<RelationMappings>sample string 8</RelationMappings>
<RemoveSpecificCharacters>sample string 6</RemoveSpecificCharacters>
<SuffixValue>sample string 16</SuffixValue>
<TableName>sample string 12</TableName>
<ValueMappings>sample string 7</ValueMappings>
</GenericImportMappingDetails>
<GenericImportMappingDetails>
<ApplicationFieldName>sample string 4</ApplicationFieldName>
<CalculateValueMapping>sample string 14</CalculateValueMapping>
<DateTimeFormat>sample string 13</DateTimeFormat>
<FileFieldName>sample string 3</FileFieldName>
<GSTFieldToAdd>sample string 11</GSTFieldToAdd>
<Id>1</Id>
<IgnoreWhileUpdating>true</IgnoreWhileUpdating>
<IsEnum>true</IsEnum>
<IsKeyColumn>true</IsKeyColumn>
<MappingConfigId>2</MappingConfigId>
<OtherApplicationFieldNames>sample string 9</OtherApplicationFieldNames>
<OtherApplicationIgnoreRelationMapping>true</OtherApplicationIgnoreRelationMapping>
<OverrideValue>sample string 5</OverrideValue>
<PrefixValue>sample string 15</PrefixValue>
<RelationMappings>sample string 8</RelationMappings>
<RemoveSpecificCharacters>sample string 6</RemoveSpecificCharacters>
<SuffixValue>sample string 16</SuffixValue>
<TableName>sample string 12</TableName>
<ValueMappings>sample string 7</ValueMappings>
</GenericImportMappingDetails>
</GenericImportMappingDetails>
<HeaderRowIndex>5</HeaderRowIndex>
<Id>1</Id>
<IgnoreQuotes>true</IgnoreQuotes>
<ImportType>Campaign</ImportType>
<MappingName>sample string 2</MappingName>
<PriceDecimals>1</PriceDecimals>
</GenericImportMappingConfiguration>
<GenericImportMappingConfiguration>
<AddNewRecordIfNoMatch>true</AddNewRecordIfNoMatch>
<CostDecimals>1</CostDecimals>
<ExcludeAPNWithSpecificLength>sample string 3</ExcludeAPNWithSpecificLength>
<ExcludeBarcodeIfStartsWith>sample string 4</ExcludeBarcodeIfStartsWith>
<FieldDelimiter>Comma</FieldDelimiter>
<GenericImportMappingDetails>
<GenericImportMappingDetails>
<ApplicationFieldName>sample string 4</ApplicationFieldName>
<CalculateValueMapping>sample string 14</CalculateValueMapping>
<DateTimeFormat>sample string 13</DateTimeFormat>
<FileFieldName>sample string 3</FileFieldName>
<GSTFieldToAdd>sample string 11</GSTFieldToAdd>
<Id>1</Id>
<IgnoreWhileUpdating>true</IgnoreWhileUpdating>
<IsEnum>true</IsEnum>
<IsKeyColumn>true</IsKeyColumn>
<MappingConfigId>2</MappingConfigId>
<OtherApplicationFieldNames>sample string 9</OtherApplicationFieldNames>
<OtherApplicationIgnoreRelationMapping>true</OtherApplicationIgnoreRelationMapping>
<OverrideValue>sample string 5</OverrideValue>
<PrefixValue>sample string 15</PrefixValue>
<RelationMappings>sample string 8</RelationMappings>
<RemoveSpecificCharacters>sample string 6</RemoveSpecificCharacters>
<SuffixValue>sample string 16</SuffixValue>
<TableName>sample string 12</TableName>
<ValueMappings>sample string 7</ValueMappings>
</GenericImportMappingDetails>
<GenericImportMappingDetails>
<ApplicationFieldName>sample string 4</ApplicationFieldName>
<CalculateValueMapping>sample string 14</CalculateValueMapping>
<DateTimeFormat>sample string 13</DateTimeFormat>
<FileFieldName>sample string 3</FileFieldName>
<GSTFieldToAdd>sample string 11</GSTFieldToAdd>
<Id>1</Id>
<IgnoreWhileUpdating>true</IgnoreWhileUpdating>
<IsEnum>true</IsEnum>
<IsKeyColumn>true</IsKeyColumn>
<MappingConfigId>2</MappingConfigId>
<OtherApplicationFieldNames>sample string 9</OtherApplicationFieldNames>
<OtherApplicationIgnoreRelationMapping>true</OtherApplicationIgnoreRelationMapping>
<OverrideValue>sample string 5</OverrideValue>
<PrefixValue>sample string 15</PrefixValue>
<RelationMappings>sample string 8</RelationMappings>
<RemoveSpecificCharacters>sample string 6</RemoveSpecificCharacters>
<SuffixValue>sample string 16</SuffixValue>
<TableName>sample string 12</TableName>
<ValueMappings>sample string 7</ValueMappings>
</GenericImportMappingDetails>
</GenericImportMappingDetails>
<HeaderRowIndex>5</HeaderRowIndex>
<Id>1</Id>
<IgnoreQuotes>true</IgnoreQuotes>
<ImportType>Campaign</ImportType>
<MappingName>sample string 2</MappingName>
<PriceDecimals>1</PriceDecimals>
</GenericImportMappingConfiguration>
</ArrayOfGenericImportMappingConfiguration>
text/csv
Sample:
Sample not available.
application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Sample:
PK �1�\A#� 5 xl/workbook.xml � (� ����0��&�C���R8q���{i�H����[J ��mgv�ۡ�������ɄƷX��B��Y8Y&�F�5�I�'��8��5�Hʢ��ʚ �x���
�AD=�(͔���]�=�!�dlu�5D~S4�����aZܳ�0��M����oT���Wb �Z�W��w%���PK �1�\���� � [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�\_*�G' ' _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="R4fcf061443684d35" /></Relationships>PK �1�\
��� W xl/worksheets/sheet1.xml � (� ��Ms�@��
�}a�?Rj*�1�x�����1P����; ������=��PL�ҽ���"��ԇ�=�m�6�ާ������lr��G+Uzϊ�|��ey��b�4*}P�Y��<�Js���z�K6j�7�Tee� `a��QiRqr(�s���*���u ��*��̟M���^U��j7����^8����D���k���_�?���vꃚ
{�N�3��j��/}Z��=.M�h���}Q�ziR������?%�2��2�0d�ͱ(u���^�gjt誃$� �dBp4�Ǎ�z0����.8֓FO�z$AP���z��i���Br� ����Y�gm�8 sH���7z~��� ��a�h��V���c�#�e����D��A�a#�!��
���3 ���!d$�u���C$��x*0����2��BI�$d`��!�g�>0�f�\���^6�sY��̜��������!��O}u�y��]�O�.���K�� �%�}�w�U�]�O�.����Եi���^��+Ԉ<�~@˄'b�0w �
���a�@,#^��X[ݮYi_i-w��+[;�v���g�3�vƁ��8�b;3�����
8�Hk;3^�ځ�΄7��|��|�u���mx�J��PK �1�\7B�� P xl/_rels/workbook.xml.rels � (� ��KN�0@�b͞8� �i7l�-��c�㨉m�n�gc���V� �X��j4��'�|���o�D���hME�A#����)�����'�DУ$��Ё��=Q�ƙ��:4����yL������e���_2�I��!Z�F��V�f4�0}��4br�~���O)�k(�D���+���d/Q2&���Z�� ï�w���U�=WmS��=bsW�=ʗ�ӥ�N��B��˂7�f��Y^ɫ����PK �1�\Ѓ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�\�>ɺw / xl/sharedStrings.xml � (� }�oo�@ƿJt�t!@i��vi���i/֝��t�8;����M �/ퟭ�~����l����L.D�^m|�w��7DA^�
��$���"�"�zZ��9~*KR: "�L�!9�����4
��ly�X�//
F�Y��(Fo~���Md SW\��*��ʧ�9�A�y�
8���Őxw�3�>(;j�������u�����ϐ�����o������iʚ@��2��$��5�5{��6<�^�aJ�Z�Bk�aLSz��nQ����&t�j6��x6���2��,.Z��rMq>�1c0�?���4~7Ż4����`�����&X����|�M^�g��LzL�˷�$�]#�3@����?�2|�PK- �1�\A#� 5 xl/workbook.xmlPK- �1�\���� � � [Content_Types].xmlPK-
�1�\_*�G' ' U _rels/.relsPK- �1�\
��� W � xl/worksheets/sheet1.xmlPK- �1�\7B�� P � xl/_rels/workbook.xml.relsPK- �1�\Ѓc'2 E
� xl/styles.xmlPK- �1�\�>ɺw / a xl/sharedStrings.xmlPK � &
application/vnd.ms-excel
Sample:
PK �1�\'Hɵ 5 xl/workbook.xml � (� ����0��J}�(� �: `b�ڡ� N� ?�S��/�ԭ��|�|����97���,���C������<�e�\0^�)�%�N�
�(�,���D�,
��h������h�
e@[ޜO�Uk��ƙ�\���j2���o�J��")f�`�[��Yr�}�s�B����A�w�P2W���������PK �1�\���� � [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�\-NQ�' ' _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="Rf64e795718cb41b7" /></Relationships>PK �1�\
��� W xl/worksheets/sheet1.xml � (� ��Ms�@��
�}a�?Rj*�1�x�����1P����; ������=��PL�ҽ���"��ԇ�=�m�6�ާ������lr��G+Uzϊ�|��ey��b�4*}P�Y��<�Js���z�K6j�7�Tee� `a��QiRqr(�s���*���u ��*��̟M���^U��j7����^8����D���k���_�?���vꃚ
{�N�3��j��/}Z��=.M�h���}Q�ziR������?%�2��2�0d�ͱ(u���^�gjt誃$� �dBp4�Ǎ�z0����.8֓FO�z$AP���z��i���Br� ����Y�gm�8 sH���7z~��� ��a�h��V���c�#�e����D��A�a#�!��
���3 ���!d$�u���C$��x*0����2��BI�$d`��!�g�>0�f�\���^6�sY��̜��������!��O}u�y��]�O�.���K�� �%�}�w�U�]�O�.����Եi���^��+Ԉ<�~@˄'b�0w �
���a�@,#^��X[ݮYi_i-w��+[;�v���g�3�vƁ��8�b;3�����
8�Hk;3^�ځ�΄7��|��|�u���mx�J��PK �1�\���.� P xl/_rels/workbook.xml.rels � (� ��KN�0@�b͞8 D�i7lؖ^���8jbG��l,8W�j��J,�t5��ӓf�?�V��ido��]�(�������讅�z��Q�<�0G�W\���4?q��I����r�|�d�i��,�^�ȫ�|�aɀk&�g��
��>L��`���>Z�l'C���K)�SE�{1l�4BQEZեA`�fj1G��^�|!��J��
��Za}S+���N��B͠l���T�֦jNj��/�?PK �1�\Ѓ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�\�>ɺw / xl/sharedStrings.xml � (� }�oo�@ƿJt�t!@i��vi���i/֝��t�8;����M �/ퟭ�~����l����L.D�^m|�w��7DA^�
��$���"�"�zZ��9~*KR: "�L�!9�����4
��ly�X�//
F�Y��(Fo~���Md SW\��*��ʧ�9�A�y�
8���Őxw�3�>(;j�������u�����ϐ�����o������iʚ@��2��$��5�5{��6<�^�aJ�Z�Bk�aLSz��nQ����&t�j6��x6���2��,.Z��rMq>�1c0�?���4~7Ż4����`�����&X����|�M^�g��LzL�˷�$�]#�3@����?�2|�PK- �1�\'Hɵ 5 xl/workbook.xmlPK- �1�\���� � � [Content_Types].xmlPK-
�1�\-NQ�' ' T _rels/.relsPK- �1�\
��� W � xl/worksheets/sheet1.xmlPK- �1�\���.� P � xl/_rels/workbook.xml.relsPK- �1�\Ѓc'2 E
� xl/styles.xmlPK- �1�\�>ɺw / ^ xl/sharedStrings.xmlPK � #