SOLVED - HubDB API - CSV Import fails when updating with primaryKeyColumn
I have a script that's importing a csv into a HubDB table via the import csv api. If the table is empty, the data is imported without issue. However, if I run the script again, the import fails with:
{"status":"error","message":"internal error","correlationId":"f82f9f09-9418-49c8-8077-537e46658c1e","requestId":"0aa07a8 (truncated...)
If I remove the primaryKeyColumn property from my json config, then it will import over and over without issue. Obviously that's not what I want since it adds duplicate records to the table. Am I missing something when it comes to importing and checking for duplicates?