twigfiddle.com - Fiddle vsvty1 v1 - Created on March 26, 2024 12:30

File

{% set emailObject = {
    "CreationDate": null,
    "Notes": "",
    "Subject": "new subject",
    "idList": 1,
    "idMessage": 1,
    "Content": "new content",
    "Fields": [
        {"Description": "FirstName", "Id": 1, "Value": "11"},
        {"Description": "LastName", "Id": 2, "Value": "222"},
        {"Description": "Company", "Id": 3, "Value": "333"},
        {"Description": "City", "Id": 4, "Value": ""},
        {"Description": "Province", "Id": 5, "Value": ""},
        {"Description": "ZIP", "Id": 6, "Value": ""},
        {"Description": "State", "Id": 7, "Value": ""},
        {"Description": "Region", "Id": 8, "Value": ""},
        {"Description": "Address", "Id": 9, "Value": ""},
        {"Description": "Gender ", "Id": 10, "Value": ""},
        {"Description": "phone", "Id": 11, "Value": ""},
        {"Description": "CustomerID", "Id": 12, "Value": ""},
        {"Description": "LatestOrderID", "Id": 13, "Value": ""},
        {"Description": "LatestOrderDate", "Id": 14, "Value": ""},
        {"Description": "LatestOrderAmount", "Id": 15, "Value": ""},
        {"Description": "LatestOrderProductIDs", "Id": 16, "Value": ""},
        {"Description": "LatestOrderCategoryIDs", "Id": 17, "Value": ""},
        {"Description": "LatestShippedOrderDate", "Id": 18, "Value": ""},
        {"Description": "LatestShippedOrderID", "Id": 19, "Value": ""},
        {"Description": "LatestAbandonedCartDate", "Id": 20, "Value": ""},
        {"Description": "LatestAbandonedCartTotal", "Id": 21, "Value": ""},
        {"Description": "LatestAbandonedCartID", "Id": 22, "Value": ""},
        {"Description": "TotalOrdered", "Id": 23, "Value": ""},
        {"Description": "TotalOrderedLast12m", "Id": 24, "Value": ""},
        {"Description": "TotalOrderedLast30d", "Id": 25, "Value": ""},
        {"Description": "AllOrderedProductIDs", "Id": 26, "Value": ""},
        {"Description": "Birthday", "Id": 27, "Value": ""}
    ],
    "Structure": null,
    "Tags": [],
    "UseDynamicField": false,
    "Embed": false,
    "IsConfirmation": false,
    "PreHeader": null,
    "TrackingInfo": {"CustomParams": "", "Enabled": true, "Protocols": [""]},
    "Attachments": []
} %}

{% set transformedFields = {} %}
{% for index, field_value in requestBody.data.fields %}
    {% if index == 0 %}
    {{continue}}
    {% else %}
    
    {% set fieldId = index + 1 %}
    {% set fieldValue = field_value %}
    
    {% if field_value == "" or field_value == null %}
        {% for field in emailObject.Fields %}
            {% if field.Id == fieldId %}
                {% set fieldValue = field.Value %}
            {% endif %}
        {% endfor %}
    {% endif %}
    
    {% set transformedFields = transformedFields | merge({ (fieldId): fieldValue }) %}
    {% endif %}
{% endfor %}

{
  "Subject": "{{ requestBody.data.subject is defined ? requestBody.data.subject : emailObject.Subject }}",
  "Content": "{{ requestBody.data.content is defined and requestBody.data.content != '' ? requestBody.data.content : emailObject.Content }}",
  "Notes": "{{ requestBody.data.notes is defined ? requestBody.data.notes : emailObject.Notes }}",
  "PreHeader": "{{ requestBody.data.preheader is defined and requestBody.data.preheader != '' ? requestBody.data.preheader : emailObject.PreHeader }}",
  "Fields": [
    {% for key, value in transformedFields %}
    {
      "Id": "{{ key }}",
      "Value": "{{ value }}"
    }{% if not loop.last %},{% endif %}
    {% endfor %}
  ],"Embed": false,
    "IsConfirmation": false,
    "TrackingInfo": {
        "CustomParams": "",
        "Enabled": true,
        "Protocols": []
    }
}

Format

{
    "requestBody": {
        "data": {
            "fields": [
                null,
                "",
                "",
                "kj",
                "kj",
                "vk",
                "jv",
                "kjv",
                "kjv",
                "123",
                "vkj",
                "v",
                "kjv",
                "kjv",
                "jk",
                "vk",
                "v",
                "kjv",
                "kjv",
                "kj",
                "vkj",
                "v",
                "kjv",
                "kj",
                "vkj",
                "vk",
                "jv",
                "kj"
            ],
            "select_list": "1",
            "select_email": "2",
            "subject": "new subject",
            "content": "new content",
            "notes": "kjk",
            "preheader": "jkjg"
        },
        "template_name": "dummy name",
        "template_branding_app_name": "dummy name"
    }
}