Show the select box variable label instead of the value.

[imkhan]

Hi All,

I just have query, we are using a multirow variable set, and we have a variable, so how do we show the variable label after selecting the choice from the select box instead of the value? We are getting data from a third party to show that is not storing in ServiceNow.

[Ankur Bawiskar]

@imkhan 

do this

1) when you are making API call and you get the response as {"data":[{"TopicID":4,"Name":"A&E"},{"TopicID":1,"Name":"E&A”}],"message":"Succes
s"} -> parse and get the TopicID and Name

2) query question_choice table with this choice value and label and if not found then add for your variable

3) this way no duplicates will be inserted into question_choice table

No scheduled job required.

I hope I have provided enough guidance and you can take it from here based on your developer skills.

If my response helped please mark it correct and close the thread so that it benefits future readers.

[imkhan]

Hi @Ankur Bawiskar ,

Thank you! I'll take it forward with the same approach.

[Ankur Bawiskar]

@imkhan 

If my response helped please mark it correct and close the thread so that it benefits future readers.