Have you tried making the request in Postman? I just had this problem awhile ago, I ended up writing the response into a text file and uploading into Excel. Also I generated the token separately then did a http request through the Utility - HTTP.
Not quite yet Devendran, but thanks for following up.
Updated for all:
TO FIX THIS, ADD SHOW EXCEL ACTION.------------------------------Melissa MichielsenJunior Automation DeveloperTransAlta------------------------------