Cognos Analytics

 View Only
  • 1.  Update(replace) Excel File thru rest API?

    Posted Wed August 04, 2021 12:55 PM
    Hi

    I'm using excel files as sources for my data modules. Can I update(replace) them tru rest api?
    I'm using cognos anaytics on cloud.

    Or any other way to automate this replace file?

    Thanks

    ------------------------------
    CESAR JAVIER SASAKI NIMURA
    ------------------------------

    #CognosAnalyticswithWatson


  • 2.  RE: Update(replace) Excel File thru rest API?

    Posted Wed August 04, 2021 08:06 PM
    Hi,

    You may use Jupyter to load file content available in a specific URL and then save data in a data set.

    And you can schedule Jupyter Notebook.

    ------------------------------
    JEAM COELHO
    Cognos Solution Architect

    LinkedIn: https://www.linkedin.com/in/jeamcoelho/
    ------------------------------



  • 3.  RE: Update(replace) Excel File thru rest API?

    Posted Wed August 04, 2021 08:30 PM
    Hi Jeam

    So Jupyter to load a file? how can you do that in cognos?

    ------------------------------
    CESAR JAVIER SASAKI NIMURA
    ------------------------------



  • 4.  RE: Update(replace) Excel File thru rest API?

    Posted Thu August 05, 2021 11:05 AM

    It should be possible as there are API endpoints for it.   I have not tried it though.   Whether the cloud aspect would affect things is not known to me.

    https://www.ibm.com/docs/en/cognos-analytics/11.2.0?topic=apis-rest-api

    https://www.ibm.com/docs/en/cognos-analytics/11.2.0?topic=api-rest-reference



    ------------------------------
    IAN HENDERSON
    ------------------------------