Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

JSON Scripting Issue - TWIG outputs does not match RAW data. #25

Open
kurtispsmith opened this issue Oct 18, 2021 · 0 comments
Open

JSON Scripting Issue - TWIG outputs does not match RAW data. #25

kurtispsmith opened this issue Oct 18, 2021 · 0 comments
Labels
bug Something isn't working
Milestone

Comments

@kurtispsmith
Copy link

I'm seeing several scenarios where the TWIG template is outputting the wrong values when I run campaigns.

In the example you can see the output data does not match the raw JSON data when you compare stocks #s.

SAMPLE:
image

CODE:

<!-- INVENTORY SNIPPETS --> 
{% TWIG_BLOCK %} 
    {% set items = lead.c_inventory_json | json_decode %}
    {% for item in items %}
<table width="100%" border="0" cellspacing="0" cellpadding="0" class="em_full_wrap" bgcolor="{contactfield=d_page_bgcolor}" style="table-layout:fixed;">
  <tr>
    <td align="center" valign="top"><table width="100%" border="0" cellspacing="0" cellpadding="0" class="em_full_wrap" bgcolor="{contactfield=d_page_bgcolor}" style=" table-layout:fixed;">
        <tr>
          <td align="center" valign="top"><table align="center" width="580" border="0" cellspacing="0" cellpadding="0" class="em_main_table" style="width:580px; table-layout:fixed; background-color: {contactfield=d_body_bgcolor};" data-section-wrapper="1">
              <tr>
                <td valign="top" align="center" data-section="1"><table width="580" border="0" cellspacing="0" cellpadding="0" align="center" style="width: 580px;" class="em_wrapper" data-slot-container="1">
                    <tbody>
                      <tr>
                        <td valign="top" align="center" style="padding: 0px 16px 16px 16px;" class="em_ptblr15"><div data-slot="text">
                            <table border="0" cellspacing="0" cellpadding="0" align="center" width="100%">
                              <tbody>
                                <tr>
                                  <td valign="top" align="center"><table border="0" cellspacing="0" cellpadding="0" align="left" width="267" style="width: 267px;" class="em_wrapper">
                                      <tbody>
                                        <tr>
                                          <td valign="top" align="center" class="em_full_img em_btn_butm"><a href="{{ item.VDP_URL }}" ses:tags="campaign:lead-accelerator-21d-new-inventory;content:explore-vehicle-cta;handraiser:yes;type:image" target="_blank" style="text-decoration: none;"><img src="{{ item.MainImage }}" width="267" alt="" style="display: block; border: 0px; max-width: 267px; color: #000000; font-size: 18px; line-height: 22px; font-family: Arial, sans-serif;" class="em_full_img" /></a></td>
                                        </tr>
                                      </tbody>
                                    </table>
                                    
                                    <!--[if gte mso 9]></td><td valign="top"><![endif]-->
                                    
                                    <table width="265" border="0" cellspacing="0" cellpadding="0" align="right" style="width: 265px;" class="em_wrapper">
                                      <tbody>
                                        <tr>
                                          <td height="35" style="height: 35px;" class="em_hide"></td>
                                        </tr>
                                        <tr>
                                          <td valign="top" align="center"><a ses:tags="campaign:lead-accelerator-21d-new-inventory;content:explore-vehicle-cta;handraiser:yes;type:button"  href="{{ item.VDP_URL }}?utm_source=3birds&utm_medium=email&utm_campaign={contactfield=c_customer_id}_leadaccelerator_21d_new_inventory" target="_blank" style="text-decoration: none;"> <span style="font-family: {contactfield=d_font_family}; color: {contactfield=d_body_color}; font-size: 16px; line-height: 17px;padding-bottom: 2px;"> {{ item.VehicleType }} {{ item.Year }} {{ item.Make }}</span><br>
                                            <span style="font-family: {contactfield=d_font_family}; color: {contactfield=d_body_color}; font-size: 25px; line-height: 17px;padding-bottom: 5px;"> {{ item.Model }}  {{ item.Trim1 }}</span></a></td>
                                        </tr>
                                        <tr>
                                          <td valign="top" align="center" style="font-family: {contactfield=d_font_family}; color: {contactfield=d_body_color}; font-size: 13px; line-height: 17px;padding-bottom: 19px;"> {{ item.Mileage }} miles<br />
                                            Stock #: {{ item.StockNumber }}<br /></td>
                                        </tr>
                                        <tr>
                                          <td valign="top" align="center"><table width="261" style="width: 261px;" border="0" cellspacing="4" cellpadding="0" align="center" class="em_wrapper">
                                              <tbody>
                                                <tr>
                                                  <td valign="middle" align="center" height="36" bgcolor="{contactfield=d_btn_bgcolor}" style="height: 36px; font-family: {contactfield=d_font_family}; color: {contactfield=d_btn_color}; font-size: 12px; font-weight: bold; border-radius: {contactfield=d_btn_radius}px;"><a ses:tags="campaign:lead-accelerator-21d-new-inventory;content:explore-vehicle-cta;handraiser:yes;type:button"  href="{{ item.VDP_URL }}?utm_source=3birds&utm_medium=email&utm_campaign={contactfield=c_customer_id}_leadaccelerator_21d_new_inventory" target="_blank" style="text-decoration: none; color: {contactfield=d_btn_color}; line-height: 36px; display: block;">GET TODAY'S PRICE</a></td>
                                                </tr>
                                              </tbody>
                                            </table></td>
                                        </tr>
                                      </tbody>
                                    </table></td>
                                </tr>
                              </tbody>
                            </table>
                          </div></td>
                      </tr>
                    </tbody>
                  </table></td>
              </tr>
            </table></td>
        </tr>
      </table></td>
  </tr>
