Should a Multi-Reference table/field work like a subtable for data insert?

I have multiple subtables that are inserting data without issue. I recently added a multi-reference table (Address_Contact) to the Server Connect API.

But when attempting to POST data to it, it’s throwing a 500 error.

{
   "status":"500",
   "code":"42703",
   "message":"insert into \"Address_Contact\" (\"Address1\", \"Contact_id\") values ($1, $2) - column \"Address1\" of relation \"Address_Contact\" does not exist",
   "stack":"error: insert into \"Address_Contact\" (\"Address1\", \"Contact_id\") values ($1, $2) - column \"Address1\" of relation \"Address_Contact\" does not exist\n    at Parser.parseErrorMessage (/opt/node_app/node_modules/pg-protocol/dist/parser.js:287:98)\n    at Parser.handlePacket (/opt/node_app/node_modules/pg-protocol/dist/parser.js:126:29)\n    at Parser.parse (/opt/node_app/node_modules/pg-protocol/dist/parser.js:39:38)\n    at Socket.<anonymous> (/opt/node_app/node_modules/pg-protocol/dist/index.js:11:42)\n    at Socket.emit (node:events:513:28)\n    at addChunk (node:internal/streams/readable:324:12)\n    at readableAddChunk (node:internal/streams/readable:297:9)\n    at Readable.push (node:internal/streams/readable:234:10)\n    at TCP.onStreamRead (node:internal/stream_base_commons:190:23)"
}

It appears the Data Bindings only see the reference table with foreign keys. Ideally, I would be able to pick the Address field(s).

image

Community Page
Last updated: