[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
RE: Bank Routing Number Validation Web Service
Yep, sometimes easier is better. Depending on usage, how about getting it direct from the Fed?
http://www.fededirectory.frb.org/fpddir.txt
Can still get it using HTTP and import it into a database file and then it is available locally.
-----Original Message-----
From: ftpapi-bounces@xxxxxxxxxxxxxxxxxxxxxx [mailto:ftpapi-bounces@xxxxxxxxxxxxxxxxxxxxxx] On Behalf Of Alan Campin
Sent: Wednesday, October 8, 2014 2:01 PM
To: HTTPAPI and FTPAPI Projects
Subject: Re: Bank Routing Number Validation Web Service
Buzz, have you considered using a simpler API. I did a search online and found this service that uses a simple REST interface.
http://www.routingnumbers.info/api/name.html
Example
http://www.routingnumbers.info/api/name.json?rn=324377516
Result.
{"code": 200, "message": "OK", "name": "AMERICA FIRST FEDERAL CREDIT UNION", "rn": "324377516"}
On Wed, Oct 8, 2014 at 8:06 AM, Scott Klement <sk@xxxxxxxxxxxxxxxx> wrote:
> Buzz,
> XML is case-sensitive. I noticed in your XML document, you have some
> things capitalized that SoapUI has in lower-case.
> Please make sure everything matches exactly.... including upper &
> lower case.
> Personally, I just copy/paste the stuff rather than retyping it. That
> helps ensure that it all matches.
> -SK
> On 10/7/2014 4:45 PM, Buzz Fenner wrote:
>
> All,
>
>
> First, this is my -first- opportunity to use a web service; if I can
> get this program up and running in a reasonable time frame, I hope my
> boss will be open to using web services more (which will give me the
> opportunity to learn more about them) with RPG. Some years ago, Scott K
> posted up some code to do bank routing number validation
>
> ([1][1]http://www.scottklement.com/archives/ftpapi/200701/msg00017.htm
> l
> )
> which I found via the RPG List Archive. So I downloaded it and got to
> work. However, running his code "as is" kept returning empty data sets;
> it appears that the service used in the program has possibly been
> discontinued?
>
>
> On the webservicex.net website, the link to the ABA Lookup service
> description (the WSDL Scott's code uses) now points to the newer one,
> FedACH. So, I imported the FedACH WSDL into SoapUI and created a
> request using the getACHByRoutingNumber service to see what the XML
> looked like. I inserted data, ran the request and got results. So I set
> about adapting Scott's code to match (more or less) what SoapUI
> generated.
>
>
> I'm receiving internal server errors but the fault string mentions some
> procedure (?) that I did not see in the FedACH WSDL, and being a
> newbie, not able to decipher the error log which follows:
>
>
> HTTPAPI Ver 1.24 released 2012-01-23
>
> OS/400 Ver V7R1M0 ** CUME C4143710 **
>
>
> http_url_post(): entered
>
> http_persist_open(): entered
>
> http_long_ParseURL(): entered
>
> DNS resolver retrans: 2
>
> DNS resolver retry : 2
>
> DNS resolver options: x'00000136'
>
> DNS default domain: JONESBOROCWL.ORG
>
> DNS server found: 192.168.0.107
>
> DNS server found: 192.168.0.106
>
> http_persist_post(): entered
>
> http_persist_req(POST) entered.
>
> http_long_ParseURL(): entered
>
> do_oper(POST): entered
>
> There are 0 cookies in the cache
>
> POST /FedACH.asmx HTTP/1.1
>
> Host: [2]www.webservicex.net
>
> User-Agent: http-api/1.24
>
> Content-Type: text/xml
>
> SOAPAction: [3]http://www.webservicex.net/getACHByRoutingNumber
>
> Content-Length: 357
>
>
>
> senddoc(): entered
>
> <?xml version="1.0" encoding="iso-8859-1" standalone="no"?>
> <SOAP-ENV:Envelope
> xmlns:SOAP-ENV=[4]"http://schemas.xmlsoap.org/soap/envelope/"
> xmlns:web=[5]"http://www.webservicex.net/"> <SOAP-ENV:Header/>
> <SOAP-ENV:Body> <web:GetACHByRoutingNumber>
> <web:RoutingNumber>102000021</web:RoutingNumber>
> </web:GetACHByRoutingNumber> </SOAP-ENV:Body> </SOAP-ENV:Envelope>
>
> recvresp(): entered
>
> HTTP/1.1 500 Internal Server Error
>
> Cache-Control: private
>
> Content-Length: 2582
>
> Content-Type: text/xml; charset=utf-8
>
> Server: Microsoft-IIS/7.0
>
> X-AspNet-Version: 4.0.30319
>
> X-Powered-By: ASP.NET
>
> Date: Tue, 07 Oct 2014 20:14:17 GMT
>
> X-Cache: MISS from barracuda.jonesborocwl.org
>
> Via: 1.1 barracuda.jonesborocwl.org (http_scan_byf/3.3.1)
>
> Connection: keep-alive
>
>
>
> SetError() #13: HTTP/1.1 500 Internal Server Error
>
> recvresp(): end with 500
>
> recvdoc parms: identity 2582
>
> header_load_cookies() entered
>
> recvdoc(): entered
>
> SetError() #0:
>
> <?xml version="1.0" encoding="utf-8"?><soap:Envelope
> xmlns:soap=[6]"http://schemas.xmlsoap.org/soap/envelope/"
> xmlns:xsi=[7]"http://www.w3.org/2001/XMLSchema-instance"
> xmlns:xsd=[8]"http://www.w3.org/2001/XMLSchema
> "><soap:Body><soap:Fault><fa
> ultcode>soap:Server</faultcode><faultstring>System.Web.Services.Protoco
> ls.SoapException: Server was unable to process request. --->
> System.Exception: Error occured when get webservices record --->
> System.Data.SqlClient.SqlException: Procedure or function
> 'getFedACHdirbyRoutingNumber' expects parameter '@RoutingNumber', which
> was not supplied.
>
> at System.Data.SqlClient.SqlConnection.OnError(SqlException
> exception, Boolean breakConnection, Action`1 wrapCloseInAction)
>
> at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException
> exception, Boolean breakConnection, Action`1 wrapCloseInAction)
>
> at
> System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserState
> Object stateObj, Boolean callerHasConnectionLock, Boolean
> asyncClose)
>
> at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior,
> SqlCommand cmdHandler, SqlDataReader dataStream,
> BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj,
> Boolean& dataReady)
>
> at System.Data.SqlClient.SqlDataReader.TryConsumeMetaData()
>
> at System.Data.SqlClient.SqlDataReader.get_MetaData()
>
> at
> System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds,
> RunBehavior runBehavior, String resetOptionsString)
>
> at
> System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior
> cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean
> async, Int32 timeout, Task& task, Boolean asyncWrite, SqlDataReader
> ds)
>
> at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior
> cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String
> method, TaskCompletionSource`1 completion, Int32 timeout, Task&
> task, Boolean asyncWrite)
>
> at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior
> cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String
> method)
>
> at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior
> behavior, String method)
>
> at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior
> behavior)
>
> at ACH.FedACH.getACHByRoutingNumber(String RoutingNumber,
> FedACHList& FedACHLists)
>
> --- End of inner exception stack trace ---
>
> at ACH.FedACH.getACHByRoutingNumber(String RoutingNumber,
> FedACHList& FedACHLists)
>
> --- End of inner exception stack trace ---</faultstring><detail
> /></soap:Fault></soap:Body></soap:Envelope>
>
> SetError() #13: HTTP/1.1 500 Internal Server Error
>
> http_close(): entered
>
>
> This is the snippet of code that creates the request and sends it to
> the server:
>
>
> SOAP=
>
> '<?xml version="1.0" encoding="iso-8859-1"
> standalone="no"?> +
>
> <SOAP-ENV:Envelope +
>
>
> xmlns:SOAP-ENV=[9]"http://schemas.xmlsoap.org/soap/envelope/" +
>
> xmlns:web=[10]"http://www.webservicex.net/"> +
>
> <SOAP-ENV:Header/> +
>
> <SOAP-ENV:Body> +
>
> <web:GetACHByRoutingNumber> +
>
> <web:RoutingNumber>' + RoutNo +
> '</web:RoutingNumber> +
>
> </web:GetACHByRoutingNumber> +
>
> </SOAP-ENV:Body> +
>
> </SOAP-ENV:Envelope>';
>
>
> // ----------------------------------------------
>
> // Send request to server, and get response
>
> // ----------------------------------------------
>
>
> soapfile = http_tempfile();
>
>
> rc = http_url_post( '[11]
> http://www.webservicex.net/FedACH.asmx'
>
> : %addr(SOAP)+2
>
> : %len(SOAP)
>
> : soapfile
>
> : HTTP_TIMEOUT
>
> : HTTP_USERAGENT
>
> : 'text/xml'
>
> : '[12]http://www.webservicex.net/+
>
> getACHByRoutingNumber');
>
>
> Any help/suggestions will be greatly appreciated.
>
>
> --
>
> Buzz Fenner, Analyst/Systems Administrator
>
> +1 (870) 930.3374 [[13]2]bfenner@xxxxxxxxxxxxxxxx
>
>
> City Water and Light of Jonesboro
> Office: +1 (870) 935.5581 / Fax: +1 (870) 930.3301
> Physical: 400 East Monroe Ave., Jonesboro, AR 72401
> Mailing: PO Box 1289, Jonesboro, AR 72403-1289
>
>
> This e-mail message may contain confidential or legally privileged
> information and is intended only for the use of the intended
> recipient(s). Any unauthorized disclosure, dissemination, distribution,
> copying or the taking of any action in reliance on the information
> herein is prohibited. E-mails are not secure and cannot be guaranteed
> to be error free as they can be intercepted, amended, or contain
> viruses. Anyone who communicates with us by e-mail is deemed to have
> accepted these risks. City Water and Light of Jonesboro is not
> responsible for errors or omissions in this message and denies any
> responsibility for any damage arising from the use of e-mail. Any
> opinion and other statement contained in this message and any
> attachment are solely those of the author and do not necessarily
> represent those of the company.
>
> References
>
> 1. [14]http://www.scottklement.com/archives/ftpapi/200701/msg00017.html
> 2. [15]mailto:bfenner@xxxxxxxxxxxxxxxx
>
>
> ----------------------------------------------------------------------
> - This is the FTPAPI mailing list. To unsubscribe, please go to:
> [16]http://www.scottklement.com/mailman/listinfo/ftpapi
> ----------------------------------------------------------------------
> -
>
> References
>
> 1. http://www.scottklement.com/archives/ftpapi/200701/msg00017.html
> 2. http://www.webservicex.net/
> 3. http://www.webservicex.net/getACHByRoutingNumber
> 4. http://schemas.xmlsoap.org/soap/envelope/
> 5. http://www.webservicex.net/
> 6. http://schemas.xmlsoap.org/soap/envelope/
> 7. http://www.w3.org/2001/XMLSchema-instance
> 8. http://www.w3.org/2001/XMLSchema
> 9. http://schemas.xmlsoap.org/soap/envelope/
> 10. http://www.webservicex.net/
> 11. http://www.webservicex.net/FedACH.asmx
> 12. http://www.webservicex.net/+
> 13. mailto:2]bfenner@xxxxxxxxxxxxxxxx
> 14. http://www.scottklement.com/archives/ftpapi/200701/msg00017.html
> 15. mailto:bfenner@xxxxxxxxxxxxxxxx
> 16. http://www.scottklement.com/mailman/listinfo/ftpapi
>
> ----------------------------------------------------------------------
> - This is the FTPAPI mailing list. To unsubscribe, please go to:
> http://www.scottklement.com/mailman/listinfo/ftpapi
> ----------------------------------------------------------------------
> -
>
>
-----------------------------------------------------------------------
This is the FTPAPI mailing list. To unsubscribe, please go to:
http://www.scottklement.com/mailman/listinfo/ftpapi
-----------------------------------------------------------------------