Develop Integrations with Web Services | APIs

Hi, I am new to Acumatica, I am researching on Acumatica Rest API to integrate in our platform. We are a product based company building a SaaS Management platform. We are integrating multiple SaaS Application and Acumatica is a part of it. I have created a new account in Acumatica and want to know how I can create a OAuth client and generate the Client ID and Secret so that I can authorize and generate the access token to test the APIs. Please help me.

I am trying to get the response from acumatica in JSON format for this call.This is the call I am making using POSTMAN{{acumaticaurl}}/odatav4/$metadata?$format=jsonI have also tried changing the Accept header to “application/json”, but that is not changing the format.So, does that mean that the only format I will get when making a metadata call is going to be ATOMXML?Thank You,Abhijit

I have a service that is creating Acumatica SO’s via REST calls, and now I need to also create Payments to apply to each SO as it comes in. Is it possible to create an SO with a payment in one PUT request for the sake of simplicity and rate limiting issues? I saw some conflicting information in this thread where a user says:https://stackoverflow.com/questions/57093218/unable-to-create-payment-for-order-using-rest-api But when I tried this, the response from the server is: {'message': 'An error has occurred.', 'exceptionMessage': "'OrigDocAmt' cannot be empty.\nOrigDocAmt: 'OrigDocAmt' cannot be empty.", 'exceptionType': 'PX.Api.ContractBased.OutcomeEntityHasErrorsException', 'stackTrace': '  … Any help is appreciated!

Hi teamIm creating PO through API in old tenenat i was creating only skeleton of PO with no line items and it still defaulting to on hold status but now when we changed the to new tenant the PO will default to “Closed” how can i change that here is the PO  Instaed of defaulting to Closed if i don’t have items mapped i want it to be defaulted to “Open” OR “On-Hold”       Thanks

I understand how to do it from the UI, however is there a way of doing that programmatically, using e.g. a RESTful request or a SBAPI command.(One of the desired product flows I’m exploring entails creating a workspace if needed and then populating it with a couple of GIs) 

