I am exporting issues through the API with python and encounter strange data with description field

Darryl Dillman

When I export the description field using python and csv I get a bunch of data I would not expect.

 

"{'version': 1, 'type': 'doc', 'content': [{'content': [{'text': 'PLATFORM: MySQL', 'type': 'text'}, {'type': 'hardBreak'}, {'text': 'USER: access.test', 'type': 'text'}, {'type': 'hardBreak'}, {'text': 'ENDPOINT: test-aurora-edt-c1-0.cpdk4xuooxvm.us-east-1.rds.amazonaws.com', 'type': 'text'}, {'type': 'hardBreak'}, {'text': 'DATABASE: access_automation', 'type': 'text'}, {'type': 'hardBreak'}, {'text': 'SCHEMA: access_automation', 'type': 'text'}, {'type': 'hardBreak'}, {'text': 'ACCESS: RO', 'type': 'text'}, {'type': 'hardBreak'}, {'text': 'BUCKET NAME:', 'type': 'text'}, {'type': 'hardBreak'}, {'text': 'REQUEST ID: auto generate', 'type': 'text'}, {'type': 'hardBreak'}, {'text': 'REQUEST DATE: 03/27/2019', 'type': 'text'}, {'type': 'hardBreak'}, {'text': 'REQUESTOR: janet delage', 'type': 'text'}, {'type': 'hardBreak'}, {'text': 'REQUEST TICKET: OPS-4700: Access Automation - TEST TICKET TO DO', 'type': 'text'}], 'type': 'paragraph'}]}"

Andy Heinzer

Hi Darryl,

I see you are exporting some data from Jira Cloud and there appears to be some confusion over the formatting of the description field.  

This specific formatting is known as the Atlassian Document Format, more details in https://developer.atlassian.com/cloud/jira/platform/apis/document/structure/.  This document format is expected to be in a json format like you see here.  Jira Cloud has started to implement a different text editor on some Jira Cloud sites.  As such this editor doesn't utilize the same previous wiki-markup that the previous editor did to handle description formatting.

I can't speak to the content you see there, but I suspect the confusion is regarding the layout of this data (json vs wiki markup).  If so, then I hope that the documentation link above will help to clarify.   If I have misunderstood the confusion here could you please help to clarify what you expected to see in this example?

Thanks

Andy