How to create a drop-down list for catalog item

[pathat]

Hello.

I want to present the user with a drop down list with names of groups (in a remote system) when the user goes to request a custom catalog item I created (called "Request Remote Access"). In the catalog item definition I see the different types of variables I can create like "Lookup Multiple Choice", and I have played around with this a little. Here's what I think I need to do:

1. Create a new table to hold the group names I want to display

2. Populate the table with names (i can manually enter names for now)

3. In the catalog item definition, select type "Lookup Multiple Choice"

4. In the catalog item definition, point to this new table

5. Find a way to populate the table with values retrieved in real-time from an external system (using a scheduled web service that calls to it).

At this point, the user should be able to select the group name from a list displayed in the request form, instead of having to type it in (that's how it works now): Am I on the right track, or is there a better way to do this? Also, let me know if you've tried or know how to populate the table with a web service.

Thx!

[pathat]

Thx Berny. I wanted to mention a couple issues I had to deal with since we last talked, before we close the thread:

1) Once I created the custom table and then created the scheduled job to populate the table, I had to deal with a table security issue which prevented a regular user from seeing the data in the table (The data was supposed to be displayed in a drop-down list when the user orders my catalog item). I had to make sure all my users had the new role that SN defined for accessing the table.

2) As mentioned, I have a scheduled job that runs a gets the data from an external table (it gets group names in the external system) and populates the SN table with these group names. I used Glide scripting to do this. But I know need to modify the logic to account for the case where a group is deleted from the external system, in which case I want to also delete it from the SN table. I suppose one way would be to empty the SN table before populating it again.

[utchili]

Go to catalog item --> varaible ----> and select the type as Select Box..

[pavani19]

Thanks for this thread.

May i know how to populate data from external sql db.

i have rest api implemented to get data from sql.

please help.

[manirathore]

how did you populate the table manually? can you please tell