Skip to main content

SmartObject OData API

  • 16 March 2018
  • 2 replies
  • 23 views

Trying to use the SmartObject OData API in K2 Five. I configured it but when I try to access it from Excel 2016 as described in this
article https://help.k2.com/onlinehelp/k2five/userguide/5.0/default.htm#How_Tos/ODataFeedService/ODataFeedWithExcel.htm, Excel tells me
that I am not authorized and after three attempts, my Windows account is locked. I looked into the K2 log and there is a message:

 

"5761567","20*personal details removed*:09:58","Error","Communication","8130","ConnectionPacketError","SourceCode.SocketService.Legacy::HandlePacket","8130 Error processing message from 157.23.160.11:58577: Authentication With Server Failed : The user name or password is incorrect","","","VS-FRMV-KZ01:C:Program FilesK2Host ServerBin","5761567","0b0064c4b9d146e3b6b547b47bdbf239",""


I tried under PowerPivot for Excel 2010 using the same account/password and managed to connect by configuring the connection as follows:

 

15716i97B814EEF34600B2.jpg

 

However, when I moved to the next screen, the list of tables is empty with the following message:

 

No tables were found in the data source. Check the connection information and login credentials.

 

Any ideas? Thanks.

Are you able to run a browser as this same account and browse to the Odata URL for this SmartObject?  I.e.


https://k2.denallix.com/api/odata/v3/TestSMO


 


Does it also prompt for credential but do not accept it?  If so, perhaps 'Basic Authentication' was not installed on the server similarly to:


http://help.k2.com/support-services/kbt144086


 


Both the Odata and Workflow subsites will need Anonymous and Basic Authentication enabled.

Basic Authentication is not enabled right now. We'll activate it and test again. Thanks for the answer.

Reply


View our Community Site Map

Nintex Community Sitemap
Terms & ConditionsCookie settings