SDC and MS SQL Reporting Services

51 views
Skip to first unread message

Dan B.

unread,
Nov 27, 2012, 2:56:39 PM11/27/12
to googl...@googlegroups.com
Has anyone fetched data through SDC to MS SQL Reporting Services?

In an App Script, the following works for web-based MS SQL report 2008r2 server with Basic Authentication, but when pointing to an SDC resource returns "Bad Request" or "DNS Error" and when debugged, no errors, but response_content_size: 0

var textContentUrl = UrlFetchApp.fetch("http://web.reportserver.com/reportserver?/Reports+Folder/Report&rs:Command=Render&rs:Format=CSV",options).getContentText();

where options is an object with the method:get and Authorization:Basic+encrypted_authentication_string

use_intranet:yes was included for SDC calls, which returns existing file in any folder.


Reply all
Reply to author
Forward
0 new messages