Pipelines: Outlook Event - set "show as" status
I have a Pipeline that creates Outlook calendar events for tasks in an app where I am the task owner. All the events come in to my calendar with the "Show as" field as "busy". I want them to go in as "free" so they don't block the available time on my calendar. I don't see a native way to do this in Pipelines - the "Show as" field is not available to select. Does anyone have a work around? ------------------------------ Sherry Blackburn ------------------------------Pipeline limits and shutting down pipelines when running out of steps
Quickbase - What is the deal with pipelines?? You're going to press people to migrate to pipelines from automations, that fine. BUT -- when they run out of steps you stop ALL PIPELINES! Including internal pipelines that are not using billable steps! Further, you give no way at all to add additional steps to prevent stoppage! I'm directed to reach out to my account rep which I did days ago, but get no response. What can your customers do if the account rep is on vacation?? Also, individual users can only see their OWN pipelines, in spite of the fact that every user is consuming steps from the same pool! At the very least you should be allowing run over and just bill for additional steps used! OR give us a way to buy more steps easily! This is a very bad and sloppy implementation of this system and it makes no sense to push people to pipelines when it operates this way. We are extremely unhappy with this. While pipelines are great when they work, this ridiculous limitation makes me think twice about using it for ANY important functions. ------------------------------ Jeff Peterson ------------------------------
Pipeline & Oauth 2 Token
Good Evening I am trying to use Pipelines to connect QB to Azure for the purpose of dropping a CSV file on the server. I have sorted most of this however the OAuth 2 Credentials seems to be not working, I have never done this with Pipelines before so it is entirely possible that it's me that is doing something wrong.I am pretty sure that the 3 fields are filled out correctly (Client Credentials, Client Secret & Token URL). My question is this: When you fill in the data should you get the access token returned automatically or do you need to use a GET command?? If it is the later please can you cut/paste a screenshot or add an example as it seems that the data I am adding is not returning the token. Many Thanks Paul ------------------------------ Paul Paul ------------------------------
Parallel Looping - Pipeline
How to avoid parallel looping in pipeline... i.e. In for each statement have 2 records... currently loop is running parallel... but i want to run one by one sequence... based on 1st record update value, i need to update second record value. ------------------------------ Karthikeyan N ------------------------------
Correct format for Address in Pipelines, if field name has a space
I recently had trouble having a pipeline populate one address to another. My originating address field had a space in the name, and I thought I just needed to include an underscore to make it work. It turns out, that is not the case. Through testing and customer support's help, the correct syntax is: {{a['Address 1_city']}} as opposed to {{a.Address 1_city}} or {{a.Address_1_city}} Hope this helps others who run into this unfortunate bug! ------------------------------ Mike Tamoush ------------------------------To capture an XML response from an API in Pipelines
Hi All, I would like to use a simple Quickbase API (API_ProvisionUser) in a Pipeline and use the user id included in the response in my subsequent Pipeline steps. Response promised in the API docs: <?xml version="1.0" ?> <qdbapi> <action>api_provisionuser</action> <errcode>0</errcode> <errtext>No error</errtext> <userid>112248.5nzg</userid> </qdbapi> Is there a way I can parametrize a Quickbase channel API request to get the XML response? Suppose getting my stuff out of the XML text would be somehow possible, but how can I capture the API response? Seems Pipelines does not offer any available new field after establishing this API request step. Or I am doing something wrong... Thank You! ------------------------------ Laszlo M ------------------------------
Pipelines - Mailchimp Connection Amazing
I just have to share something, not a question on this one.... I had to use Pipelines yesterday for the first time to build an integration with Mailchimp and it was incredible. We needed to issue a COVID-19 mass email and our old way of creating a mailchimp distribution was a disaster. Employees sending in spreadsheets iwth bad data etc. We have a contact database in QuickBase. I created a pipeline to load all existing contacts into mail chimp in about 2 minutes, boom all done running within a few minutes later. I created a separate pipeline to add all future newly created contacts right into mailchimp. Just an amazing tool so really wanted to share. We dont use too many other 3rd party software pieces I could see connecting it too but this one was really fantastic. ------------------------------ Ivan Weiss ------------------------------Pipelines and Regex
I'm currently working on a Pipeline to automate our in-house IT Help Desk, but I'm running into issues with the "matches regex" option in the Outlook Channel "Search Emails" step. What I'm trying to do is find a sequence like "Ticket #20200618-1507-RM-74". I created a regular expression that I would normally add to a function in JavaScript like so: /Ticket #\d{8}-\d{4}-\w{2}-\d{2}/g I'm trying to catch a pattern in the subject line "Ticket" & # & 8 digits & - & 4 digits & - & 2 letters & - & 2 digits" with the global flag appended to the end. It works in JavaScript, but it seems as if Pipelines doesn't recognize this pattern. Is there a a specific way of writing regex with Pipelines or am I completely off track with the "matches regex" option in Pipelines for the Outlook "Search Emails" option? I'm also attaching an image of the "Search Emails" step I'm referencing with the "matches regex" conditional step. I don't see any documentation referencing how to use regex with Pipelines either. When I run the Pipeline I get a "Found no Emails" response in the "Running Pipeline" window. The email is in the inbox with that exact pattern, but Pipelines does not recognize my regex pattern. Thanks! ------------------------------ AR ------------------------------Outlook Channel - Remote API returned authentication error 'refresh token'
For almost 2 years we have been sending emails without a problem and are using the Outlook channel in Quickbase Pipelines for this purposes. Since last week we have started to experience issues receiving following errors: Remote API returned authentication error: (invalid_request) AADSTS900144: The request body must contain the following parameter: 'refresh_token'. Trace ID: 6f796e19-28f3-430c-8938-3a9274901800 Correlation ID: 3d7633a0-df23-404b-9b5a-d7df2400e3b6 Timestamp: 2024-09-30 18:38:43Z We have not changed our Microsoft Azure AD account / application settings, this has just come out of nowhere. Using different email domains we experience the same issue. Is there anyone experiencing the same that can give us some guidance ? we have been looking to activate offline_access on the application in Azure AD, been review MFA settings, trying to use application passwords, etc. but to no good end result yet. And for almost a week now the Quickbase helpdesk is also not providing any active support. In the meantime we are reconnecting Outlook channels every hour to keep the lights on .... appreciate your input
MIME Pipeline issue
Hi, pipeline guru's We suddenly started getting the following pipeline error to an email template that we have in the application, but there have been no changes made to the template or form, but its preventing the email being sent to the user. Any suggestions on what we should be focusing on to resolve this? Remote service reported an error: A supported MIME type could not be found that matches the content type of the response. None of the supported type(s) 'Microsoft.OData.ODataMediaType, Microsoft.OData.ODataMediaType, Microsoft.OData.ODataMediaType, Microsoft.OData.ODataMediaType, Microsoft.OData.ODataMediaType, Microsoft.OData.ODataMediaType, Microsoft.OData.ODataMediaType, Microsoft.OData.ODataMediaType, Microsoft.OData.ODataMediaType, Microsoft.OData.ODataMediaType, Microsoft.OData.ODataMediaType, Microsoft.OData.ODataMediaType, Microsoft.OData.ODataMediaType, Microsoft.OData.ODataMediaType, Microsoft.OData.ODataMediaType, Microsoft.OData.ODataMediaType, Microsoft.OData.ODataMediaType, Microsoft.OData.ODataMediaType, Microsoft.OData.ODataMediaType, Microsoft.OData.ODataMediaType, Microsoft.OData.ODataMediaType, Microsoft.OData.ODataMediaType, Microsoft.OData.ODataMediaType, Microsoft.OData.ODataMediaType, Microsoft.OData.ODataMediaType, Microsoft.OData.ODataMediaType, Microsoft.OData.ODataMediaType, Microsoft.OData.ODataMediaType, Microsoft.OData.ODataMediaType, Microsoft.OData.ODataMediaType, Microsoft.OData.ODataMediaType, Microsoft.OData.ODataMediaTyp...' matches the content type 'application/x-www-form-urlencoded'.
