Can we get the record value without id by using Custom picker template from REST API

[Sreenivas Narala]

Hi Folks,

I have created a script field with custom picker template and fetching the input data from REST API but while returning the value getting 'Failed to find record with ID' and getting output as a single string instead of list values.

Could you please check and let me know how we can sort out this issue.

Script snippet :-

import com.onresolve.scriptrunner.canned.jira.fields.model.PickerOption

import groovyx.net.http.ContentType

import groovyx.net.http.HTTPBuilder

import groovyx.net.http.Method

import java.net.HttpURLConnection;

import net.sf.json.groovy.JsonSlurper

import net.sf.json.JSON;

import groovy.json.JsonBuilder

import java.util.TreeSet;

def get = "https://abc-data-service.eu-gb.mybluemix.net/api/v2/projects?token=xxxxxxxxx".toURL().text

def json = new JsonSlurper().parseText(get)

def Name = json."name"

def result = ""

def sort = new TreeSet();

for (key_value in json) {

    def Status_Value = key_value."status"

    def BU_Value = key_value."bu"

    def ProjectCategory_Value = key_value."projectCategory"

if (!((Status_Value == 'Cancel') || (Status_Value == 'Close') || (ProjectCategory_Value == " Test") || (BU_Value == "Data")))      

    {

   sort.add(key_value."name")

   }

}

for (key_value in sort) {

   result = result + "<option>"+key_value

search = { String inputValue ->

    result }

getItemFromId = { String id ->

   key_value."id" }

renderItemViewHtml = { String inputValue ->

    result

}

renderItemTextOnlyValue = renderItemViewHtml

toOption = { String value, Closure highlight ->

    new PickerOption(

        value: result,

        label: result  

    )

}

}

Error Message :-

Failed to find record with ID: <option>Test<option>TestABC<option>Test123<option> List<option>