Database view on remote table

[Colleen]

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?

[Mohith Devatte]

Hello ,

Can you please try replacing the where clause by below ?

I assume SUB  would be your prefix , use underscore instead of DOT

sub_course_id=54591 && sub_assignment_id=307988

Please mark my answer correct if it helps you 

[Colleen]

Thanks for the tip on the database view where clause.

I have updated the where clause as instructed, and the database view is still not returning any records from the remote table.

None of the logging statements in the remote table definition script are being executed, so it does not appear that the script is actually being called.

[Shree3]

Hi Colleen,

In database view where clause dot won't work, replace (sub.course_id=54591 && sub.assignment_id=307988) by (sub_course_id=54591 && sub_assignment_id=307988)

[t0]

hi @Colleen 

By any luck, did you find a way to display the remote table record in database view? I am in a similar situation now.
Thankyou