Help

Linking to a synched table fails from the API

Topic Labels: API
Solved
Jump to Solution
1629 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Olafur_Petursso
5 - Automation Enthusiast
5 - Automation Enthusiast

steps to reproduce:
1 create a synched table, say Users and create one user
2 in another db add the synched User table
3 create a table, say Exam, that has a field that links to the user
4 verify that you can, from the Exam table, link a user from the synched table
5 from the API call the create method on the Exam table with the field user : [ user-rec-id ]
6 notice you receive an error 422 ‘Record ID user-rec-id does not exist’

expected result:
You should be able to create an Exam record from the API with a user linked to the synched User table

1 Solution

Accepted Solutions
Olafur_Petursso
5 - Automation Enthusiast
5 - Automation Enthusiast

Thank you Scott for your reply. After much digging I see that the synched User table in the Exam database has a different rec id than the User in the original database. Problem is solved. Thanks again for the swift reply!

See Solution in Thread

2 Replies 2

It’s working okay for me when using the API to create a new record that links to a synced table.

Are you putting the record ID in quotation marks?

And are you choosing the proper record ID (and is it from the table that the linked record field is linking to)?

The cURL data that you’re posting to create a new record should look something like this:

{
"fields": {
    "Text Field 1": "Test data here",
    "Text Field 2": "Hello world!",
    "Linked Record Field": ["recABC123defghi456"]
  }
}
Olafur_Petursso
5 - Automation Enthusiast
5 - Automation Enthusiast

Thank you Scott for your reply. After much digging I see that the synched User table in the Exam database has a different rec id than the User in the original database. Problem is solved. Thanks again for the swift reply!