ContributionsMost RecentMost LikesSolutionsRe: Pipelines - Get Length of List of Pipeline RowsI do want to get the resulting records from step D. However, step D is using the 'Search Pipeline Rows' function from the Bucket channel. Could that be the reason why {{ (d | count) / 20}} isn't working? Does Jinja only work for the 'Search Records' function in the QuickBase channel? I created a bucket because I am performing a query upon a query. I need to get the latest 20 records, and then search within those records for the records that match a certain criteria. Would it be easier if I tried to put all the filter criteria into the initial Search Records step (Step 1 from my initial post)? ------------------------------ Ryan Peart Database Analyst Minerva Knowledge Management WA ------------------------------ Re: Pipelines - Get Length of List of Pipeline RowsHi Sharon! Thanks for getting back to me. I tried using {{ (d | count) / 20 }} and the Pipeline can successfully run now. But I don't think (d | count) returns the count of records from step D. When I test run the Pipeline, step D does return a number of rows, but the final records get updated with the value 0. Is there a different syntax I can use with Jinja? ------------------------------ Ryan Peart Database Analyst Minerva Knowledge Management WA ------------------------------ Pipelines - Select 20 Most Recent RecordsHello, I am trying to schedule a pipeline that will query the 20 most recent records from a table sorted in descending order by a date lookup field. But when I try to use the Search Records function from the QuickBase channel, there isn't a way to sort records and then select the 20 most recent records. Is there a way this can be done in QuickBase Pipelines? Thanks in advance! ------------------------------- EDIT 10/25/21 I was able to perform the query using the Fetch JSON step. That is where you can specify the sorting order using a "sortBy". Then you can add an option to select the top 20 from the sorted list. After fetching my JSON, I needed to iterate over the JSON records in order for them to be readable/usable in the rest of the pipeline. ------------------------------ Ryan Peart Database Analyst ------------------------------Pipelines - Get Length of List of Pipeline RowsHello, I am trying to schedule a weekly calculation every Friday using Pipelines. The calculation process is as follows: Select the 20 most recent records from a QuickBase App table, sorted by a date lookup field (I also can't get this to work, but I will make another post about this issue). Define a Pipeline Rows table using the Bucket channel. For each of the 20 QB App table rows, store them all in the Pipeline Rows table. Search the 20 Pipeline Rows table to return a filtered list of Pipeline Rows whose fields match certain conditions. Search the QB App table again for all records created over the past week. For each of those QB App table records created over the week, update a field with: (# of Pipeline Rows matching the conditions / 20). I was able to successfully return a filtered list of Pipeline Rows that match the conditions. But when I try to perform step #6 and update the records with {{length(d.record_id) / 20}}, I get this error: Validation error: Incorrect template "{{length(d.record_id) / 20}}". UndefinedError: 'length' is undefined. Is there a different way I should be trying to get the number of filtered Pipeline Rows out of the 20 selected that match the conditions in order to use it in my calculation? ------------------------------ Ryan Peart Database Analyst Minerva Knowledge Management ------------------------------ SolvedRe: Order results returned in Pipeline search queryI am also interested in sorting the search query. Does the order have to be sorted before the query? ------------------------------ Ryan Peart Database Analyst Minerva Knowledge Management ------------------------------ RESTful API getAppTables ErrorHello, I am trying to use QuickBase's RESTful API portal as a Custom Connector to Microsoft Power Apps. I downloaded the OpenAPI file from the developer site (link for reference) and very slightly modified it so that it would be accepted by Microsoft when I import it to Power Apps. Upon the initial import, it looks like it was successful and Power Apps says it is "Connected". But when I try to use this custom connector to access QuickBase from Power Apps, specifically using the 'getAppTables' action, I am getting an error message that says "QuickBaseAPI.getAppTables failed: No listener for endpoint: /internal/defaulttables" . I am providing the App ID, the host domain name, and a user token as parameters. When I use the same values to test on the QuickBase developer site, I am getting the proper response. I am not very experienced with developing APIs, but I didn't change anything drastically when I was modifying the OpenAPI file. Could someone with a little more API development experience tell me what this error means? Any help is appreciated. Thanks in advance! ------------------------------ Ryan Peart Database Analyst Minerva Knowledge Management ------------------------------