Develop Integrations with Web Services | APIs

Hi, Previously my request successfully worked with another acumatica instance for creating purchase receipts, now throws the following error : Here is my request : URL : https://test.acumatica.com/entity/ARTEndpoint/18.200.001/PurchaseReceipt?$expand=Details&$select=Branch,ReceiptNbr,CurrencyID,Details/InventoryID,Details/POOrderNbr,Details/POOrderType,Details/ReceiptQty,Details/TransactionDescription,Details/UnitCost,Details/UOM,Details/WarehouseBODY :{  "Location": {    "value": "MAIN"  },  "CreateBill": {    "value": "false"  },  "VendorID": {    "value": "PT"  },  "VendorRef": {    "value": "PP414-kkk"  },  "PostPeriod": {    "value": "11-2022"  },  "Details": [    {      "POOrderType": {        "value": "Normal"      },      "POOrderNbr": {        "value": "PO001200"      },      "ReceiptQty": {        "value": "1"      },      "POLineNbr": {        "value": "1"      }          }  ]}Please suggest how to troubleshoot itI attached stack of the error {    "message": "An error ha

HiI’m wanting to do a carrier integration for a client and I need help finding where to start.Main consideration: Should I be sending POST API calls from Acumatica directly to the freight software or should I be using a third-party application to send GET requests to Acumatica then POST calls to my freight software. If I send POST API calls from Acumatica:Would be the Shipment Screen be the best endpoint to look at?  Can I trigger a POST call from this Shipment Screen? And If so can I send all the information from these endpoints? If I set up this POST, can I edit how the JSON is formatted in the API body? Should I be looking at the Carrier Label screen instead (SO645000)?  If I did it this way, would the customisation need to be written in a complex C# customisation project? (It’s hard to write custom C# with the online hosted version of Acumatica (MYOB Advanced) used in Australia and New Zealand). Any suggestions, experience or success stories anyone has on this topic would be apprec

Does anyone know of an import scenario of API integration to convert approved Expensify expense claims into AP Bills in Acumatica?

I am not that experienced with Acumatica so this may be a straight forward task.I have about 2000 guest user accounts that I need to assign a new role to. After a few hours, I couldn’t find a great way to do it in either the UI or via the Rest API. Can someone point me in the right direction? I appreciate it!!!

If I already Login but My token has been expired .How to refresh token get. or Any other way to get token through rest API. 

Greetings folks, We are on the Cloud version of Acumatica, not yet through our first year. We had a user inadvertently leave Migration Mode on after performing a task that required it, and now the business would like us to find a way to detect if it’s on. Any suggestions for how to go about this? We interact with Acumatica via Serverless lambda functions in AWS, but I’ve not located an API for this. Thank you, Dave

I’m looking to use the REST API to create Project Quotes - is this possible? I’m not seeing the Entity in the webservices view

Sorry I should have inspected the response, it contains an element `expires_in` which is 3600 seconds

{ 'client_id': "xxxxxxx@company", 'client_secret': "xxxxxxxxxx", 'grant_type': 'client_credentials', # 'grant_type': 'password', 'scope': "api", 'username': 'xxxx', 'password': 'xxxx',}This is the body I am sending, but I am getting `{'error': 'unauthorized_client'}` what am I missing?Secondly, the documentation says the grant_type must set to `password`, but if I do that, I get `invalid_grant`

Does the ‘Multiple Warehouse Locations’ feature need to be enabled, no matter which inventory transfer method (1-Step or 2-Step) you were to use, in order to successfully create an inventory transfer through the REST API? If I have that feature enabled I am able to create Transfer documents successfully through the REST API but if that feature is not enabled my REST API call fails.  When that feature is not enabled I receive an ‘locationID cannot be empty’ error no matter which type of transfer I attempt to create, 1-Step or 2-Step.

I’d like to be able to make one of the web endpoints read-only.  Is that possible without going through security/roles?There are some other web endpoints that I would like to make specific fields read-only as well. Is there a way to do that?  I could make a non-persisted field that mirrors the value of the field I want to display and expose that in the endpoint. I’m wondering if I’ve overlooked something. 

I’m trying to create a new Customer using the PUT Method in Postman, and I’m receiving the following error message."error": "Inserting  'Location' record raised at least one error. Please review the errors.","SalesAccount": {     "error": "'Sales Account' cannot be empty."},Here’s what I’m sending through the Body.{ "CustomerName": {"value":"TEST TEST"}, "Location":[ {"SalesAccount": {"value": "60040"}} ]}I copied this Sales Account value from another record, so I’m not sure why it’s not recognizing the value.

I’m trying to build a script that will create a new customer via REST API. I’m running into issues with linked entities not shown in the Web Service Endpoints form yet I need to pass a value for them. For example, I receive the following error message. 'error': "Inserting 'Location' record raised at least one error. Please review the errors.; CSalesAcctID: 'Sales Account' cannot be empty." However, I’m not sure how to resolve this issue when I’m sending a PUT method to Acumatica with the following parameters.    },    'Location':{        'CSalesAcctID': {'value': 60030},    }, I noticed that Location was not listed as a linked entity in the Web Service Endpoints list. How am I able to make the connection to Location if it’s not a part of the endpoints list?

