[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: Bank Routing Number Validation Web Service

From: Alan Campin <alan0307d@xxxxxxxxx>
To: HTTPAPI and FTPAPI Projects <ftpapi@xxxxxxxxxxxxxxxxxxxxxx>
Subject: Re: Bank Routing Number Validation Web Service
Date: Wed, 8 Oct 2014 13:01:20 -0600

   Buzz, have you considered using a simpler API. I did a search online
   and found this service that uses a simple REST interface.
   [1]http://www.routingnumbers.info/api/name.html
   Example
   [2]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 <[3]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][4]http://www.scottklement.com/archives/ftpapi/200701/msg00
     017.html)

   � �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 [5]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: [6]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][7]www.webservicex.net
     � �User-Agent: http-api/1.24
     � �Content-Type: text/xml
     � �SOAPAction:
     [3][8]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]"[9]http://schemas.xmlsoap.org/soap/envelope/";
     � �xmlns:web=[5]"[10]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: [11]ASP.NET
     � �Date: Tue, 07 Oct 2014 20:14:17 GMT
     � �X-Cache: MISS from [12]barracuda.jonesborocwl.org
     � �Via: 1.1 [13]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]"[14]http://schemas.xmlsoap.org/soap/envelope/";
     � �xmlns:xsi=[7]"[15]http://www.w3.org/2001/XMLSchema-instance";
     �     �xmlns:xsd=[8]"[16]http://www.w3.org/2001/XMLSchema";><soap:Body><so
     ap:Fault><fa

   �   �ultcode>soap:Server</faultcode><faultstring>System.Web.Services.Proto
   co
   � �ls.SoapException: Server was unable to process request. ---&gt;
   � �System.Exception: Error occured when get webservices� record
   ---&gt;
   � �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(TdsParserSta
   te
   � �Object stateObj, Boolean callerHasConnectionLock, Boolean
   asyncClose)
   � � � at System.Data.SqlClient.TdsParser.TryRun(RunBehavior
   runBehavior,
   � �SqlCommand cmdHandler, SqlDataReader dataStream,
   � �BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject
   stateObj,
   � �Boolean&amp; 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&amp; 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&amp;
   � �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&amp; FedACHLists)
   � � � --- End of inner exception stack trace ---
   � � � at ACH.FedACH.getACHByRoutingNumber(String RoutingNumber,
   � �FedACHList&amp; 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]"[17]http://schemas.xmlsoap.org/soap/envelope/";
     +
     � � � � � � � � �     xmlns:web=[10]"[18]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][19]http://www.webservicex.net/FedACH.asmx'
     � � � � � � � � � � � � � � � �: %addr(SOAP)+2
     � � � � � � � � � � � � � � � �: %len(SOAP)
     � � � � � � � � � � � � � � � �: soapfile
     � � � � � � � � � � � � � � � �: HTTP_TIMEOUT
     � � � � � � � � � � � � � � � �: HTTP_USERAGENT
     � � � � � � � � � � � � � � � �: 'text/xml'
     � � � � � � � � � � � � � � � �:
     '[12][20]http://www.webservicex.net/+
     � � � � � � � � � � � � � � � � �     getACHByRoutingNumber');
     � �Any help/suggestions will be greatly appreciated.
     � �--
     � �Buzz Fenner, Analyst/Systems Administrator
     � �+1 (870) 930.3374 [[13]2][21]bfenner@xxxxxxxxxxxxxxxx
     � �City Water and Light of Jonesboro
     � �Office: [22]+1 (870) 935.5581 / Fax: [23]+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][24]http://www.scottklement.com/archives/ftpapi/200701/msg00017.
     html
     � �2. [15]mailto:[25]bfenner@xxxxxxxxxxxxxxxx
     --------------------------------------------------------------------
     ---
     This is the FTPAPI mailing list.� To unsubscribe, please go to:
     [16][26]http://www.scottklement.com/mailman/listinfo/ftpapi
     --------------------------------------------------------------------
     ---
     References
     � �1.
     [27]http://www.scottklement.com/archives/ftpapi/200701/msg00017.html
     � �2. [28]http://www.webservicex.net/
     � �3. [29]http://www.webservicex.net/getACHByRoutingNumber
     � �4. [30]http://schemas.xmlsoap.org/soap/envelope/
     � �5. [31]http://www.webservicex.net/
     � �6. [32]http://schemas.xmlsoap.org/soap/envelope/
     � �7. [33]http://www.w3.org/2001/XMLSchema-instance
     � �8. [34]http://www.w3.org/2001/XMLSchema
     � �9. [35]http://schemas.xmlsoap.org/soap/envelope/
     � 10. [36]http://www.webservicex.net/
     � 11. [37]http://www.webservicex.net/FedACH.asmx
     � 12. [38]http://www.webservicex.net/+
     � 13. mailto:[39]2][40]bfenner@xxxxxxxxxxxxxxxx
     � 14.
     [41]http://www.scottklement.com/archives/ftpapi/200701/msg00017.html
     � 15. mailto:[42]bfenner@xxxxxxxxxxxxxxxx
     � 16. [43]http://www.scottklement.com/mailman/listinfo/ftpapi
     --------------------------------------------------------------------
     ---
     This is the FTPAPI mailing list.� To unsubscribe, please go to:
     [44]http://www.scottklement.com/mailman/listinfo/ftpapi
     --------------------------------------------------------------------
     ---

