SBM External Relational Fields Featured Hot
Add new "External" Single and Multi-Relational fields that use a rest service to access the related records outside of SBM. This permits 'just in time' access to external data.
A relational field consists of an ID (single relational) or list of IDs (multi-relational) that are associated with an SBM Item. On the field itself (not the item) there is additional metadata information that identifies the data source for the relational field, or, in other words, an SBM table containing records.
This proposal is to create new field types that, like the single and multi-relational fields, store IDs in the item record. The metadata on the field would, instead of identifying a record in SBM, would contain an ID for a REST endpoint. In addition, we would add controls to the form palette that would use a REST call to access the source data and then select the records associated with the IDs in the field. This would be similar to the relational grid described here, but would use the REST call instead of a SBM Report to obtain the candidate data for the field.
Please login to view any attachments.