sys_journal_field not available in REST api

JusCuz · ‎04-25-2016

Hopefully someone has some insight to this..... in the REST api explorer, I am unable to query the sys_journal_field table, it just doesn't show up in the list. I have verified that the 'Allow access to this table via web services' checkbox is checked on the table. Is there anything else I should be checking? I am an admin on the instance, I have gotten the same results in my community developer instance as well.

martygrinstead · ‎04-29-2016

Hi Jason,

There is a glide property that can be used to allow "sys_" tables to be displayed in the REST API Explorer:

glide.ui.permitted_tables

This is really only a UI issue, so you can still use the sys_journal_field when using other REST clients, even without changing this property.

So, just find this system property, and add any "sys" tables you want displayed.

Marty

View solution in original post

Mike Patel · ‎04-25-2016

It was available in Fuji but it's not available in Geneva.

JusCuz · ‎04-25-2016

How do we pull comments and work notes out for a record then?

JusCuz · ‎04-29-2016

bump....anyone have any insight to this?

poornachander · ‎04-29-2016

There are 2 options

1. Scripted REST Web Services

2. Processor which sends back the JSON object

The following code can retrieve the journal entries, which can be send back in Response.

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

Thanks

Poorna