Bulk request edit via python script invoked from command prompt

Please refer to the below link to install and configure python on the server.

Steps for configuring the script:

Extract the zip in a particular location, eg: <SupportCenterPlus_home>\integration\custom_scripts

Update the app url and technician_key in the script.

Create a Query Report with the below query and save it with a name.

SELECT wo.WORKORDERID AS "workorderid" FROM WorkOrder wo LEFT JOIN WorkOrderStates wos ON wo.WORKORDERID=wos.WORKORDERID LEFT JOIN StatusDefinition std ON wos.STATUSID=std.STATUSID LEFT JOIN WorkOrder_Queue woq ON wo.WORKORDERID=woq.WORKORDERID LEFT JOIN QueueDefinition qd ON woq.QUEUEID=qd.QUEUEID WHERE ( ( ( ( wo.CREATEDTIME < 1689791400000 ) AND ( ( ( wo.CREATEDTIME != 0 ) AND ( wo.CREATEDTIME IS NOT NULL ) ) AND ( wo.CREATEDTIME != -1 ) ) ) AND ( qd.QUEUENAME = 'Cash Desk' ) ) AND ( std.STATUSNAME = 'Closed Quote request' ) ) AND wo.ISPARENT='1'
Please update the above as per your instance in the query and export the report as a csv file.
Save the exported file in the same location as the python file.

Open command prompt with administrator permission and invoke the below command. CMD: py update_requests_csv.py <report_filename>.csv