Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Configuration steps

1

Create a SQL procedure that returns the necessary data

Use SAMPLE_POLLED_FILE_PROCEDURE as a starting point

Info

If you intend to use this file with Zapier, the result set must contain a column called TODO id that can be used for de-duplication. See https://platform.zapier.com/docs/dedupe and comments in SAMPLE_POLLED_FILE_PROCEDURE for more details.

Otherwise, LearningBuilder imposes no specific schema on the result set.

2

Add the procedure to the list of Custom Database Objects

Go to Sys Admin → App Configuration → Custom Database Objects and add that procedure using Feature Enum 10 for PolledDataFile

3

Add a Polled Data File linked to that procedure

Go to Sys Admin → Polled Data Files and create a new data file

  1. Select the desired procedure as the data source

  2. Select the API Key permission(s) that are required to access the file. If there are no custom permissions that you wish to use, then select the built-in ACCESS_POLLED_DATA_FILES permission.

4

Create an API Key authorization ruleset that provides the necessary permissions

Create (or edit an existing) API Key ruleset in Sys Admin → App ConfigurationAuthorization Rules.

This ruleset must grant:

  1. The built-in ACCESS_POLLED_DATA_FILES permission;

  2. The permission required by the Polled Data File (if using a custom permission)

...