将学术搜索API调用到Power BI或Excel中 [英] calling academic search API into Power BI or Excel

问题描述

我一直在尝试使用OData连接将任何API调用到电源中。$ n $; 看起来它调用了查询但是当我把密钥放入其中时要求在任何身份验证方法Basic中进行授权时，它会以未经授权的方式返回Web API吗？

解决方案

< blockquote>

嗨约翰，感谢有趣的牛津学术API，首先你应该去https://projectoxfordkeysignup.azurewebsites.net/订阅（点击请求新的关键按钮）学术API，之后你会得到你的订阅密钥（初级/次级）。然后，现在支持学术API的
plz下面有3个操作，详细的API参考请参阅https://msdn.microsoft.com/en-US/library/mt637114.aspx 

http://api.projectoxford.ai/academic/v1.0/interpret?query= [您的查询]& subscription-key = [您的主键]

http://api.projectoxford.ai/academic/v1.0/evaluate?expr= [您的表达]& subscription-key = [您的主键]

http：/ /api.projectoxford.ai/academic/v1.0/calchistogram?expr=[your expression]& subscription-key = [your primary key]

 

I have been trying to call the any of the APIs into Power
BI using the OData connection.   It looks like it call the query but when I put the key in when it asks to authorize in any authentication method Basic, web API it comes back unauthorized, any insight?

解决方案

Hi John, thanks for interesting Oxford academic API, firstly you should go https://projectoxfordkeysignup.azurewebsites.net/  subscribe(click request new key button) academic API, after that you will get your subscription keys(primary/secondary). Then, plz go with below for 3 operations now academic API supported, the detailed API reference see https://msdn.microsoft.com/en-US/library/mt637114.aspx 

http://api.projectoxford.ai/academic/v1.0/interpret?query=[your query]&subscription-key=[your primary key]

http://api.projectoxford.ai/academic/v1.0/evaluate?expr=[your expression]&subscription-key=[your primary key]

http://api.projectoxford.ai/academic/v1.0/calchistogram?expr=[your expression]&subscription-key=[your primary key]

 

这篇关于将学术搜索API调用到Power BI或Excel中的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！