How do I access my data with the types "Journal" and Choice" via the REST table API?

thecoywwlf
Kilo Contributor

I noticed that when I pull my table via REST, any columns that are type "Journal" and "Choice" are empty in my JSON object. They are there in Servicenow though.

Maybe i'm missing something.

Please let me know.

Thanks.

Dave

1 ACCEPTED SOLUTION

Jace Benson
Mega Sage

Those journaled values aren't stored on that record.   they are stored on a combination of sys_audit, sys_history_line, and sys_journal, DONT JUST LOAD those tables they're huge.  



Here's some threads about people getting the notes, but I think it's a big gap in the tool.



sys_journal_field not available in REST api


What is the best way to find sys_audit record for sys_journal_field


View solution in original post

2 REPLIES 2

Deepak Kumar5
Kilo Sage

var notes = current.work_notes.getJournalEntry(-1); //gets all journal entries as a string where each entry is delimited by '\n\n'


var worknotesArray = notes.split("\n\n");     //stores each entry into an array of strings



Jace Benson
Mega Sage

Those journaled values aren't stored on that record.   they are stored on a combination of sys_audit, sys_history_line, and sys_journal, DONT JUST LOAD those tables they're huge.  



Here's some threads about people getting the notes, but I think it's a big gap in the tool.



sys_journal_field not available in REST api


What is the best way to find sys_audit record for sys_journal_field