How do I run a Table to Table Import?
Hi all. I have a webhook for Table A, and I want it to run a Table to Table Import into Table B whenever records are added to Table A. Here are the details of the webhook: Enpoint URL - https://amzl.quickbase.com/db/*********?a=api_runimport Body - <qdbapi> <usertoken>%user.token.************%</usertoken> <id>12</id> </qdbapi> I'm still new to QuickBase so I'm never 100% sure with what I'm doing but I'm guessing the "12" is referring to the ID of the import.
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 ------------------------------
