How to retrieve data of the Choice List type?

Ask for Help
1

Hi everyone,

I’m exploring how to use Grist to organize my marketing workflows.

Currently, I’m testing how to add records to a table on make.com.

Thankfully, I’ve had no issues populating columns with sample data.

However, I’m having trouble retrieving data of the Choice List type.

I’d appreciate some guidance on querying tables with the API.

Thank you.

  1. Example table with Choice List data in the last column
    image
    image1617×779 135 KB
  1. Fetching records from the table on make.com
    Question: I don’t understand why there is an extra “L” in the output for the values in the last column. It wasn’t added to the table and is nowhere to be seen within the table.
    image
    image1865×1004 87 KB
  1. Fetching records from the table through the API console
    This output raises the same question as before.
    image
    image1412×521 55.6 KB
  1. Question: How do you filter records by Choice List type values?
    While it’s straightforward to filter for these values in the app, the API returns no data to such queries.
    image
    image1865×1004 67.1 KB

    image
    image1383×404 86.6 KB

    image
    image1397×280 45.6 KB
2

Hi @John_Wu.

The "L" is part of Grist’s internal representation of cell values. There’s more information here, including a list of other types you may come across.

Filtering Choice List columns via the API doesn’t quite work today (sorry about that). I just added something to our backlog to get it looked at.

George

1 Like