Pipelines and Filters
Hello, I'm attempting to setup a Pipeline which checks to see if a record has two Numeric Summary Fields which equal each other, and if they do, it updates a multi-text status field from "Assigned" to "Delivered." When attempting to create the Pipeline, I've been struggling to get it to run. When attempting to set the filter so that it checks if Field A equals Field B, it seems like I can't check Field A against another field specifically, only enter a value of my own. I thought about getting around this by using a checkbox formula on the record which says if Field A = Field B, true and then having the Pipeline filter be setup such that it runs when the Checkbox field is true. However, the Pipeline never seemed to trigger off that Checkbox, even when it was changed from unchecked to checked. Is the issue that I'm not actually updating the record, but instead Summary fields which are being updated? If so, is there any way around that? Thank you in advance.34Views0likes5CommentsNew form "email" option, automate?
Hi Everyone, I'm looking to automate via pipeline a way to email a form just like the new option when viewing a form (see attached pic). I'm not sure it's possible and I tried searching for a solution in the discussions. I know this feature is relatively new and thought I'd reach out to see if anyone has the same interest. I'm more interested in using the native "email" function like below than using GMail but if there's no other way, I'll pursue that route instead. Thanks!8Views0likes0Comments(Pipelines) Get Users in Role / Process XML from HTTP API
Hello, any help/advice would be much appreciated. I'm trying to send a reminder email to users in a specific Role, in a specific App, using Pipelines. As far as I can tell, there is not a JSON RESTful API call that does this (Get Users only returns all users for an App, with no info on Roles). However, API_UserRoles returns each user from an app with what Roles they have. In theory, I could somehow loop over this and send the email to only those users with a specific role. I can successfully use the Quickbase Channel -> 'Quickbase APIs' -> 'Make Request' step to call API_UserRoles and get this data. Here's where I run into trouble: How do I process this XML into a form that another step could use (e.g. loop over it and send emails)? I found this question: "To capture an XML response from an API in Pipelines" but I can't seem to figure out how get {{a.json.qdbapi.value}}. When I try to view its contents (emailed to myself) it is blank. There isn't any "Result" field or something like that from this request step available in subsequent steps. Only URL, Method, Headers, Content Type, & Body. For instance, if I want to get the JSON out of the XML (using {{a.json.qdbapi.value}}) with the JSON Handler Channel -> 'Iterate over JSON Records', the 'JSON Source' field states 'No json sources in the pipeline' Thank you for any help you can offer, ~Daniel ------------------------------ Daniel ------------------------------66Views0likes3CommentsWhen the Expiration Date is On or Before Today, Change the Contract Status to Expired
Hello: I have a contract application. Goal: When the Contract Expiration Date field is on or before today, and the Exception to the Expiration Date Dynamic Form Rule field is unchecked, I want theContract Status field to automatically change to Expired. Question: What is the best method to accomplish the above goal, form rule, text formula, or pipeline? 1. I tried the below form rule. However,it works intermittently. I still see expired contracts that show as active 2. I created a formula - Text field named Contract Status Formula, but I am unsure whether my formula is correct. If( Today() <= [Contract Expiration Date], "Expired") 3. I tried to create apipeline. My first attempt was to Search Records/Update Record. My second attempt was to On New Event/Search Records/Update Record. However, I know I am missing a step. Any step-by-step guidance would be greatly appreciated. Thank you, RoulaSolved119Views1like12CommentsPipeline API Post
I am using a Pipeline to create a single record in a table with a Post Method from a Make a Request step. I cannot use a Create Record Step as the number of possible destination tables is too large. After much trial and tribulation that is working now. The next piece of my workflow I need the Record ID from the record just created. The REST API logic says to use a 'fields ToReturn ' Looking at the Activity I can see that the RID is getting back to the Pipeline. However I do not know how to use it inside of the Pipeline in a future Step. Any suggestions from the Python/ JSON and Jinja wizards?Solved25Views0likes2CommentsParse JSON
If you are looking to parse a JSON response in a Pipeline and you know where and what value are looking for there is a simple way to get to a specific piece of data. Credit for this goes to Jenny on the QB Support Team for getting me the solution. There are five parts to the Jinja Expression The STEP that the JSON is resident in The SECTION of the JSON to get What part of the ARRAY to get The FIELD to get The value Here is the expression {{STEP.json.SECTION[ARRAY]['FIELD'].value}} So here is what my JSON looked like { 'data': [{'3': {'value': 14}}], 'metadata': {'updatedRecordIds': [], 'createdRecordIds': [14], 'unchangedRecordIds': [], 'totalNumberOfRecordsProcessed': 1}} {createdRecordIds} } This is a really small array. In the 'data' section is only one piece of data for FID3 and its value is 14. That is what I wanted to get. So my working Jinja Expression is {{b.json.data[0]['3'].value}} The JSON was coming from Step B. data is the section I want to get something from. There is another on it called metadata but I am not interested in those at the moment. 0 is the first part of the array. If your JSON returns ten records JSON counts to ten by going: 0, 1, 2, 3, 4, 5, 6, 7, 8, 9 3 is the name of the information I want. The real world case here is that I asked for the value of FID 3. In QB the name of the field would be Record ID but the name is not what got returned it was the FID value tells it to give me the value for '3' The answer that the Pipeline Step kicks out is 14 which is exactly what I needed for the next part of my problem. If you have large arrays, need to search for data or manipulate the result further, this is probably not helping much. If you know where and what you want to pull from the JSON, it will do the trick.1View0likes0CommentsParse JSON
If you are looking to parse a JSON response in a Pipeline and you know where and what value are looking for there is a simple way to get to a specific piece of data. Credit for this goes to Jenny on the QB Support Team for getting me the solution. There are five parts to the Jinja Expression The STEP that the JSON is resident in The SECTION of the JSON to get What part of the ARRAY to get The FIELD to get The value Here is the expression {{STEP.json.SECTION[ARRAY]['FIELD'].value}} So here is what my JSON looked like { 'data': [{'3': {'value': 14}}], 'metadata': {'updatedRecordIds': [], 'createdRecordIds': [14], 'unchangedRecordIds': [], 'totalNumberOfRecordsProcessed': 1}} {createdRecordIds} } This is a really small array. In the 'data' section is only one piece of data for FID3 and its value is 14. That is what I wanted to get. So my working Jinja Expression is {{b.json.data[0]['3'].value}} The JSON was coming from Step B. data is the section I want to get something from. There is another on it called metadata but I am not interested in those at the moment. 0 is the first part of the array. If your JSON returns ten records JSON counts to ten by going: 0, 1, 2, 3, 4, 5, 6, 7, 8, 9 3 is the name of the information I want. The real world case here is that I asked for the value of FID 3. In QB the name of the field would be Record ID but the name is not what got returned it was the FID value tells it to give me the value for '3' The answer that the Pipeline Step kicks out is 14 which is exactly what I needed for the next part of my problem. If you have large arrays, need to search for data or manipulate the result further, this is probably not helping much. If you know where and what you want to pull from the JSON, it will do the trick.1View0likes0CommentsJSON Parse from QB Response
If you are looking to parse a JSON response in a Pipeline and you know where and what value are looking for there is a simple way to get to a specific piece of data. Credit for this goes to Jenny on the QB Support Team for getting me the solution. There are five parts to the Jinja Expression The STEP that the JSON is resident in The SECTION of the JSON to get What part of the ARRAY to get The FIELD to get The value Here is the expression {{STEP.json.SECTION[ARRAY]['FIELD'].value}} So here is what my JSON looked like { 'data': [{'3': {'value': 14}}], 'metadata': {'updatedRecordIds': [], 'createdRecordIds': [14], 'unchangedRecordIds': [], 'totalNumberOfRecordsProcessed': 1}} {createdRecordIds} } This is a really small array. In the 'data' section is only one piece of data for FID3 and its value is 14. That is what I wanted to get. So my working Jinja Expression is {{b.json.data[0]['3'].value}} The JSON was coming from Step B. data is the section I want to get something from. There is another on it called metadata but I am not interested in those at the moment. 0 is the first part of the array. If your JSON returns ten records JSON counts to ten by going: 0, 1, 2, 3, 4, 5, 6, 7, 8, 9 3 is the name of the information I want. The real world case here is that I asked for the value of FID 3. In QB the name of the field would be Record ID but the name is not what got returned it was the FID value tells it to give me the value for '3' The answer that the Pipeline Step kicks out is 14 which is exactly what I needed for the next part of my problem. If you have large arrays, need to search for data or manipulate the result further, this is probably not helping much. If you know where and what you want to pull from the JSON, it will do the trick.1View0likes0CommentsPipeline help
I don't know how to fix this error. It used to work fine now it does not. I am extracting tracking number from the response however It is giving me an error. I had help setting this up so I'm not too good at fixing the code. But in step I and J I am doing an applied expressions and getting all the info. In step K I am attempting to put that info into my fields in QuickBase.19Views0likes1CommentHow to handle error in Upload step in Pipeline
I have a pipeline that uploads a file attachment to another record. There may not always be an attachment. This causes and error on the upload step. I have tried using a condition with is the file attachment set and also tried not equal to "blank" and neither by passes the upload step. Is there another way to test to see if there is an attachment to upload?8Views0likes1Comment