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 ԓ�\��� 5 xl/workbook.xml � (� ����0D�&�C���@�N\�z��EhK��|o�vfg��������
[����`�5*p'3���X>H�b�me��i�
�g�(ʘ��4�urtt���r�E�C�jXQ
����@��=$Nn�����&ak�����/E4(,i
(Y��(iL�-d�y.���&W��8,6��l�]}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
ԓ�\��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="R32ebf32320c44a3a" /></Relationships>PK ԓ�\
��� 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 ԓ�\��+�� P xl/_rels/workbook.xml.rels � (� ��KN�0@�b͞�i�&��vÆm���8��ؑ�=�����ĂM��|��$����f�6�|�m �0���
��y�a���i��6B�O��'64��8�9��C�&�ib�1�ҷ|Bu�B�%�s�2��2��Θ^ѣS�l��_�?��(;�o)6��
���,Q�=����^Xb)k-u��wS�2P����g2V:E���ZK��L���s���N��L��2����h�j��.�_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 ԓ�\�>ɺ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- ԓ�\��� 5 xl/workbook.xmlPK- ԓ�\���� � [Content_Types].xmlPK-
ԓ�\��n' ' V _rels/.relsPK- ԓ�\
��� W � xl/worksheets/sheet1.xmlPK- ԓ�\��+�� P � xl/_rels/workbook.xml.relsPK- ԓ�\Ѓc'2 E
� xl/styles.xmlPK- ԓ�\�>ɺw / c xl/sharedStrings.xmlPK � (
application/vnd.ms-excel
Sample:
PK ԓ�\�iyP� 5 xl/workbook.xml � (� ����0��&�C�p�TR8q����
�m�-ik���'�x�3;���im�>�5>u�!t)�/%i�;ۑv�u� �l]��
[�5� �(J�Q�AY��<�i��|�+/��ng�Fex��0&�fE���`,uG���ߔ�`�Ť�AM/0 g�s�2s�R5�
��R���Dɑ���W���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
ԓ�\�L��' ' _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="R24cf48986f2444a2" /></Relationships>PK ԓ�\
��� 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 ԓ�\�K��� P xl/_rels/workbook.xml.rels � (� ��KN�0@�b͞� vڠ�ݰa[z�'Q۲]�gc���V� �X��j4��'�|�lvo�D^0���ʂA��m��)��5춛=N2�8�>��bcCJ��Ҩ�e,�G�;ƅY����z���GZ1VӰd�5���Ctƌ
�:�h�`���1� �A�S?�H/�,2ȓna�%3k]�+�5����ZL� ��w����P�+�M�o*3Ȁ�9�|�Ӳ�P�JQ�2Zu��N^���_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 ԓ�\�>ɺ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- ԓ�\�iyP� 5 xl/workbook.xmlPK- ԓ�\���� � [Content_Types].xmlPK-
ԓ�\�L��' ' V _rels/.relsPK- ԓ�\
��� W � xl/worksheets/sheet1.xmlPK- ԓ�\�K��� P � xl/_rels/workbook.xml.relsPK- ԓ�\Ѓc'2 E
� xl/styles.xmlPK- ԓ�\�>ɺw / c xl/sharedStrings.xmlPK � (