Recent searches


No recent searches

API Export of Tickets & Comments to CSV: Comment data unusable



Posted Nov 03, 2023

I am using a Python script that exports (to CSV) a set of tickets using the Search API (/v2/search.json). In my script, I'm also making a call to get all ticket comments and combine into a single field (/v2/tickets/{ticket_id}/comments.json. 

For the majority of the tickets/comments, everything exports as it should and all comments combine, but it looks like that if a ticket has a quite large amount of comments, when exported to CSV, it overflows to multiple lines below the ticket and makes the ticket data unusable. I've included a screenshot (with some content hidden) to give you an idea of what is happening. I have tried getting the comments by using 'body' & 'html_body', but it doesn't make a difference. 

Any thoughts on this? Is there a limitation in how many characters can be included in Excel and/or a CSV column? 


0

1

1 comment

I believe this issue may be caused by the fact that csv files have a limit of 32,767 characters per cell. When I get back to this project, I'm going to attempt to truncate my 'comments' field being exported to CSV.

0


Please sign in to leave a comment.

Didn't find what you're looking for?

New post