The web service is returning an error telling me the XML I post is invalid.
I know the XML is valid as I can run it successfully from Excel VBA using the MSXML library. I avoided the need to escape characters by using ' instead of ". Is there any additional escaping I should be doing with Data Explorer?
The mistake was the ) in the wrong place. I also had to use the Text.ToBinary() - thanks Chris!. I also had to use anonymous credentials when using the content properties.
Works a treat.
The use case I have in mind is to using DE as a self service Data Integration tool for combining cloud and on-premise data sources. I have sourced the cloud data (the hard part!) so it's looking like I'm on the way to getting what I've been looking
Thanks Microsoft Research and the DE devs.
Marked as answer byLee HawthornFriday, June 14, 2013 1:24 PM
Friday, June 14, 2013 1:24 PM
Microsoft is conducting an online survey to understand your opinion of the Msdn Web site. If you choose to participate, the online survey will be presented to you when you leave the Msdn Web site.