Do you use Alteryx in a language other than English? If so, we want to hear from you! Please help us improve the international experience of our products by participating in this 5 minute survey.

We are updating the requirements for Community registration. As of 7/21/21 all users will be required to register a phone number with their My Alteryx accounts. If you have already registered, you will be prompted on your next login to add your phone number.

Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
SOLVED

API Write Data to Quickbase

mphillips27
7 - Meteor

Is there a way to write to quickbase using an API in designer? Using the download tool and a parse XML I've downloaded data from Quick base but I can't find any help on how to write data back to quickbase.

 

Thanks!

5 REPLIES 5
mceleavey
16 - Nebula

Hi @mphillips27 ,

 

you will need to build an API connector. The following link has the API documentation:

 

https://help.quickbase.com/api-guide/intro.html

 

We at Bulien can build the connector for you. DM me if you are interested.

 

M.

Drussek
8 - Asteroid

It's my sample workflow which do INSERT into choosen table.

Drussek_0-1616536543222.png

You need to replace all "xxxx" with proper values.

Hope this is what you asked for.

You can make some tests here:

https://developer.quickbase.com/operation/upsert

 

 

PS. you should receive in response sth like this.

Drussek_1-1616536654654.png

 

mphillips27
7 - Meteor

Drussek, amazing! Thank you!

mphillips27
7 - Meteor

This works great, however when I do the API call, I can't figure out how to control what columns I'm calling. It seems to dump a bunch of columns from the default table, ironically none of the ones I'm trying to get. I tried creating a body field with a query using the restful API body request but that didn't work.

{"from":"xxxxxxx","select": [3,6]}

 

Any help?

Drussek
8 - Asteroid

@mphillips27Did you find an answare? If not:

 

You can send to:

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

such body (you need to change a table name)

As a result you will receive all columns and their numbers.

I don't use Quickbase, just did some tests and research, so I can't be more helpful.

 

{
  "from""brbsbj4nj",
  "select": [

  ],
  "sortBy": [
    {
      "fieldId"4,
      "order""ASC"
    },
    {
      "fieldId"5,
      "order""ASC"
    }
  ],
  "groupBy": [
    {
      "fieldId"6,
      "grouping""equal-values"
    }
  ],
  "options": {
    "skip"0,
    "top"5,
    "compareWithAppLocalTime"false
  }
}
Labels