Parse 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.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 ------------------------------
'ToText' equivalent in Jinja
I have a multiple choice field with the options '1,2,3,4'. Since Multiple choice is seen as text, for QB, these aren't actually numbers. I have a numerical field, [NumberField]. In a pipeline I want to set [Multiple Choice] to [NumberField]. I am trying to set a text multiple choice to a number, and QB doesn't like that. My solution for now is just to create a formula text field with my calculation, ToText the result and use that formula field. Is there a shortcut to do this all in pipelines? I know below isn't right, but it paints the picture of what I want. Set [Multiple Choice] to: ToText{{a.NumberField}} ------------------------------ Mike Tamoush ------------------------------
Pipeline Help - Use List field in Search step - Jinja solution?
I have a table with Emails (child) and a table of Companies (Parent). The email Table has email fields such as To, From, CC, etc. and the Companies Table has a list field of All Email Addresses. I am trying to build a Pipeline that triggers every time a Company record is updated (adding or changing an email address) and will search the Emails Table fields for a matching email address contained in the All Email Addresses list field and update the Related Company field with the Record ID. Clear as mud? #Pipelines #JINJA ------------------------------ Nichole Braswell ------------------------------