POST api/genericimport/mappingconfiguration/save
Save - Add/Update mapping configuration with child values - fiel fields and application fields mappings
Request Information
URI Parameters
None.
Body Parameters
Mapping Configuration detail
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. |
Request Formats
application/json, text/json
Sample:
{
"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"
}
]
}
application/xml, text/xml
Sample:
<GenericImportMappingConfiguration xmlns:i="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://schemas.datacontract.org/2004/07/EziManager.Models.EMC.GenericImport">
<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>
application/x-www-form-urlencoded
Sample:
Sample not available.
Response Information
Resource Description
integerResponse Formats
application/json, text/json
Sample:
1
application/xml, text/xml
Sample:
<int xmlns="http://schemas.microsoft.com/2003/10/Serialization/">1</int>
application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Sample:
PK k3�\u�з 5 xl/workbook.xml � (� ����0��J}�(��[U(0�t���S"H��T��@ u��;�?��c�Q�v�-i��T0�D�
��L�î3V�Ҿ��:)�6�P{�DѕY�K�]/'G7�?,7Y����^�J�Դ:��K���٭2{��$l��_a�Ū��%��%�soKSb�G���֤1DQ��ٍ������PK k3�\���� � [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
k3�\wb' ' _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="R252bc0a9a26f45ea" /></Relationships>PK k3�\��4 � xl/worksheets/sheet1.xml � (� �Q�n� ��}%��j�U���n�ۙ%N@
82����6M�e������<��Ȯ@��ox��8�bg���9�w����t ��aO
71N{!Bk��� |z둜�)�A`��N��|۪� �Q�T*;���G+L�+ܸJ9m=W��I=�g}Ï5gBɂ|���_1�m|"^r��5�*X�|.�_�u��y�o�<�LLz(��Pv�l�gN�ʹ�.��?m��j�M�v��z��+��:騕$\�礚��G����Z�kf���ߎW�Is:#F����W�PK k3�\����� P xl/_rels/workbook.xml.rels � (� ��An� E��f_6I�*N6�t���ۊ
�&9[=R�P�H-���&+4��i������2��
}�m�Z���v
��y�a�Y�q�1��0����@��Li�=N2nF�:��I�T���Re��dlI}{&9\g��3h�9}���?����1��A�c?Q��/�K��~QjS��K��5�0��#�_�[�ɘ�'U/Ui�2��ؾF�6�;�q�&�Z����aF(y����/PK k3�\Ѓ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 k3�\�/�� � xl/sharedStrings.xml � (� 5�A� �B�nA�h&�@@ڵ����������d2;}Ҧ�X9frp(�9/�V���p��i�[&t�E5��YTO��r՚���R7�\���u�\*����M��9��#��s#qЧ��������~PK- k3�\u�з 5 xl/workbook.xmlPK- k3�\���� � [Content_Types].xmlPK-
k3�\wb' ' V _rels/.relsPK- k3�\��4 � � xl/worksheets/sheet1.xmlPK- k3�\����� P . xl/_rels/workbook.xml.relsPK- k3�\Ѓc'2 E
t xl/styles.xmlPK- k3�\�/�� � � xl/sharedStrings.xmlPK � �
application/vnd.ms-excel
Sample:
PK k3�\h!~� 5 xl/workbook.xml � (� ����0��&�C��@
8q����Zi�?ik��-%�x�3;��Գq��1/�Q���k����bD�d,��S�tOf�A
�x+ԁYvf'�h?J��J���C���Դ�HM�ぐziv�8�$���]L���M� �_$E4(lh(IεohN��dn���_8���˒��V��w�PK k3�\���� � [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
k3�\?��' ' _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="R35899797d44c47eb" /></Relationships>PK k3�\��4 � xl/worksheets/sheet1.xml � (� �Q�n� ��}%��j�U���n�ۙ%N@
82����6M�e������<��Ȯ@��ox��8�bg���9�w����t ��aO
71N{!Bk��� |z둜�)�A`��N��|۪� �Q�T*;���G+L�+ܸJ9m=W��I=�g}Ï5gBɂ|���_1�m|"^r��5�*X�|.�_�u��y�o�<�LLz(��Pv�l�gN�ʹ�.��?m��j�M�v��z��+��:騕$\�礚��G����Z�kf���ߎW�Is:#F����W�PK k3�\%��� P xl/_rels/workbook.xml.rels � (� ��KN�0@�b͞�I�B��ݰa[z��=��&vd�@�Ƃ#q�"A*�`��h~OO��|���ަ��P��w�� FNy=���S2w��n�4b��sdy��lJ��,M?���Ä)���3�#��+!V<,p�d��L�!zcE�^�&r�0��-Qv��S���%�E�{��U����X�T�l[`�fj1�G��^��B��WF��B"57��H?��/�tZ�j´��X馩e�ʋ����PK k3�\Ѓ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 k3�\�/�� � xl/sharedStrings.xml � (� 5�A� �B�nA�h&�@@ڵ����������d2;}Ҧ�X9frp(�9/�V���p��i�[&t�E5��YTO��r՚���R7�\���u�\*����M��9��#��s#qЧ��������~PK- k3�\h!~� 5 xl/workbook.xmlPK- k3�\���� � � [Content_Types].xmlPK-
k3�\?��' ' U _rels/.relsPK- k3�\��4 � � xl/worksheets/sheet1.xmlPK- k3�\%��� P - xl/_rels/workbook.xml.relsPK- k3�\Ѓc'2 E
r xl/styles.xmlPK- k3�\�/�� � � xl/sharedStrings.xmlPK � �