Web Services | APIs

Web Services Discussion Forum

  • 85 Topics
  • 274 Replies

85 Topics

A
Freshman I
Andrew1986Freshman I
asked in Web Services | APIs

Acumatica Endpoints

Hi Team,I have a small question about Acumatica Endpoints.I am using the following endpoint to integrate data from our test Acumatica account.https://{HOST}/AcumaticaERP/ But I see that on production some of our Clients use only the HOST to integrate data. I mean https://{HOST} , without AcumaticaERP/. I would be very grateful if you could clarify where in Acumatica can I check the true Endpoint.Or what is the standard Endpoint that Acumatica recommends using to integrate data?

2
A
Freshman I
1 day ago
J
Freshman I
jaysonFreshman I
asked in Web Services | APIs

Attributes not updated in PUT Request(creation/updating of record)

URL: https://esquared.acumatica.com/entity/Default/22.200.001Payload:{    "CustomerID": {        "value": "T99999"    },    "custom": {        "baccount": {            "AttributeCWCID": {                "value": "Sample123"            }        }    }} I’m getting 200 response but the AttributeCWCID is not updating

2
J
Freshman I
2 days ago
J
Freshman I
jaysonFreshman I
asked in Web Services | APIs

Can't Update Customer Custom Field

 

1
J
Freshman I
3 days ago
J
Freshman I
jaysonFreshman I
asked in Web Services | APIs

Fetching User-Defined-Field in Customer Acumatica REST-API

I'm trying to fetch the user-defined-field that I added in Customer Entity but it's not working. I'm getting this error: "message": "An error has occurred.", "exceptionMessage": "The column 'Document_AttributeCWCID' is not found in the data set.",It is working in Contact entity and SalesOrderMy sample parameter in Contact $custom = Contact.AttributeCWCIDIn SalesOrder: $custom = Document.AttributeSOID

2
J
Freshman I
3 days ago
A
Freshman I
aworth56Freshman I
asked in Web Services | APIs

Power Automate Connector

Has any one used the Acumatica connection in MSFT Power Automate? I cant get passed the login information and keep having issues. I would love help if you have done it before. First image is a few of the questions it asks, everything I have tried doesnt work.Any article I have found is only for custom APIs using power automate, nothing for the built in connector. 

0
A
Freshman I
9 days ago
aaldrich
Freshman I
aaldrichFreshman I
asked in Web Services | APIs

How to Retrieve Stock Items > Related Items from Api

Hello,I’m looking for a way to retrieve the Related Items from the Acumatica APIs. Is there any way to do this? I expected that I would be able to find it on the /entity/Default/20.200.001/StockItem API but it does not appear to exist as a detail object.

2
aaldrich
Freshman I
9 days ago
P
Freshman I
phatFreshman I
asked in Web Services | APIs

get value in OpenID provider

I'm having a problem with customizing in openID provider page.I'm wanting to get the value of the issuer identifier then use it to concatenate my string and save it to the database when choosing save. I am using graph extension to do this but I am getting error.CS0122: 'OidcProviderMaint' is inaccessible due to its protection levelCS0122: 'OidcProviderMaint' is inaccessible due to its protection level    I'm a bit stuck on what else I can try to make this happen. Do you have any other suggestions? :) Thanks a lot  

0
P
Freshman I
10 days ago
D
Freshman I
DharmandarKumarFreshman I
asked in Web Services | APIs

Inserting 'CA Transaction' record raised at least one error. Please review the errors.; FinPeriodID: 'Post Period' cannot be empty.

