The CreatorCon Call for Content is officially open! Get started here.

API GET - Planned start date & planned end date from a Change Request.

Ninh V Bui
Kilo Contributor

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. 
find_real_file.png
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. 

1 ACCEPTED SOLUTION

Matthew Glenn
Kilo Sage

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

find_real_file.png

 

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.

View solution in original post

2 REPLIES 2

Matthew Glenn
Kilo Sage

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

find_real_file.png

 

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.

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:
find_real_file.png


 

Thank you!