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 ܓ�\�@� 5 xl/workbook.xml � (� ����0��&�C��@H58q����J�H����[ �x�3;��ԓ����/�ѣ �o���U��^��p�M�
�k�I�'�àz�l��h"+��3�#DeM�����a�D��Q�+J�2�=��fw�SXd2���I�b��z���"46���,�U44��W*
7,���Kι��=��;�f���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
ܓ�\r�E�' ' _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="R859fe09fb98b4f0a" /></Relationships>PK ܓ�\��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 ܓ�\F��� P xl/_rels/workbook.xml.rels � (� ��KN�0@�b͞8�:�i7lؖ^���q�Ďl��Xp$��U$H%l����I3�����4�q𮃪(��S^���̝��f��Q�<�0G�W\���4?P��I����r��0ɔ���Y����e�iX2�I���C��
�:M��`���1Z�d/C����R��P�
�Iw�Úk��Z2�z3���#�_��|!#��`�`�`--�����s
��K�ey�f�z�u%�C�8o/j��/6_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 ܓ�\�/�� � 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- ܓ�\�@� 5 xl/workbook.xmlPK- ܓ�\���� � � [Content_Types].xmlPK-
ܓ�\r�E�' ' U _rels/.relsPK- ܓ�\��4 � � xl/worksheets/sheet1.xmlPK- ܓ�\F��� P - xl/_rels/workbook.xml.relsPK- ܓ�\Ѓc'2 E
r xl/styles.xmlPK- ܓ�\�/�� � � xl/sharedStrings.xmlPK � �
application/vnd.ms-excel
Sample:
PK ܓ�\֏2� 5 xl/workbook.xml � (� ����0��&�C�����N\�z�^`+
�'m
>��o�vfg�:k;�Z��#'�J[��{S�$s'm@��V2�}���[��$K��01/�r�0��X�X`� ��V�dB��x@�.͞fe0�����"�)a�ETH1 n�gE��W8�Ȗ"���oה�d�<)Z��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
ܓ�\��:�' ' _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="R18275b3710aa4df0" /></Relationships>PK ܓ�\��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 ܓ�\��&� P xl/_rels/workbook.xml.rels � (� ��KN�0@�b͞�N�P�nذ-���㨉�.г��H\�H�J,�t5��ӓf>�?�۷id/��]���i�
�o��M��zG#�<�0G�W\l��4�s�� c�gr�c|�0�4�|F}��x)D�Ò�L�?���7f����q"�� �W�%`{=�~J���,2�c��NW��V���r�D��_M-��H���;_Ƞ�.]�U��W���{J!_z�,/ԌT(e��E�T��j��/6_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 ܓ�\�/�� � 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- ܓ�\֏2� 5 xl/workbook.xmlPK- ܓ�\���� � [Content_Types].xmlPK-
ܓ�\��:�' ' V _rels/.relsPK- ܓ�\��4 � � xl/worksheets/sheet1.xmlPK- ܓ�\��&� P . xl/_rels/workbook.xml.relsPK- ܓ�\Ѓc'2 E
s xl/styles.xmlPK- ܓ�\�/�� � � xl/sharedStrings.xmlPK � �