Skip to main content
Nintex Community Menu Bar

SmartObject OData API

  • March 16, 2018
  • 2 replies
  • 30 views
  • Translate
F

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.

    2 replies

    T
    Forum|alt.badge.img+18
    • tin
    • 555 replies
    • March 16, 2018

    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.

    Translate
    F
    • Ferko
    • Author
    • Rookie
    • 12 replies
    • March 21, 2018

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

    Translate

    Reply


    Sidebar Buttons
    Nintex Community Home Contact Nintex Support Email Nintex Community Check Nintex Status
    Terms & ConditionsCookie Settings

    Cookie policy

    We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

     
    Cookie Settings