UPDATE `ohrm_external_integration_process` SET `configuration` = '{"replacementParameters":{"client_id":"Oauth client id","client_secret":"Oauth client secret"},"subscribedEvents":[],"processCoordinator":"BasicIntegrationProcessCoordinator","dataFlow":[{"name":"APIDataFetchMediator","properties":{"oauthConfig":true,"oauthConfigData":{"grantType":"client_credentials","client_id":"##client_id##","client_secret":"##client_secret##","scope":"","url":"https://[systemURL]/index.php/oauth/issueToken","redirect_uri":"","state":"","username":"","password":"","refresh_token":""},"method":"get","parameters":[{"parameterName":"limit","fieldName":"limit","fieldPath":[]},{"parameterName":"offset","fieldName":"offset","fieldPath":[]}],"parametersDataPath":["filters"],"expectedResponseCode":"200","additionalHeaders":[],"dataURl":"https://[systemURL]/index.php/api/exportReportData/uniqueName/Changed_Employee_Information_Export_Report/format/csv/culture/en/limit/[limit]/offset/[offset]","aggregatedFieldName":"employeeData","dataConvertConfig":{"from":"csvArray","to":"phpArray"},"aggregatedDataSet":"message"}},{"name":"ArrayManipulateMediator","properties":{"arrayFormats":[{"formatName":"mergeArrayValues","properties":{"arrayPath":["employeeData"],"aggregatedFieldName":"Employee Name","fieldPath":[],"fieldNames":["Personal-Employee First Name","Personal-Employee Last Name"]}},{"formatName":"changeArrayValues","properties":{"arrayPath":["employeeData"],"aggregatedFieldName":"Email","fieldPath":[],"fieldNames":["Personal-Employee Email"]}},{"formatName":"changeArrayValues","properties":{"arrayPath":["employeeData"],"aggregatedFieldName":"Job Title","fieldPath":[],"fieldNames":["Job-Job Title"]}},{"formatName":"changeArrayValues","properties":{"arrayPath":["employeeData"],"aggregatedFieldName":"Sub Unit","fieldPath":[],"fieldNames":["Job-Sub Unit"]}},{"formatName":"changeArrayValues","properties":{"arrayPath":["employeeData"],"aggregatedFieldName":"Location","fieldPath":[],"fieldNames":["Job-Location"]}},{"formatName":"changeArrayValues","properties":{"arrayPath":["employeeData"],"aggregatedFieldName":"Employment Status","fieldPath":[],"fieldNames":["Job-Employment Status"]}},{"formatName":"changeArrayValues","properties":{"arrayPath":["employeeData"],"aggregatedFieldName":"Basic Salary","fieldPath":[],"fieldNames":["Personal-Employee Basic Salary"]}},{"formatName":"changeArrayValues","properties":{"arrayPath":["employeeData"],"aggregatedFieldName":"Contract Start Date","fieldPath":[],"fieldNames":["Job-Contract Start Date"]}},{"formatName":"changeArrayValues","properties":{"arrayPath":["employeeData"],"aggregatedFieldName":"Contract End Date","fieldPath":[],"fieldNames":["Job-Contract End Date"]}},{"formatName":"changeArrayValues","properties":{"arrayPath":["employeeData"],"aggregatedFieldName":"Employee Number","fieldPath":[],"fieldNames":["Personal-Employee Id"]}},{"formatName":"changeArrayValues","properties":{"arrayPath":["employeeData"],"aggregatedFieldName":"Job Category","fieldPath":[],"fieldNames":["Job-Job Category"]}},{"formatName":"changeArrayValues","properties":{"arrayPath":["employeeData"],"aggregatedFieldName":"Employee Name","fieldPath":[],"fieldNames":["Personal-Employee First Name Personal-Employee Last Name"]}}]}},{"name":"ArrayValidationMediator","properties":{"validatingData":{"dataPath":["employeeData"]},"nonValidatingSubArrays":{"arrayIndexes":[0]},"validations":[{"fieldName":"Employee Name","fieldPath":[],"fieldIndex":1,"validationParameters":[{"validatorName":"notEmpty","params":[]},{"validatorName":"stringType","params":[]},{"validatorName":"length","params":[0,10]}],"warningAndProceed":true},{"fieldName":"Email","fieldPath":[],"fieldIndex":2,"validationParameters":[{"validatorName":"notEmpty","params":[]},{"validatorName":"email","params":[]}],"warningAndProceed":true},{"fieldName":"Location","fieldPath":[],"fieldIndex":7,"validationParameters":[{"validatorName":"notEmpty","params":[]}],"warningAndProceed":true},{"fieldName":"Employment Status","fieldPath":[],"fieldIndex":4,"validationParameters":[{"validatorName":"notEmpty","params":[]}],"warningAndProceed":true},{"fieldName":"Job Title","fieldPath":[],"fieldIndex":3,"validationParameters":[{"validatorName":"notEmpty","params":[]},{"validatorName":"stringType","params":[]},{"validatorName":"length","params":[0,10]}],"warningAndProceed":true}]}},{"name":"ArrayLocalizationMediator","properties":{"dataPath":["employeeData"],"nonLocalizingSubArrays":{"arrayIndexes":[0]},"localizations":[]}}]}' WHERE `name` = 'ChangedEmployeeReportGeneration';