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.

Dhivya_Aroma1's avatar
Dhivya_Aroma1
New Contributor III
6 years ago

Thanks Christwr. It worked.
I can read the csv successfully with Response Entity Type = TEXT.
And now I do not get any error for xlsx file with the Response Entity Type = BINARY. But I am unable to parse it.
Can you please help me by suggesting the downstream snap to read the xlsx.
And the response I received is
“statusLine”:{

“protoVersion”:

“HTTP/1.1”

“statusCode”:

200

“reasonPhrase”:

“OK”

}

“entity”:

“Base64 encoded data”

“headers”:{

“vary”:

“Accept-Encoding,User-Agent”

“strict-transport-security”:

“max-age=31536000; includeSubDomains”

“connection”:

“Keep-Alive”

“set-cookie”:

“JSESSIONID=F1364F716045134FD84398E72019F2CA; Path=/; HttpOnly;Secure;HttpOnly”

“transfer-encoding”:

“chunked”

“content-type”:

“application/octet-stream”

“server”:

“Apache-Coyote/1.1”

“date”:

“Tue, 28 Jan 2020 11:54:02 GMT”

“keep-alive”:

“timeout=10, max=100”

}