Hi Guys
Sorry for the delay in replying, just getting round to looking at this now(!) - it's been a busy few months.
OK, so I've had some success in querying the REST API sn_customerservice_case table.. I can retrieve cases out of it, but I can't get the notes and other activity items associated with it. Here's one way I get some XML of a case:
https://mycompanyname.service-now.com/sn_customerservice_case.do?XML&sys_id={my case sys_id here}
The linked article by Jeff Hoffman says that another table sys_journal_field holds the notes, but my SN doesn't seem to have this; I don't see it in my REST API explorer, and if I fire off something like this:
https://mycompanyname.service-now.com/sys_journal_field.do?XML&sysparm_query=element_id%3D{my case sys_id here}
The response is:
<xml/>
Any clue how I can get the notes/activities (additional comments/work notes/field changes/emails sent) referenced in the below pic?
