Jira Pipelines - Cannot access custom fields
Hi all, I ran into a bit of a snag when integrating Jira with my Quickbase application. We utilize Jira as an externally facing tool for data collection within our company and Quickbase is reserved specifically for my team, due to data separation policies.We developed a workflow in Jira that other employees can interact with to catalog specific information, and we store those details within "Custom Fields" in Jira. I am trying to create a pipeline that takes information from linked Jira tickets whenever a status is changed and brings that into a linked record in Quickbase. However, I am unable to access all of the fields in the Jira ticket from within pipelines. Most of the information available is metadata included in all Jira tickets. I cannot access the specific Custom Fields that I need to collect data from. Any advice on how to access all of the fields within my Jira ticket so I can use them within Pipelines? ------------------------------ Matthew Rand ------------------------------
Webhook | API Add Record - Formulas
Hello everyone, I am trying to make an API Call that, when triggered, will add an apartment record with the same values of the current one with the sole difference of the Monthly Rent be negative - for example. You guys can help me to discover what i have been doing wrong? Example: API_AddRecord <qdbapi> <usertoken>######</usertoken> <field fid="6">[Unit #]</field> <field fid="9">[# of Bathrooms]</field> <field fid="10">[Monthly Rent]*-1</field> </qdbapi> ------------------------------ Pedro Sampaio ------------------------------
Do webhooks not trigger for grid edit actions?
I have a webhook set to trigger when a field is modified. It triggers fine when the field is modified within a form; when I update a record in a Grid Edit report, the webhook doesn't trigger. Do webhooks not trigger for grid edit actions? ------------------------------ Raymond Sakar ------------------------------
Why do APIs/webhooks run before Pipelines?
I'm doing some testing on an app and noticed functionality based on APIs/webhooks was completing its task well before the pipeline was triggered. The pipeline trigger was a field on a form, so when I saved the form both the API/webhook and the pipeline should start. Why does it take longer for the pipeline to start? I'm asking because I'm thinking of deploying a process whereby this order matters. If the were reversed, and the pipeline fired first, the webhook wouldn't run. Will it always be the case that pipelines will be slightly slower to trigger and run than APIs and webhooks? Thanks, ------------------------------ Daniel Johnson ------------------------------Webhook Delays Anyone?
Hello Quickbase Community, We are seeing delays in Webhooks to external services and wondering if anyone else is seeing this? Started yesterday - ish? Things seem to eventually run but not as quickly as we were experiencing before. Any input is appreciated. ------------------------------ Jim Harrison transparency = knowledge + understanding : The Scrum Dudes ------------------------------Ran a bad webhook and used up our step quota. How long is a quota period?
Got this lovely message from QB Customer support: "Reviewing the case notes, it seems you are out of steps, or are close to running out. If you need additional steps, you will need to work with your account manager to discuss options as additional steps typically come at cost, even if the step were consumer by user error." Anyone know what the quota period is? Plan is to wait to the next quota period rather than cough up $$ for a mistake. ------------------------------ George Bramhall ------------------------------
RESTful Webhook to Update Record
I've got a webhook coming from our customer survey application, that I want it to update a project in our project table with the results. I have to use json because it doesn't like the xml webhook for some reason. I set it up as a Insert/Update record. My issue is that occasionally the results don't have a project ID (fid 3), and when the webhook sends, rather than just rejecting the update as an error, it creates a new project with the survey results. How can I prevent the webhook from creating new records, but only update existing ones? Here's what it looks like { "to": "[DBID]", "mergeFieldID": "3", "data": [ { "3": { "value": "${e://Field/QBProID}" }, "3513": { "value": "${rs://ResponseStatus}" } }] } ------------------------------ Sean Boat-Moore Manager SMB Development Project Management Office and Quality Control NCR Corporation sean.boat-moore@ncr.com | ncr.com ------------------------------Post Webhook Response In The Record
I currently have a POST webhook setup in QuickBase with Endpoint to our 3rd party software. The way it triggers, is when New Client record is added in Quickbase, it runs the webhook, that creates a user name in our 3rd party software. When I run that webhook via Postman, if it's successful, it would display a response value (the value would be the user ID that it created in our 3rd party software). Response: <?xml version="1.0" encoding="utf-8"?> <string xmlns="http://www.tempuri.org/">1079</string> How can I have QuickBase see that response value (1079), because I want that value integrated in a specific field, from New Client record in Quickbase. ------------------------------ Gene Gene ------------------------------Webhook access denied
Hi, I am the owner of the app and I created the webhooks, but my other team mates who is also an administrator can't able to access the webhooks, even they created the webhooks and I am not able to see. Can you please suggest what we have to do?? Many thanks. ------------------------------ Saurabh Rathi ------------------------------
Editing a field with a Webhook while importing
Hello, I created a formula field that will pull the record id from another table. I then created a webhook that takes the record id and deposits it into a look up field (Relationship field) from that same table. This works great when you manually add a record to the table. The issue I am having is when I have to import several records into the table, the webhook only works on the first record. I watched the Mult-Record Changes video from the Webhooks Example-Manage Records training video in the University, but I am not sure how to get it to just do this one action. Below is the message body from the edit record webhook (this one is the one that works when manually creating records) and the message body API_ImportFromCSV: Edit Record: <qdbapi> <udata>mydata</udata> <usertoken>%user.token. </usertoken> <apptoken>APPTOKEN</apptoken> <rid>[Record ID#]</rid> <field fid="56">[Record ID Zip]</field> </qdbapi> API_ImportFromCSV: <qdbapi> <udata>mydata</udata> <usertoken>%user.token. </usertoken> <apptoken>APPTOKEN</apptoken> <records_csv> <[!CDATA[ %RepeatOn% [<rid>[Record ID#]</rid> <field fid="56">[Record ID Zip]</field> %RepeatOff% ]]> </records_csv> </qdbapi> I am not sure what I am doing wrong or if this can even be done. Any help with this would greatly be appreciated. ------------------------------ Nicole Varner ------------------------------
