{"replacementParameters":{"adminusername":"User Name of the admin","adminuserpassword":"Password of the admin"},"subscribedEvents":[],"processCoordinator":"BasicIntegrationProcessCoordinator","dataFlow":[{"name":"APIDataFetchMediator","properties":{"oauthConfig":true,"oauthConfigData":{"grantType":"password","client_id":"public_rest_api_client","client_secret":"","scope":"","url":"https://[systemURL]/index.php/oauth/issueToken","redirect_uri":"","state":"","username":"##adminusername##","password":"##adminuserpassword##","refresh_token":""},"method":"get","parameters":[],"parametersDataPath":[],"expectedResponseCode":"200","additionalHeaders":[],"dataURl":"https://[systemURL]/index.php/api/exportReportData/uniqueName/pim.Employee_Salary_Report/format/csv/culture/en","aggregatedFieldName":"","dataConvertConfig":{"from":"csv","to":"phpArray"},"aggregatedDataSet":"message"}},{"name":"BulkDataProcessMediator","properties":{"arrayPath":[],"iterativeVariables":[],"mediators":[{"name":"DataAggregateMediator","properties":{"aggregations":[{"aggregateFields":[{"fieldName":"Personal-Employee Last Name","fieldPath":[],"removeField":false,"value":""}],"separator":" ","aggregatedField":{"fieldName":"lastName","fieldPath":[]}},{"aggregateFields":[{"fieldName":"Personal-Employee First Name","fieldPath":[],"removeField":false,"value":""}],"separator":" ","aggregatedField":{"fieldName":"firstName","fieldPath":[]}},{"aggregateFields":[{"fieldName":"Job-Job Title","fieldPath":[],"removeField":false,"value":""}],"separator":" ","aggregatedField":{"fieldName":"Job Title","fieldPath":[]}},{"aggregateFields":[{"fieldName":"Job-Employment Status","fieldPath":[],"removeField":false,"value":""}],"separator":" ","aggregatedField":{"fieldName":"Employment Status","fieldPath":[]}},{"aggregateFields":[{"fieldName":"Job-Joined Date","fieldPath":[],"removeField":false,"value":""}],"separator":" ","aggregatedField":{"fieldName":"Joined Date","fieldPath":[]}},{"aggregateFields":[{"fieldName":"Job-Sub Unit","fieldPath":[],"removeField":false,"value":""}],"separator":" ","aggregatedField":{"fieldName":"Sub Unit","fieldPath":[]}},{"aggregateFields":[{"fieldName":"Job-Location","fieldPath":[],"removeField":false,"value":""}],"separator":" ","aggregatedField":{"fieldName":"Location","fieldPath":[]}},{"aggregateFields":[{"fieldName":"Salary-Pay Grade","fieldPath":[],"removeField":false,"value":""}],"separator":" ","aggregatedField":{"fieldName":"Pay Gread","fieldPath":[]}},{"aggregateFields":[{"fieldName":"Salary-Currency","fieldPath":[],"removeField":false,"value":""}],"separator":" ","aggregatedField":{"fieldName":"Currency","fieldPath":[]}},{"aggregateFields":[{"fieldName":"Salary-Effective Date","fieldPath":[],"removeField":false,"value":""}],"separator":" ","aggregatedField":{"fieldName":"Effective Date","fieldPath":[]}},{"aggregateFields":[{"fieldName":"Salary-All Earnings/Deductions","fieldPath":[],"removeField":false,"value":""}],"separator":" ","aggregatedField":{"fieldName":"All Earnings/Deductions","fieldPath":[]}}]}},{"name":"DataFilterMediator","properties":{"filterType":"include","dataFields":[{"fieldName":"firstName","fieldPath":[]},{"fieldName":"lastName","fieldPath":[]},{"fieldName":"Job Title","fieldPath":[]},{"fieldName":"Employment Status","fieldPath":[]},{"fieldName":"Joined Date","fieldPath":[]},{"fieldName":"Sub Unit","fieldPath":[]},{"fieldName":"Location","fieldPath":[]},{"fieldName":"Pay Gread","fieldPath":[]},{"fieldName":"Currency","fieldPath":[]},{"fieldName":"Effective Date","fieldPath":[]},{"fieldName":"All Earnings/Deductions","fieldPath":[]}]}}]}},{"name":"DataTypeConvertMediator","properties":{"from":"phpArray","to":"json"}},{"name":"FileDataDispatchMediator","properties":{"filePath":"/tmp/reportData.json","flag":""}}]}