Create and update an update set in Flow Designer

[Ron28]

I have a table with rows for a number of applications. The table holds config information (JSON format, saved as string) for these application that needs to be validated in the DEV instance prior to getting the validated table row 'promoted' to Pre-PROD etc.

The promotion is to be requested via a Service Catalog Item, where the user selects those records from the table that have been marked as valid. The Catalog Item would trigger a Flow designer flow.

Doing this manually, I would create a local update set, make that my current update set and viewing each item of the table that needs moving to the next system, click 'add to update set'.  I would like to do this automatically in the flow, as the user will have selected records these are passed to the flow in a list.

Then comes the tricky bit. I gather there are no standard actions that do this, and one would need to be scripted. I found old documentation about GlideUpdateManager2 that would be interesting as it is able to add items to an update set. But that no longer appears to work (on  Vancouver).

The update set itself appears just a record in a table, creating one should be ok when the flow is run in global scope. 

My questions are:
- If I can create an update set, how do I make that the current one?
- How can I script adding an item to the update set that was just created?
- Failing that, can I script an xml export of the records that need to be applied to another instance?

Thanks

Ron

[Mani A]

We can use flow designer ..I will come up with solution as its required script

[Ron28]

Thanks for the offer to help with a script. I looked at it and there appear to be a number of system tables involved in update sets so I have abandoned that idea.  Instead, I've gone for a remote table populated via rest message. That gives me a different headache altogether but will raise another question for that.