Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

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

Darryl Dillman
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
May 31, 2019

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'}]}"

1 answer

0 votes
Andy Heinzer
Atlassian Team
Atlassian Team members are employees working across the company in a wide variety of roles.
June 10, 2019

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

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events