Skip to main content
Solved

OData Credentials Don't Work


Forum|alt.badge.img

Hello,

I am trying to access OData to eventually pipe data to Excel but I cannot get my credentials to work.  I am using the URL http://<application site domain>/odata/

We only have one company so there is nothing to add after ‘odata/’, although I’ve tried that as well.

I am then prompted for credentials and I enter my Acumatica username and password, and the credentials are invalid.  I have checked the box for OData4 User for my username.

What am I missing here?

Thanks!

Best answer by gbrazelton14

@josborn - Since you only have one tenant, your user name should just be your login name (do not include the @ tenant part)

View original
Did this topic help you find an answer to your question?

4 replies

Kandy Beatty
Captain II
Forum|alt.badge.img+16
  • Captain II
  • 2183 replies
  • January 4, 2024

Forum|alt.badge.img
  • Author
  • Freshman I
  • 32 replies
  • January 4, 2024

Hi @Kandy Beatty,

Thank you for your reply.  From what I understand the login username is userid@tenant.  Our Tenant has spaces in the name which I think may be preventing it from working.  Do I need to remove the spaces from the tenant name?

Thanks!

 


craig2
Pro I
Forum|alt.badge.img+2
  • Pro I
  • 90 replies
  • January 4, 2024

Hi @josborn ,

A couple of notes on OData after wrestling with it for a few years:

  • A dedicated login for OData feeds seems to be the way to go.  Then you can better tweak access rights and set the password to not expire.  After upgrading to 23R2, there were a lot of forced access rights changes, and I had to add all the “Viewer” roles to our OData login.
  • A lot of my Excel tools use multiple OData feeds.  If you Refresh All with the wrong credentials (like password), Acumatica will register that as multiple failed logins and could temporarily lock the account.  You can unlock the account in the Users screen, then try again.
  • If the wrong OData credentials are entered (at least in Excel), it will save them.  You need to clear them out and start fresh.  Go to the Data tab > Get Data > Data Source Settings.  Select the URL that got saved for your feed, and click Clear Permissions.  This will then get you to enter your credentials again.
  • I would still use the company name after the /ODATA/ , but we do have multiple entities so I can’t confirm if you need to do that.

Hopefully some of that is helpful, good luck!

 


Forum|alt.badge.img
  • Jr Varsity III
  • 61 replies
  • Answer
  • January 4, 2024

@josborn - Since you only have one tenant, your user name should just be your login name (do not include the @ tenant part)


Reply


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