none
How get data from Web Service with token?

    Question

  • Can I get data from Web Service made with Java?

    This WS has a Token.

    Any ideas o reference?

    Regards!


    Fran Díaz | twitter: @frandiaz_ | Blog: {geeks.ms/blogs/fdiaz/} | Communities: {onobanet.es} & {secondnug.com}

    Wednesday, October 23, 2013 3:03 PM

Answers

All replies

  • I think what will be needed is for Microsoft to add a new signature to Web.Contents which accepts an HTTP headers collection operand. Of course you could create a server-side proxy to the service so that you could put the token in the currently available options operand.

    http://office.microsoft.com/en-us/excel-help/web-contents-HA104112310.aspx?CTT=5&origin=HA104122363

    Sunday, November 10, 2013 6:46 PM
  • Such a change to Web.Contents is currently under consideration but I'm not in a position to make any promises about when it would be delivered. Feel free to use this thread to indicate your interest in it.

    Sunday, November 10, 2013 9:02 PM
  • We've now added this ability to Web.Contents. You can say something like

    Web.Contents("http://my.web.service/1", [Headers=[#"The-Token"="0a0138ef2d"]])

    and it will pass a header with the key "The-Token" and the value "0a0138ef2d" as part of the HTTP request. For security reasons, this will only work for anonymous web requests.

    The December preview can be downloaded from http://www.microsoft.com/en-us/download/details.aspx?id=39933&WT.mc_id=blog_PBI_Update_PowerQuery

    Saturday, December 14, 2013 2:45 PM
  • Hi,

    I can't install the plugin, this message appears when i tried to install the plugin:

     

    Any ideas?

    Regards


    Fran Díaz | twitter: @frandiaz_ | Blog: {geeks.ms/blogs/fdiaz/} | Communities: {onobanet.es} & {secondnug.com}

    Monday, December 16, 2013 2:50 PM
  • We've gotten intermittent reports of this problem but aren't sure why it happens -- nothing about our requirement for this feature of Office have changed from older versions of the addin. I think the only advice we've given is to try to use the "repair" feature of Office that's available through the Control Panel.
    Monday, December 16, 2013 3:00 PM
  • I'm repairing now.... ^^

    Fran Díaz | twitter: @frandiaz_ | Blog: {geeks.ms/blogs/fdiaz/} | Communities: {onobanet.es} & {secondnug.com}

    Monday, December 16, 2013 3:12 PM
  • I don't install the plugin after repair the office from Control Panel, i return back to the 2.8.3476.202 version (32bit) :-(


    Fran Díaz | twitter: @frandiaz_ | Blog: {geeks.ms/blogs/fdiaz/} | Communities: {onobanet.es} & {secondnug.com}

    Monday, December 16, 2013 3:34 PM
  • Just to make sure I understand correctly, 

    1. You did a "repair" on the Microsoft Office installation but it didn't help.
    2. The December release gave you this error but you were able to reinstall the November release successfully.

    Is that right?

    Monday, December 16, 2013 3:41 PM
  • Correct ^^

    Fran Díaz | twitter: @frandiaz_ | Blog: {geeks.ms/blogs/fdiaz/} | Communities: {onobanet.es} & {secondnug.com}

    Monday, December 16, 2013 3:43 PM
  • I solved my problem with this solution: http://social.technet.microsoft.com/Forums/en-US/c94aaf63-eef1-4da7-a55a-d3b7b159361d/excel-net-programmability-feature?forum=powerquery

    Fran Díaz | twitter: @frandiaz_ | Blog: {geeks.ms/blogs/fdiaz/} | Communities: {onobanet.es} & {secondnug.com}

    • Marked as answer by Fran Diaz Thursday, January 09, 2014 4:49 PM
    Thursday, January 09, 2014 4:49 PM