Forum Discussion

Dhivya_Aroma1's avatar
Dhivya_Aroma1
New Contributor III
6 years ago
Solved

Error while getting the xlsx or csv file from Anaplan platform using REST Get Snap

Team, I can connect to Anaplan api using REST Get and Post Snap to export the file. Finally after the export when I am trying to download the csv / xlsx file I am getting the parsing error. Kin...
  • christwr's avatar
    christwr
    6 years ago

    If the data you’re receiving in the response isn’t JSON, then you don’t want to have “DEFAULT” selected as the response type on the REST snap. You probably want to select “BINARY” (if XLSX) and then treat your data as such in the downstream snaps.

christwr's avatar
christwr
Contributor III
6 years ago
Copy Link

Even though you can specify that you’re receiving BINARY data, I don’t believe the REST GET snap supports defining the output view as BINARY (triangle shape), which would make it easier.

I have a similar process on my end, and I have to add a Mapper and DocumentToBinary snap like below to get the data into a usable structure.

Then, you can use a CsvParser or ExcelParser snap, depending on your data.