Domo Simple API - Insert null value using json

guilhermekido

It seems Simple API does not accept null value in json format. How can I insert null in a column using API? I tried "" and it works but this recognizes the column as string, if I need a int column or date column, this approach it's not what I'm looking for. Thanks!

GrantSmith

In my experience, the Simple API doesn't allow for nulls with numerical values in JSON. This is why I typically use the dataset or stream APIs to upload a CSV value and just have an empty value in my CSV to process a null.

https://developer.domo.com/portal/eb00606e6f114-format-data-to-import

https://developer.domo.com/portal/3b1e3a7d5f420-data-set-api

This last document should have a better example of uploading CSV with the Content-Type of text/csv:

https://developer.domo.com/portal/3989acf1bafff-import-and-export-data

MarkSnodgrass

@GrantSmith might know the answer to this.

GrantSmith

In my experience, the Simple API doesn't allow for nulls with numerical values in JSON. This is why I typically use the dataset or stream APIs to upload a CSV value and just have an empty value in my CSV to process a null.

https://developer.domo.com/portal/eb00606e6f114-format-data-to-import

https://developer.domo.com/portal/3b1e3a7d5f420-data-set-api

This last document should have a better example of uploading CSV with the Content-Type of text/csv:

https://developer.domo.com/portal/3989acf1bafff-import-and-export-data