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 �0�Zx�0B� 5 xl/workbook.xml � (� ����0D�&�C��B�N\�z��bhK��|o�vfg����kcz�Q�v�-��~�s�@�dF�a���i_�t�l�2�[��,>�Sfq /�vB����Xn���^ +J�Դ<�s����-2[��$l ��_`�Ţ����%�soQbs�Gi�Dm�L���������PK �0�Z���� � [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 �0�Z7 �b' ' _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="R2795427efd5a4b99" /></Relationships>PK �0�Z ��� 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 �0�Zc"��� P xl/_rels/workbook.xml.rels � (� ��KN�0@�b͞8 n⢦ݰa[z��Q۲]�gc���V� �X��j4��'�|�lvo�D^0������V:5ڡ�S�wv��'��D4��$��I�?P��Y��y���]�E�i��(�uY64,p�$�����֣�G'O3�����p�19�0`���%TE�yR�+Ѵ�Ruݯ��| ��L-�����;_���E/[��{yS#���N��BM�\3�x��b��5z��/PK �0�ZЃ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 �0�Z�>ɺ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- �0�Zx�0B� 5 xl/workbook.xmlPK- �0�Z���� � [Content_Types].xmlPK- �0�Z7 �b' ' V _rels/.relsPK- �0�Z ��� W � xl/worksheets/sheet1.xmlPK- �0�Zc"��� P � xl/_rels/workbook.xml.relsPK- �0�ZЃc'2 E � xl/styles.xmlPK- �0�Z�>ɺw / b xl/sharedStrings.xmlPK � '
application/vnd.ms-excel
Sample:
PK �0�ZM�Bk� 5 xl/workbook.xml � (� ����0D�&�C����� '.^=x_�" �%m ~��o�vfg�N1k34Z�#GesS�)g��%ؓ�P�]���y1�u�c��[�r�E)38�Z�^L���Xv2���W��hu<R,͞g�7���I�b��"������%��%���%=Sbr�G�%1d)﮷8nyCw�+����PK �0�Z���� � [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 �0�Zƴ<�' ' _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="Rb64b21f3cf474824" /></Relationships>PK �0�Z ��� 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 �0�Z�|f=� P xl/_rels/workbook.xml.rels � (� ��KN�0@�b͞�I���ݰa[zמ�Q;�]�gc���V� �X��j4��'�|���o�H^0���ʂA��\��)uw l7��*�h�9���b6���Ҩ-N*~F�;��J9 =��>�i�XMÒ�L�?����A�ק ]�L_}8F����U�1��S���"S�<�vB �d���=�F�Л��t1�z}�K#�`��)���Me� h�Sȗ^:-�5\ f��%/���ѫ��|PK �0�ZЃ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 �0�Z�>ɺ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- �0�ZM�Bk� 5 xl/workbook.xmlPK- �0�Z���� � [Content_Types].xmlPK- �0�Zƴ<�' ' V _rels/.relsPK- �0�Z ��� W � xl/worksheets/sheet1.xmlPK- �0�Z�|f=� P � xl/_rels/workbook.xml.relsPK- �0�ZЃc'2 E � xl/styles.xmlPK- �0�Z�>ɺw / b xl/sharedStrings.xmlPK � '