Cognos Analytics

Cognos Analytics

Connect, learn, and share with thousands of IBM Cognos Analytics users! 


#Product
#Analytics
#CognosAnalytics
#Analyticstools
#TechXchange Partner
#TechXchange Session
#TechXchange Presenter
#AI
 View Only

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

    Posted 08/04/21 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 08/04/21 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 08/04/21 08:30 PM
    Hi Jeam

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

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

    Original Message


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

    Posted 08/05/21 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
    ------------------------------



Related Content