xml results to third party

Priya123
Tera Contributor

hi team 

 

we have a servicenow api link which is ingested by a 3rd party tool for processing the data

if we click the api url link the xml the values are not right , the date format is different for sys updated on field

sample:

Result: 29-Jul-24

Expected: 2021-01-05 01:00:00

 

similarly for some fields backend values are coming up like sys id for number , 3 for closed etc

 

 

api URL :

https: //<  instance Name>  / api/now/table/core_company?sysparm_query=sys_updated_onBETWEENjavascript&colon;gs.dateGenerate(%272024-05-31%27%2C%2721:15:30%27)@javascript&colon;gs.dateGenerate(%272024-09-05%27%2C%2722:13:10%27)&sysparm_first_row=1&sysparm_view=true&sysparm_display_value=false  

 

Any leads ? 

 

0 REPLIES 0