Domo Simple API - Insert null value using json

guilhermekido · October 2022

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 · April 2023

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 · April 2023

@GrantSmith might know the answer to this.

GrantSmith · April 2023

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

Domo Simple API - Insert null value using json

Best Answer

Answers

Categories