TM1 URI API Syntax - WebsheetPath UNC path on network 10.2.2

[7Zark7]

Hi All,

I am currently having issue migrating tm1 websheets where I am referencing a file using UNC path in TM1 10.2.2

### This Works - if its placed in the application folder

http://TM1WebHostName:9510/tm1web/UrlApi.jsp#
Action=Open
&Type=WebSheet
&Workbook=Applications/MyFolder/MyFile
&AdminHost=host
&TM1Server=Tm1ServerName

## But this does not - if referenced on network share

http://TM1WebHostName:9510/tm1web/UrlApi.jsp#
Action=Open
&Type=WebSheet
&Workbook= //tm1server/sharepath/filename.xlsx
&AdminHost=host
&TM1Server=Tm1ServerName

In version 10.1.1 I was able to see this file:

http://TM1WebHostName/TM1Web/TM1WebMain.aspx?
&action=OpenObject
&type=Websheet
&value=\\cusydcogapp104\TM1\Data\}Externals\NonTM1UsersReports\MyReport.xlsx

It appears the parameter = value is no longer available?

In short all I want to do is open up an excel file within a folder. Is there something missing from my syntax? Under 10.1.1 all was working fine.

Cheers

Zark

[rmackenzie]

Between 10.2.0 and 10.2.2 the URL API got incrementally rolled out so there may still be bits and pieces that weren't re-implemented. Remember the underlying stack has totally changed between 10.1.x and 10.2 and there were casualties along the way e.g. the way integrated login used to work etc. I don't think you are doing anything wrong other than trying to use functionality that might not be there - best to raise an official support call.

[7Zark7]

Thanks Robin. I have raised a ticket with IBM support to see whether they can advise a solution or workaround.

Cheers

[7Zark7]

Hi All,

I have been in touch with IBM and they have logged this as a defect under: APAR PI28510. Hoping now that this is released in the next fix pack.

Cheers

Shock

[blackhawk]

They considered this a defect? I am a bit surprised that you can specify //tm1server/sharepath/filename.xlsx, because to me this seems to be a security issue (at least from an external front-end server perspective).

[7Zark7]

Hi All,

Fix has been found and resolved. See example below:

# Full compter name needs to be used

ie use: computerName.domain
instead of: computerName

#######

http://computerName.domain:9510/tm1web/UrlApi.jsp
#Action=Open
&Type=WebSheet
&Workbook=\\tm1server\sharepath\filename.xlsx
&AdminHost=computerName.domain
&TM1Server=host

Cheers

Shock