Update / Delete a row in a dataset

Aymeric

Hi,

 

I think that what I'm looking for doesn't exist in the API... At least based on what I can read in the documentation, on my Google search, and search in this forum.

 

Is there any way to delete or update a specific row in a dataset, knowing I have an ID column that is unique to identify the row? Like some others, I may have large dataset of rows and updating 5,000 rows for only 1 row that has actually been changed is a pain...

 

Thanks

MarkSnodgrass

You may want to look into the recursive dataflow option. You can do it in SQL or ETL. Here are the two articles to look at:

SQL: https://knowledge.domo.com/Prepare/DataFlow_Tips_and_Tricks/Creating_a_Recursive%2F%2FSnapshot_SQL_DataFlow

 

ETL: https://knowledge.domo.com/Prepare/DataFlow_Tips_and_Tricks/Creating_a_Recursive%2F%2FSnapshot_ETL_DataFlow

MarkSnodgrass

You may want to look into the recursive dataflow option. You can do it in SQL or ETL. Here are the two articles to look at:

SQL: https://knowledge.domo.com/Prepare/DataFlow_Tips_and_Tricks/Creating_a_Recursive%2F%2FSnapshot_SQL_DataFlow

 

ETL: https://knowledge.domo.com/Prepare/DataFlow_Tips_and_Tricks/Creating_a_Recursive%2F%2FSnapshot_ETL_DataFlow