BPA – Process Automation for Project Team Assignments

Hi Experts,

I am looking for custom process automation to build and this is for SAP Business ByDesign. The need is this as follows

1. Trigger a Bot (Planning to have this scheduled for a particular time in the day to trigger and execute)

2. Query the Projects (SOAP Web services) in ByDesign for a specific list of projects to consider for automation

3. Connect to a Sharepoint site and locate an Excel that has a list of employees to be assigned to the project

4. Loop in the project from the query service response (step 1) and assign the team found in the Excel to those project headers

5. Set a flag (extension field) on the header that the team is assigned for the users to review and release the project

Can the above process be achieved via BPA for ByDesign?

I need the BoT to trigger automatically on a daily or periodic basis (time frame yet to be decided) and once the BoT is triggered the above process steps to be automated by the BoT.

how can I achieve the above process automation?

Attended Bot or Unattended Bot?

API-based Bot or UI Navigation Bot?

Is SOAP supported or ODATA supported in BPA?

 

Our goal is to achieve this in the backend without having any interruptions to the end users or anyone from the team. We are stuck on the flow and implementing this, need expert advice and steps to fulfill our need.

Any content or materials, video references, or blogs that help me to develop this process automation is helpful for us.

Please help and appreciate your support and guidance here.

Thank you,

Hanu

Scroll to Top