This issue was simply a documentation inconsistency. The documentation has now been updated. "state" should be "FUTURE", "ACTIVE" or "CLOSED".

      Issue Summary

      Jira ignore the Sprint state in JSON file even though it has been set to "Complete"

      Steps to Reproduce

      • Follow the steps as outlined here Importing data from JSON
      • Set the state of the sprint to "Complete" and make sure there is no existing Sprint with the same name.
                  "priority" : "High",
                  "description" : "Test JSON import",
                  "status" : "DONE",
                  "reporter" : "abcde-12345-fedcba",
                  "issueType" : "Bug",
                  "summary" : "Test JSON import",
                  "customFieldValues": [
                    {
                      "fieldName": "Sprint",
                      "fieldType": "com.pyxis.greenhopper.jira:gh-sprint",
                      "value": [
                        {
                          "rapidViewId": 11,
                          "state": "Complete",
                          "name": "SEK Sprint 123"
        
      • Import the json file using the External system import

      Expected Results

      Sprint is imported as "Complete Sprint" and not showing in backlog

      Actual Results

      Sprint is imported as "Future Sprint" and visible in backlog

      Workaround

      No workaround at this moment

            [JSWCLOUD-18538] Jira ignores the Sprint state in JSON import

            I'm still having problems with this.

             

            Error returned from import...

            Cannot add value [ [\{rapidViewId=12, state=CLOSED, name=Big New Sprint, startDate=2018-01-01, endDate=2018-01-01, completeDate=2018-01-01}] ] to CustomField Sprint in Issue with summary 'Test JSON import': null

             

            any ideas?

            Nigel Budd (CV) added a comment - I'm still having problems with this.   Error returned from import... Cannot add value [ [\{rapidViewId=12, state=CLOSED, name=Big New Sprint, startDate=2018-01-01, endDate=2018-01-01, completeDate=2018-01-01}] ] to CustomField Sprint in Issue with summary 'Test JSON import': null   any ideas?

            Closed as this was a documentation problem and the documentation has been updated at: https://confluence.atlassian.com/adminjiracloud/importing-data-from-json-776636779.html/

            Pedro Tacla Yamada added a comment - Closed as this was a documentation problem and the documentation has been updated at:  https://confluence.atlassian.com/adminjiracloud/importing-data-from-json-776636779.html/

            Hello, this was a documentation issue.

            The valid values for sprint state field in the JSON import are:

            • "CLOSED"
            • "ACTIVE"
            • "FUTURE"

            When a sprint is "CLOSED" or "ACTIVE" it's also required that they have:

            • "startDate" - When this sprint started
            • "endDate" - When this sprint was planned to end

            And "CLOSED" sprints also should provide:

            • "completeDate" - When this sprint actually ended

            An example JSON is this:

            {
              "projects": [
                {
                  "name": "Project",
                  "key": "KEY",
                  "type": "software",
                  "issues": [
                    {
                      "externalId": "1",
                      "priority": "High",
                      "description": "Sample 1",
                      "reporter": "abcde-12345-fedcba",
                      "issueType": "Bug",
                      "summary": "Sample 1",
                      "customFieldValues": [
                        {
                          "fieldName": "Sprint",
                          "fieldType": "com.pyxis.greenhopper.jira:gh-sprint",
                          "value": [
                            {
                              "rapidViewId": 1,
                              "name": "Future sprint"
                            }
                          ]
                        }
                      ]
                    },
                    {
                      "externalId": "2",
                      "priority": "High",
                      "description": "Sample 2",
                      "reporter": "abcde-12345-fedcba",
                      "issueType": "Bug",
                      "summary": "Sample 2",
                      "customFieldValues": [
                        {
                          "fieldName": "Sprint",
                          "fieldType": "com.pyxis.greenhopper.jira:gh-sprint",
                          "value": [
                            {
                              "rapidViewId": 2,
                              "startDate": "2018-01-01",
                              "endDate": "2018-01-10",
                              "completeDate": "2018-01-10",
                              "state": "CLOSED",
                              "name": "Closed Sprint"
                            }
                          ]
                        }
                      ]
                    }
                  ]
                }
              ]
            }
            

            The documentation at https://confluence.atlassian.com/display/AdminJIRACloud/Importing+data+from+JSON has been updated with this information.

            Pedro Tacla Yamada added a comment - Hello, this was a documentation issue. The valid values for sprint state field in the JSON import are: "CLOSED" "ACTIVE" "FUTURE" When a sprint is "CLOSED" or "ACTIVE" it's also required that they have: "startDate" - When this sprint started "endDate" - When this sprint was planned to end And "CLOSED" sprints also should provide: "completeDate" - When this sprint actually ended An example JSON is this: { "projects" : [ { "name" : "Project" , "key" : "KEY" , "type" : "software" , "issues" : [ { "externalId" : "1" , "priority" : "High" , "description" : "Sample 1" , "reporter" : "abcde-12345-fedcba" , "issueType" : "Bug" , "summary" : "Sample 1" , "customFieldValues" : [ { "fieldName" : "Sprint" , "fieldType" : "com.pyxis.greenhopper.jira:gh-sprint" , "value" : [ { "rapidViewId" : 1, "name" : "Future sprint" } ] } ] }, { "externalId" : "2" , "priority" : "High" , "description" : "Sample 2" , "reporter" : "abcde-12345-fedcba" , "issueType" : "Bug" , "summary" : "Sample 2" , "customFieldValues" : [ { "fieldName" : "Sprint" , "fieldType" : "com.pyxis.greenhopper.jira:gh-sprint" , "value" : [ { "rapidViewId" : 2, "startDate" : "2018-01-01" , "endDate" : "2018-01-10" , "completeDate" : "2018-01-10" , "state" : "CLOSED" , "name" : "Closed Sprint" } ] } ] } ] } ] } The documentation at  https://confluence.atlassian.com/display/AdminJIRACloud/Importing+data+from+JSON  has been updated with this information.

              Unassigned Unassigned
              amdzan Azmir Zan (Inactive)
              Affected customers:
              1 This affects my team
              Watchers:
              4 Start watching this issue

                Created:
                Updated:
                Resolved: