Develop Integrations with Web Services | APIs

Hi community,Where I work we have been using the REST API quite a lot to automate redundant tasks in Acumatica and tie some of our in house software in to it. However, I do not have a lot of experience using “Actions” aside from the “Release” button and so have come to you for help. Objective: Add a PO Receipt to an existing Bill. The Bill has already been created and is on “Hold”. I have added the “AddPOReceipt” action to my extended web service endpoint. When I POST to “AddPOReceipt” endpoint I get a 204 response to which I follow up with a GET to check the status of the request and I get a 200 response. When I look at the bill there is no receipt added to it though. What am I doing wrong? myurl = "https://4iiii.acumatica.com/entity/ManleyEndpoint/17.200.001/Bill/AddPOReceipt"jsonUpdate = { 'entity': { 'Type': {'value': 'Bill'}, 'ReferenceNbr': {'value': '006357'}, }, 'parameters': { 'ReceiptNbr': {'value': '003341'}, '

I’m following the example in Lesson 3.1 of the I310 training course.  But instead of retrieving attachments of a Stock Item, I want the attachments of a Purchase Order.  In Postman, I’m performing a GET to:https://localhost/PhoneRepairShop/entity/Default/20.200.001/PurchaseOrder/000001?$select=OrderNbr,files&$expand=files The response is: Operation is not valid due to the current state of the object. This happens for both open and closed purchase orders.   Am I missing something? 

Hello , i need to check this  default value "mode de reglément"  in customer with API.thank you for help. 

Hello Team, I hope things are going well. Could you please help me with the following question.Acumatica has the Customer Summary module. Link to the description - https://help-2017r2.acumatica.com/Wiki/ShowWiki.aspx?pageid=4d224cd8-6553-4930-872b-d667ddff891e I want to receive all Customers from this summary and their Currency Ending Balance column.But I cannot find the API to receive these Customers and their Currency Ending Balances. Could you provide a link to the API?Of course, if it is possible.

Hello Team,Could you please provide an example of the request how to update the Customer’s credit limit?Or could you provide a link to the API that describes how to update the record at the customer level?Regards,Andrew

Can you please forward me the doc link where you mention all the native rest API and its schema and all details. if we have custom fields on Sales Order like Amazon ID , how can i get same on invoice creation automatically 

Hello,I have a problem getting the value of auto-incremented field of a new inserted record.In my DAC the Id field has [PXDBIdentity(IsKey = true)]. It is the only key field.Here’s some code.MyDac newDac = graph.MyDac.Insert(new MyDac()) ;int? tempId = newDac.Id;graph.MyDac.Cache.Persist(PXDBOperation.Insert);int? newId = newDac.Id;tempId is negativ as expected. But newId is alway 0, I’d expect the real value of the newly created entry like in DB. NewDac is still in Cache.Inserted and in DirtyCashes.If I call graph.Actions.PressSave() instead of Cache.Persist() newDac.Id is updated and it moves to Cache.Cached. But I have entities in other views that should not be saved at this time.I am sure, that with other Dac classes the Id is updated after callling Persist(). Does the system check relations to other entities and and therefore may not give back the new Id in my case?How can I get the real Id of the newly inserted record without PressSave()?

Hi, I have 4 APIs, The first is POST method that posts the credentials to the CIS system and accessToken is generated(the token changes daily) which is used in the GET methods. The rest are GET methods that gets the data and imports into Acumatica. So far my code retrieves the data successful and they are in json format.How can I import this data into Acumatica?N/B The integration is permanent, not a one time thing. Data is Customer Data, Invoices and Payments.

Hi, I have extended Default/18.200.001 endpoint to include Construction SubContracts like this http://localhost/test/entity/Subcontracts/18.200.001/Subcontracts I can filter by a field from the summary like thishttps://localhost/entity/Subcontracts/18.200.001/Subcontracts?$filter=SubcontractNbr eq 'SC-000002' However, can I filter on a field in a details table?Example, Is it possible to filter by the Project field in Document Details tab in SubContracts end point? 

I have several detail grids with one master. Each detail has its own tab. The problem is the grids that are in a tab, that is not in view, are not updated when the master record changes.I’ve already done in aspx and code:MasterGrid: <px:PXGrid SyncPosition="true" KeepPosition="true" <AutoCallBack Command="Refresh" Target="tree" ActiveBehavior="True">      <Behavior RepaintControlsIDs="DetailGrid1, DetailGrid2View"               BlockPage="True" CommitChanges="False"></Behavior> </AutoCallBack> (I am unsure about Target in this case)   DetailGrid_n: <px:PXGrid SkinID="DetailsInTab" SyncPosition="True” <CallbackCommands>         <Refresh SelectControlsIDs="MasterGrid" ></Refresh> </CallbackCommands>   Graph: public SelectFrom<DetailDAC_n> .Where<DetailDAC_n.Id.IsEqual<MasterDAC.Id.FromCurrent>>             .View Details_n; BLC: _(Events.RowSelected<MasterDAC> e) {            Details_n.V

I’m looking at Endpoint version 20.200.001 and specifically the Customer endpoint. The settings indicated that this endpoint is connected to screen AR303000. Under Customer is a field defined as:BillingContactOverride, Financial → Financial Settings, OverrideBillContactBut that field isn’t on that tab. OverrideBillContact is Billing → Bill-to Address → Override, OverrideClicking Validate Entity returns a message that says it validated.Am I missing something on understanding the field mapping or is the mapping incorrect?

Hello,I need a configure screen that contains also password and store them to DB.I set the TextMode to “Password” to hide it.    <px:PXTextEdit ID="edPassword" runat="server" DataField="Password" TextMode="Password" /> But the web browser (Chrome and Firefox) fills-in the login password into this field.Is there a possibility to prevent that in code? Thanks,Michael

Hello All,I am trying to create a POAddress record from C#.But I get exception after insert that “CustomerID' cannot be empty.”This is very confusing because Customer ID Is not empty, as seen in the sample screenshot.Please tell me what I am doing wrong here?  

I have an authentication problem with oauth2 during I did the steps well (client id, secret code ....) but when I authenticate the postman display this error in the image.thank you for help 

Hello Team, My company integrates with Acumatica, and I have a few questions:1. Could you provide a link to API on how we can send a request to Acumatica so that to update data in Acumatica.For example, we want send a request to Acumatica to update the Credit Limit.2. Can we update the Credit Limit if the Credit hold is On.Thank you,Andrew

Hello Team,Could you please provide a list of errors that the Acumatica back-end can return during the record updating request?We are going to use the API to update the Customer's Credit Limit in Acumatica.And It would be perfect if you could provide the list of back-end errors that Acumatica can return during the request.Thank you!

Hello Team,Could you help me with the following question?I try to create a payment.But receive the following error:Response: {"message":"The request is invalid.","modelState":{"entity":["The Entity field is required."]}}An error has occurred.","exceptionMessage":"Inserting  'CA Transaction' record raised at least one error. Please review the errors.\nFinPeriodID: 'Post Period' cannot be empty.","exceptionType"Could you provide a correct example of the request?

Error when I update the Customer Credit Limit Request:PUT https://{Base_URL}/Customer?$select=CreditVerificationRules&$filter=CustomerID%20eq%20'0e31e8a5-08e3-ea11-a828-000d3ab2c384' Response: {"message":"An error has occurred.","exceptionMessage":"Syntax error: character '%' is not valid at position 10 in 'CustomerID%20eq%20'0e31e8a5-08e3-ea11-a828-000d3ab2c384'Team, could you help me with this error?What I should do to eliminate the error?

Hi, I followed this example https://help-2018r1.acumatica.com/(W(2))/Wiki/ShowWiki.aspx?pageid=d806636f-3cb8-4fd6-bc1e-fef9cdf9683dto delete an item. It works on Stock and Non-StockItem but it does not work on a Ledger. Instead of passing the line below to delete a StockItem    string stockItem = rs.Delete("StockItem", inventoryID);     I tried     string msg = rs.Delete("Ledger", "0915ACT");but it does not work.I have tried endpoints 6.00.001, 17.200.001, 18.200.001 and 20.200.001 and all of them failed.Using EndPoint 20.200.001 fails to login using the same code.The ledger screen is  localhost/Main?ScreenId=GL201500&LedgerCD=0915ACT Is it possible to delete a Ledger through the Web Service?  The problem is we have many ledgers we setup and we want to programmatically delete them.    We would also like to use the same code to do batch cleans of items we no longer want instead of manually deleting items. Thanks in Advance Mark

Hello Everyone,I’m trying to use OpenAPI to connect to Acumatica.To follow below guideline to login Acumatica. I got a error message. https://help-2019r1.acumatica.com/Help?ScreenId=ShowWiki&pageid=0322492a-de9b-4443-b256-923c48aff31d Does anyone know how to fix it? I tried to post to http and https. Both returned same message. Error message:{    "message": "The requested resource does not support http method 'GET'."}

Using a an Azure Classic Cloud Service, we are making REST API calls to a 2020R2 instance (default endpoint), using a token granted through a Connected Application. So for each API request, we are including the “Bearer” header with the access token. This access token was acquired by a different system and sent to the cloud service to process an import/export of data. (The cloud service makes no “login” request, requests with username/password, no “logout” request, no token renewals)When exporting data TO the Acumatica instance, depending on the amount of data to be executed, we make 25-1000+ API calls to that instance (checking if a record exists, if not creating the record. Also checking dependencies).Issue: In the middle of an export process, we experience a failed call with a HTTP Status Code 401 returned with the following data:{"message":"You are not logged in."}This occurred after checking the status of a long-running ReleaseBill Action. This is the order of requests:GET /entity/

We Add Customer Payments through Acumatica’s Screen Based API (We use Authorize.NET’s Customer Information Manager for processing).  It works fine for a customer’s first payment method.  When we attempt to add a new Payment Method (Same CustomerProfileId but different PaymentProfileId), it doesn’t throw an exception but it does not add.  It returns the existing Payment Method Token. Here is my current code:                AR303010Content AR301000 = context.AR303010GetSchema();                context.AR303010Clear();                AR303010Content[] AR303010content = context.AR303010Submit(                    new Command[]                {                    new Value { Value = customerId, LinkedCommand = AR301000.PaymentMethodSelection.Customer },                    new Value { Value = ccType, LinkedCommand = AR301000.PaymentMethodSelection.PaymentMethod },                    new Value { Value = "AUTHNETAPI", LinkedCommand = AR301000.PaymentMethodSelection.ProcCenterID },              

Creating a Bill document with all fields populated using SOAP results in error “System.InvalidOperationException: Cant find method for action \"http://www.acumatica.com/entity/3/DefaultRLSFT/17.200.001/Put\"\n   at System.Monads.ArgumentCheck.CheckNull[TSource](TSource source, Func`1 exceptionSource)\n   at PX.Api.ContractBased.Soap.WebApiSoapController.<Login>d__6.MoveNext()\n--- End of stack trace from previous location where exception was thrown ---\n   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()\n   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)\n   at System.Threading.Tasks.TaskHelpersExtensions.<CastToObject>d__1`1.MoveNext()\n--- End of stack trace from previous location where exception was thrown ---\n   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()\n   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)\n   at System.Web.Http.Co

Has anyone figured out silent login of Acumatica user? We should be able to pass the user id and pwd to specific URL and auto-login or silent login so it bypasses the login and takes you to specific page to perform certain action and then when we close it logs off, this shld be possible assuming help.acumatica.com works that way.  This feature allows to do lot of things within the framework and allows to scale for online approvals or proofing etc. Any hacks or thoughts, pls share.