Follow my colleagues' discussions:https://community.automic.com/discussion/11158/ae-12-1-test-automation-engine-rest-api-with-soap-ui-beginner-levelhttps://community.automic.com/discussion/10794/getting-started-with-the-rest-api-for-automic-v12-1I have a task related to this topic and I want to share what I did, hopefully it will help someone.How it look like: $row[VALUE2]/$row[VALUE3] show up because I change the code to an non-existed database.
My Target: 1/ Create a webpage that allowed user to input value/ choose value from a drop-down (populate data from a SQL database).2/ Based on user input, when they click the "Transfer Information" button all the information will send to AE server and execute a specific job. 3/ Show the result (JOB's runID or Error message) which returned from AE Server.Requirement:- Automation Engine v12.1 and above (Active JCP/JWP) - Database server: I'm using MSSQL 12- Web hosting (PHP): In my case, I'm using XAMPP in Windows. So I need to install: + ODBC MSSQL clienthttps://us.v-cdn.net/5019921/uploads/editor/3b/wug72djo0y16.png" width="612">+ Accessing SQL Server Databases with PHP:++ https://github.com/Microsoft/msphpsql/releasesCopy to C:\xampp\php\ext++ Config the PHP.ini file:
The code:I'm not a developer, so the code might look stupid and not clean =) Please download the attachment for that.- index.php: + AE Prompt-set variable:
+ Authorization: Basic ************=I took this from Postman. To be honest, I still can't figure out how to send the NAME/DEPARTMENT with PASSWORD directly to AE server. Looking for some suggestion :) https://us.v-cdn.net/5019921/uploads/editor/aa/2lnqj2lpji56.jpg" width="1045">- config.php: Connect to the database