I have a connection field named “Division” with technical name “field_18”.
The Knack API payload is not correctly serialized to a table from the query select * from GLAccounts. Payload contains the connection field values:
{"total_pages":1,"current_page":1,"total_records":3,"records":[{"id":"63e62616725b39001120cf92","field_18":"<span class="63e62287c743bb0012338d90">ITn Solutions</span>","field_18_raw":[{"id":"63e62287c743bb0012338d90","identifier":"IT Solutions"}],"field_6":"0820","field_6_raw":"0820","field_2":"Rekening courant divers","field_2_raw":"Rekening courant divers","field_4":"69405e88-4c91-4298-a03f-a8188154a379","field_4_raw":"69405e88-4c91-4298-a03f-a8188154a379","field_78_raw":"","field_78":"","field_132_raw":"","field_132":"","field_127":"","field_127_raw":[]},{"id":"63e62617c743bb0012343880","field_18":"<span class="63e62287725b3900112039e7">Stg</span>","field_18_raw":[{"id":"63e62287725b3900112039e7","identifier":"Stg"}],"field_6":"0810","field_6_raw":"0810","field_2":"Rekening courant John","field_2_raw":"Rekening courant John","field_4":"28dc5551-bb58-420b-a5d6-b7cb766cf1fe","field_4_raw":"28dc5551-bb58-420b-a5d6-b7cb766cf1fe","field_78_raw":"","field_78":"","field_132_raw":"","field_132":"","field_127":"","field_127_raw":[]},{"id\":"63e626170be58300126af04a","field_18":"<span class="63e62287c743bb0012338d90">IT Solutions</span>","field_18_raw":[{"id":"63e62287c743bb0012338d90","identifier":"IT Solutions"}],"field_6":"0800","field_6_raw":"0800","field_2":"Rekening Courant VWC","field_2_raw":"Rekening Courant ABC","field_4":"2e6cd6e5-4fed-45fd-842d-67ba6ec414d8","field_4_raw":"2e6cd6e5-4fed-45fd-842d-67ba6ec414d8","field_78_raw":"","field_78":"","field_132_raw":"","field_132":"","field_127":"","field_127_raw":[]}]}
But, the output in query editor is always empty for the connection field:
Ultimately I want to write data to the connection field.