Strange Issue with 'Each' Loop in FTP Template

Avatar
Nuri Ensing
Celigo University Level 4: Legendary
Awesome Follow-up
Engaged

I'm running into a strange issue where an error keeps popping up, and I can't figure out why. It feels like it might be a bug. Here's a simplified version of the XML to show what I mean:


 


The preview works fine, but I keep seeing a 'data not found' error whenever it hits the 'each' loop in the template.




Hope someone can help me out here.

0

Comments

3 comments
Date Votes
  • Avatar
    Tyler Lamparter
    (Edited )
    Principal Product Manager
    Awesome Follow-up
    Engaged
    Top Contributor
    Answer Pro
    Celigo University Level 4: Legendary

    It's the validation for have an each loop specifically for the batch_of_records. As long as your page size is set to 1 and skip aggregation is set to true, then this will work. We're hoping to remove this validation in an upcoming release.

    <?xml version="1.0" encoding="UTF-8"?>
    <TEST>{{#each batch_of_records}}
     <ID>{{this.rows.0.id}}</ID>
     {{#each this.rows}}
     <LINE>{{this.line}}</LINE>
     {{/each}}
     {{/each}}
    </TEST>

    1
  • Avatar
    Nuri Ensing
    NetSuite Integration Whiz
    Celigo University Level 4: Legendary
    Awesome Follow-up
    Engaged

    Thanks, this works! I assume that after the release, the current handlebar template setup which is now in place will still function properly following the release update, correct?

    For anyone who encounters a similar situation, here are some screenshots to help fix it:

    1. In the Export, set the page size to 1.
    2. In the FTP transfer, set it to skip aggregation.

       
    0
  • Avatar
    Tyler Lamparter
    Principal Product Manager
    Awesome Follow-up
    Engaged
    Top Contributor
    Answer Pro
    Celigo University Level 4: Legendary

    Yeah existing templates would work as they are.

    0

Please sign in to leave a comment.

 

Didn't find what you were looking for?

New post