I have created a web service for Equipment Timecard.In the web service, I have the entry screen (EP308000) as DocumentSummary, the Summary Tab (EP308000) as a collection named DocumentLine, the Details Tab (EP308000) as a collection named LineDetail and the main screen Equipment Timecards (EP407000).   Web Service Setup for Equipment TImecardWhen I run this in Postman, it only creates a record in EP308000 and there is no detail and EP407000 there are no totals.  Result of running web service in Postman - Missing the totalsResult of running web service in Postman - Missing the Summary Tab and Details Tab data This is the body of the content that I am sending in Postman.  It is not throwing any errors. Based on how the screen works, I believe I am mimicking the flow. Is the flow I am attempting wrong? {    "RefNbr": {"value":"EQ00000045"},    "EquipmentID": {"value":"1"},    "Status": {"value":"On-Hold"},    "Week": {"value":"2024-06"},    "Type": {"value":"Normal"},    "DocumentSummary"

Hello everyone! We are currently working on a new version of the Default REST API Endpoint and we’d like to hear from you. Are there any specific screens you’d like to see in the new version of the endpoint?Are there any workflows you’d like to see supported?  We’d be happy to hear your feedback and hopefully incorporate it into the new version of the endpoint to make it more convenient for you to integrate with Acumatica ERP via REST API.

I have an integration written that matches an external invoice line to an Acumatica invoice line. I am matching our external invoice line to an SO line, then using that same line to lookup the correct line on the Acumatica invoice.It occasionally fails to make a match.I found that “Order Line Nbr.” is available on the Acumatica invoice detail lines. Is "Order Line Nbr" on invoice detail lines the sales order detail line number for the matching SO line? Should I match to this rather than Line “Nbr”? Why would these lines differ?Thanks for any help.

We are building an integration for our order management platform. We are using OData to get information from Acumatica (like tracking updates), but the REST API to send orders. Is it better to stay signed-in, or to sign-out between each transaction? Anything we should be considering in determining this?

Good day.We are receiving the following error when trying to update a customer record: Another process has added the 'Customer' record. Your changes will be lost.  Any guidance on the above will be appreciated.  Kind regards, Alecia

https://{myendpoint}.acumatica.com/entity/{myentity}/v1/SalesOrder/CreatePurchaseOrderI am attempting to invoke the webservice endpoint here (created by me): I have created another request where the mapped action is the createPurchaseOrder@replenishment to attempt that as well: I want to simulate the conditions of this buttonhere is the postman request (screenshot 3)I am unable to find anything anywhere to understand what parameters may be required, and the reponse is downright confusing.The error returns this-     "innerException": {        "message": "An error has occurred.",        "exceptionMessage": "Purchase Order '{0}' created.",The ambition is to process the order below, but i have zero feedback from the api’s themselves on missing required parameters or other oversights.Any assistance would be appreciated,Chris

When I go to https://xx-xx.acumatica.com/ODatav4/myCompany/PX_OBJECTS_IN_INSETUP I get the error You don't have the user rights to view this page. HTTP ERROR 403. I get the same error for table PX_OBJECTS_CR_BACCOUNT. I don’t have any trouble with the other CR tables like contact, location, or the IN tables like INSITE, or INITEMCOST. I do have CR and IN viewer roles enabled for the user. Do these tables have a relation or something to a table I don’t have access to.So where else do I need to grant access? Also, is there a location in Acumatica to see what roles the tables are bound to? Thanks! 

I am investigating different integration options and wondering if others have utilized Azure Data Factory as their ETL tool or have any insight into this tool.

I was able to implement a custom screen with an action button that when clicked, it open an external url which is basically a UI which works with the acumatica RestApi and perform specific actions and AI analysis on it. It working perfectly. But I want to try something else, to reduce the delay - in fact the user has to click on the button to open the web application inside acumatica frame. I want to execute 2 actions:   when I open the custom screen it automatically loads trigger the URL redirection and load the web application.  to pass the user role in the query : “http://webapplication.com?role=’role of the user’ 

Hi Community,I am trying to add One Line item in Appointment Details tab having Line type as "Non-Stock Item" through Acumatica.RESTApi using PutEntityAync from C#. But when I try to insert any value for ActualQty field I am getting an error as "exceptionMessage": "An error occurred during processing of the field Qty: Specified cast is not valid.." But the datatype of that field is decimal and I am trying to insert same as Decimal.If I keep ActualQty as Null then the remaining fields are inserting as expected.And while updating any Non-Stock Item if I give ActualQty any input then I am getting same error.Here if I keep ActualQty as Null then I am getting "exceptionMessage": "Nullable object must have a value". But If I remove ActualQty filed from the request, then the update is working fine.Remaining Decimal type fields are updating but facing this issue with ActualQty.Also while adding a new line in details, I’m unable to insert AcutalQty thorugh Postman or API PUT call.If I pass Actu

'{"error":{"code":400,"details":[{"@type":"type.googleapis.com/google.rpc.ErrorInfo","metadata":{"action_name":"CreateAttachment","cause":"Invalid input for attribute Content to operation CreateAttachment.rsb, only InputStream is allowed.","connection_type":"Acumatica"}}],"message":"Unable to execute the specified action.","status":"FAILED_PRECONDITION"}}' We have been trying to pass CreateAttachment action, but it displays the following error. What kind of InputStream shall we provide? Any Ideas?

Hi Everyone.Is it possible for me to add a second statement in Acumatica? The first statement type would be the open statements. The second would be the balance brought forward. The open balance statement would be the default. I would then want to be able to generate a second balance brought forward statement and send both to the customer.Any ideas on how I could set this up?

I want to create a custom button and call it using the postman. I tried it with the "CreatePayment" button. But it doesn't work  Is it possible to do this? 

Good day. We’re having a bit of a struggle determining the naming of entities in order to extract the relevant information via api calls. Example: We are trying to expand/extract the Ecommerce Data tab field “description”. Where exactly can we look to find the naming of this entity to expand? Will appreciate any guidance.Thank you     

I am trying to get the Purchase Receipts and Purchase Orders filter by Date using RestAPI in postman, please provide me some example.

Hi Everyone,I'm trying to override the currency rate on a payment via the REST API.I can do this no worries in the UI however I'm struggling to get the API to do it.I've attempted to extend the endpoint to add the CurrencyRate field however this isn't making a difference, the payment will still create however it will just use the regular exchange rate.Does anyone know how to get this working? 

Hi everyone,I recently set up a new instance in MYOB Advanced and extended a new endpoint specifically for managing Purchase Orders. I'm trying to complete a purchase order through this endpoint, but I keep encountering an error. I'm hoping someone might be able to shed some light on this issue.Endpoint and Request: I'm sending a POST request to:POST http://localhost/MyStoreInstance7/entity/Default/1.1/PurchaseOrders/CompleteProcessingCategoryWith the following JSON body:{  "entity": {    "OrderNbr": "PO001326"  }}Response: However, I'm receiving a 500 Internal Server Error with the following details:{    "message": "An error has occurred.",    "exceptionMessage": "Operation failed",    "exceptionType": "PX.Data.PXInvalidOperationException",    "stackTrace": "...",    "innerException": {        "message": "An error has occurred.",        "exceptionMessage": "The Complete Order button is disabled.",        "exceptionType": "PX.Data.PXActionDisabledException",        "stackTrace": "..." 

Hi Forum, I recently created a Generic Inquiry and then Created an Entity on the Web Services panel extending the default endpoint. I followed the steps on this link: https://www.acumatica.com/blog/contract-based-apis-in-generic-inquiries/. The Guide works perfect, I could create the entity, I could retrieve the data using a Put method on Postman and everything seems fine, But, Now if I tried to filter the data using the information from one of the fields in the Results (The ProjectID). I can not filter the information. I tried to use the next query but it gives me the error shows in the image below: Query working:  Query not working:  My intention is not to just get the information in the Generic Inquiry, I can do that very easy with the Generic Inquiry directly, my end goal is to be able to update data on the Generic Inquiry. I want to update one field from the table I’m using in the Generic Inquiry. Please your help to know if I’m doing something wrong on my Query on Postman that I

Hello Community,I have been searching out for APIs related to Emails. Can anyone guide me out where can I find one? or any references.Thanks in advance.