Forum Discussion

ChayceDuncan's avatar
ChayceDuncan
Qrew Captain
2 years ago

Re: Connected Table Auto Refresh More Frequently

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 Replies

  • AidonOlligschla's avatar
    AidonOlligschla
    Qrew Cadet
    2 years ago

    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
    ------------------------------
    • RaziD_'s avatar
      RaziD_
      Qrew Cadet
      2 years ago

      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
      ------------------------------
      • AidonOlligschla's avatar
        AidonOlligschla
        Qrew Cadet
        2 years ago

        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
        ------------------------------