- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-05-2020 08:49 PM
Hi All,
I'm trying to use the GET API to get a body response back that includes the time values for Planned Start Date & Planned End Date within a Change record but so far I haven't able to achieve this.
Queried the Change sys_id and the response body comes back with no entries for these.
I've had a look at the Change Management API but I don't see any details about it:
https://developer.servicenow.com/dev.do#!/reference/api/orlando/rest/change-management-api
Any idea how I can approach in collect these values for Planned Start Date & Planned End Date within a Change record?
Thank you for viewing.
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-05-2020 09:17 PM
When you say no entries are coming back, do you mean that these columns aren't listed in the response body? If these are the OOB columns I think they are, you're looking for start_date and end_date, correct?
These should be listed in both the standard Table API when querying the change_request table, or using the Change Request API you linked, selecting one of the "GET" functions seen below
If they're not coming back at all, and by that I mean they aren't listed in the response body under the names of start_date and end_date, I'd look and see if there are any ACLs or query Business Rules in place that would prevent whatever account you're using from seeing these columns
If you want, post a few screenshots of what you're sending in and what the response body looks like and we can maybe help you locate the issue.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-05-2020 09:17 PM
When you say no entries are coming back, do you mean that these columns aren't listed in the response body? If these are the OOB columns I think they are, you're looking for start_date and end_date, correct?
These should be listed in both the standard Table API when querying the change_request table, or using the Change Request API you linked, selecting one of the "GET" functions seen below
If they're not coming back at all, and by that I mean they aren't listed in the response body under the names of start_date and end_date, I'd look and see if there are any ACLs or query Business Rules in place that would prevent whatever account you're using from seeing these columns
If you want, post a few screenshots of what you're sending in and what the response body looks like and we can maybe help you locate the issue.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-05-2020 11:04 PM
Thank you for your response Matthew.
I was able to retrieve the planned start date and planned end date using the Change request in your screenshot as you mentioned.
Before I was using the now/table request which did not return back the required values:
Thank you!