JIRA Api - Different Syntax Format

Question

Hello.  I am accessing Jira via the API with our ETL Tool.  When I connect and pull down fields it puts it into a format that I have never seen.  I have pasted a snippet of the 'field' names below.  Does anyone know happen to know what format or syntax the field names are in and how I can try and find a list.

I am running into an issue when I try and pull down the 'subtasks' field and write to a table to see what fields are underneath.  This is the error:

Database error occurred: CREATE TABLE failed because column 'subtasks[46].fields.Title' in table 'tran_test' exceeds the maximum of 1024 columns.

Linked_Issues[2].type.idLinked_Issues[2].type.inwardLinked_Issues[2].type.nameLinked_Issues[2].type.outwardLinked_Issues[2].type.selfreporter.activereporter.avatarUrls.16x16reporter.avatarUrls.24x24reporter.avatarUrls.32x32reporter.avatarUrls.48x48

Michael Tran_0ztmyo · Answer

Sorry I'll try and provide more context.  I am using a an ETL tool called Rapidminer to acess the JIRA Api.  I've pasted a screenshot of the 'query' operator.

I then have to use another 'operator(function)' to convert it from 'JSON' to a format that I can work with.  From there I do other adjustments to the data but those 'field' names already come through like the photo I posted initially.

Nic Brough -Adaptavist- · Answer

Ok, so we are going to need a lot more info about "I am accessing Jira via the API with our ETL Tool"

Everything you have written after that point appears to be what this tool is doing.  Some of the bits are definitely Jira data, but it is all as the tool is interpreting it.  We can't really help you here - we have less information about what your tool is doing with the Jira data than you do!