Is it possible to merge or batch update sets via flow or script?

[Markell]

As asked in the subject. Is there a way to batch or merge update sets via flow or via script?

I've seen articles regarding trying this via script which all look unsuccessful but haven't seen anything regarding trying it via flow.

[Bert_c1]

The sys_update_set table has the 'base_update_set' field (Reference to sys_update_set) that can be set via script, and maybe via a flow. I do not understand what a script approach wouldn't work. But then you don't post what you have tried.

[Markell]

Ha fair. I have got as far as looking around the tables to see what I could access. I t is more of an idea at this stage but hadn't seen anything as yet that made it seem viable. I'll try with the tables you suggested in a flow and go from there. Thanks

[Robbie · Accepted solution]

Hi @Markell,

Fundamentally, as update sets are simply records within a table (Table name: 'sys_update_set'), you could script this and update the record as you would manually by populating the 'parent' field. (This is the part you could script - updating the parent field or batch field as you require)

However, a word of caution, just because something is possible, it doesn't necessarily mean this is always a good idea.

My caveat behind this is, if you are scripting this or are batching update sets (either via scripts or manually), I would make sure this batch is prepared in Dev or an environment and tested as a 'Release package' in QA (or any other pre-prod environment you may have available) to ensure the batch update set itself is tested before releasing on Prod.

To help others (or for me to help you more directly), please mark this response correct by clicking on Accept as Solution and/or Kudos.



Thanks, Robbie