Data fields are offset when retrieving data in Chunks via API

Options
AW25
AW25 Member, ALL USERS, GroupMember, Community Member Posts: 4 Occasional Contributor
in Extensibility

I'm retrieving a large export via the API and because of the size of the file, Anaplan breaks up the export into multiple chunks. The issue is the column structure in the first and last record of each chunk isn't consistent. For example, in the attached image, the first chunk ended on the first row mid-way through the Version field and continued in the first row of the following chunk. Since a chunk can cut off at any point in the row, I don't see any practical way of piecing the data back together. Is there any workaround for this?

 

AW25_0-1581630440085.png

 

Tagged:

Comments

  • AW25
    AW25 Member, ALL USERS, GroupMember, Community Member Posts: 4 Occasional Contributor

    Hi @JaredDolich,

     

    Thanks for the reply. I'm using the method outlined here in the API v2 documentation. I've attempted to get the data via Alteryx and Postman and had the same issue with both.

     

    There aren't any special characters in this dataset. This break actually happens in the middle of number strings as well. The documentation says that the chunk size for Exports is set to 10MB but I couldn't find any information on changing that.

Categories