Using _ragicId to load a linked value instead of ambiguous displayed value?

Hi, I feel like I am asking a very basic question but here it goes.
When using the API to create a new record, I would like to use the Ragic ID to specify a linked and loaded value instead of the actual value which could be ambiguous/non-unique.

lets say I have a “cars” table that links and loads the displayname (combination of first and last name) column from a “customers” table.

Lets say I have three customers:
_ragicId, displayname, phone
4301, “John Smith”, “313-999-4444”
4302, “Jane Doe”, “313-123-4567”
4303, “John Smith”, “902-782-5555”

When creating a new record in the “cars” table via the API, I am only able to successfully enter a record by specifying “John Smith” as a string… but I don’t want to do that because there are multiple John Smiths - Instead, I know that I want to specifically reference John Smith with Ragic ID of 4303… I tried submitting 4303 as an integer hoping that the endpoint would understand it as a foreign key, but when I do that, I just get a blank value in the “cars” table for the customer’s displayname.

I tried so many things but I am out of guesses :frowning:

Hi there – this is Kate from Ragic Support. If you’d like input from our development team regarding your API question, feel free to reach out to us at support@ragic.com. We’d be happy to take a closer look and discuss it further with you. Thanks!