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 %} ] }
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
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 ------------------------------
Pipeline message-Skipped because set values are the same as in source object.
I have a quickbase we will call it Network that has a connected table to another quickbase that we will call Escalations. On the connected table in the Network QB, i have two added fields that reps update in the Network QB. I then want to send the data in those two fields back to the Escalations QB. The fields in the Escalations QB have the same name. I created a pipeline who's trigger is when one of those fields in the Network QB is updated. My next step is search record query on the Escalations QB and it pulls back the record where the Escalation QB record id matches the Network Escalation record id. Next step is the loop and the final step is an update record. The record to be updated is the search record. I pull in the fields to be updated and do the matching. The pipeline ran with no errors but the record from the Escalation QB did not update. On the activity I see on the update record step, it gives me this, "Skipped because set values are the same as in source object.". What have I done wrong? Thanks
