Skip to main content
Question

Using API Do_Query within the 'Advanced Query' on a pipeline in 'Search Records'

  • October 7, 2020
  • 0 replies
  • 123 views
Hi,

I'm trying to use a pipeline to create a bunch of records based on what's returned in a search.  My first step is to use the 'Search' in Pipelines to attempt to return the records I'm looking for.  My suspicion is that I've got the syntax all wrong. Here is what I've got so far:

My image appears to be little fuzzy.  I should break down whats in the pic. 
1. Account = "Zapier and other integrations".  This has worked in the past so I think I'm all good on that part
2. Table: I'm pointing to our 'Channel Partner' Table in the 'Channel Partner' App
3. FIelds: Channel Partner Name (FID 6), Channel Partner Notes (FID 7)
4. Advanced Query:
https://domain.quickbase.com/db/tableURL?a=API_DoQuery&
includeRids=1&
apptoken=mytoken&
udata=mydata&. //I'm not sure what to add in the 'mydata section')
query={'67'.CT.'CA'} //I'm saying if the field ID 67 contains the state of CA.  67 is a combined text field
   
What I'm hoping this will all add up to in psudeo code is:
1. Go to the Channel Partner Table
2. Return all the records where CA is containd in the combined text field (fid 67)
Thanks in advance for any help.  
Jake


------------------------------
Jake R
------------------------------
This topic has been closed for replies.

Jake -

Using the Advanced Query is unnecessary for what you're trying to accomplish. You'll need to use the standard Query option at the bottom of this form like this:



------------------------------
Blake Harrison
bharrison@datablender.io
DataBlender - Quick Base Solution Provider
Atlanta GA
404.800.1702 / http://datablender.io/
------------------------------
Terms & ConditionsAccessibility statement