Develop Integrations with Web Services | APIs

New to Acumatica, we are in early implementation phase. Our iPaaS system is MuleSoft, and our CRM is Salesforce. Currently, we are working to POST new customers to Acumatica via REST API.  Receiving an error that we do not appear to have permission to create the SF Price Cls field, so the method fails.  When I look at the endpoint in Acumatica, I don’t even see that field as available.  Do I need to do the mapping inside Acumatica individually?  And do I simply extend the endpoint to do so?  Any insight appreciated, thanks!

I am uploading a project via Postman to acumatica. The project is getting created, but the default branch is always coming up as empty. I am sending a valid default branch and it is a part of the webservice endpoint. There is no error message.In the course of setting up the project, I am using a project template. This project template does not have a default branch set. Will the project template’s default branch override the one I am sending via POSTMAN?

I have a scenario with 2023 R2 Construction Edition with standard Equipment (EP208000) whereby I want to utilize a Project Attribute enabled for Equipment in the Web Service for Equipment.  I am not understanding how to reference the Attribute in the web service.  I have read a similar question on Sales Orders but this does not seem to be the same procedure.  I would like for the dev team to be able to evaluate the “Attribute” and the “Value”.  In this case, the “Value” will hold a default value that is needed.  Thanks in advance! 

Hi There,Working with 2023 R1.I am trying to run the following query through PostManhttp://AcumaticaVM/AcumaticaDemoDB/ODatav4/PX_Objects_GL_GLTran?$apply=groupby((AccountID,BranchID,LedgerID,FinPeriodID),aggregate(DebitAmt with sum as SumDebitAmt))And Acumatica is coming back with the following error:"error": {        "code": "",        "message": "An error has occurred.",        "innererror": {            "message": "Object reference not set to an instance of an object.",            "type": "System.NullReferenceException",            "stacktrace": "   at PX.Data.SQLTree.SQLinqExecutor.SQLinqExpressionVisitor.VisitDacProperty(Type propertyType, String propertyName, SQLExpression defaultExpression)\r\n   at PX.Data.SQLTree.SQLinqExecutor.SQLinqExpressionVisitor.VisitMember(MemberExpression expression)\r\n   at Remotion.Linq.Parsing.ThrowingExpressionVisitor.Visit(Expression expression)\r\n   at PX.Data.SQLTree.SQLinqExecutor.SQLinqExpressionVisitor.Visit(Expression expression)\r\n   at

“CustomerSignedReport” is a GUID field in database and also in FSAppointment class. I am working on an external application that is capturing signature and sending email to customer with pdf report.I have everything sorted, only issue I am facing is that I am unable to update the new file id in the field “CustomerSignedReport” as I am not able to add it in the web service endpoint even by extending it. My requirement is to update this field from REST API or web service SOAP.I need help from the community if I am missing something here.For reference:SQL : Select CustomerSignedReport,* from FsAppointment where refnbr='TMVT000069-1' and CompanyID=3DAC Class: 

I have a process in Azure Data Factory that downloads about 55k images and stores them to a storage container for use on an external eCommerce website.Sometimes I have to do a full sync/download, the issue is that it takes forever to download them all due to API limits etc. Are there any tips on how I  can overcome it?  My download process can take 4-5 days to complete if I have to reseed the data...I am just looking for something that isn’t as long.Thanks!Eric

