Skip to main content
August 9, 2023
Question

Write to multiple datastore entity

  • August 9, 2023
  • 15 replies
  • 0 views

Hi Everyone,

Is it possible to update the certain columns only and not all columns of a data store entity using write to multiple datastore entity smart service.

Thank you!

    15 replies

    August 9, 2023

    Just query the rows you want to update and modify the data in required columns then pass the updated row data with primary key in WDSE.

    stefanhelzle0001
    Brainy
    August 9, 2023

    Writing to a datastore will always update the full row. This is in contrast to Appian Records, where only the provided fields will be updated.

    August 9, 2023

    [mention:126a676c85024855948336691b0a7b92:e9ed411860ed4f2ba0265705b8793d05] , Is there any way so that only required columns are updated in a row, not the full row.

    stefanhelzle0001
    Brainy
    August 9, 2023

    Not with CDTs and Data Stores.

    May I ask why you are concerned?