Develop Integrations with Web Services | APIs

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

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