</table>
{% endfor %}
{% END_TWIG_BLOCK %} 
<!-- END INVENTORY SNIPPET --> 

JSON:

[ { "Vin": "WA1GAAFYXN2020549", "StockNumber": "125232", "Make": "Audi", "Model": "Q5", "Trim1": "S line Premium", "BodyStyle": "SUV", "Year": 2022, "VehicleType": "New", "IsCertified": false, "Mileage": 10, "VDP_URL": "http://www.jackdanielsparamusaudi.com/catcher.esl?vehicleId=3bbafeb80a0e09a863ce5adb3236638f", "DateInStock": "2021-10-09", "MSRP": 0, "DateCreated": "2021-10-09", "InternetPrice": 0, "MainImage": "https://content.homenetiol.com/640x480/9d93fecf64c543749930a746798da91e.jpg", "StockImage": "https://content.homenetiol.com/stock_images/5/2022AUS02_640/2022AUS020001_640_01.jpg" }, { "Vin": "WA1GAAFY0N2019569", "StockNumber": "125233", "Make": "Audi", "Model": "Q5", "Trim1": "S line Premium", "BodyStyle": "SUV", "Year": 2022, "VehicleType": "New", "IsCertified": false, "Mileage": 10, "VDP_URL": "http://www.jackdanielsparamusaudi.com/catcher.esl?vehicleId=3bbafd0f0a0e09a97fb17999bd212a47", "DateInStock": "2021-10-09", "MSRP": 0, "DateCreated": "2021-10-09", "InternetPrice": 0, "MainImage": "https://content.homenetiol.com/640x480/1365fd683f3444bebf81e68861881a1c.jpg", "StockImage": "https://content.homenetiol.com/stock_images/5/2022AUS02_640/2022AUS020001_640_01.jpg" }, { "Vin": "WA1EAAFY7N2020161", "StockNumber": "125234", "Make": "Audi", "Model": "Q5", "Trim1": "S line Premium Plus", "BodyStyle": "SUV", "Year": 2022, "VehicleType": "New", "IsCertified": false, "Mileage": 10, "VDP_URL": "http://www.jackdanielsparamusaudi.com/catcher.esl?vehicleId=3bbafc8a0a0e09a97fb17999835188e2", "DateInStock": "2021-10-09", "MSRP": 0, "DateCreated": "2021-10-09", "InternetPrice": 0, "MainImage": "https://content.homenetiol.com/640x480/d5dabe9bf25f442792ad52540cb4ca20.jpg", "StockImage": "https://content.homenetiol.com/stock_images/5/2022AUS02_640/2022AUS020001_640_01.jpg" }, { "Vin": "WA1EAAFY2N2019550", "StockNumber": "125236", "Make": "Audi", "Model": "Q5", "Trim1": "S line Premium Plus", "BodyStyle": "SUV", "Year": 2022, "VehicleType": "New", "IsCertified": false, "Mileage": 10, "VDP_URL": "http://www.jackdanielsparamusaudi.com/catcher.esl?vehicleId=3bbafaee0a0e09a97fb17999f2f624fc", "DateInStock": "2021-10-09", "MSRP": 0, "DateCreated": "2021-10-09", "InternetPrice": 0, "MainImage": "https://content.homenetiol.com/640x480/0e12d14246a14377ae4a8f7858c03d05.jpg", "StockImage": "https://content.homenetiol.com/stock_images/5/2022AUS02_640/2022AUS020001_640_01.jpg" }, { "Vin": "WA1EAAFY5N2019560", "StockNumber": "125235", "Make": "Audi", "Model": "Q5", "Trim1": "S line Premium Plus", "BodyStyle": "SUV", "Year": 2022, "VehicleType": "New", "IsCertified": false, "Mileage": 11, "VDP_URL": "http://www.jackdanielsparamusaudi.com/catcher.esl?vehicleId=3bbafbcd0a0e09a97fb179992e604df1", "DateInStock": "2021-10-09", "MSRP": 0, "DateCreated": "2021-10-09", "InternetPrice": 0, "MainImage": "https://content.homenetiol.com/640x480/bd4820362b2f4c9184d22d6ebbb94af9.jpg", "StockImage": "https://content.homenetiol.com/stock_images/5/2022AUS02_640/2022AUS020001_640_01.jpg" }, { "Vin": "WA1EAAFY0N2019465", "StockNumber": "125238", "Make": "Audi", "Model": "Q5", "Trim1": "S line Premium Plus", "BodyStyle": "SUV", "Year": 2022, "VehicleType": "New", "IsCertified": false, "Mileage": 11, "VDP_URL": "http://www.jackdanielsparamusaudi.com/catcher.esl?vehicleId=3bbaf9030a0e097120e50d484db79fd4", "DateInStock": "2021-10-09", "MSRP": 0, "DateCreated": "2021-10-09", "InternetPrice": 0, "MainImage": "https://content.homenetiol.com/640x480/fe2abb1b45504cf0b81de4ae002fc323.jpg", "StockImage": "https://content.homenetiol.com/stock_images/5/2022AUS02_640/2022AUS020001_640_01.jpg" }, { "Vin": "WA1EAAFY1N2020110", "StockNumber": "125237", "Make": "Audi", "Model": "Q5", "Trim1": "S line Premium Plus", "BodyStyle": "SUV", "Year": 2022, "VehicleType": "New", "IsCertified": false, "Mileage": 11, "VDP_URL": "http://www.jackdanielsparamusaudi.com/catcher.esl?vehicleId=3bbaf9d40a0e09a97fb1799903d738dd", "DateInStock": "2021-10-09", "MSRP": 0, "DateCreated": "2021-10-09", "InternetPrice": 0, "MainImage": "https://content.homenetiol.com/640x480/038fb403ed0a4e9e840686330eea57c5.jpg", "StockImage": "https://content.homenetiol.com/stock_images/5/2022AUS02_640/2022AUS020001_640_01.jpg" }, { "Vin": "WA1BAAFY6M2071281", "StockNumber": "124551", "Make": "Audi", "Model": "Q5", "Trim1": "Premium Plus", "BodyStyle": "SUV", "Year": 2021, "VehicleType": "New", "IsCertified": false, "Mileage": 10, "VDP_URL": "http://www.jackdanielsparamusaudi.com/catcher.esl?vehicleId=2112a0f00a0e0a173e8f42ae818f0bb7", "DateInStock": "2021-04-02", "MSRP": 0, "DateCreated": "2021-09-30", "InternetPrice": 0, "MainImage": "https://content.homenetiol.com/640x480/9e052de1c6d34daaab9447fbe6cfef16.jpg", "StockImage": "https://content.homenetiol.com/stock_images/5/2021AUS02_640/2021AUS020001_640_01.jpg" }, { "Vin": "WA1BAAFY5M2136783", "StockNumber": "125085", "Make": "Audi", "Model": "Q5", "Trim1": "Premium Plus", "BodyStyle": "SUV", "Year": 2021, "VehicleType": "New", "IsCertified": false, "Mileage": 10, "VDP_URL": "http://www.jackdanielsparamusaudi.com/catcher.esl?vehicleId=f73d23280a0e09b1110b8372a5c9f31b", "DateInStock": "2021-08-13", "MSRP": 0, "DateCreated": "2021-09-30", "InternetPrice": 0, "MainImage": "https://content.homenetiol.com/640x480/406c5f03fc5b4c0ba41f35a92e27a3fb.jpg", "StockImage": "https://content.homenetiol.com/stock_images/5/2021AUS02_640/2021AUS020001_640_01.jpg" }, { "Vin": "WA1BAAFY5M2031466", "StockNumber": "S124170", "Make": "Audi", "Model": "Q5", "Trim1": "Premium Plus", "BodyStyle": "SUV", "Year": 2021, "VehicleType": "New", "IsCertified": false, "Mileage": 45, "VDP_URL": "http://www.jackdanielsparamusaudi.com/catcher.esl?vehicleId=783855c20a0e0adf6a6e7a177787ba53", "DateInStock": "2020-12-18", "MSRP": 0, "DateCreated": "2021-09-30", "InternetPrice": 0, "MainImage": "https://content.homenetiol.com/640x480/186be7fe66c741e9ba9d9026127c0c83.jpg", "StockImage": "https://content.homenetiol.com/stock_images/5/2021AUS02_640/2021AUS020001_640_01.jpg" } ]

NOTE: IF I SEND THE SAME TEMPLATE TO THE SAME CONTACT USING THE "CONTACT > SEND EMAIL" FEATURE, IT WORKS JUST FINE. HOWEVER, WHEN I'M RUNNING BATCH CAMPAIGNS IT DOES NOT WORK. IT APPEARS THERE IS A STATE ISSUE WHERE THE SCOPE OF THE OBJECT IS NOT BEING RESET PER RECIPIENT.

@MarketSmart MarketSmart added the bug Something isn't working label Jul 11, 2022
@MarketSmart MarketSmart added this to the 2.0 milestone Jul 12, 2022
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
bug Something isn't working
Projects
None yet
Development

No branches or pull requests

2 participants