[external] User Defined API - Get data from data sources (Part 2)

External content by Daniel Krüger; June 14, 2026;
The original post appeared on daniels-notes.de

The 'Get data from data source' running mode of User Defined APIs lets you:

• expose any existing data source as a REST endpoint
• provide friendly names
• JSON conversion is handled automatically
• user privileges are applied when using BPS internal views.

Before relying on it in production, there are several limitations to account for: a hard cap of 1000 returned records, loss of seconds in datetime values from BPS internal views, and timezone handling that may require a SQL workaround. You should verify the last two in your WEBCON version.

You can read up on all the details and workarounds in this blog post.