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