Using Table API, is it possible to fetch the last updated 'Additional comments'?

Go to solution
Suggy
Giga Sage

‎02-19-2025 10:31 AM - edited ‎02-19-2025 07:54 PM

Using Table API/Rest API is it possible to get the last updated comments?

 

PS - I see few posts talking about querying sys_journal_field table, but I dont want to go via that approach as I believe its not recommended to query such large tables, sorting on large tables etc

 

  • 1,533 Views
1 ACCEPTED SOLUTION

Go to solution
Ankur Bawiskar
Tera Patron
Tera Patron

‎02-20-2025 02:52 AM

@Suggy 

not possible with Table API as journal entries are stored in sys_journal_field table

You can use Scripted REST API and then get the latest comments and send as API response

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

Regards,
Ankur
✨ Certified Technical Architect  ||  ✨ 9x ServiceNow MVP  ||  ✨ ServiceNow Community Leader

View solution in original post

0 Helpfuls
5 REPLIES 5

Go to solution
Ankur Bawiskar
Tera Patron
Tera Patron
In response to Suggy

‎02-20-2025 08:52 PM

@Suggy 

I haven't tried it yet but I believe so.

Regards,
Ankur
✨ Certified Technical Architect  ||  ✨ 9x ServiceNow MVP  ||  ✨ ServiceNow Community Leader
0 Helpfuls