Skip to main content
Answer

Acumactica PUT and GET API

  • April 15, 2024
  • 8 replies
  • 693 views

Forum|alt.badge.img+3

Hi all, I am planning to get the complete customer data from my Acumatica instance and then going to put updated customer info from my local database to Acumatica Customer form in Attributes Tab. I want to ask which API should i use? Please help me to find the solution. I have read the documentation but did not get the point. If anyone guides me it would be appreciated. Thanks ALL>

Best answer by Vignesh Ponnusamy

@tahayabali,

Yes, it is possible to update only the specific. Pass the fields that you need to modify in the JSON, along with the key fields. The input should be JSON, it is not possible to switch the request payload format. 

8 replies

Forum|alt.badge.img+3

NicholasBova52
Acumatica Employee
Forum|alt.badge.img+1
  • Acumatica Employee
  • April 16, 2024

Also, if you specifically need to insert/update records on the Attributes tab of the Customer, then the endpoint entity in this screenshot is what you’re looking for.

And if you’re updating the Attributes records for an existing Customer, then you can follow this specific article (Update a Customer) from the linked posted by @ruchikasharma23, just replace any usage of “BillingContact” with “Attributes” and then specify the “Attributes” fields you want to update.


Forum|alt.badge.img+3
  • Author
  • Captain I
  • April 16, 2024

Thankyou all, That help me alot. Can i do it in python put request or only Post man ?

 


NicholasBova52
Acumatica Employee
Forum|alt.badge.img+1
  • Acumatica Employee
  • April 16, 2024

Thankyou all, That help me alot. Can i do it in python put request or only Post man ?

 

As long as it’s a valid HTTP request and your credentials to the site are valid, then you can do it from Python, Postman, or any other REST API framework in any language.


Forum|alt.badge.img+3

 @tahayabali 
You should be able to achieve this in the language of your choice. We have example of implementation in C# and Java
https://github.com/Acumatica/AcumaticaRESTAPIClientForCSharp
https://github.com/Acumatica/Java-based-REST-API

 


Forum|alt.badge.img+3
  • Author
  • Captain I
  • April 16, 2024

Does it only accept JSON format or can I choose? For example, if I want to transfer data from my local database to the attributes tab in Acumatica. For instance, if a customer's email is 'xyz' in my local database and I only want to update the email field.

I am considering structuring the code flow like this: to retrieve data from the Customer form and update only the fields that I want to, leaving the other data unchanged. Is it possible to do that?

 


Vignesh Ponnusamy
Acumatica Moderator
Forum|alt.badge.img+5

@tahayabali,

Yes, it is possible to update only the specific. Pass the fields that you need to modify in the JSON, along with the key fields. The input should be JSON, it is not possible to switch the request payload format. 


Forum|alt.badge.img+3
  • Author
  • Captain I
  • April 18, 2024

Thanks. If i need to create new DAC and put the whole data of customer over there. Any guide or blog on how to create DAC and put data accordingly? Thanks in advance.