I reached the character limits. Now what?

[Jeremy Wood]

Our company is using Jira to track product development lifecycle. One of the steps is for a product to go through a set of tests on specified testing hardware. We have been able to create a script that writes the json output of these test results to a jira custom field, This is great because we can then connect PowerBi to read this same custom field and are able to create report graphs that show us the test data throughout the duration of the test. 

The problem we are running into is when we run larger or longer tests, the json output is  longer then the Jira character limit allows for. I understand with Cloud this limit is due to Atlassian's backend database and cannot be increased natively.

Is there any marketplace apps, or something similar out there that provides a custom field substitute that can be written to with a larger character limit? 

[Trudy Claspill]

Hello @Jeremy Wood 

Gemini suggested the following apps:

https://marketplace.atlassian.com/apps/1233647/rich-text-editor-for-jira

https://marketplace.atlassian.com/apps/1228720/awesome-custom-fields-custom-fields-for-jira-jsm

https://marketplace.atlassian.com/apps/1214558/markdown-rich-text-editor-for-jira-with-latex-mermaid-uml?hosting=server&tab=overview

I have not reviewed the details of each app to confirm they can actually meet your requirement. And I have not used any of these apps before.

[Sam]

Hi there,

You've run into Jira Cloud's character limit on custom fields. It constraint can block you from storing detailed data like large JSON test results.

I'm with the Table Grid Next Generation team. Our app, specifically its Grid Custom Field, is designed for structured, often large data within Jira issues. It works like an embedded spreadsheet, where the grid data itself has no inherent size limitation.

Table Grid Next Generation lets you store your large JSON test results within a Grid Custom Field and continue PowerBI reporting. You can use a Textarea column within the Grid Custom Field. While native Jira fields have strict character limits, a Textarea column can be configured to support a large number of characters, allowing you to store complete JSON for even your biggest test runs.

Your script can push JSON data into the grid using our REST API. You'll just need to adjust your script's API endpoint and payload.

Once your data is in a Grid Custom Field, your script can read the JSON data back via our REST API and send it to tools like PowerBI for reporting. For structure, you can either:

- Store the full raw JSON in a single Textarea column. Your script then parses this data for PowerBI.

- Create separate columns for specific JSON fields (e.g., test status, metric values) to simplify PowerBI preparation.

With a Grid Custom Field, your test data remains in Jira, accessible to your scripts and reporting tools, and you can store large JSON payloads without hitting native Jira's character limits.

If you'd like to discuss how to best configure the grid for your specific JSON structure or integrate it with your script, feel free to reach out to us at our support portal: https://tablegrid.atlassian.net/servicedesk/customer/portal/1