Jupyter Workspace upsert data with composite keys

NathanDalley

Hello!

I've been investigating domojupyter.write_dataframe to upsert data. My dataset has a composite key, two Integer columns.

My suggestion is to make UPSERT in Jupyter consitent with other DOMO ingestion methods, by updating the domojupyter package to allow for composite keys. ie ["ItineraryId", "ItineraryItemId"]

Notes

When attempting to use a composite key, I get the below error:

It looks like when the package updates the schema to be sent:

existing.update(objects=[{"Identity": update_key}])

It doesn't allow for a list object. When attempting to send a list object, the output is incorrectly formated. see screenshot.