Pipeline Error trying to Create a Record
I am not a fan of Pipelines. I miss Automations. I used to be able to build an Automation in like 30 min and it did what I wanted. I've been working two days to build this Pipeline, even using the AI...
Forum Discussion
You could also try using Make Request (MR) within the Quickbase channel using the standard api structure for querying (using new rest api). If you go this route, you can then check for the existence of a record from the data returned in the conditional: evaluates to true: {{step.json.metadata.totalRecords}}==1
I was forced to use this step, MR, instead of Search, I know you said Look up (but as you've noted you can only match on the Record ID or a Key field, if you set a unique one on the table that isn't the Record ID), because of performance issues. This way you can also query on multiple fields versus just the one. And, you can even test this in their online api playground: api