Flow designer Using power shell with export sets

[VaranAwesomenow]

SourceCode : Flow designer Using power shell with export sets - Share | ServiceNow Developers

Flow designer : Using power shell with export sets 

Usecase : you want to export large data set on daily basis but in ServiceNow all data doesnt change and only new records get added.

Create an export set

Create export target (if trying on personal dev without a midserver) try fix script provided in appendix

Create scheduled data export for the export set

Solution : Create a flow that triggers export set and runs a powershell script after export set is complete.

    Flowtowaituntilexportiscomplete

        apply wait for condition to check if export history for the export set changes state to completed.

    trigger powershell script that combines two files

        create action of type powershell

            powershell script : Get-Content inputFile1.txt, inputFile2.txt | Set-Content joinedFile.txt

    Reference : https://shellgeek.com/powershell-get-content-get-top-lines-of-the-file/#:~:text=In%20PowerShell%20to%20select%20first,10%20lines%20of%20the%20file.

appendix

********

Fix script to set midserver to validated state

var grMid = new GlideRecord('ecc_agent');

grMid.get('a065930a4785591021eaf2e753XXXX'); // update to midserver sysid

grMid.setValue('validated', true);

grMid.setWorkflow(false);

grMid.update();

https://dev111463.service-now.com/nav_to.do?uri=scheduled_data_export.do?sys_id=3f485f0e4785591021eaf2e7536d43c8

//script to execute scheduled export

var sExport = new GlideRecord('scheduled_data_export');

sExport.get('name', 'Dummy export of incidents');

gs.print(sExport.name);

SncTriggerSynchronizer.executeNow(sExport);

//script to run on powershell

Get-Content es_t_incident_20220802093446.csv | Select -First 10

References :

https://servicenowguru.com/scripting/execute-scheduled-jobs-script/

https://docs.servicenow.com/en-US/bundle/sandiego-application-development/page/product/rpa-studio/task/use-general-try-catch.html

https://developer.servicenow.com/dev.do#!/reference/api/orlando/rest/r_AttachmentAPI-POST