...
| URL Samples | Note: SubFunds is a required field when checking for multiple accounts |
|---|---|
| All Parameters | |
| Just SubFunds | https://dev.api.finance.uconn.edu/webapi/accounts/cider/accounts?subfunds=OPAUX,OPOTF,OPOTP,OPTUI,RFNDA,RFNDO,RSFAD,RSNSF,RSNSP,RSTSP,UNRSF,UNRSP |
| SubFunds and OrgCode | https://dev.api.finance.uconn.edu/webapi/accounts/cider/accounts?&subfunds=OPTUI,RSTSP&orgcodes=1832,1731,1863 |
| FromDate, ToDate, and SubFunds | https://dev.api.finance.uconn.edu/webapi/accounts/cider/accounts?fromDate=2021-04-25&toDate=2021-04-29&subfunds=PLRES,OPTUI,RSTSP |
Sample Response
| Single Account | https://dev.api.finance.uconn.edu/webapi/accounts/cider/account?accountNumber=4343430 |
| Other Queries | see bottom of page |
Sample Response - Single Account
<Account> <id>C1F881630C4C0012E0430A031C730012</id> <accountName>2010 Pi Allotment</accountName> <accountNumber>4343430</accountNumber> <chartOfAccountsCode>UC</chartOfAccountsCode> <status>CLOSED</status> <fiscalOfficerIdentifier>dbm02001</fiscalOfficerIdentifier> <accountTypeCode>IP</accountTypeCode> <bankCode>15</bankCode> <consolidationChartOfAccountsCode/> <consolidationAccountNumber/> <reportsToAccountNumber/> <reportsToChartOfAccountsCode/> <FundSIDCode>1161000<<FundSIDCode>1171000</FundSIDCode> <fundSIDDescription>Tuition <fundSIDDescription>Research Fund</fundSIDDescription> <accountManagerSystemIdentifier>jai05001<<accountManagerSystemIdentifier>dak02005</accountManagerSystemIdentifier> <accountsSupervisorySystemsIdentifier>dtc13003<<accountsSupervisorySystemsIdentifier>mjp02013</accountsSupervisorySystemsIdentifier> <organizationCode>1214<<organizationCode>1321</organizationCode> <subFundGroupCode>OPTUI<<subFundGroupCode>UNRSP</subFundGroupCode> <departmentAccountOwnercode>DEP<<departmentAccountOwnercode/departmentAccountOwnercode>> <departmentReference1/> <cfdaNumber/> <projectName/> <plantFundsParentCode/> <plantFundsParentCodeDescription/> <accountExpenseGuidelineText>Conform to University/Sponsor policies</accountExpenseGuidelineText> <accountIncomeGuidelineText>Conform to University/Sponsor policies</accountIncomeGuidelineText> <accountPurposeText> To record transactions and balances for this account. </accountPurposeText> <effectiveDate>2021<effectiveDate>2011-0410-26<25</effectiveDate> <expiredDate xsi:nil="true"/><expiredDate>2011-12-31</expiredDate> </account></accountResponse>Account> | |
WSDL Definition
Definition URLs | UAT - https://kualinp.uconn.edu/kfs-uat/remoting/chartOfAccountsInquiry?wsdl |
|---|---|
Binding | {http://kfs.kuali.org/kfs/v5_0}chartOfAccountsInquirySoapBinding |
SOAP Version | SOAP 1.1 |
...
| Code Block | ||||
|---|---|---|---|---|
| ||||
<soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/">
<soap:Body>
<soap:Fault>
<faultcode>soap:Server</faultcode>
<faultstring>Account not found.</faultstring>
<detail>
<ns2:AccountInquiryFault xsi:nil="true" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"xmlns:ns2="http://kfs.kuali.org/core/v5_0"/>
</detail>
</soap:Fault>
</soap:Body>
</soap:Envelope> |
Code Examples
Java
...
| language | java |
|---|---|
| title | JUnit |
...
Sample SQL example
select account_NBR, account_nm, Sub_fund_grp_cd, acct_closed_ind, acct_create_dt, acct_effect_dt, acct_expiration_dt
--select count(*)
from kfs_uat.CA_ACCOUNT_T
where sub_fund_grp_cd IN ('PLEQP', 'PLRES', 'PLBHC', 'PLRHC', 'OPOTF', 'PLBND', 'PLREV', 'PLUNR')
-- and acct_create_dt > TO_DATE('2016-08-25','YYYY-MM-DD')
-- and acct_create_dt < TO_DATE('2016-09-17','YYYY-MM-DD')
--order by account_nbr
;
Code Examples
Java
Code Block language java title JUnit package com.example.coa.service; import java.time.LocalDate; import java.util.ArrayList; import java.util.List; import javax.xml.bind.JAXBElement; import org.junit.Test; import org.kuali.kfs.core.v5_0.GetAccountsResponse; import org.springframework.oxm.jaxb.Jaxb2Marshaller; import junit.framework.TestCase; public class AccountInquiryServiceTest extends TestCase { @Test public void testGetAccounts() throws Exception { List<String> subFunds = new ArrayList<String>(); subFunds.add("PLEQP"); subFunds.add("PLRES"); subFunds.add("PLBHC"); subFunds.add("PLRHC"); subFunds.add("OPOTF"); subFunds.add("PLBND"); subFunds.add("PLREV"); subFunds.add("PLUNR"); List<String> organizationcodes = new ArrayList<String>(); organizationcodes.add("1832"); organizationcodes.add("1731"); organizationcodes.add("1863"); LocalDate fromDate = LocalDate.parse("2016-08-26"); LocalDate toDate = LocalDate.parse("2016-09-15"); ChartOfAccountsInquiryServiceClient client = new ChartOfAccountsInquiryServiceClient(); Jaxb2Marshaller marshaller = new Jaxb2Marshaller(); marshaller.setContextPath("org.kuali.kfs.core.v5_0"); client.setMarshaller(marshaller); client.setUnmarshaller(marshaller); subFunds.add("PLEQP"); JAXBElement<GetAccountsResponse> response = subFundsclient.add("PLRES"getAccounts(subFunds, organizationcodes, fromDate, toDate); subFunds.add("PLBHC" assertNotNull(response); } subFunds.add("PLRHC")}
Code Block language java title Client package com.example.coa.service; import java.time.LocalDate; import java.util.List; subFunds.add("OPOTF"); subFunds.add("PLBND"); subFunds.add("PLREV"); subFunds.add("PLUNR"); List<String> organizationcodes = new ArrayList<String>(); organizationcodes.add("1832"); organizationcodes.add("1731"); organizationcodes.add("1863"import javax.xml.bind.JAXBElement; import javax.xml.datatype.DatatypeFactory; import org.kuali.kfs.core.v5_0.AllAccountRequest; import org.kuali.kfs.core.v5_0.GetAccounts; import org.kuali.kfs.core.v5_0.GetAccountsResponse; import org.kuali.kfs.core.v5_0.ObjectFactory; import org.springframework.ws.client.core.support.WebServiceGatewaySupport; public class ChartOfAccountsInquiryServiceClient extends WebServiceGatewaySupport { public JAXBElement<GetAccountsResponse> getAccounts(List<String> subFunds, List<String> organizationcodes, LocalDate fromDate, LocalDate toDate) throws Exception { ObjectFactory factory = new ObjectFactory(); DatatypeFactory datatypeFactory = DatatypeFactory.newInstance(); LocalDateString fromDateuri = LocalDate.parse("2016-08-26")"https://kualinp.uconn.edu/kfs-dev/remoting/chartOfAccountsInquiry"; LocalDateGetAccounts toDaterequest = new LocalDate.parse("2016-09-15"GetAccounts(); AllAccountRequest allAccountRequest = new AllAccountRequest(); allAccountRequest.getSubFund().addAll(subFunds); ChartOfAccountsInquiryServiceClient client = new ChartOfAccountsInquiryServiceClient(); allAccountRequest.getOrganizationCode().addAll(organizationcodes); allAccountRequest.setFromDate(factory.createAllAccountRequestFromDate(datatypeFactory.newXMLGregorianCalendar(fromDate.toString()))); Jaxb2Marshaller marshaller = new Jaxb2Marshaller() allAccountRequest.setToDate(factory.createAllAccountRequestToDate(datatypeFactory.newXMLGregorianCalendar(toDate.toString()))); marshaller.setContextPath("org.kuali.kfs.core.v5_0");request.setArg0(allAccountRequest); client.setMarshaller(marshaller); client.setUnmarshaller(marshallerreturn (JAXBElement<GetAccountsResponse>) getWebServiceTemplate().marshalSendAndReceive(uri, request); } }
Ruby
Code Block language ruby title Client require 'savon' client = Savon.client( :wsdl => "https://kualinp.uconn.edu/kfs-uat/remoting/chartOfAccountsInquiry?wsdl", :ssl_verify_mode => :none, JAXBElement<GetAccountsResponse> response:namespace = client.getAccounts(subFunds, organizationcodes, fromDate, toDate); assertNotNull(response); } }
Code Block language java title Client package com.example.coa.service; import java.time.LocalDate; import java.util.List; import javax.xml.bind.JAXBElement; import javax.xml.datatype.DatatypeFactory; import org.kuali.kfs.core.v5_0.AllAccountRequest; import org.kuali.kfs.core.v5_0.GetAccounts; import org.kuali.kfs.core.v5_0.GetAccountsResponse; import org.kuali.kfs.core.v5_0.ObjectFactory; import org.springframework.ws.client.core.support.WebServiceGatewaySupport; public class ChartOfAccountsInquiryServiceClient extends WebServiceGatewaySupport { public JAXBElement<GetAccountsResponse> getAccounts(List<String> subFunds, List<String> organizationcodes, LocalDate fromDate, LocalDate toDate) throws Exception { ObjectFactory factory = new ObjectFactory(); DatatypeFactory datatypeFactory = DatatypeFactory.newInstance(); String uri = "https://kualinp.uconn.edu/kfs-dev/remoting/chartOfAccountsInquiry"; GetAccounts request = new GetAccounts(); AllAccountRequest allAccountRequest = new AllAccountRequest(); allAccountRequest.getSubFund().addAll(subFunds); allAccountRequest.getOrganizationCode().addAll(organizationcodes); allAccountRequest.setFromDate(factory.createAllAccountRequestFromDate(datatypeFactory.newXMLGregorianCalendar(fromDate.toString()))); allAccountRequest.setToDate(factory.createAllAccountRequestToDate(datatypeFactory.newXMLGregorianCalendar(toDate.toString()))); request.setArg0(allAccountRequest); return (JAXBElement<GetAccountsResponse>) getWebServiceTemplate().marshalSendAndReceive(uri, request); } }Ruby
Code Block language ruby title Client require 'savon' client = Savon.client( :wsdl => "https://kualinp.uconn.edu/kfs-uat/remoting/chartOfAccountsInquiry?wsdl", :ssl_verify_mode => :none, :namespace => "http://kfs.kuali.org/core/v5_0" ) puts client.operations response = client.call(:get_accounts, soap_action: false, message: { arg0: { accountNumber:7744640 } }) puts response.to_xml> "http://kfs.kuali.org/core/v5_0" ) puts client.operations response = client.call(:get_accounts, soap_action: false, message: { arg0: { accountNumber:7744640 } }) puts response.to_xml
Other Queries