Skip to main content
Developer Communities Admin
Community Manager
September 15, 2026

I was working on an HR export that includes a header, data, and a footer.

  • September 15, 2026
  • 3 replies
  • 3 views

Originally posted by Aman Gaur on December 15, 2025 at 12:15 AM.

 

Hi everyone,

I was working on an HR export that includes a header, data, and a footer. I initially tried building it using Integration Studio. Although I defined a single header, a data array, and a footer, the header and footer are repeating for every data record, and I’m not sure why this is happening.

Since that approach didn’t work, I created the same export using XML/XSLT. However, in the client environment it fails with the error “Input string was not in the correct format”, while the exact same file works fine in a different environment.

I’ve also tried simplifying the file to include only a single text field, but I’m still encountering the same issue.

Any suggestions or pointers would be appreciated.

Thanks.

Is this conversation helpful so far?

 

    3 replies

    Developer Communities Admin
    Community Manager
    September 15, 2026

    Originally replied by Steve Bryson on Dec 15, 2025, 9:33 AM.

     

    Hi Aman,

    I believe in order for your header and footers to work correctly in Integration Studio, you need to select the output type “Segmented Character-Separated Values/Delimited Text File”.
    Developer Communities Admin
    Community Manager
    September 15, 2026

    Originally replied by Steve Bryson on Dec 15, 2025, 9:53 AM.

     

    You need the Segmented version of that.

     

    Developer Communities Admin
    Community Manager
    September 15, 2026

    Originally replied by Aman Gaur on Dec 15, 2025, 10:10 AM.

     

    Thank you, Steve! It worked; you are genius.