B2B Integration

 View Only

  • 1.  Using ITX to scrape Finance data and display in a spreadsheet

    IBM Champion
    Posted Fri March 27, 2020 11:00 AM

    I wrote a quick ITX map today, to scrape some current share prices from Yahoo's Finance pages and then update a spreadsheet to give me an approximate valuation for my portfolio. (Good time to be buying).

    ITX is such a versatile general purpose tool, I love it!

    Steps:

    • Batch script to call Command Server to get the data via the HTTP adapter for a preset list of symbols, saving the results to a flat text file with a CSV extension.
    • Use the same batch script to open the CSV file with a fork ('start') call that brings it up in Excel
    • A second fork to open a pre-prepared spreadsheet that has live links to that same CSV.

    Assuming the second sheet can find all the values in the same places in the CSV, then the formulas update, giving the latest information.

    Easy!

    ------------------------------
    __________________________________________________
    Paul Brett
     
    IBM Sterling Transformation Extender (ITX) Client Support
    ------------------------------

    #B2BIntegration
    #SupplyChain


  • 2.  RE: Using ITX to scrape Finance data and display in a spreadsheet

    Posted Mon March 30, 2020 04:04 AM
    Excellent!! Paul. If you can upload the map on any GitHub link then I hope others can also benefit from the same.

    Thanks for sharing your experience with the community.

    ------------------------------
    BHARAT BALOTHIA
    ------------------------------

    Original Message


  • 3.  RE: Using ITX to scrape Finance data and display in a spreadsheet

    Posted Tue March 31, 2020 05:38 AM
    Hi Paul,

    I could do with that! :-)

    Have you tried using the Excel adapter now available in ITX to write the data directly as an XLS instead of a CSV? I've only gone the other way as Rex Chan helped me put together a map to read an XLS and convert it to JSON for a use case a UK financial institution had.

    ------------------------------
    RICHARD CROSS
    ------------------------------

    Original Message


  • 4.  RE: Using ITX to scrape Finance data and display in a spreadsheet

    IBM Champion
    Posted Tue April 07, 2020 08:39 AM
    Richard,

    I could have used the Excel adapter to read a template with my formulas already in it, but it was too much work, and the CSV solution got me to my results much faster.

    Thanks.

    ------------------------------
    __________________________________________________
    Paul Brett
     
    IBM Sterling Transformation Extender (ITX) Client Support
    ------------------------------

    Original Message


  • 5.  RE: Using ITX to scrape Finance data and display in a spreadsheet

    Posted Tue April 07, 2020 09:29 AM
    Hi  Paul Brett,

    I am facing an issue while connecting to and https url to get the token.

    WSAConnectSSL: GSK Error Code: 406, GSK_ERROR_IO.

    Failure: SSL connection NOT established with target server, <target server url>, on port, 443.

     

    Below is the code I am using in WTX map.

     

    GET( "HTTP" , "-URL https://123.com/connect/Token   -METHOD POST  -TV -HDR+ -TYPE application/x-www-form-urlencoded  ", package(httpPayload Data:httpTokenRequest))

    I am using ITX 9.0.0.3




    ------------------------------
    Suriya Prakash
    ------------------------------

    Original Message


  • 6.  RE: Using ITX to scrape Finance data and display in a spreadsheet

    Posted Tue April 14, 2020 12:04 PM
    Hi Paul,

    Could you please share the ITX map. I have requirement with HTTP adapter, it will be helpful for me. ​

    ------------------------------
    Hemachandra C G
    ------------------------------

    Original Message