I’m trying to add expenses to the EXPENSES table via API, specifically using the Zapier integration.
The issue is with adding already known values from a list.
Here’s the doc shared
I have a table People (with people in it), and a table Expenses, which has a column with a drop down of all possible people from the table People (naturally). It has a column lookup…
I can’t make this work with the Zapier/API.
What do I send to this cell of a new row to populate the field with the right Person from the table People?
Everything gets parsed as a text… nothing I try ends up correctly matching the lookup value and using that.
I tried all I could think off from the api get of the desired target of the lookup.
I tried to get some id from the API, but not sure how to use it.
index: 0 name: Filip values: c-UqX7n3kPLq: $20.00 c-8023jxb0p1: grocery c-NLT-8Pw5jE: Filip displayValue: Filip type: row id: i-g4dDzUa3Pm createdAt: 2018-02-06T22:23:41.955Z
People has rows Filip and Marie. Filip adds an expense of $22, specifying he is the one who paid (this columns is a lookup to the table People).
I tried to pull the Filip row data from People, but nothing here parses either (I tried the id and the display id and the row value and name… )
This works fine with a simple Select List column like Category in my table. It just does not work when the column is a lookup of another table
Thanks for suggestions!