Lookup Property from sys_properties table in UI Builder

Elena · ‎06-07-2021

Hi everyone,

I am trying to lookup a system property (sys_properties table) in UI Builder.

I tried with the data resource "Look Up Properties" but I guess it looks for properties of the experience not the system, so I'm getting a null as a result.

I also tried with the data resource "Look Up Record" but I cannot select the correct table (sys_properties).

Is anyone more successful than me and can show me how to do it?

Thanks.

Brad Tilton · ‎06-07-2021

Hi Elena,

The Look Up Properties composite data resource is restricted to looking up properties defined in the glide.graphql.property.whitelist system property, which is not editable by customers right now.

You can create a transform data resource that will do this. Transform data resources let you execute server-side code and make the results available in UIB. If you go this route, don't forget to create an ACL for your DR. You can find out more about transform data resources here: https://developer.servicenow.com/blog.do?p=/post/quebec-ui-builder-data-resources/

View solution in original post

Daniel Draes · ‎06-08-2021

Thanks for this post @Brad Tilton. I was scratching my head on why I only get 'null' back. I would have never guessed we limit the available properties in such way.

Martin76 · ‎08-16-2022

I'm also having troubles finding this information in the documentation 😞
Thanks a lot, Brad. The workaround seems unnecessarily complex, though.

Fabio Fragapane · ‎08-01-2025

Thanks for providing such information. A message explaining this directly in the UIB when selecting the component will be great 😉