Trigger Report Subscription via Pipelines Webhook channel

Question

We have a report that is set to send on a subscription basis but, as we know, that's limited to 1x per day send. We now need to trigger the report to send 4x per day.

We also know that calling a URL that looks like this:

https://<<URLROOT>>/db/<<DBID>>?a=sendsubscription&id=<<REPORTID>>
would trigger the report to send on-demand ... so there's a way to do it - we just need to find a way to schedule the invocation of that URL.

So, the thought was that we could use the Webhook Pipeline to make the call on a schedule - problem is, we've been unsuccessful - likely due to authentication - in making the call successfully.

Any thoughts / tips / tricks on how to pull this all together?

Dave

------------------------------
Dave Minker
------------------------------

MarkShnierYou · Answer

I have asked various people at QuickBase and they say it is not possible. I also tried the same thing as you did to try to jam in a URL into a pipeline and every time it failed on authentication. The problem is that the URL is not a proper API (?a=sendsubscription&id=xx)

A suggestion might be to have a Helper table with a Dummy record (Record ID# = 1) which contains an embedded report of the contents of the subscription. That report link field would match the 1 of the Record ID# to a formula 1 on the detail records.

And you can have a pipeline run several times per day and it will update a date time field on that dummy record to be the current date and time. That within trigger a notification. You would have to contrive the notification recipients to be the recipients that you wanted the subscription report to go to.

------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------

Sign up

Login to the community