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 GenericImportMappingConfigurationName | 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", "gstFieldToAdd": "sample string 10", "tableName": "sample string 11", "dateTimeFormat": "sample string 12", "calculateValueMapping": "sample string 13", "prefixValue": "sample string 14", "suffixValue": "sample string 15" }, { "$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 13</CalculateValueMapping> <DateTimeFormat>sample string 12</DateTimeFormat> <FileFieldName>sample string 3</FileFieldName> <GSTFieldToAdd>sample string 10</GSTFieldToAdd> <Id>1</Id> <IgnoreWhileUpdating>true</IgnoreWhileUpdating> <IsEnum>true</IsEnum> <IsKeyColumn>true</IsKeyColumn> <MappingConfigId>2</MappingConfigId> <OtherApplicationFieldNames>sample string 9</OtherApplicationFieldNames> <OverrideValue>sample string 5</OverrideValue> <PrefixValue>sample string 14</PrefixValue> <RelationMappings>sample string 8</RelationMappings> <RemoveSpecificCharacters>sample string 6</RemoveSpecificCharacters> <SuffixValue>sample string 15</SuffixValue> <TableName>sample string 11</TableName> <ValueMappings>sample string 7</ValueMappings> </GenericImportMappingDetails> <GenericImportMappingDetails> <ApplicationFieldName>sample string 4</ApplicationFieldName> <CalculateValueMapping>sample string 13</CalculateValueMapping> <DateTimeFormat>sample string 12</DateTimeFormat> <FileFieldName>sample string 3</FileFieldName> <GSTFieldToAdd>sample string 10</GSTFieldToAdd> <Id>1</Id> <IgnoreWhileUpdating>true</IgnoreWhileUpdating> <IsEnum>true</IsEnum> <IsKeyColumn>true</IsKeyColumn> <MappingConfigId>2</MappingConfigId> <OtherApplicationFieldNames>sample string 9</OtherApplicationFieldNames> <OverrideValue>sample string 5</OverrideValue> <PrefixValue>sample string 14</PrefixValue> <RelationMappings>sample string 8</RelationMappings> <RemoveSpecificCharacters>sample string 6</RemoveSpecificCharacters> <SuffixValue>sample string 15</SuffixValue> <TableName>sample string 11</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 13</CalculateValueMapping> <DateTimeFormat>sample string 12</DateTimeFormat> <FileFieldName>sample string 3</FileFieldName> <GSTFieldToAdd>sample string 10</GSTFieldToAdd> <Id>1</Id> <IgnoreWhileUpdating>true</IgnoreWhileUpdating> <IsEnum>true</IsEnum> <IsKeyColumn>true</IsKeyColumn> <MappingConfigId>2</MappingConfigId> <OtherApplicationFieldNames>sample string 9</OtherApplicationFieldNames> <OverrideValue>sample string 5</OverrideValue> <PrefixValue>sample string 14</PrefixValue> <RelationMappings>sample string 8</RelationMappings> <RemoveSpecificCharacters>sample string 6</RemoveSpecificCharacters> <SuffixValue>sample string 15</SuffixValue> <TableName>sample string 11</TableName> <ValueMappings>sample string 7</ValueMappings> </GenericImportMappingDetails> <GenericImportMappingDetails> <ApplicationFieldName>sample string 4</ApplicationFieldName> <CalculateValueMapping>sample string 13</CalculateValueMapping> <DateTimeFormat>sample string 12</DateTimeFormat> <FileFieldName>sample string 3</FileFieldName> <GSTFieldToAdd>sample string 10</GSTFieldToAdd> <Id>1</Id> <IgnoreWhileUpdating>true</IgnoreWhileUpdating> <IsEnum>true</IsEnum> <IsKeyColumn>true</IsKeyColumn> <MappingConfigId>2</MappingConfigId> <OtherApplicationFieldNames>sample string 9</OtherApplicationFieldNames> <OverrideValue>sample string 5</OverrideValue> <PrefixValue>sample string 14</PrefixValue> <RelationMappings>sample string 8</RelationMappings> <RemoveSpecificCharacters>sample string 6</RemoveSpecificCharacters> <SuffixValue>sample string 15</SuffixValue> <TableName>sample string 11</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 )�D[��O� 5 xl/workbook.xml � (� ����0��&�C��@���x��})�m�?ik��-%�x�3;��Գq�ޘ��I��5T�`+�<����Ew�q B����8J���o�:�"�J�p� ��BZOW�?,o��bPӊR 5m�B��C�쓌�Vw1 [C�7U'�~�Ѡ���$9���9%��q����%����<\chcﰚm��/PK )�D[���� � [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="R4244bf7c20b44df2" /></Relationships>PK )�D[ ��� 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 )�D[D�{� P xl/_rels/workbook.xml.rels � (� ��AN�0E�b͞8I���ݰa[z��=N�&vd�@�Ƃ#q�"�+�`ӕ5짧�lvo��^��ɚD�##�����)�v�͞f��ճ�����νiA�ٕL�h��t_Qq ^�y�]ʀk&;�W��j=Iz�� ���uG?`t�~"�/��"ؓ�`_H��@QS_����p���z}ԔB���l��2#:R���M�Ni�Ω�h�(MT�꾽����PK )�D[Ѓ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 )�D[�>ɺ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- )�D[��O� 5 xl/workbook.xmlPK- )�D[���� � � [Content_Types].xmlPK- )�D[��' ' U _rels/.relsPK- )�D[ ��� W � xl/worksheets/sheet1.xmlPK- )�D[D�{� P � xl/_rels/workbook.xml.relsPK- )�D[Ѓc'2 E � xl/styles.xmlPK- )�D[�>ɺw / a xl/sharedStrings.xmlPK � &
application/vnd.ms-excel
Sample:
PK )�D[�X3� 5 xl/workbook.xml � (� ����0��&�C��H�FR8q���{��4П�5���H�yۙ��v�l��3����/]��lI��Pܟ�w�8�C��E����to:�<�.��ă4��z���ay��~ jZQ�K���!�4{J�}����.&"k���X��I!�T��c��{_�3F��qxм�r(nW�RJ��������PK )�D[���� � [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[C=��' ' _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="R0bae62cf1ef04637" /></Relationships>PK )�D[ ��� 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 )�D[�I�� P xl/_rels/workbook.xml.rels � (� ��An� E������8 ɦ�l�\ �`����ٺ�z��Tj��n�B���h�|�Xoߦ�!��;�iUcNy=�^�S6K�ݬ�0�\n$;�����9�!IY�d�| W:��I�Rƞ��������9�2���?Do̠�٫�.�&�>��d�!�%r=hU���{Κ�A�.L�9����nj)_FH�^��Lf�5Ն�G�1������K�e�s�y<S����\-���W5r�/6_PK )�D[Ѓ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 )�D[�>ɺ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- )�D[�X3� 5 xl/workbook.xmlPK- )�D[���� � [Content_Types].xmlPK- )�D[C=��' ' V _rels/.relsPK- )�D[ ��� W � xl/worksheets/sheet1.xmlPK- )�D[�I�� P � xl/_rels/workbook.xml.relsPK- )�D[Ѓc'2 E � xl/styles.xmlPK- )�D[�>ɺw / b xl/sharedStrings.xmlPK � '