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 B�[E��&� 5 xl/workbook.xml � (� ����0��&�C��HT��x��})[i�?ik��-%�x�3;��T�qcg�H>jҾt5B�%c�����Ew�8!J�bFɱ5��P�gٍ9� H�� ��+�����bPӊR 5m�B���S�쓌�Vw1 [C�7U%�~�Ѡ��-�$9���gJ\)���g9� ��zɀӝ��*��n�PK B�[���� � [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 B�[fH��' ' _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="R87f7555657d94e7a" /></Relationships>PK B�[ ��� 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 B�[�/V� P xl/_rels/workbook.xml.rels � (� ��;n�0@�"p�%�E�,Y��� CQ�[2$�m�֡G�*�@� �d"�{x ����M�xag[�3�-9=خ�s4+�n�{1���siņ��G)�<a���6u��Ɣ�N�H'�XJ��/p�����!:c❣��6���ΟB�A�w[�)y y�� �t{2� :6�MU*$�nj!^F�^��B�Pͪ�US]��*�*ӣg�}���iY^��F<*My�Wee�������PK B�[Ѓ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 B�[�>ɺ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- B�[E��&� 5 xl/workbook.xmlPK- B�[���� � � [Content_Types].xmlPK- B�[fH��' ' T _rels/.relsPK- B�[ ��� W � xl/worksheets/sheet1.xmlPK- B�[�/V� P � xl/_rels/workbook.xml.relsPK- B�[Ѓc'2 E � xl/styles.xmlPK- B�[�>ɺw / _ xl/sharedStrings.xmlPK � $
application/vnd.ms-excel
Sample:
PK B�[�*��� 5 xl/workbook.xml � (� ����0D�J��(� EHE���k��&�&�$(IE?�R�n�����l��Z;���/]EeSɘ5�����]o���{1��J`c�[� ,K��9!(k�T�����B�%b��Ҡ��'B���p����^w1 �B�7�W�q�*b@cE@��ܻ����R��q�5ǢM1�\dq��g���PK B�[���� � [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 B�[_�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="Rcb61e965917545d8" /></Relationships>PK B�[ ��� 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 B�[f��j� P xl/_rels/workbook.xml.rels � (� ��Kn�0@�b;! ɦ�n�\`0F�Nۜ���W��J-���&�����4����ݿM#{!�kjI ����`�Ρ{X�~�=Ј!Nx=̞��k�!�ν�4�O�L&v:�&1u=�Q��'��i�ݒ�Lv�����AѣU�L��_�;yM���j�)y~ "�T`Om �Je+IE#H�T� ����e$����/dh-D��9��(�]e4:j����^:-���*�U�Y*S�^���_� PK B�[Ѓ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 B�[�>ɺ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- B�[�*��� 5 xl/workbook.xmlPK- B�[���� � � [Content_Types].xmlPK- B�[_�z�' ' U _rels/.relsPK- B�[ ��� W � xl/worksheets/sheet1.xmlPK- B�[f��j� P � xl/_rels/workbook.xml.relsPK- B�[Ѓc'2 E � xl/styles.xmlPK- B�[�>ɺw / b xl/sharedStrings.xmlPK � '