I’m struggling getting the Employee ChangeEmployeeID Action to work.  In Postman I’ve setup the following:Verb: PUTURL: <host>/entity/Default/20.200.001/employee/ChangeEmployeeIDBODY:{"entity": {"EmployeeID": {"value": "{OldEmployeeID}"}},"parameters": {"EmployeeID": {"value": "{NewEmployeeID}"}}}I’m receiving the following error: "Specified argument was out of the range of valid values. Parameter name: Invalid uri structure"Does anyone have a working payload for this action?Thanks in advance

i am trying to perform a lookup based on employee email to get the details.is there anyway to query an employee based on his email via restApi in acumatica

I am calling entity/auth/login as restful PI and usually get 202 response.  But every third or fourth time or so get 500 - API Login Limit If I walk away for 10 minutes and come back exact same code works for a whileI have made sure I am logging out after each login.  I am doing them farily slow by hand so maybe a second each attempt.  Any suggestions where I might trty and look to inderstand what I am doijng wrong?Thanks,Keith 

What REST API endpoint would I use to transfer a stock item from one Warehouse location to another Warehouse location?

We use https://[tenant].acumatica.com/identity/connect/authorize to get an authorization code which works fine then we callhttps://[tenant].acumatica.com/identity/connect/tokenendpoint with below params:grant_type: authorization_codeclient_id: [client id]client_secret: [client secret]code: (the value from "code" query parameter from the first request respomse)redirect_uri: https://[local].ngrok.io/accumatica/access-tokenWe get a bad request with error message:{ "error": "invalid_client"}What could be the reason?

Hi there,can anyone please help me out on how to setup things in acumatica for establishing connection from an integration tool and fire some restAPIS. thank you 

Hi,I’m trying to create a shipment via the rest api. The api call succeeds and the shipment is created but I’m getting errors in the Request Profiler. How do I debug these? The errors are vague and the stack traces don’t help either.Data:Type = “Shipment”, ShipmentDate = “9/12/2022”, CustomerID = 2943, Operation = “Issue”, WarehouseID = “MAIN”.Detail lines:OrderNbr = “SO123”, LineNbr = 1, InventoryID = “50500”, UOM = “CASE”, OrderedQty = 2, OpenQty = 0, OrderType = “SO”, ShippedQty = 2, WarehouseID = “MAIN”. How do I figure whether I’m filling in all the appropriate fields for the call?The request profiles is giving these errors:Sequence contains no matching element Exception has been thrown by the target of an invocation Operation Failed Object reference not set to an instance of an object

We Want To Create A  Batch Payment for multiple bills & Credit Adjustmentin batch payment create custom batch number . 

Hi, I am trying to customize or filter the Inventory ID Lookup on the Sales Order Screen (SO30100) by using SOLine_InventoryID_CacheAttached. Whenever I select the item, the grid line is filled up with the internal inventory ID value instead of the inventory CD.After selecting the item Here is my code public class SOOrderEntry_Extension : PXGraphExtension<PX.Objects.SO.SOOrderEntry> { [PXMergeAttributes(Method = MergeMethod.Append)] [InventorySelectorCustom(typeof(InventoryItem.inventoryCD))] protected virtual void SOLine_InventoryID_CacheAttached(PXCache cache) { } [Serializable] public class InventorySelectorCustom : PXCustomSelectorAttribute { public InventorySelectorCustom(Type type) : base(type, typeof(InventoryItem.inventoryCD),typeof(InventoryItem.descr) , typeof(InventoryItem.itemClassID), typeof(InventoryItem.itemStatus), typeof(InventoryItem.itemType)

How to access acumatica from an integration applications using auth 2.0 authorization

Hello all I have made a custom Inquiry screen, that filters and provides a record based on passing 3 input parameter.Item Sales Price ScreenNow I want the same value to be returned when via WebService . I did extend  my webservice Endpoint and added new screen. However, I am not able to see the right value on mapped object Item Sales Price InquiryWhen I call via my POSTMAN, I get empty result. Below is my code.public class ItemSalesPrice : PXGraph<ItemSalesPrice>    {        public PXFilter<SalesPriceFilter> Filter;        [PXFilterable]        public PXSelect<SalesPriceResult> DetailsView;        public PXCancel<SalesPriceFilter> Cancel;        protected virtual IEnumerable<SalesPriceResult> detailsView()        {                 ----                yield return ar;            }        }}  public class SalesPriceFilter : IBqlTable { #region CustomerID [PXDefault(PersistingCheck = PXPersistingCheck.Nothing)] [CustomerActive(Displ

why this payload is giving me an Error:422 "error": "Inserting 'Address' record raised at least one error. Please review the errors.; CountryID: 'Country' cannot be empty.",{"Status": {"value": "Active"},"EmployeeID": {"value": "CRIC123789"},"EmployeeName": {"value": "Doe, Jane"},"FinancialSettings":{"APAccount": {"value": "ACCOUNT123"},"APSubaccount": {"value": "000000"},"ExpenseAccount": {"value": "ACCOUNT456"},"PaymentMethod": {"value": "CHECK"},"PrepaymentSubaccount": {"value": "000000"},"SalesAccount": {"value": "ACCOUNT789"},"TaxZone": {}},"EmployeeSettings":{"BranchID": {"value": "CRIC012345"},"Calendar": {"value": "NEWCAL1234"},"CurrencyID": {"value": "USD"},"CurrencyRateTypeID": {"value": "SPOT"},"DepartmentID": {"value": "1"},"EmployeeClass": {"value": "EMPCLASSNE"}},"ContactInfo":{"LastName": {"value": "Doe"}},"Address":{"CountryID":{"value":"India"}}}