References

   1. http://www.routingnumbers.info/api/name.html
   2. http://www.routingnumbers.info/api/name.json?rn=324377516
   3. mailto:sk@xxxxxxxxxxxxxxxx
   4. http://www.scottklement.com/archives/ftpapi/200701/msg00017.html
   5. http://webservicex.net/
   6. http://JONESBOROCWL.ORG/
   7. http://www.webservicex.net/
   8. http://www.webservicex.net/getACHByRoutingNumber
   9. http://schemas.xmlsoap.org/soap/envelope/
  10. http://www.webservicex.net/
  11. http://ASP.NET/
  12. http://barracuda.jonesborocwl.org/
  13. http://barracuda.jonesborocwl.org/
  14. http://schemas.xmlsoap.org/soap/envelope/
  15. http://www.w3.org/2001/XMLSchema-instance
  16. http://www.w3.org/2001/XMLSchema
  17. http://schemas.xmlsoap.org/soap/envelope/
  18. http://www.webservicex.net/
  19. http://www.webservicex.net/FedACH.asmx
  20. http://www.webservicex.net/+
  21. mailto:bfenner@xxxxxxxxxxxxxxxx
  22. tel:%2B1%20%28870%29%20935.5581
  23. tel:%2B1%20%28870%29%20930.3301
  24. http://www.scottklement.com/archives/ftpapi/200701/msg00017.html
  25. mailto:bfenner@xxxxxxxxxxxxxxxx
  26. http://www.scottklement.com/mailman/listinfo/ftpapi
  27. http://www.scottklement.com/archives/ftpapi/200701/msg00017.html
  28. http://www.webservicex.net/
  29. http://www.webservicex.net/getACHByRoutingNumber
  30. http://schemas.xmlsoap.org/soap/envelope/
  31. http://www.webservicex.net/
  32. http://schemas.xmlsoap.org/soap/envelope/
  33. http://www.w3.org/2001/XMLSchema-instance
  34. http://www.w3.org/2001/XMLSchema
  35. http://schemas.xmlsoap.org/soap/envelope/
  36. http://www.webservicex.net/
  37. http://www.webservicex.net/FedACH.asmx
  38. http://www.webservicex.net/+
  39. mailto:2
  40. mailto:bfenner@xxxxxxxxxxxxxxxx
  41. http://www.scottklement.com/archives/ftpapi/200701/msg00017.html
  42. mailto:bfenner@xxxxxxxxxxxxxxxx
  43. http://www.scottklement.com/mailman/listinfo/ftpapi
  44. 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
-----------------------------------------------------------------------

Follow-Ups:
- RE: Bank Routing Number Validation Web Service
  - From: Mike Krebs

References:
- Bank Routing Number Validation Web Service
  - From: Buzz Fenner
- Re: Bank Routing Number Validation Web Service
  - From: Scott Klement

Prev by Date: Re: Bank Routing Number Validation Web Service
Next by Date: RE: Bank Routing Number Validation Web Service
Previous by thread: Re: Bank Routing Number Validation Web Service
Next by thread: RE: Bank Routing Number Validation Web Service
Index(es):
- Date
- Thread