Get credentials for Acumatica via events

Hi @Ivan 

We can achieve this by using endpoint entity Users. But still, the password is in an encrypted format. you need to write logic to decrypt and use for this.
 

Hope this will help you.

Hi, jinin

Thank you for response

I need to clarify one moment : “the password is in an encrypted format. you need to write logic to decrypt and use for this.”

By which approach the password can be decrypted ? It can be done by standard .NET tools or it must be done by specific way ?

I believe by default Acumatica hashes the passwords which would mean you can’t actually get the original password(the default admin password “setup” is stored in plaintext though).

You should be able to get the current User ID using ICurrentUserInformationProvider.GetUserId() and from there you can just use Users.PK.Find(graph, userID) the Users object will have the username and the password hash.

If you have disabled password hashing(not recommended) and instead are using encryption you should be able to use IUserManagementService.GetUser(userID) to get the MembershipUser object and then call GetPassword() on that. If password hashing is enabled then it will throw an error. 

Below is a short code sample from within a graph.

        [InjectDependency]
        private ICurrentUserInformationProvider currentUserInformationProvider { get; set; }

        [InjectDependency]
        private IUserManagementService userManagementService { get; set; }

        private Guid? getCurrentUserID()
        {
            return currentUserInformationProvider.GetUserId();
        }

        private string GetPassword(Guid userID)
        {
            return userManagementService.GetUser(userID).GetPassword();
        }

Hi, jinin 

I have added Users entity to Acumatica as you suggested 

but the request is unworkable

I tried to find fields named admin and password, but they are absent here 

I added PX,Data . Now the types are available for usage

However the last string receive the error

It required PX.Export

After I added it to project the error was removed

After I started project I received this error : 
Can't restore password for MembershipPasswordFormat.Hashed password format

Yeah that is what I was saying, by default Acumatica will hash passwords(using the SHA1 algorithm I believe) and only store the hash. As such you cannot get the actual password. You can get the password hash off the Users object though: Users.PK.Find(graph, userID). 

Basically if you are trying to re-use the current Acumatica username and password in an API call(assuming I am understanding you correctly) that is not an option with you current configuration. Acumatica doesn’t actually know your password in this scenario it just knows the hashed result of your password. So when you type in your password to login Acumatica performs the same hashing function on it and then compares that to the the stored hash result(in the database) to determine if it is the correct password.

You can turn off the hashing but that’s not recommended.

It sounds like you are trying to make an API call to Acumatica itself from within graph code which is probably not the best route. If you absolutely have to I would look at other API authorization methods(that don’t involve user passwords). Generally speaking though anything done through the API can be done via internal code. What is it you are trying to accomplish with the API calls?

I need to do API calls in order to extract data from different entities. When the user saves the payment in Acumatica, my solution creates documents on local machine with this payment, invoices which are located in “Document to Apply tab and Customer entity data.”. I use API calls in order to make link between entities and provide valid data.

You understood me correctly, I need to re-use password in order to omit writing credentials inside the project, because they can be changed, that is the reason why I need to get login, password, Url and company in order to build request and make call to other entities inside the event 

That can all be done via internal code and would be much more performant(and probably easier to code). 

In the event handler you already have access to the payment data but if you need other records you can use BQL statements to retrieve them. If you need to create invoices or apply payments that can all be done via various graphs and methods as well.

Hi markusray17

I found how to extract elements form Documents To Apply tab (I wrote about this in previous comment)

Now it remains to get the customer record. You suggested to use this : Customer.PK.Find(customerID);

It requires the graph parameter 

I do not know what must be putted here. I can create just object of this type and put it here or it must be initialized and contain some specific data ?

Thank you for response

I understand that going  through the training is important to omit lost of stages, but I need to finish it as soon as possible