EndpointCheck PUT Request Body{"CuryOrigDocAmt":{"value":0},"CashAccount":{"value":"10600"},"Type":{"value":"Check"},"Vendor":{"value":"AASERVICES"},"CurrencyID":{"value":"USD"},"Hold":{"value":false},"PaymentAmount":{"value":500},"PaymentMethod":{"value":"AMEX"},"FinPeriodID":{"value":"12-2022"},"Details":[{"PostPeriod":{"value":"122022"},"FinPeriodID":{"value":"12-2022"},"BranchID":{"value":null},"InventoryID":{"value":null},"OrderQty":{"value":0},"WarehouseID":{"value":null},"AmountPaid":{"value":500},"Balance":{"value":500},"CashDiscountBalance":{"value":null},"DocType":{"value":"Bill"},"ReferenceNbr":{"value":"004212"}}],"PostPeriod":{"value":"122022"}}  Response Body{"id":"00f6eadd-6293-ed11-bb54-000d3a19a590","rowNumber":1,"note":{"value":""},"error":"Inserting  'CA Transaction' record raised at least one error. Please review the errors.; FinPeriodID: 'Post Period' cannot be empty.","ApplicationDate":{"value":"2023-01-13T00:00:00+00:00"},"CashAccount":{"value":"10600"},"Currency

1
manikantad18
Varsity II
14 days ago
D
Freshman I
DharmandarKumarFreshman I
asked in Web Services | APIs

How to pass FinePeriod Id in Create check for a bill.

When we create a new check for a bill  i found that FinePeriodId error.How To fix It.I have already passed the FinePeriodId property In checkRequest 

1
aaghaei
Captain II
18 days ago
I
Freshman I
ignacio85Freshman I
asked in Web Services | APIs

customer addresses changing id on each request

Hi, I’m using this GET to get tue customer with the bill to and ship to addresses/entity/Default/18.200.001/Customer?$expand=MainContact,MainContact/Address,ShippingContact/Address,BillingContact/Address It works just fine, the only thing I noticed is that on each request I get the Address.id property (that looks like a guid) changes value Is this expected?What is the best way to get a unique ID of it? Thanks,Ignacio

1
J
Semi-Pro III
1 month ago
I
Freshman I
ignacio85Freshman I
asked in Web Services | APIs

SalesPriceInquiry gives an error, how can I get the data I see in the AR202000 screen?

Hi,I’m trying to get the same list I get using the AR202000 screen by using this GET:https://MYCOMPANYNAME.acumatica.com/entity/Default/18.200.001/SalesPricesInquiry When I do this in postman I get this error:"message": "An error has occurred.",    "exceptionMessage": "Optimization cannot be performed.The following fields cause the error:\r\nEffectiveAsOf: View Filter has BQL delegate\r\nPriceWorkgroupIsMine: View Filter has BQL delegate\r\nInventoryID: View Filter has BQL delegate\r\nItemClassID: View Filter has BQL delegate\r\nPriceClass: View Filter has BQL delegate\r\nPriceCode: View Filter has BQL delegate\r\nPriceManager: View Filter has BQL delegate\r\nPriceManagerIsMe: View Filter has BQL delegate\r\nPriceType: View Filter has BQL delegate\r\nPriceWorkgroup: View Filter has BQL delegate\r\n",    "exceptionType": "PX.Api.ContractBased.OptimizedExport.CannotOptimizeException",    "stackTrace": "   at PX.Api.ContractBased.OptimizedExport.NotWorkingOptimizedExportProvider.get_CanOp

3
Shawn Burt
Jr Varsity I
1 month ago
K
Freshman I
kuldeepsinghFreshman I
asked in Web Services | APIs

"The record cannot be saved because at least one error has occurred. Please review the errors.",

I am trying to use the endpoint to update an employee Payment instructions & getting this exception for the records LocalizedMessage, Message, MessageNoNumber, MessageNoPrefix. The exception is trigerred after the PXWait.LongOperation tried to check PXAction. I have checked the locales table & it has data.  

2
K
Freshman I
1 month ago
R
Freshman II
RafaDiazBAIFreshman II
asked in Web Services | APIs

Rest API

I am trying use the Login to Acumatica Rest API with Postman. ​​According to the documentation I have found in the web, I should be using http://MyCompany.acumatica.com/entity/auth/login as URL The body as detailed below:{"name":"johnd","password":"johndpassword","tenant":"mytenant"} I get an error in Postman as detailed below:{"message":"An error has occurred.","exceptionMessage":"Error: Invalid credentials. Please try again.","exceptionType":"PX.Data.PXException","stackTrace":" at PX.Data.PXLogin.LoginUserImpl(HttpContext httpContext, String userName, String password)\r\nWhat am I doing wrong?

4
R
Freshman II
1 month ago
K
Freshman I
kuldeepsinghFreshman I
asked in Web Services | APIs

"Inserting 'Payment Type Detail' record raised at least one error. Please review the errors.; DetailValue: 'Value' cannot be empty.",

Hi Team,I am geting this exception while trying to add an employee with payment instructions using an endpoint.I cannot see the DetailValue property when I try to check the swagger documentation.Thanks 

1
Kulvir Kaila
Jr Varsity I
1 month ago
J
jakovsmallco
asked in Web Services | APIs

Payroll / PTO API endpoints

Hi everyoneWe are trying to integrate data from Acumatica into another database/application.While integrating financial information we tried looking for a way to pull Payroll/PTO data using web services / API but we could not find the appropriate endpoint.Can you please point us in the right direction? We are not Acumatica developers or heavyweight users so sorry if the question is inappropriate! Thank you.

1
Yuriy Zaletskyy
Jr Varsity I
1 month ago
I
Freshman I
ignacio85Freshman I
asked in Web Services | APIs

using $Filter with a numeric value field

Hi, I’m tryiung to do a GET request from:acumatica/entity/Default/18.200.001/invoice?$filter=CreatedDateTime gt datetimeoffset'2021-09-10T00:00:00.000-00:00' and Status eq 'Open' That returns the open invoices starting one date.Now I want to add a Balance component but I cannot make it works, I tried: CreatedDateTime gt datetimeoffset'2021-09-10T00:00:00.000-00:00' and balance gt 0ALSOCreatedDateTime gt datetimeoffset'2021-09-10T00:00:00.000-00:00' and balance=0 With no success, I’m pretty sure it is a simple thing, but I cannot find it How can I do it? Thanks,Ignacio

4
J
Semi-Pro III
1 month ago
D
Freshman II
davidrichards12Freshman II
asked in Web Services | APIs

How to make value of non-persisted field available on web service endpoint

I have a method, FooBar() that returns a value that I want to be made available on my web service endpoint. I display the value on a non-persisted field by setting it in the RowSelecting event, but it does not make it to the endpoint? How can I get the value of my non-persisted field to the endpoint?

7
D
Freshman II
1 month ago
E
Jr Varsity I
eellistonJr Varsity I
asked in Web Services | APIs

OData4 - Inventory Items. Expand Attributes

I am trying to port some of my calls over from using the Rest API to using the ODATA4 interface. Using a simple call like this… http://ODATAV4_URL/PX_Objects_In_InventoryItem?$filter=InventoryCD eq 'BCWICFGBLK’&$format=json How to include a list of all the attributes and values associated to a InventoryItem. With the RestAPI, I could just $expand=Attributes and it would return that in the payload. I can’t seem to figure it out when using ODATA. Thank you all! Eric

1
Leonardo Justiniano
Jr Varsity I
1 month ago
E
Jr Varsity I
eellistonJr Varsity I
asked in Web Services | APIs

Acumatica Data Field Names

Is there a place I can go to see all the field names for a given entity (ie: StockItems).My reason is that I have some sync processes that download StockItems via the rest API. However, the properties/field names that the rest API returns are different than what I see in a Generic Inquiry. For instance, in the rest API, the field name for Description is “Description”. In the GI, its called DESC. I was hoping there was some sort of way I can see how those mappings work. I am porting some of these REST Api calls over to oData and am unsure what the fields are called in the Generic Inquiry UI screen. Thanks! Eric

2
Naveen Boga
Captain II
1 month ago
E
Jr Varsity I
eellistonJr Varsity I
asked in Web Services | APIs

Image downloading intermittent issues

Hello, I have a process that syncs stockitems from Acumatica for use on an external eCommerce web application. I download the images as part of the sync and store them in Azure storage. The web application loads the images from the storage accounts.I am finding that when I download a batch of images...perhaps syncing 10 products in a batch, I will get the first 3 images and then the response stops sending any content. I get an HTTP 200, but I receive no bytes in my download.If I slow down my process it seems to work better.I have seen similar issues when calling the rest API. If I download 1 product at a time, if my sync process goes too fast, Acumatica sends empty results….no error or anything like that. I was able to work around that issue by downloading batches of stock items in groups of 500 and storing the raw JSON to the DB and then doing the ETL steps after.  Is there some sort of limit in Acumatica or a better approach to fetching the images? I have my service account set to un

2
E
Jr Varsity I
1 month ago
SBalmer1
Freshman I
SBalmer1Freshman I
asked in Web Services | APIs

Sales Order creation via Rest APIs with Manual Sale Tax override

We can easily import sales order with Acumatica REST APIs but we cant get TaxOverrides to work during the api call.  We did create a Manual Tax zone and Tax ID  and both comes in but when the order gets created but the tax amount comes in at zero and not the values we send in.For example this below JSON  crates the order but tax amount comes to zero instead of $2{  "OrderType": {  "value": "SO"  },  "CustomerID": {  "value": "AMAZONG"  },  "Details": [ {"InventoryID": {  "value": "SKU1"   },        "OrderQty": { "value": 1 },        "UOM": { "value": "EA" },      "UnitPrice": { "value": 10.0 } } ],  "FinancialSettings": { "OverrideTaxZone" : { "value": true },"CustomerTaxZone" : { "value": "MANUAL" } },  "TaxDetails": [ { "TaxID": { "value": "MANUAL" },        "TaxableAmount": { "value": 10.0 },        "TaxAmount": { "value": 2.0 }  } ],  "TaxTotal": { "value": 2.0 }} Once the order is created, users can go through the UI and open the order and in the taxes TAB, update the Tax amount.

4
J
Semi-Pro III
1 month ago
Y
Freshman I
yeehangchong19Freshman I
asked in Web Services | APIs

Time related error in work order API

Hi All,My observation     Please understand below one of the scenario is causing error.  Actual Staring time : 7:30 PM (UTC Time is 11:30 PM) Actual Ending time:  8:00 PM (UTC Time is 12:00 AM)  In that scenario causing issue "WorkOrder.Labor[0].ActualEndTime: The times are invalid. The end time cannot be earlier than the start time.\nWorkOrder.Labor[0].ActualStartTime: The start time cannot be later than the end time. Correct the values.\nWorkOrder.Labor[0].StartDate: The start time cannot be later than the end time. Correct the values." Even though we pass time along with the date , these Actual start time and end time not considering Date in the request format We tried below accepted format already Local time format with time zoneActual Start Time : 2022-10-21T19:30:00-04:00Actual End Time : 2022-10-21T18:00:00-04:00  UTC FormatActual Start Time : 2022-10-21T23:30:00Actual End Time : 2022-10-22T00:00:00 Both format system not getting accept and throwing the error.  Below is the samp

1
Troy Vars
Varsity I
1 month ago
R
Freshman II
rskieresz88Freshman II
asked in Web Services | APIs

Using & in API/endpoint request

Hi,  Trying to get customer data out via API request and am having an issue when the key data I’m including has an &.  Specifically trying to get customer and/or customer contact information and the endpoint for customer works fine for IDs with no special character, but a bunch of customers on this implementation have an & in the customer code and when I execute the same command via postman using those customer IDs an error is returned.  I did some digging and did try a few workarounds, etc. I found on the web most involving using %26 in place of the &, but everything I’ve seen on the web I’ve tried and still get the same error returned.  Has anyone encountered this and is there workaround or specific syntax I need to use?  Thanks, pasting the URL, just using the ‘base’ endpoint that comes with the system, engaging the customer endpoint (and eventually contact information as well). Works fine and customer data is returned  Returns errors  

3
Chris Hackett
Community Manager
1 month ago
development93
Freshman I
development93Freshman I
asked in Web Services | APIs

ODATA PULLING DIFFERENT TIME?

The data pulled is -3hours. Will appreciate any help here

10
BenjaminCrisman
Acumatica Employee
1 month ago
E
Jr Varsity I
eellistonJr Varsity I
asked in Web Services | APIs

Create SalesOrder - Rest API. Unit conversion is missing error

I have an issue when trying to place a SalesOrder via the Rest API. For this scenario, I am getting an error 422 - Unprocessable Entity. The error message is:   "error": "Unit conversion  is missing.; Unit conversion  is missing.", This particular order has a quite a few items, so if the issue is related to one of the products, how could I find that out.Any thoughts on how I could find the offending entity? Thank you! 

3
E
Jr Varsity I
1 month ago

Badge winners

Show all badges
Terms & ConditionsCookie settings
About Acumatica ERP system
Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
© 2008 — 2022  Acumatica, Inc. All rights reserved