how to execute a URL in url customfield in behavior script and show response in another customfield?

[rakesh rocckz]

I have a URL custom field and a text custom field. if someone pastes a URL in the URL custom field it should execute that URL and show the JSON response of that URL in another custom field.is it possible through Behavior scripts? please help me out how to execute a GET request behind the scenes and shows the response in another custom field??

[Peter-Dave Sheehan]

If you add a server-side script to your URL field, you can execute the get and store the result in another form field like this:

import groovyx.net.http.ContentType
import groovyx.net.http.HTTPBuilder
import groovyx.net.http.Method

def url = getFieldById(getFieldChanged()).value
def targetField = getFieldByName("Url fetch result field name")
if(url){
   def responseText
   def httpBuilder = new HTTPBuilder(url)
   httpBuilder.request(Method.GET, ContentType.JSON) {
      response.success = {resp, json->
         targetField.setFormValue(json.toPrettyString())
      }
      response.failure = {resp, data ->
         targetField.setFormValue("Unable to fetch data from $url. The status was $resp.statusLine. The HTTP GET returned the following text: ${data.toString()}")
     }
   }
}

Note that this will execute after you focus changes from the URL field.

Also, it will fail if the URL is bad or doesn't return a valid json (this method automatically parses the json into an object). So you may want to wrap the httpBuilder request into a try/catch block.