Hi Alex,
The good news is, yes you can upload. The way to do it depends a bit on the type of cloud version you use.
When talking about CA Hosted, you can use the sftp method to upload your file.rest to any subdirectory under webcontent. Please consult your welcomekit for more info on sftp setup. In this case you can end up configuring your rest api connector as follow:
jdbc:ibmcognos:autorest:config='/data/dropbox/webcontent/RESTAPI_CONFIG/file.rest';
or
jdbc:ibmcognos:autorest:config='https://servername.ca.analytics.ibm.com/RESTAPI_CONFIG/iextrading.rest';
/data/dropbox/ refers to the sftp endpoint for uploading all your assets to ca cloud ; any path under this can be used to reference your file.rest ; in above example I created one subdirectory for all my .rest configuration files
When talking about CA on Demand, you can also upload files (javascript or other) via extension definition. For more info on how to do this , please refer to
https://public.dhe.ibm.com/software/data/sw-library/cognos/mobile/scriptable_reports/static/html/HowToUseAnExtensionToHostJavaScript.htmVia this method you should be able to address the file via below string
jdbc:ibmcognos:autorest:config='https://<servername.ca.analytics.ibm.com>/bi/v1/Ext/<EXTENSION_NAME>/file.rest';
Hope this helps
Peter
------------------------------
Peter D'Haeyer
------------------------------
Original Message:
Sent: Thu November 19, 2020 11:00 AM
From: Alex Santamarta
Subject: How to upload a REST endpoint configuration file to IBM Analytics on the cloud
I'm trying to setup a REST datasource and this has several URLs depending on the items you want to query.
According to this guide
https://www.ibm.com/support/knowledgecenter/SSEP7J_11.1.0/com.ibm.swg.ba.cognos.ag_manage.doc/autorestjdbcug.pdf?view=kc
it is possible to create a REST file with format file.rest
to map all tables in a single file. How can I upload this file to Cognos?
------------------------------
Alex Santamarta
------------------------------
#CognosAnalyticswithWatson