Using SR Resources in a Rest Endpoint script

[Steve Morris]

I am trying to set up a bunch of Rest Endpoints in Script Runner to retrieve data from databases to populate drop-downs based on other fields in the form.  I know you can use resources within the built-in scripts but my logic is going to be a bit more complicated and we might need to call multiple databases from an rest endpoint. 

My question is: how do I set up a database 'resource' that controls the user/password and class definitions but then use the resource pool from within my rest endpoint code?  All the examples I've found only hardcode the connection string, user/pasword, etc in the script itself in plain text.  That's not an option for use and we'd prefer to use the resources to set the password in a single place and have all code just use that resource. 

Any examples of doing this would help.

[Ivan Tovbin · Accepted solution]

Hi Kevin,

I don't quite understand what exactly you are trying to achieve here. By the looks of it, your "Budget Status" field is a scripted field with HTML template. You want to get this field's value, cut off all HTML tags and pass the actual value somewhere else (to another field)?

If this is the case, then I suggest matching your "Budget Status" value against a regex and the pass the result to wherever you need.