AndrewHansen1
Qrew Member
Joined 5 years ago
User Profile
User Widgets
Contributions
Re: Pipeline to create JSON only collects first 200 records
Thanks Justin! Unfortunately the Pipeline options in the Quickbase channel are too slow to be tenable for our application, so API it is! I will look over the documentation that you provided, and see if I can get a working solution. Regards, Andrew ------------------------------ Andrew Hansen ------------------------------43Views0likes0CommentsPipeline to create JSON only collects first 200 records
Hi Everyone, I have a pipeline that uses the quickbase API to run a custom report that I have created and exports the results into a JSON. No matter what I seem to do the JSON is only built with the first 200 records of the report. The report has hundreds more records when I run it manually. I am pretty sure that there is a setting or something else that I am missing that is limiting either the report or the API in some way. Has anyone experienced this before? What was your solution? Thanks, Andrew Pipeline info: Pipeline Channel = Make Request URL https://api.quickbase.com/v1/reports/9/run?tableId=TABLE_ID Method POST Headers Name QB-Realm-Hostname Authorization Value MY_QB_REALM QB-USER-TOKEN MY_QB_USER_TOKEN ------------------------------ Andrew Hansen ------------------------------ #Pipelines #APIsandcustomcode10Views0likes2CommentsBlank Cells in Pipeline IF/THEN logic
I have a logical test that fails when comparing blank fields. The test checks if a field in Table A is equal to a field in Table B. Table A is an is created within quickbase and Table B was manually imported from excel. The IF/THEN statement works fine until it encounters two fields that are blank. Looking through the activity log, pipelines reads the value of the blank field in Table A as "None" and the value in Table B (excel import) as "". I have gone through the fields in my tables and verified that they are all empty. Has anyone else experienced anything like this? Does anyone have any idea why one empty field is read by pipelines as "" and another as "None"? #Pipelines ------------------------------ Andrew Hansen ------------------------------34Views0likes1CommentSingle pipeline trigger on excel import
I am working on creating a pipeline that I would like to trigger and run only one time when I import a large Excel sheet into quickbase. Is this possible? All of my attempts so far have triggered the pipeline to execute multiple times, as the import creates multiple new records. ------------------------------ Andrew Hansen ------------------------------