I have set up a remote table that is populated by a REST call to our Canvas VLE that downloads assignment submission data. The remote table definition script requires the course_id and assignment_id to be specified in order to make the API call. I have successfully queried the remote table from the list view, a report, a data table widget and a GlideRecord query.
However, when I use the table in a database view, no records are returned. The remote table is the only table in the view. I have tried both hard-coding a query in the where clause (sub.course_id=54591 && sub.assignment_id=307988) and querying from the list view. The remote table definition script writes to the application log, and nothing is logged when I query the database view.
Has anyone successfully used a remote table in a database view?
