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'.
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
Google Calendar Add Event Pipeline
I am trying to create a pipeline that will send an invite to the user's google calendar when a meeting is scheduled. The pipeline is working and I am getting the calendar invite for the correct date however, it is not utilizing the time entered in the Date/Time field as the start time. This is pulling off of a Date/Time Field from the record created that triggered the pipeline. I have fields that split the date (Meeting Date) and time (Meeting Start Time) into two separate fields and have tried to use those in the pipeline but that shows as an incorrect format for date. Help!
Make Request JSON returning blank when only one record returned
I am retrieving data from an external data source using Make Request. I am then using another Make Request to send data to a QB table using the format shown below. It works great when I have 2 or more records in the response. However, when I only have one, then every field ends up being blank, even though I can see data in the response. Any thoughts? {# create records in XXXX table #} "to": "XXXXX", "data": [ {% for rec in f.json.response.xxxxxs.xxxx %} {% if loop.index0<5800 %} { "12":{ "value": "{{rec['@creationdate']}}"}, "6":{ "value": "{{rec['@id']}}"}, "38":{ "value": "{{rec['@status']}}"} } {{ ", " if not loop.last else "" }} {% endif %} {% endfor %} ] }
Pipeline to create record and populate a date field
I created a pipeline to create a record in a table (Statuses) after a record in another table (Masters) is created. For each Master record created I need 4 Status records created - each with a due date at 3,6,9, and 12 months after the expected start date noted in the Master. I have tried several formulas but am unable to get the right formula. The Expected Start Date in the Masters table is FID 13. If that date is 11-1-2024, how do I write the Status Due Date pipeline formula(s) to create a record with the due date of 2-1-2025 (and subsequently 5-1-2025, 8-1-2025 and 11-1-2025)? Dates will be different for each Master so I can't plug in hard dates. Can i create all 4 records in the same pipeline by adding additional 'create' steps? Or do I need 4 separate pipelines?
JSON error when importing or updating Google Sheets from QB
So I have pipelines to import and update data from quickbase to Google Sheets to essentially mirror each other. I just tried a pipeline that imports data from a newly created record to Google sheets and got this error message: Remote service reported an error: Invalid JSON payload received. Unknown name "values": Cannot bind query parameter. Field 'values' could not be found in request message. When I update a record I get this message: Remote service reported an error: Invalid JSON payload received. Unknown name "dataFilters": Cannot bind query parameter. 'dataFilters' is a message type. Parameters can only be bound to primitive types. I am having a hard time figuring out what this could be as my test environment pipelines for google sheets work fine. Any insight would be appreciated. Thanks, JamesPipeline Error
Does anyone have any idea why I am getting this error when trying to update a record in a table from another record in another table? Validation error: Invalid date/time value: 0.0 I don't have any date/time values that are being updated. They are all date values being updated by date value fields.
Pipeline to remove file attachments
I am trying to investigate if there is a way to use a pipeline to remove file attachments? I am automating a process to incorporate data into our system using CSV uploads. The issue is that I would like to keep some of the information from the upload available (e.g. the Requestor, Date Uploaded, File Name) but I don't want to actually archive the file on QuickBase due to space limitations. Is there a way to just delete the file itself without deleting the entire record? You can of course click into the file and manually delete it (see below), but I want this to be automated as I won't be doing the uploads myself. The field type is "file attachment" and it appears to be stored as a URL/Link. It does not behave like other fields in the pipeline and I have not found a way to override it yet. Thanks! ------------------------------ Kevin Gardner ------------------------------
