Pipeline Bulk Record question

Question

I've migrated most of the simple automations to pipelines and have started on the more complex automations.  The first ones I started with are replacing the table to table import automations.  I started with the documentation provided by Quickbase in the help section, but wasn't sure what to enter in the Headers section for the Name and Values fields for the Make a Request step.  Then I looked at this post, Building Table-to-Table (T2T) Imports using Pipelines and saw it did not include the step for Make a Request.  I deleted the step and the pipeline worked as needed.  
I have two questions, first, do I need the Make a Request step since it worked as needed without that step.  Second, What values should go in the Name and Values fields of the Make a Request step?Thank you in advance.------------------------------Paul Peterson------------------------------

MarkShnierYou · Answer

There are two methods. If you already have the T2T import built, then the easiest way is to "Make Request".

The API call looks like this

https://mycompany.quickbase.com/db/xxxxx?a=API_RunImport&id=11
Method = POST

The xxxx is the target table, the 11 is the ID of the import visible in the URL when you edit the import

Otherwise the no code method is to create the bulk upsert, do the search and then add a row for every search result and then commit the upsert.

------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------

Sign up

Login to the community