- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-09-2023 08:18 AM - edited 10-09-2023 08:20 AM
Hi,
I am updating the Service Catalog TASKS from Excel 2019 (64 bit) using REST API. I am able to do updates. But I am facing some difficulties in updating "State" field. I like to know how to supply the values to the "State" field. Should we send as Integer format or as string format?
0 - Pending
1 - Open
2 - Work In Progress
3 - Closed Complete
4 - Closed InComplete
5 - Closed Skipped
I see the list values in the combo box of State field as above (only strings not numbers). Should I sent as Numbers as 0, 1, 2, etc or should I send as String like "Open", Work In Progress", etc. Is String a case sensitive?
Where to find the "State" Values?
Kindly help me to resolve this issue.
Thank you all.
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-09-2023 08:34 AM
You need to send the integer values, for checking the backend values of state just right click on state field on the form and click on "show choice lists"
Note: Please check the state values at your instance, might be someone has updated it
If my answer solved your issue, please mark my answer as ✅ Correct & 👍Helpful based on the Impact.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-09-2023 08:43 AM
@SN_2023 Here are the values for the state field.
Also, you can find the state values using the following steps.
1. Right click on the state field and choose config dictionary.
On the list, apply the filter Element is state and table is task (SC task inherits from task table)
Hope this helps.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-09-2023 08:34 AM
You need to send the integer values, for checking the backend values of state just right click on state field on the form and click on "show choice lists"
Note: Please check the state values at your instance, might be someone has updated it
If my answer solved your issue, please mark my answer as ✅ Correct & 👍Helpful based on the Impact.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-09-2023 10:38 AM
Done. Thank you so much..

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-09-2023 08:43 AM
@SN_2023 Here are the values for the state field.
Also, you can find the state values using the following steps.
1. Right click on the state field and choose config dictionary.
On the list, apply the filter Element is state and table is task (SC task inherits from task table)
Hope this helps.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-09-2023 10:39 AM
Thank you for resolving the issue.