SQL Formatting an Array

Hi everyone, I feel like i’m biting my teeth out on this one.
I’m trying to update a multi-select field with SQL but this formatting:

UPDATE Talente SET beruflicheKenntnisse='["Microsoft Office","SAP"]' WHERE E-Mail = '{email}'

only gets me this error:
{‘error_message’: ‘failed to convert value: invalid value’}
Same with any other multi-select field. The values are definitely correct.
Is my formatting just wrong?

Updating values in multiple select, please use parentheses instead of brackets. The SQL should be somehow like:

UPDATE Talente SET beruflicheKenntnisse=("Microsoft Office","SAP") WHERE ....

Please try again

1 Like

Yes that was it.

This topic was automatically closed 2 days after the last reply. New replies are no longer allowed.