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 GenericImportMappingConfiguration
NameDescriptionTypeAdditional 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�5xl/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"���Pxl/_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'2E
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�5xl/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'2E
�xl/styles.xmlPK-�0�Z�>ɺw/b	xl/sharedStrings.xmlPK�'

application/vnd.ms-excel

Sample:
PK�0�ZM�Bk�5xl/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=�Pxl/_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'2E
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�5xl/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'2E
�xl/styles.xmlPK-�0�Z�>ɺw/b	xl/sharedStrings.xmlPK�'