• State Suggested Answer
  • Replies 4 replies
  • Answers 2 answers
  • Subscribers 6 subscribers
  • Views 4463 views
  • Users 0 members are here
Related Discussions
Home » Discussions » Integrations

WEB API issue when is writing to the DB

miket0001

Hi,

I'm experiencing issues when I'm trying to write to DB with another user. Basically my API looks exactly like this one: https://docs.appian.com/suite/help/18.3/Web_API_Tutorial_-_Level_II.html 

With my user is working fine, but with another user I'm getting 500: "There was an error writing to the data store"

I put this user with Administrator privileges to  the datastore, constant, data type object and API object so basically has the same privileges like me for all the objects that this API is using, but somehow is not working.

Is there something that I'm missing?

Thank you in advance.

  Discussion posts and replies are publicly visible

Parents
  • 0
    Certified Lead Developer
    Hi couple of workaround to find out the root cause of this issue:

    -- I would not recommend setting up the security to the user's directly, instead create a group for the basic users who can access this API
    -- Try mapping this user under this newly created group
    -- Allow this newly created group as Viewer permission to the following types of objects
    -- API, Data Store Entity, rules directory (in case some rules are being used in this API) and the process model(if its being triggered by this API)

    If the above solution didn't work, then try debugging this as mentioned below:
    -- Try mapping this user under the same group as yours, once it's done, try accessing this API using the other user account.
    -- If this is working means, your group security setting with respect to objects are different than the basic user group.
    -- If this also didn't work then i would recommend you to have a look on log, as HTTP ERROR 500 represents exceptions

    Hope this will help you trace/debug the actual error and resolve it.
Reply
  • 0
    Certified Lead Developer
    Hi couple of workaround to find out the root cause of this issue:

    -- I would not recommend setting up the security to the user's directly, instead create a group for the basic users who can access this API
    -- Try mapping this user under this newly created group
    -- Allow this newly created group as Viewer permission to the following types of objects
    -- API, Data Store Entity, rules directory (in case some rules are being used in this API) and the process model(if its being triggered by this API)

    If the above solution didn't work, then try debugging this as mentioned below:
    -- Try mapping this user under the same group as yours, once it's done, try accessing this API using the other user account.
    -- If this is working means, your group security setting with respect to objects are different than the basic user group.
    -- If this also didn't work then i would recommend you to have a look on log, as HTTP ERROR 500 represents exceptions

    Hope this will help you trace/debug the actual error and resolve it.
Children
No Data
© 2024 Appian. All rights reserved.
We want to hear from you! Submit a review on Gartner or G2.