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).
Community Page
Last updated:
Last updated: