Parse CSV file attachment from graph API into table

Queries and Resources
1

Hello! I have following issue:
I am making a Graph API call to get available SharePoint storage data from a tenant, which I then want to display in a table.

retool-graph

The API call is successful and returns a content-type: application/octet-stream with a CSV file attachment.

retool-output1
retool-output1594×617 33.2 KB

retool-output2
retool-output2594×617 32.2 KB

However, I can't seem to parse the attched CSV file.....

Problem solved: return Papa.parse(atob(data.base64Data),{header:true}).data

4

Hi @Servet!

Apologies for the confusion on parsing the CSV file, it sounds like you were able to get that figured out using the papa.parse() libbrary!

Just so that the solution is easier to read for any future users that come across this post, the solutions involves them using the following code snippet.

return Papa.parse(atob(data.base64Data),{header:true}).data