Discussions

 View Only
Expand all | Collapse all

Connected Table Auto Refresh More Frequently

  • 1.  Connected Table Auto Refresh More Frequently

    Posted 01-06-2021 13:34
    Is there any way to perform an auto refresh on a connected table more frequently than once an hour?


    ------------------------------
    A Brown
    ------------------------------


  • 2.  RE: Connected Table Auto Refresh More Frequently

    Posted 01-06-2021 14:30
    Not natively.

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



  • 3.  RE: Connected Table Auto Refresh More Frequently

    Posted 02-08-2022 12:46
    Edited by Razi D 02-08-2022 13:44
    Hi Ahuva;
    You can do this with webhook and it can be done natively in Quickbase. You need to know the replicationID of table.
    Please see webhook in attached image. You can find single and plural record name in table advanced settings.
    Also you can see this post for finding replicationID : 
    https://community.quickbase.com/communities/community-home/digestviewer/viewthread?MessageKey=ba4a6b93-bb6c-4dff-9e97-a70fc52b6283&CommunityKey=d860b0f8-6a48-487b-b346-44c47a19a804&tab=digestviewer
    Thank you
    refresh



    ------------------------------
    Razi D.
    Desta Tech LLC
    razi@destatechs.com
    ------------------------------



  • 4.  RE: Connected Table Auto Refresh More Frequently

    Posted 03-16-2023 14:13

    This is delayed from when you posted, but thank you, Razi!! This worked amazingly for me just now and your sharing it is much appreciated. 




  • 5.  RE: Connected Table Auto Refresh More Frequently

    Posted 10-03-2023 15:30

    Hello All,

    Here is the problem I'm trying to solve: we use a third party system and receive email notifications.  However, email traffic is already excessive.  The goal is to create a dummy gmail address into these notifications, connect the mailbox with Quickbase, and utilize QB's notification structure to send SMS Text Message alerts.  All working so far except for my hourly limitation of the connected table refresh.

    I believe I've set the Webhook up correctly, including user token and replication ID, but how do I know how often I can have the table automatically refresh?  It would be fantastic if it could refresh every minute or two, as the SMS messages could then be received within a 5 minute interval of actual occurrence.  Screenshot attached for reference.

    Thank you,



    ------------------------------
    Aidon Olligschlager |
    Flight Operations Technical Support
    Pentastar Aviation
    Waterford MI
    aolligschlager@pentastaraviation.com | 248-202-9587
    ------------------------------



  • 6.  RE: Connected Table Auto Refresh More Frequently

    Posted 10-03-2023 15:34

    If you look at the history of the refreshes, you can see how many minutes they take.  I think you can refresh as often as you like, as long as the table is not already refreshing when you call for the refresh.



    ------------------------------
    Mark Shnier (Your Quickbase Coach)
    mark.shnier@gmail.com
    ------------------------------



  • 7.  RE: Connected Table Auto Refresh More Frequently

    Posted 10-03-2023 18:23

    Are you trying to trigger the refresh based on each new email being received? This may work for a while but if you get too many emails too fast and you trigger too may refresh attempts QB might interpret it negatively and shut down the sync thinking its corrupted. Its not an ideal solution - but you could move the http request to a Pipeline and copy it something like (4) times and have it run 15 minutes. Or 6 times for every 10 minutes etc. You want to give it enough time per Marks comment but not too much that QB thinks something might be wrong with it if to your point there is a lot of email traffic. 



    ------------------------------
    Chayce Duncan
    ------------------------------



  • 8.  RE: Connected Table Auto Refresh More Frequently

    Posted 10-04-2023 12:46

    Chayce,

    Full disclosure - I am in no means familiar with API's or this sort of thing, so I'm pretty much taking what others have done and trying to replicate.

    I am not trying to trigger the refresh based on receiving the email, but rather have it automatically refresh the table more frequently than one hour so that if an email comes through, it will trigger the notification within a reasonable timeframe (up to an hour later is too long).

    Utilizing your pipeline(s) recommendation, I have tried to replicate the webhook but cannot get it to work.  Here is the error message that is triggering:



    ------------------------------
    Aidon Olligschlager |
    Flight Operations Technical Support
    Pentastar Aviation
    Waterford MI
    aolligschlager@pentastaraviation.com | 248-202-9587
    ------------------------------



  • 9.  RE: Connected Table Auto Refresh More Frequently

    Posted 10-04-2023 13:22

    Hi Aidon,

    You don't need Authentication, User Name and password in Pipeline Webhook request. You may want to add content type to headers. That should work.

    Please don't share your user token here. 

    Thank you



    ------------------------------
    Razi D.
    WEP Forms
    http://www.destatechs.com
    ------------------------------



  • 10.  RE: Connected Table Auto Refresh More Frequently

    Posted 10-04-2023 13:45

    Hi Razi,

    I made your recommended changes, but still getting the following error message.  I've also deleted the old user token and replaced with a new one.  Thanks for the heads up on that.



    ------------------------------
    Aidon Olligschlager |
    Flight Operations Technical Support
    Pentastar Aviation
    Waterford MI
    aolligschlager@pentastaraviation.com | 248-202-9587
    ------------------------------



  • 11.  RE: Connected Table Auto Refresh More Frequently

    Posted 10-04-2023 13:50

    When I did this long ago I ended up getting and actual auth ticket using api_authenticate, but by looking at that start of this thread you need to put QB-USER-TOKEN before your actual token in the body. So: 

    BODY:

    QB-USER-TOKEN xxxxxxxx 



    ------------------------------
    Chayce Duncan
    ------------------------------



  • 12.  RE: Connected Table Auto Refresh More Frequently

    Posted 10-04-2023 13:54

    Sorry not the body - I meant the Headers. Try putting QB-USER-TOKEN before your actual token in header. Mistype on my part. 



    ------------------------------
    Chayce Duncan
    ------------------------------



  • 13.  RE: Connected Table Auto Refresh More Frequently

    Posted 10-04-2023 14:10

    Please see both attached images, This is how I just set up the webhook(in Pipeline) and it works. I am not sure if you are missing anything. 

    Thank you



    ------------------------------
    Razi D.
    WEP Forms
    http://www.destatechs.com
    ------------------------------



  • 14.  RE: Connected Table Auto Refresh More Frequently

    Posted 10-04-2023 14:16

    Yes, looks like QB-USER-TOKEN is the primary missing element. 



    ------------------------------
    Chayce Duncan
    ------------------------------



  • 15.  RE: Connected Table Auto Refresh More Frequently

    Posted 10-04-2023 14:20

    This worked!  Thank you all for your assistance.  Much appreciated!



    ------------------------------
    Aidon Olligschlager |
    Flight Operations Technical Support
    Pentastar Aviation
    Waterford MI
    aolligschlager@pentastaraviation.com | 248-202-9587
    ------------------------------