For new APIs and anything being set up for prod services in LEAP TEST and PROD:
-Mark Wiggins will need to set up the service with Netscaler and the DNS Name along with updating or modifying new certificates
-Specifically for the error we were receiving with this, Mark had to modify the certificate in regards to:
- For multi-domain certificates, the option to choose should be 'InCommon Multi Domain SSL (SHA-2)'
- Hostnames listed should also be separated by commas (api.dtw.uconn.edu, api.travel.uconn.edu)
- Mark will also need to know the port
-Specifically for LEAP , any new certificates created will need to be added to WebSphere
-Any new Domain names created will need to be added to WebSphere Whitelist
-Action updated for the method used (GET, POST, PUT, DELETE)
-A useful tool to use for checking the services for any certificate issues is:
https://www.ssllabs.com/ssltest/analyze.html?d=prd.aeweb.uconn.edu
| API Endpoint URLs (RESTful) | Description | Type | Inputs | Outputs | Applications Utilized *note, some endpoints may exist in applications other than stated, but are not used. |
|---|---|---|---|---|---|
For NetScaler: https://api.finance.uconn.edu/webapi/departments/listDepartments OLD AIX: https://prd.aeweb.uconn.edu:8055/webapi/departments/listDepartments | Returns a list of all KFS Departments | GET | orgCode orgName headNetId location typeName reportsToOrgCd message | EnterpriseFinancialsSystemAccessRequest Concur Role Access Request | |
For NetScaler: https://api.finance.uconn.edu/webapi/departments/findByCode/1515 OLD AIX: https://prd.aeweb.uconn.edu:8055/webapi/departments/findByCode/1515 | Look up orgCode and return department info | GET | orgCode | orgCode orgName headNetId location typeName reportsToOrgCd message headName headEmail title | EnterpriseFinancialsSystemAccessRequest University Expense Card Request Concur Role Access Request |
For NetScaler: https://api.finance.uconn.edu/webapi/ldapSearch/byNetIdorName?netId=pam16105&lastName=Klaben&firstName=James | ldap search with GET method to search LDAP. This search can be done with first/last/NetID and also accepts wild card searches (*). | GET | netId lastName firstName | netId lastName firstName deptName deptNumber phoneNumber fullName | Enterprise Financials System Access - System Review Concur Role Access Request |
| https://api.travel.uconn.edu/travelwebapis/usersSupervisor/byLogin/jtk17003 | Lookup employee information with NetID through the information provided by Core and LDAP. Dylan has a program which combines they information and sends it to the Enterprise Financials table. An array is also maintained where if Thomas Katsouleas is Supervisor, update Supervisor to Michael Kirk (mik05001). If a supervisor is missing, the supervisor will be populated with the department head (if a value exists). | GET | netID | employee / createdBy employee / createdDate employee / updatedBy employee / updatedDate employee / employeeID employee / loginID employee / firstName employee / lastName employee / jobTitle employee / workPhone employee / emailAddress employee / supervisorID employee / terminationDate employee / travelClass employee / travelerType employee / groupHierarchy employee / orgCode1 employee / orgCode2 employee / orgCode3 employee / orgCode4 employee / orgCode5 employee / orgCode6 employee / unionCode employee / exPreqApprover employee / location employee / country employee / address1 employee / address2 employee / address3 employee / address4 employee / city employee / county employee / state employee / postal supervisor / createdBy supervisor / createdDate supervisor / updatedBy supervisor / updatedDate supervisor / employeeID supervisor / loginID supervisor / firstName supervisor / lastName supervisor / jobTitle supervisor / workPhone supervisor / emailAddress supervisor / supervisorID supervisor / terminationDate supervisor / travelClass supervisor / travelerType supervisor / groupHierarchy supervisor / orgCode1 supervisor / orgCode2 supervisor / orgCode3 supervisor / orgCode4 supervisor / orgCode5 supervisor / orgCode6 supervisor / unionCode supervisor / exPreqApprover supervisor / location supervisor / country supervisor / address1 supervisor / address2 supervisor / address3 supervisor / address4 supervisor / city supervisor / county supervisor / state supervisor / postal | University Expense Card Request Concur Role Access Request |
| TBD- not used - https://kualinp.uconn.edu/kfs-dev/huskybuy/disableErpSync | Accepts XML POST to disable HuskyBuy supplier ERP Sync in HuskyBuy **requires the sharedsecret to be passed which HuskyBuy needs for verification** | POST | supplierID supplierName | TestSupplierSyncDeactivation | |
For NetScaler: https://api.finance.uconn.edu/webapi/generatePaymentReport DEV: https://dev.api.finance.uconn.edu/webapi/generatePaymentReport PRD: https://prd.aeweb.uconn.edu:8055/webapi/generatePaymentReport | Accepts XMLHTTPRequest object array and returns blob data type. | POST | monthEnding companyName projectName awardingAgencyName projectNumber smbe mobilizationDate projectValue percentComplete finalReport completionDate reportEntryDate printedAuthorizedSignature //texbox array list for table company dasCode contractAmount monthlyPayment paymentToDate | USDP Status Report System | |