topic Re: Quickbase + alteryx in Alteryx Designer Desktop Discussions

Quickbase + alteryx

jbravman_ — Fri, 05 Oct 2018 14:40:25 GMT

Is it possible to export data from Quickbase via alteryx?

we have our own quickbase site...

www.companyname.quickbase.com

Re: Quickbase + alteryx

MarqueeCrew — Fri, 05 Oct 2018 17:34:23 GMT

@jbravman_,

A quick google of "Quickbase API" returns this hit: https://help.quickbase.com/api-guide/index.html

You might be the first to build a connector macro to it.

Cheers,

Mark

Re: Quickbase + alteryx

Reddy4 — Tue, 07 Apr 2020 17:22:17 GMT

Create a Text Input with a FieldName: TableURL and add table URL to it as a record (remember that Table Id is different from App Id)

https://companyname.quickbase.com/db/[TableId]

2. Add a Download tool to the Text Input tool.

Basic:
- URL: TableURL
- Encode URL Text checked
- Output to a field String and Data encoded as Unicode UTF-8
Headers:
- do nothing
Payload:
- HTTP Action: GET (or FTP)
- Select Compose Query String/Body and add the following

Name Value

a API_DoQuery

usertoken [usertoken] /*can be created in quickbase - see quickbase documentation*/

apptoken [Your App Token] /*ask your admin to create one for you*/

Connection:
- do nothing

3. Then connect this download tool to a XML Parse tool.

Field with XML Data: DownloadData
XML Element to Parse: Auto Detect Child

You can try to put the following URL in any browser to see xml data

https://companyname.quickbase.com/db/[TableId]?a=API_DoQuery&fmt=structured&usertoken=[Your User Token]&apptoken=[Your App Token]

Re: Quickbase + alteryx

cowannbell — Thu, 18 May 2023 19:48:23 GMT

Reddy, I just ran across this post because I'm also trying to connect to QuickBase using API.

When I try what you have posted below, I receive the error

Error transferring data: Failure when receiving dat from peer.

Do you have any ideas what the issue could be?

Re: Quickbase + alteryx

cowannbell — Mon, 22 May 2023 17:00:07 GMT

FYI: I figured out my issue. I'm on a Virtual Machine and I had to make sure that in my user settings on the advanced tab, that at the bottom I had Enable Proxy Credentials

Re: Quickbase + alteryx

RainerNgo — Tue, 19 Mar 2024 19:05:31 GMT

Hello, wondering if we can extract the data via JSON query?

Re: Quickbase + alteryx

wesmcada — Tue, 03 Feb 2026 20:43:40 GMT

I also would like to know how to work with the Quickbase JSON RESTful API in Alteryx. REF: Quickbase API Portal

Re: Quickbase + alteryx

wesmcada — Tue, 03 Feb 2026 20:49:15 GMT

Have you figured this out?

Re: Quickbase + alteryx

wesmcada — Wed, 04 Feb 2026 19:25:48 GMT

I figured out how to use the Quickbase RESTful JSON API. Documentation: Quickbase API Portal

Text Input shape
1 Row, 2 Columns: EndpointURL; JSONbody

EndpointURL like https://api.quickbase.com/v1/records/query

JSONbody like Sample Request example (see documentation)

Download shape

Basic Tab
Field set to EndpointURL
Output To a Field, String, Data Encoded As Unicode UTF-8

Headers Tab
QB-Realm Host Name, User-Agent, Authorization, and Content-Type (see documentation)

Payload Tab
Take Query String/Body from Field: JSONbody

JSON Parse shape
JSON Field, DownloadData, Output values into single string field

Note that each attribute of each object returned in the response (JSON array) is listed as a "record" coming out of the JSON Parse step. For example, if six text fields are selected from each record, you get six rows (records).

Similarly, the Record Owner field when returned results in rows for each attribute contained therein (email, id, and name). I included six field IDs in my select statement including Record Owner and Last Modified By (both users with three attributes each), so I got four + three + three (10) rows for each QB record.