Flow designer update multiple record not work working network adaptor table.

[Ajay16]

Hello,

I am using "Update Multiple Records" action in flow designer to update multiple records network adaptor table. I actually want to make Configuration Item empty through it.

I have added below step in flow designer.

I am making Configuration Item and Mac manufacturer empty through script(as keeping it empty also not working).

When I look at one of the updated record, It shows that 3 marked fields have updated. However, it should have updated CI to empty but it is not doing it.

What could be the issue?

Note : I am able to make it empty on form or through script.

Any help would be appreciated.

[Voona Rohila]

Hi ajay

can you share the script you wrote to map ci value.

[Ajay16]

Hi Roila,

Here it is,

[Muralidharan BS · Accepted solution]

Hi Ajay,

If you run the below update multiple in the background script it still won't work. 

var grCmdbCiNetworkAdapter = new GlideRecord('cmdb_ci_network_adapter');
grCmdbCiNetworkAdapter.addEncodedQuery("cmdb_ci=a9a2d111c611227601fb37542399caa8");
grCmdbCiNetworkAdapter.cmdb_ci = '';
grCmdbCiNetworkAdapter.updateMultiple();

This has to be updated via lookup records, for loop and update each record (like below).

This should work.

Thanks

[Ajay16]

Hi Murali,

Yes, I did test the similar script in background script and updatemultiple methos is not working, looks like some system issue.

However, if we try the same with update method then it works, this is the reason I created my own general custom action "Update Multiple Records Custom" where we can pass table name, encoded query, field name and its value and this will update records. I have written script inside the action which uses update method and it works fine.

Thanks for your help BTW.

Regards

Ajay