Related to the topic, I have the following code, but this time I try to obtain the pdf from an api, and save it in Shipment, I show you the code and the error that appears:[PXButton(CommitChanges = true)][PXUIField(DisplayName = "Track")]protected void apiTracking(){    DownloadAndUploadFile();}public void DownloadAndUploadFile(){    try    {        using (HttpClient client = new HttpClient())        {            string url = "http://qaglp.paquetexpress.mx:8083/wsReportPaquetexpress/GenCartaPorte?trackingNoGen=19167736449";            HttpResponseMessage queryResult = client.GetAsync(url).Result;            if (queryResult.IsSuccessStatusCode)            {                byte[] fileContent = queryResult.Content.ReadAsByteArrayAsync().Result;                UploadFile(fileContent, "downloadedFile55.pdf");            }            else            {                PXTrace.WriteWarning("HTTP request was not successful.");            }        }    }    catch (Exception ex)    {        PXTrac

Question  Where is LocationID field we see in our error message, and how can we stop it being empty? Overview Our system attempts to create Appointments for Service Orders via the Acumatica API. We are having a lot of trouble with the error:LocationID' cannot be empty.; LocationID: 'LocationID' cannot be empty.This error occurs in the API only, we do not see the error when creating appointments using the UI.  Our software uses the API tries to take an existing Service Order, add an Appointment for it, and then set the Scheduled and Actual dates/times on the new appointment.  The ultimate goal is to enter an appointment log and create time cards automatically.  The error occurs when we try and set the dates and times. Technical Detail The working request to create the appointment looks like:{  "ServiceOrderNbr": {    "value": "40054"  },  "ServiceOrderType": {    "value": "TECH"  },  "BranchLocation": {    "value": "DVM"  },  "Customer": {    "value": "CSOUTHPAC"  }}Which is mapped to t

Hi,I wasn’t able to get and add relationship in sales order. This is what I’m seeing on web Service history 

Hi Everyone,Have an issue with filtering a GI through the REST API.Below is the setup for my endpoint filter.And this is my request bodyI’m getting the below error If I send a word like “test” instead of the actual ID then there is no error however if I send a number formatted as a string then it isn’t happy.Has anyone seen this before / know a fix?

Hi everyone,When sending a GET request for the CustomerLocation with a LocationID the API fails with the following error “Operation is not valid due to the current state of the object." However, if the LocationID is removed the request will succeed. Meanwhile, every other object like CustomerPaymentMethod requires an ID or they will fail and report the same error.Why is CustomerLocation different ? Is it possible to detect if a ID is supported in the API ?I am using version 23.200.001 and the Default endpoint.Thank you.

I’m attempting to use the $expand parameter in an OData v4 query. However, anything that I put in the $expand just causes the server to return 404. For example, I can get a PO with POOrder(OrderType='RO',OrderNbr='12345'). And it returns the POLineCollection property, already expanded. But if I explicitly request ?$expand=POLineCollection, I just get a 404. What’s strange to me is that if I set ?$expand= it does not expand the POLineCollection property. So it is definitely reading the $expand parameter.I’ve tried expanding multiple navigation properties, using their names defined in the OData metadata XML. None of them work. I’ve even tried copy-pasting the examples from Exact Session Title (acumatica.com) as well as the URL provided in the answer to this topic, with the same result: 404. I have no idea what I’m doing wrong here.For reference, here’s my full URL: https://myinstance.com/ODatav4/My Tenant Id/POOrder(OrderType='RO',OrderNbr='12345')?$expand=POLineCollection

I’m trying to create an eCommerce connector; deriving a lot of the functionality from the BigCommerce codebase, but I’m having problems with Shipment Exports.My connector has imported a sales order, which I’ve shipped manually (and Confirmed), and see that shipment in the Prepare Data screen. The error suggests that the shipment does not exist in Acumatica,(“The record cannot be synchronised because it does not exist in the ERP and external system”) but it’s definitely there.I’m running build 23.111.0019 locally.The problem appears to be that this line returns null instead of a populated Shipment object.bCShipment.Shipment = cbapi.GetByID<PX.Commerce.Core.API.Shipment>(bCShipment.ShippingNoteID.Value);What might be the cause of this problem?

How can I join the PMProject object with PMTasks? When I use the $expand paramater, I keep getting errors.I have tried PMTask, Task and both are resulting in errors.  

I am following this Blog Post to create a REST endpoint for a custom GI.I am doing a PUT, and I did set up the “Results” sub-entityI have set up the endpoint as described. Regardless of what I add as the $expand query value, I get: {    "id": "9a25f895-des9-4fe6-bcf4-551f8f5d7a58",    "rowNumber": 1,    "note": null,    "custom": {}}Any suggestions of what I should try?​​​​​

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