Sample Javascript usage of webservices
Sample PHP usage of webservices
Generic Web ServicesNote: To use the api/index.php to access FAMIS data a key parameter is required. Please contact the technical team if you need a key generated for your access. |
Test call to make sure the basics of the webservice are working | ||
Method | Parameters | Example Output | Logic |
Processed/Summary Data | |||
HELLO | format=json | {“code”:1, “status”:200, “data”:”Hello World”} | |
Facilities Related Web ServicesNote: To use the api/index.php to access FAMIS data a key parameter is required. Please contact the technical team if you need a key generated for your access. |
|||
Method | Parameters | Example Output | Logic |
Processed/Summary Data | |||
BACKLOG_BY_CREW | format=json value=HVAC |
[{"THIS_MTH_BACK":"635", "ONE_MTH_AGO_BACK":"625", "TWO_MTH_AGO_BACK":"1039", "THREE_MTH_AGO_BACK":"872", "FOUR_MTH_AGO_BACK":"620", "FIVE_MTH_AGO_BACK":"346", "SIX_MTH_AGO_BACK":"2406", "SEVEN_MTH_AGO_BACK":"2192", "EIGHT_MTH_AGO_BACK":"2152", "NINE_MTH_AGO_BACK":"1930", "TEN_MTH_AGO_BACK":"1809", "ELEVEN_MTH_AGO_BACK":"1629", "TWELVE_MTH_AGO_BACK":"1698", "ERA":"NOW", "Name":"HVAC"}, {"THIS_MTH_BACK":"1698", "ONE_MTH_AGO_BACK":"1632", "TWO_MTH_AGO_BACK":"1392", "THREE_MTH_AGO_BACK":"1178", "FOUR_MTH_AGO_BACK":"1086", "FIVE_MTH_AGO_BACK":"1011", "SIX_MTH_AGO_BACK":"1225", "SEVEN_MTH_AGO_BACK":"1298", "EIGHT_MTH_AGO_BACK":"1161", "NINE_MTH_AGO_BACK":"874", "TEN_MTH_AGO_BACK":"800", "ELEVEN_MTH_AGO_BACK":"643", "TWELVE_MTH_AGO_BACK":"537", "ERA":"LAST", "Name":"HVAC"}] |
Finds how many work orders were in a 90+ day state at the first of the specified month grouped by CREW.There are are two ERA’s. “NOW” is the current year and “LAST” is the previous year. |
Detailed Lists | |||
ACT_ASSIGNED | format=json value=PCA03002 |
[{"WO":"M591983", "DESCRIPTION":"INSTALL DROP CEILING (TASKS)", "STATUS":"ASSIGNED", "ASSIGNED_TO":"PCA03002", "NAME":"TORREY LIFE SCIENCES BUILDING", "FLOOR":"03", "ROOM_BILLING_ID": "147307", "ROOM":"303", "ENTER_DATE":"07-22-2014", "MAINT_TYPE":"CORRECTIVE"}, {"WO":"M619933", "DESCRIPTION":"REPAIR CEILING AND\/OR WALL DAMAGE DUE TO LEAK", "STATUS":"ASSIGNED", "ASSIGNED_TO":"PCA03002", "NAME":"HILLTOP APT-H.B.STOWE BLDG#11", "FLOOR":"03", "ROOM_BILLING_ID":"163428", "ROOM":"304", "ENTER_DATE":"03-15-2015", "MAINT_TYPE":"CORRECTIVE"}] |
|
LABOR_DETAILS | format=json value=WO_NUMBER,PAY_CODE range=M630937,REGULAR |
[{"CREW":"HVAC","EMPLOYEE":"GSS02003","ENTER_DATE":"30-OCT-15","WORK_DATE":"27-OCT-15","WO_NUMBER":"M630937","DESCRIPTION":"REPAIRED HEAT.","FACTOR":"1","HOURS":"2","LABOR_STATUS":"S APPROVE","PAY_CODE":"REGULAR","SHIFT":"1"},{"CREW":"HVAC","EMPLOEE":"GSS02003","ENTER_DATE":"07-NOV-15","WORK_DATE":"30-OCT-15","WO_NUMBER":"M630937","DESCRIPTION":"REPAIRED HEAT.","FACTOR":"1","HOURS":"1","LABOR_STATUS":"S APPROVE","PAY_CODE":"REGULAR","SHIFT":"1"},{"CREW":"HVAC","EMPLOEE":"GSS02003","ENTER_DATE":"19-NOV-15","WORK_DATE":"16-NOV-15","WO_NUMBER":"M630937","DESCRIPTION":"REPAIRED HEAT","FACTOR":"1","HOURS":"3","LABOR_STATUS":"S APPROVE","PAY_CODE":"REGULAR","SHIFT":"1"},{"CREW":"HVAC","EMPLOEE":"GSS02003","ENTER_DATE":"19-NOV-15","WORK_DATE":"17-NOV-15","WO_NUMBER":"M630937","DESCRIPTION":"REPAIRED HEAT","FACTOR":"1","HOURS":"3","LABOR_STATUS":"S APPROVE","PAY_CODE":"REGULAR","SHIFT":"1"}] |
Place the comma separated field name(s) to filter on the value field & the comma separated value(s) in the range field to get matching data |
WORK_ORDER_LITE | format=json value=WO_NUMBER range=M358732 |
[{"ASSIGNED_TO":"THH04003","BUILDING":"0213","COMPLETE_DATE":"09-JUN-10","CREW":"ZONE 1","DEPARTMENT":"50925AA","DESCRIPTION":"INSTALL CONDENSER LINE IN UNION STREET MARKET","DUE_DATE":"05-FEB-10","EMAIL":"CHUCK.MORRELL@UCONN.EDU","ENTER_DATE":"04-FEB-10","ENTER_USER":"FSSUCON101","MODIFY_DATE":"14-JUN-10","MODIFY_USER":"EYC08001","PRIORITY":"2","REQUESTOR":"MORRELL, CHARLES V","TELEPHONE":"(860) 486-3422","WO_CLOSE_DATE":"11-JUN-10","WO_NUMBER":"M358732","WO_STATUS":"CLOSED","EQUIPMENT":null,"FLOOR":null,"ROOM":null}] |
Place the comma separated field name(s) to filter on the value field & the comma separated value(s) in the range field to get matching data |
CREWED_EMPS | format=json value=ACTIVE |
[{"NETID":"JRG03004","FULL_NAME":"GIACCONE, JULIUS R","JOB_TITLE":"GENERAL TRADES WORKER","REPORTS_TO":"RISTAU, ARISTIDE","CREW":"GEN MNTC","CRAFT":"GEN MNTC","SHIFT":"1","DEPARTMENT":"OFFICE OF RESIDENTIAL LIFE","STATUS":"INACTIVE","TERMINATION_DATE":"03-JUN-15","PAYROLL_NUMBER":"551082","EMAIL":"JULIUS.GIACCONE@UCONN.EDU","TELEPHONE":"(860) 486-5556"},{"NETID":"DEC02006","FULL_NAME":"CHAMBERLAND, DEAN E","JOB_TITLE":"WASTE WATER TREATMENT TECH","REPORTS_TO":"MATTHEWSON, TODD A","CREW":"WPCF","CRAFT":"WPC","SHIFT":"1","DEPARTMENT":"FACILITIES INFRASTRUCTURE SERVICES","STATUS":"INACTIVE","TERMINATION_DATE":"01-AUG-15","PAYROLL_NUMBER":"402865","EMAIL":"DEAN.CHAMBERLAND@UCONN.EDU","TELEPHONE":"(860) 486-7106"},{"NETID":"TLT05003","FULL_NAME":"TUSSING, TIMOTHY L","JOB_TITLE":"MANAGER - UTILITIES","REPORTS_TO":"PACHOLSKI, MICHAEL J","CREW":"ADMIN","CRAFT":null,"SHIFT":"1","DEPARTMENT":"FACILITIES INFRASTRUCTURE SERVICES","STATUS":"INACTIVE","TERMINATION_DATE":"28-MAY-15","PAYROLL_NUMBER":"027040","EMAIL":"TIMOTHY.TUSSING@UCONN.EDU","TELEPHONE":"(860) 486-2608"}] |
In the value field, enter the Employee status and it will return all employees who have crew assignments in FAMIS with that status |
PRINT_WO_FLAG | format=json value=M620851 |
[{"message":"Success"}] |
|
REFRESH_PRINT_WO_FLAG | format=json value=M620851 |
[{"message":"Success"}] |
|
Space Related Web Services |
|||
Method | Parameters | Example Output | |
NEAREST_BUILDING (test on production) (test on test) (test on dev) |
format=json lat=41.80631261271258 lon=-72.25148302786354 |
[{"BUILDING":"BABBIDGE LIBRARY (HOMER)","BLDG_CODE":"0364","DISTANCE_m":".0000293585280815023"},{"BUILDING":"EXIT FOR UNDERGROUND CLASSROOM AREA","BLDG_CODE":null,"DISTANCE_m":".0000910354932557311"},{"BUILDING":"WHETTEN GRADUATE CENTER","BLDG_CODE":"0324","DISTANCE_m":".000314255524926921"},{"BUILDING":"INFORMATION TECHNOLOGY BUILDING","BLDG_CODE":"0434","DISTANCE_m":".00049071690727942"},{"BUILDING":"DODD RESEARCH CENTER (THOMAS J)","BLDG_CODE":"0383","DISTANCE_m":".000652384728709876"},{"BUILDING":"COLCHESTER GRAD DORM","BLDG_CODE":"0333C","DISTANCE_m":".00075614539741764"},{"BUILDING":"DERBY GRAD DORM","BLDG_CODE":"0333D","DISTANCE_m":".000887314362557845"},{"BUILDING":"BRANFORD GRAD DORM","BLDG_CODE":"0332B","DISTANCE_m":".000952355742015243"},{"BUILDING":"OAK HALL","BLDG_CODE":"0486","DISTANCE_m":".00104277710670431"}] |
|
SPACE_METRICS_UNIT_BY_BLDG (test on dev) |
format=json value=2120 |
[{"NUM_ROOMS":"171","NASF":"51910","PERCENT":"23","FACILITY_NAME":"INFORMATION TECHNOLOGY BUILDING"},{"NUM_ROOMS":"103","NASF":"37226","PERCENT":"16","FACILITY_NAME":"CASTLEMAN BUILDING (ENG. I)"},{"NUM_ROOMS":"126","NASF":"37771","PERCENT":"16","FACILITY_NAME":"ENGINEERING II"},{"NUM_ROOMS":"98","NASF":"24695","PERCENT":"11","FACILITY_NAME":"UNITED TECHNOLOGIES ENG BLDG"},{"NUM_ROOMS":"60","NASF":"22338","PERCENT":"10","FACILITY_NAME":"DEPOT - LONGLEY SCHOOL"},{"NUM_ROOMS":"56","NASF":"20072","PERCENT":"9","FACILITY_NAME":"BRONWELL BUILDING (ARTHUR B.)"},{"NUM_ROOMS":"36","NASF":"13514","PERCENT":"6","FACILITY_NAME":"BABBIDGE LIBRARY (HOMER)"},{"NUM_ROOMS":"30","NASF":"12052","PERCENT":"5","FACILITY_NAME":"DEPOT- FUEL CELL INSTITUTE BUILDING"},{"NUM_ROOMS":"12","NASF":"7374","PERCENT":"3","FACILITY_NAME":"DEPOT- MERRITT HALL"},{"NUM_ROOMS":"2","NASF":"1285","PERCENT":"1","FACILITY_NAME":"DEPOT- Depot D CT Adv. Pavement Lab"},{"NUM_ROOMS":"3","NASF":"1751","PERCENT":"1","FACILITY_NAME":"HYDRAULIC LAB-ENG,PNK RAV"}] |
|
SPACE_METRICS_UNIT_BY_DEPT (test on dev) |
format=json value=2120 |
[{"NUM_ROOMS":"119","NASF":"39081","PERCENT":"17","DEPT_NAME":"ELECTRICAL & CPTR ENGR"},{"NUM_ROOMS":"102","NASF":"39060","PERCENT":"17","DEPT_NAME":"ENGINEERING DEAN OFC"},{"NUM_ROOMS":"125","NASF":"35763","PERCENT":"16","DEPT_NAME":"MECHANICAL ENGR"},{"NUM_ROOMS":"84","NASF":"28619","PERCENT":"12","DEPT_NAME":"CIVIL & ENVIRON ENG"},{"NUM_ROOMS":"83","NASF":"24437","PERCENT":"11","DEPT_NAME":"CHEMICAL & BIOMOLECULAR"},{"NUM_ROOMS":"77","NASF":"21854","PERCENT":"10","DEPT_NAME":"COMPUTER SCIENCE & ENGR"},{"NUM_ROOMS":"50","NASF":"21247","PERCENT":"9","DEPT_NAME":"CTR CLEAN ENERGY ENGINEER"},{"NUM_ROOMS":"29","NASF":"10874","PERCENT":"5","DEPT_NAME":"CT TRANSPORTATION INST"},{"NUM_ROOMS":"11","NASF":"4964","PERCENT":"2","DEPT_NAME":"MATERIALS SCI & ENGINEER"},{"NUM_ROOMS":"12","NASF":"3332","PERCENT":"1","DEPT_NAME":"PRECISION MANUFACT CTR"},{"NUM_ROOMS":"2","NASF":"279","PERCENT":"0","DEPT_NAME":"ENGINEERING DIVERSTY PROG"},{"NUM_ROOMS":"2","NASF":"256","PERCENT":"0","DEPT_NAME":"CHEM MAT & BIOMOL ENGR"},{"NUM_ROOMS":"1","NASF":"222","PERCENT":"0","DEPT_NAME":"GRINDING CTR"}] |
|
SPACE_METRICS_UNIT_BY_DEPT_BY_BLDG (test on dev) |
format=json value=2120 |
[{"NUM_ROOMS":"20","NASF":"25795.33","BUIDING":"HAWLEY ARMORY","DEPT_NAME":"ALLIED HLTH PT"},{"NUM_ROOMS":"1","NASF":"5.18","BUIDING":"KOONS HALL","DEPT_NAME":"ALLIED HEALTH INSTR & RES"},{"NUM_ROOMS":"1","NASF":"112.97","BUIDING":"TORREY LIFE SCIENCES BUILDING","DEPT_NAME":"ALLIED HLTH PT"}] |
|
SPACE_METRICS_UNIT_BY_DEPT_BY_TYPE (test on dev) |
format=json value=2120 |
[{"NUM_ROOMS":"21","NASF":"3816.65","PERCENT":"1.1","BUILDING":"Office Facilities","DEPT_NAME":"AGRI & RESOURCE ECONOMICS"},{"NUM_ROOMS":"1","NASF":"1214.9","PERCENT":".35","BUILDING":"Classroom Facilities","DEPT_NAME":"AGRI & RESOURCE ECONOMICS"},{"NUM_ROOMS":"2","NASF":"768.77","PERCENT":".22","BUILDING":"Laboratory Facilities","DEPT_NAME":"AGRI & RESOURCE ECONOMICS"},{"NUM_ROOMS":"5","NASF":"973.32","PERCENT":".28","BUILDING":"Office Facilities","DEPT_NAME":"AGRI EXPERIMENT STATION"},{"NUM_ROOMS":"1","NASF":"168.92","PERCENT":".048","BUILDING":"Office Facilities","DEPT_NAME":"AGRI PUBLICATIONS OFC"},{"NUM_ROOMS":"47","NASF":"10772.87","PERCENT":"3.1","BUILDING":"Office Facilities","DEPT_NAME":"AGRI, HLTH & NAT RCS DEAN"},{"NUM_ROOMS":"38","NASF":"8625.79","PERCENT":"2.5","BUILDING":"Laboratory Facilities","DEPT_NAME":"AGRI, HLTH & NAT RCS DEAN"},{"NUM_ROOMS":"5","NASF":"1034.55","PERCENT":".3","BUILDING":"Support Facilities","DEPT_NAME":"AGRI, HLTH & NAT RCS DEAN"},{"NUM_ROOMS":"5","NASF":"867.3","PERCENT":".25","BUILDING":"Special Use Facilities","DEPT_NAME":"AGRI, HLTH & NAT RCS DEAN"},{"NUM_ROOMS":"4","NASF":"668.01","PERCENT":".19","BUILDING":"General Use Facilities","DEPT_NAME":"AGRI, HLTH & NAT RCS DEAN"},{"NUM_ROOMS":"2","NASF":"153.91","PERCENT":".044","BUILDING":"UNCLASSIFIED FACILITIES","DEPT_NAME":"AGRI, HLTH & NAT RCS DEAN"}] |
|
SPACE_UNITS (test on dev) |
format=json |
[{"UNIT_NAME":"AG, HEALTH & NAT RCS"},{"UNIT_NAME":"ALLIED HEALTH"},{"UNIT_NAME":"ATHLETICS"},{"UNIT_NAME":"AVERY PT REG CAMPUS"},{"UNIT_NAME":"BUSINESS"},{"UNIT_NAME":"CTR CONTINUING STUD"},{"UNIT_NAME":"DINING SERVICES"},{"UNIT_NAME":"ECONOMIC DEVELOPMENT"},{"UNIT_NAME":"EDUCATION"},{"UNIT_NAME":"ENGINEERING"},{"UNIT_NAME":"ENROLL PLAN & MGMT"},{"UNIT_NAME":"EXEC VPRES HEALTH AF"},{"UNIT_NAME":"EXVP ADMIN & CFO"},{"UNIT_NAME":"FACILITIES OPERATION"},{"UNIT_NAME":"FINE ARTS"},{"UNIT_NAME":"GLOBAL AFFAIRS"},{"UNIT_NAME":"HARTFORD REG CAMPUS"},{"UNIT_NAME":"HEALTH SERVICES"},{"UNIT_NAME":"HR & PAYROLL"},{"UNIT_NAME":"LAW"},{"UNIT_NAME":"LIB ARTS & SCIENCES"},{"UNIT_NAME":"LOGISTICS ADMIN"},{"UNIT_NAME":"NURSING"},{"UNIT_NAME":"OFC OF VP & COO"},{"UNIT_NAME":"OFFICE OF CONTROLLER"},{"UNIT_NAME":"PLAN, ARCH, ENG SVCS"},{"UNIT_NAME":"PRESIDENT"},{"UNIT_NAME":"PROCUREMT & LOG SERV"},{"UNIT_NAME":"PROV & EXVP ACAD AFF"},{"UNIT_NAME":"PUBLIC SAFETY"},{"UNIT_NAME":"RESIDENTIAL LIFE"},{"UNIT_NAME":"SCHOOL OF PHARMACY"},{"UNIT_NAME":"SOCIAL WORK"},{"UNIT_NAME":"STAMFORD REG CAMPUS"},{"UNIT_NAME":"STUDENT ACTIVITIES"},{"UNIT_NAME":"STUDENT UNION"},{"UNIT_NAME":"TORRINGTON REG CAMP"},{"UNIT_NAME":"U-CETL AVP"},{"UNIT_NAME":"U-INFRA & PROJ MGMT"},{"UNIT_NAME":"UNDERGRAD EDUCATION"},{"UNIT_NAME":"UNIV INFO TECH SVCS"},{"UNIT_NAME":"UNIVERSITY COMMUNICA"},{"UNIT_NAME":"UNIVERSITY LIBRARIES"},{"UNIT_NAME":"VP FOR RESEARCH"},{"UNIT_NAME":"VPRES STUDENT AFF"},{"UNIT_NAME":"VPROV MULTICULT AFF"},{"UNIT_NAME":"VPROV RES & GRAD ED"},{"UNIT_NAME":"WATERBURY REG CAMPUS"}] |
|
SPACE_METRICS_UNIT_BY_CATS (test on dev) |
format=json value=2120 |
[{"NUM_ROOMS":"115","NASF":"80705","PERCENT":"23","CAT_NAME":"Field Bldg","FICM":"560"},{"NUM_ROOMS":"127","NASF":"52852","PERCENT":"15","CAT_NAME":"RESEARCH LABORATORY","FICM":"250"},{"NUM_ROOMS":"161","NASF":"28163","PERCENT":"8.1","CAT_NAME":"STAFF OFFICE","FICM":"310"},{"NUM_ROOMS":"13","NASF":"23972","PERCENT":"6.9","CAT_NAME":"Animal Quarters","FICM":"570"},{"NUM_ROOMS":"26","NASF":"23081","PERCENT":"6.6","CAT_NAME":"Greenhouse","FICM":"580"},{"NUM_ROOMS":"39","NASF":"19781","PERCENT":"5.7","CAT_NAME":"Class Laboratory","FICM":"210"},{"NUM_ROOMS":"103","NASF":"16094","PERCENT":"4.6","CAT_NAME":"FACULTY OFFICE","FICM":"311"},{"NUM_ROOMS":"2","NASF":"13319","PERCENT":"3.8","CAT_NAME":"Assembly","FICM":"610"},{"NUM_ROOMS":"100","NASF":"9795","PERCENT":"2.8","CAT_NAME":"Office Service","FICM":"315"},{"NUM_ROOMS":"50","NASF":"8729","PERCENT":"2.5","CAT_NAME":"Research Laboratory Service","FICM":"255"},{"NUM_ROOMS":"10","NASF":"7254","PERCENT":"2.1","CAT_NAME":"Food Facilities Service","FICM":"635"},{"NUM_ROOMS":"19","NASF":"6740","PERCENT":"1.9","CAT_NAME":"Grhs Serv","FICM":"585"},{"NUM_ROOMS":"28","NASF":"6496","PERCENT":"1.9","CAT_NAME":"GRAD\/STUDENT OFFICE","FICM":"312"},{"NUM_ROOMS":"10","NASF":"6363","PERCENT":"1.8","CAT_NAME":"Classroom","FICM":"110"},{"NUM_ROOMS":"17","NASF":"6042","PERCENT":"1.7","CAT_NAME":"Conference Room","FICM":"350"},{"NUM_ROOMS":"2","NASF":"5158","PERCENT":"1.5","CAT_NAME":"Other (All Purposes)","FICM":"590"},{"NUM_ROOMS":"4","NASF":"5052","PERCENT":"1.4","CAT_NAME":"Shop","FICM":"720"},{"NUM_ROOMS":"14","NASF":"4469","PERCENT":"1.3","CAT_NAME":"Animal Quarters Service","FICM":"575"},{"NUM_ROOMS":"18","NASF":"4442","PERCENT":"1.3","CAT_NAME":"INACTIVE AREA","FICM":"050"},{"NUM_ROOMS":"13","NASF":"3674","PERCENT":"1.1","CAT_NAME":"Central Storage","FICM":"730"},{"NUM_ROOMS":"26","NASF":"3144","PERCENT":".9","CAT_NAME":"Class Laboratory Service","FICM":"215"},{"NUM_ROOMS":"1","NASF":"2222","PERCENT":".64","CAT_NAME":"Assembly Service","FICM":"615"},{"NUM_ROOMS":"6","NASF":"1500","PERCENT":".43","CAT_NAME":"Lounge","FICM":"650"},{"NUM_ROOMS":"2","NASF":"1103","PERCENT":".32","CAT_NAME":"ALTERATION OR CONVERSION AREA","FICM":"060"},{"NUM_ROOMS":"1","NASF":"1085","PERCENT":".31","CAT_NAME":"Ath\/P.E.","FICM":"520"},{"NUM_ROOMS":"5","NASF":"1077","PERCENT":".31","CAT_NAME":"Mechanical","FICM":"YYY"},{"NUM_ROOMS":"6","NASF":"1003","PERCENT":".29","CAT_NAME":"Cold Room","FICM":"258"},{"NUM_ROOMS":"2","NASF":"725","PERCENT":".21","CAT_NAME":"Meeting Room","FICM":"680"},{"NUM_ROOMS":"2","NASF":"712","PERCENT":".2","CAT_NAME":"Merchandising Service","FICM":"665"},{"NUM_ROOMS":"2","NASF":"680","PERCENT":".19","CAT_NAME":"Food Facilities","FICM":"630"},{"NUM_ROOMS":"1","NASF":"652","PERCENT":".19","CAT_NAME":"Open-Stack Study Room","FICM":"430"},{"NUM_ROOMS":"4","NASF":"638","PERCENT":".18","CAT_NAME":"Shop Service","FICM":"725"},{"NUM_ROOMS":"3","NASF":"590","PERCENT":".17","CAT_NAME":"Study Room","FICM":"410"},{"NUM_ROOMS":"3","NASF":"556","PERCENT":".16","CAT_NAME":"Media Production","FICM":"530"},{"NUM_ROOMS":"1","NASF":"299","PERCENT":".086","CAT_NAME":"Open Laboratory","FICM":"220"},{"NUM_ROOMS":"2","NASF":"271","PERCENT":".078","CAT_NAME":"Central Computer or Telecomm S","FICM":"715"},{"NUM_ROOMS":"2","NASF":"232","PERCENT":".066","CAT_NAME":"Central Computer or Telecommun","FICM":"710"},{"NUM_ROOMS":"1","NASF":"212","PERCENT":".061","CAT_NAME":"Merchandising","FICM":"660"},{"NUM_ROOMS":"1","NASF":"139","PERCENT":".04","CAT_NAME":"Bldg Serv","FICM":"XXX"},{"NUM_ROOMS":"2","NASF":"127","PERCENT":".036","CAT_NAME":"Classroom Service","FICM":"115"},{"NUM_ROOMS":"1","NASF":"114","PERCENT":".033","CAT_NAME":"Hazardous Materials","FICM":"760"},{"NUM_ROOMS":"1","NASF":"112","PERCENT":".032","CAT_NAME":"Hazardous Materials Service","FICM":"765"},{"NUM_ROOMS":"1","NASF":"86","PERCENT":".025","CAT_NAME":"Lounge Service","FICM":"655"},{"NUM_ROOMS":"1","NASF":"59","PERCENT":".017","CAT_NAME":"Locker Rm","FICM":"690"},{"NUM_ROOMS":"2","NASF":"38","PERCENT":".011","CAT_NAME":"Meeting Room Service","FICM":"685"},{"NUM_ROOMS":"1","NASF":"14","PERCENT":".004","CAT_NAME":"Conference Room Service","FICM":"355"}] |
|
BLDG_LITE (test on test) | format=json value=SITE_CODE range=02 |
{"SITE_NAME":"HARTFORD REGIONAL CAMPUS","SITE_CODE":"02","FACILITY_CODE":"3201","FACILITY_NAME":"GHC-UNDERGRADUATE BLDG - W.HTFD","ACTIVE_FLAG":"Y","RENO_YEAR":"UNKNOWN","NET_SQFT":"62386.58","GROSS_SQFT":"69474.71","ASSIGNABLE":"37492.39","STREET":"85 LAWLER ROAD","CITY":"HARTFORD","OWNVLEASE":null,"ACQUIRED":null,"BLDG_TYPE":"BUILDING","BLDG_YEAR":"1971","HISTORICAL":null,"JUST_PREV_CT_FY":null,"JUST_REACT_FY":null,"PM_HOURS_FY":"48.5","REACT_HRS_FY":"202.5"},{"SITE_NAME":"HARTFORD REGIONAL CAMPUS","SITE_CODE":"02","FACILITY_CODE":"3202","FACILITY_NAME":"GHC-SCHOOL OF SOCIAL WORK - W HTFD","ACTIVE_FLAG":"Y","RENO_YEAR":"UNKNOWN","NET_SQFT":"33442.61","GROSS_SQFT":"38476.05","ASSIGNABLE":"21451.1","STREET":"1798 ASYLUM AVE","CITY":"HARTFORD","OWNVLEASE":null,"ACQUIRED":null,"BLDG_TYPE":"BUILDING","BLDG_YEAR":"1968","HISTORICAL":null,"JUST_PREV_CT_FY":null,"JUST_REACT_FY":null,"PM_HOURS_FY":"21.5","REACT_HRS_FY":"165.55"}...] |
Place the comma separated field name(s) to filter on the value field & the comma separated value(s) in the range field to get matching data |
SITES_BY_UCONN (test) | format=json |
[{“SITE_CODE”:”01″,”DESCRIPTION”:”STORRS CAMPUS”}, |
|
BLDGS_BY_SITE (test) | format=json value=02 |
[{“SITE”:”02″,”BLDG_CODE”:”7327″,”BLDG_NAME”:”125 Signourney St”}, |
|
FLOORS_BY_BLDG (test) | format=json value=3201 |
[{“BLDG_CODE”:”3201″,”FLOOR”:”00″}, |
|
ROOMS_BY_FLOOR (test) | format=json value=0505 range=08 |
[{“BLDG”:”0505″,”FLOOR”:”08″,”ROOM”:”801″,”ROOM_DESC”:”CUSTODIAL CLOSET”}, |
|
ACTIVE_ROOMS (dev) | format=json value=BUILDING,FLOOR range=0001,01 |
[{"SITE":null,"CAMPUS":"STORRS CAMPUS","BLDG_NAME":"Storrs Hall","BUILDING":"0001","FLOOR":"01","ROOM":"105","SQR_FEET":"124.47","SUB_DEPT":"Nursing Instr & Res","GROUP_CODE":"22320AA","SPACE_TYPE":"Faculty Office","FICM":"311","ROOM_BILLING_ID":"156779"}, {"SITE":null,"CAMPUS":"STORRS CAMPUS","BLDG_NAME":"Storrs Hall","BUILDING":"0001","FLOOR":"01","ROOM":"110","SQR_FEET":"117.96","SUB_DEPT":"Nursing Instr & Res","GROUP_CODE":"22320AA","SPACE_TYPE":"Faculty Office","FICM":"311","ROOM_BILLING_ID":"156788"}, {"SITE":null,"CAMPUS":"STORRS CAMPUS","BLDG_NAME":"Storrs Hall","BUILDING":"0001","FLOOR":"01","ROOM":"111","SQR_FEET":"101.38","SUB_DEPT":"Nursing Instr & Res","GROUP_CODE":"22320AA","SPACE_TYPE":"Faculty Office","FICM":"311","ROOM_BILLING_ID":"156789"}, {"SITE":null,"CAMPUS":"STORRS CAMPUS","BLDG_NAME":"Storrs Hall","BUILDING":"0001","FLOOR":"01","ROOM":"109","SQR_FEET":"125.46","SUB_DEPT":"Nursing Instr & Res","GROUP_CODE":"22320AA","SPACE_TYPE":"Faculty Office","FICM":"311","ROOM_BILLING_ID":"156787"}, {"SITE":null,"CAMPUS":"STORRS CAMPUS","BLDG_NAME":"Storrs Hall","BUILDING":"0001","FLOOR":"01","ROOM":"118","SQR_FEET":"348.13","SUB_DEPT":"Nursing Instr & Res","GROUP_CODE":"22320AA","SPACE_TYPE":"Conference Room","FICM":"350","ROOM_BILLING_ID":"156782"}, |
|
BLDG_ALIASES (test) | format=json value=NULL range=01 |
[{"CAMPUS":"01","CAMPUS_NAME":"STORRS CAMPUS","NAME":"SWG STA - WPCF OPERATIONS BUILDING","F_CODE":"0388","A_TYPE":"PRIMARY","A_CODE":null,"A_DESCRIPTON":"SWG STA - CONTROL BUILDING","LATITUDE":"41.81187805","LONGITUDE":"-72.26477373"}, {"CAMPUS":"01","CAMPUS_NAME":"STORRS CAMPUS","NAME":"ARCH AND ENG SVCS","F_CODE":"0387","A_TYPE":"Communications","A_CODE":"AES","A_DESCRIPTON":"Architectural and Engineering Services","LATITUDE":"41.81115976","LONGITUDE":"-72.26289799"}, {"CAMPUS":"01","CAMPUS_NAME":"STORRS CAMPUS","NAME":"AVIAN RESEARCH BUILDING","F_CODE":"1124","A_TYPE":"Communications","A_CODE":"ARF","A_DESCRIPTON":"Avian Research Facility","LATITUDE":"41.81553083","LONGITUDE":"-72.2412705"}, {"CAMPUS":"01","CAMPUS_NAME":"STORRS CAMPUS","NAME":"DAIRY BARN & SILO","F_CODE":"0005","A_TYPE":"Communications","A_CODE":"BARN","A_DESCRIPTON":"Dairy Barn","LATITUDE":"41.81370409","LONGITUDE":"-72.25163274"}, {"CAMPUS":"01","CAMPUS_NAME":"STORRS CAMPUS","NAME":"BURTON FOOTBALL COMPLEX & SHENKMAN","F_CODE":"0480","A_TYPE":"Communications","A_CODE":"BFFC","A_DESCRIPTON":"Burton Family Football Complex","LATITUDE":"41.80286081","LONGITUDE":"-72.25486441"}, |
|
EMPLOYEE Related Web Services |
|||
EMP_REPORTS_TO (test on dev) |
format=json value=LAB10002 |
[{"EMPLOYEE":"LAB10002","NAME":"JUENGER, LARA","SUBDEPARTMENT":"24204AA","SUB_DEPT_NAME":"ENTERPRISE ADMIN SYSTE GENERAL","DEPARTMENT":"24204","DEPT_NAME":"ENTERPRISE ADMIN SYSTEMS","UNIT":"2039","UNIT_NAME":"UNIVERSITY INFO TECH SERVICES"}] |
OTHER Web Services |
||
Method | Parameters | Example Output |
GOODBYE | ||
CREWS | ||
ZONES | ||
ZONE_ASSIGN | ||
LIST_CREWS | ||
LIST_CREWS_DETAIL | ||
LIST_ZONE_DETAIL | ||
ASSIGNMENTS | ||
ZONEASSIGNMENTS | ||
ACT_PRIORITY ‘R’ ‘PM’ | ||
ACT_PRIORITY_ZONE ‘R’ ‘PM’ ACT_NEW ‘R’ ‘PM’ | ||
ACT_NEW_ZONE ‘R’ ‘PM’ | ||
ACT_PARTS ‘R’ ‘PM’ | ||
ACT_PARTS_ZONE ‘R’ ‘PM’ | ||
ACT_UNASSIGNED ‘R’ ‘PM’ | ||
ACT_UNASSIGNED_ZONE ‘R’ ‘PM’ | ||
ACT_AGING ‘R’ ‘PM’ 1 2 3 4 5 | ||
ACT_AGING_ZONE ‘R’ ‘PM’ 1 2 3 4 5 | ||
REC_OPEN ‘R’ ‘PM’ | ||
REC_CLOSE ‘R’ ‘PM’ | ||
REC_COMPLETE ‘R’ ‘PM’ | ||
REC_OPEN_ZONE ‘R’ ‘PM’ | ||
REC_CLOSE_ZONE ‘R’ ‘PM’ | ||
REC_COMPLETE_ZONE ‘R’ ‘PM’ | ||
ACT_ASSIGNED_ZONE | ||
ACT_ASSIGNED | ||
ACT_BUILDING | ||
ACT_BUILDING_ZONE | ||
ACT_BUILDING_SUBZONE | ||
BLDG_WOS | ||
BLDG_ALIASES | ||
WEATHER | ||
CURRENT_WEATHER | ||
COMP_ASSIGN | ||
ACT_BY_MAINT | ||
BACKLOG_BY_CREW | ||
CLOSED_BY_CREW | ||
OPENED_BY_CREW | ||
SITES_BY_UCONN | ||
BLDGS_BY_SITE | ||
FLOORS_BY_BLDG | ||
FLOORS_BY_BLDG_BY_ROOM | ||
ROOMS_BY_FLOOR | ||
MY_CREW | ||
THE_BULLETIN | ||
FAC_BLDG_HRS_WT_FY | ||
FAC_BLDG_HRS_FY | ||
FAC_BLDG_CT_FY | ||
FAC_BLDG_CT_WEEK | ||
FAC_BLDG_COST_FY | ||
FAC_BLDG_COST_LAST_MONTH | ||
NEAREST_BUILDING | ||
CENTER_OF_BUILDING | ||
SPACE_DEPTS_IN_BLDG | ||
SPACE_FICMS_IN_BLDG | ||
SPACE_FICMS | ||
SPACE_METRICS_IN_BLDG | ||
SPACE_METRICS_UNIT_BY_BLDG | ||
SPACE_METRICS_UNIT_BY_DEPT | ||
SPACE_METRICS_UNIT_BY_DEPT_BY_BLDG | ||
SPACE_METRICS_UNIT_BY_DEPT_BY_TYPE | ||
SPACE_UNITS | ||
SPACE_PERSONNEL | ||
SPACE_PERSONNEL_FORMAT | ||
SPACE_PERSONNEL_IN_UNIT | ||
SPACE_INACTIVE_PEOPLE_IN_UNIT | ||
SPACE_PERSONNEL_BY_BLDG | ||
SPACE_ROOM_DETAIL_BY_UNIT | ||
SPACE_ROOM_DETAIL_BY_BLDG | ||
SPACE_ROOM_DETAIL_BY_FICM | ||
SPACE_CLASSROOMS | ||
SPACE_RESIDENTIAL | ||
SPACE_BLDG_CONTACTS | ||
SPACE_ROOM_CONTACTS | ||
SPACE_PIS | ||
SPACE_BLDG_EQUIP | ||
SPACE_CPS | ||
FLOORPLAN_AVAIL | ||
SPACE_BLDG_IMGS | ||
EMP_REPORTS_TO | ||
SPACE_METRICS_UNIT_BY_CATS | ||
SPACE_METRICS_BLDGS_BY_CATS | ||
SPACE_ASBESTOS | ||
LIST_ASBESTOS_ASSESSMENTS | ||
FAMIS_REQUESTOR | ||
FAMIS_REQUESTOR_TEST | ||
PRINT_WO_FLAG | ||
REFRESH_PRINT_WO_FLAG | ||
MOBILE_SR_LIST | ||
METRICS_RECENT_SR_CREATE | ||
CHECK_PERMS | ||
METRICS_SR_CREATE_COMPLEX | ||
CP_BUDGETS | ||
CP_POS | ||
MART_UPDATE_STATUS | ||
ALL_METRICS | ||
OTHER_METRICS | ||
SS_METRICS | ||
MOBILE_METRICS | ||
FAC_HEATMAPS | ||
FAC_CREW_HEATMAPS | ||
FAC_CREW_HEATMAPS_R | ||
FAC_CREW_HEAT_FY_R | ||
FAC_CREW_HEAT_FY | ||
FELIX | ||
FELIX_BLDGS | ||
FELIX_CAT | ||
FELIX_SUBCAT | ||
FAC_OPS_WEEKS | ||
CREWED_EMPS | ||
LABOR_DETAILS | ||
WORK_ORDER_LITE | ||
BLDG_LITE | ||
GET_WO_STATUSES | ||
GET_ONE_WO | ||
MP_PROJ_SUMMARY | ||
MP_PROJ_DETAILS |