CSV Import Error: Parameter Values Exceeding 100 Characters in Jira

[VENUGOPAL KAMAKKAGARI]

Hello Community,

I'm encountering an issue while attempting to import a CSV file converted from an Excel file into Jira. The Excel file contains information about test cases, including details such as testcase name, request, response, etc.

After converting the Excel file to CSV, each time I try to import the CSV file using the CSV import functionality in Jira, I encounter the following error:

"The CSV file contains parameter values with more than 100 characters."

This error prevents the import process from completing successfully. Upon reviewing the CSV file, it seems that some parameter values, such as  request exceed the 100-character limit imposed by the Jira API.

I'm using the following endpoint for the import process:

$JIRA_BASE_URL/rest/raven/2.0/api/dataset/import?issueId=$ISSUE_ID&testIssueKey=$ISSUE_KEY

I need assistance in understanding how to handle this error and successfully import the CSV file into Jira, even if some parameter values exceed the 100-character limit.

Has anyone else encountered a similar issue when importing CSV files converted from Excel into Jira for test case management? Are there any workarounds or approaches I can try to resolve this error?

Any insights or suggestions would be greatly appreciated.

Thank you!

[Marc - Devoteam]

Hi @VENUGOPAL KAMAKKAGARI 

Welcome to the community.

You do mention Cloud on the tags, but hte URL is DC related

Are you on DC or Cloud, as the URL you are mentioning is for to make the API call is DC related and not Cloud.

Cloud has a specific URL endpoint for the Xray API And the Cloud API has no dataset import option

See API cloud doc's on Xray; https://docs.getxray.app/display/XRAYCLOUD/REST+API 

[Marc - Devoteam]

If you are on DC, see default limit is a 100 char.

See, The maximum number of characters a parameter value can have. The default value is 100, the minimum is 64 and the maximum is 255 characters.