Learn
Learn
Support
Support
Product
Community
Partners

Community
Discussion ForumsFinancials 949 Distribution 1031 Manufacturing341 Construction329 Property Management16 Field Service141 Retail-Commerce270 Payroll120 Low Code | No Code Customizations or Integrations60 Develop Customizations1431 Develop Integrations with Web Services | APIs301 Other Developer Topics49 ISV Solutions 89 Configuration and Installation 437 Reports and Generic Inquires 916 Import and Export Scenarios 364 System Health and Performance 74 Community site discussions125 Community Introductions55 Everything Else 457
News & AnnouncementsAcumatica News & Updates80 Developer Newsletter 17 Newsletter 21

Create topic
Login

Community
Discussion Forums
Develop Integrations with Web Services | APIs

Develop Integrations with Web Services | APIs

Technical discussions focused on Web Services and APIs for developers

301 Topics
1,319 Replies

When you subscribe we will email you when there is a new topic in this category

301 Topics

Recently active

Most replies Most views Newest first

rhooper91Jr Varsity III

asked in Develop Integrations with Web Services | APIs

How to set Stock Item Image Preview to Image Uploaded by API

Hello,I have successfully created a postman script that takes a csv reference file (Itemcd, filename) and creates the images (stored and referenced from a local source) in Acumatica on a stock item. I then set that image as the ImageURL, however, when I log into the system to check, the file is uploaded, the imageurl is updated, however, the image preview is not showing the image. What entity do I need to call to set this? I figure I could get the data in there and even if it isn’t available via api, I could do some event handler to finish it all the way.. thanks in advance!

17 hours ago

jdeolFreshman II

asked in Develop Integrations with Web Services | APIs

REST HTTP PUT call to Update A DropDown Custom field, 500 internal server error

Hello everyone! I have a custom field on Shipments Screen telling me the status of the order in a different system, the code is given below:declaring UsrRWSStatusthe shipments screen for a visual representationNow I have a service which will update its status to Pick Created , with the following request:POSTMAN PUT requestBut I get this error in response,"String or binary data would be truncated in table 'AcumaticaDB.dbo.SOShipment', column 'UsrRWSStatus'. Truncated value: 'P'.\r\nThe statement has been terminated.", this as the exception message, I am confused here, am I sending the request correctly, or do I have to change something else in my customization of the DAC? If any more context is required please let me know. Cheers,Jdeol

4 days ago

jininSemi-Pro III

asked in Develop Integrations with Web Services | APIs

Retrieve EST Date and time through API call

Hi All,When we try to fetch the date and time through an endpoint, we always receive the UTC time. We have attempted to send the date and time as a string format, but we are still receiving the time in UTC.How can we retrieve the Eastern Standard Time (EST) in the response?

4 days ago

eellistonJr Varsity II

asked in Develop Integrations with Web Services | APIs

Download Invoice Data via oData

Hello,I have a design question. I am trying to download/sync all of our invoice/invoice line item data to our front end eCommerce application so customers can view their invoices. At the moment, I have it working using the Rest API endpoint but its very slow and I keep hitting our license limits. I have been porting all my RestAPI calls to using oData on top of a GI. This is MUCH faster and has relieved the pressure on the API calls. The invoice sync is the last one I need to do. I am struggling to figure out how to “find” that data. I do have all the invoices downloaded via these entities. I can’t figure out how to get the invoice line items. What entities should I query?For my sales order sync, I download all the sales orders, and then download all the line items. My sync process joins the data together in my eCommerce app DB. Its very fast. I am looking to do a similar approach here.I am open to tapping into the oData4 endpoint if that is a better option. Any help would be greatly

5 days ago

alicezyks51Semi-Pro II

asked in Develop Integrations with Web Services | APIs

Acumatica shipping integration with WorldShip transition to EasyPost shipping

Help! We are updating to 2022 R2 and therefore will no longer be able to use the imbedded Acumatica shipping integration with WorldShip. We have created an EasyPost account, followed the steps in the EasyPost configuration guide and still have unresolved questions / issues which our VAR is struggling to get answered from Acumatica.Has anyone made the transition from the Acumatica Smart Shipment integration with UPS WorldShip to the EasyPost integration? Below are our questions and the partial answers which we have received.“End of Day”: WorldShip includes an “End of Day” function which created a consolidated scan ticket for the driver, a Daily Shipment Detail Report and triggered the emails from UPS with the tracking numbers.Will WorldShip show the shipments which are confirmed in the EasyPost integration? (If so we would then be able to do End of Day in WorldShip and the three functions above would be completed.) If we can’t do End of Day in WorldShip then how do we get a consolidated

5 days ago

ashishCodecornersFreshman I

asked in Develop Integrations with Web Services | APIs

Error exceptionMessage: Entity without screen binding cannot be used as top level entity.

Please help me out from this exception Message. I don’t understand why this happen.All API working fine, but in some API occurred a error.Please suggest me a solution for this issue.

5 days ago

brettbFreshman I

asked in Develop Integrations with Web Services | APIs

Unable to add shipment allocations via REST

Hi,I’m trying to add inventory allocations to a shipment order, but I’m getting an error. I’m able to create a Shipment without including the Details and Allocations entities, but when I include them I get an error. I’m trying to follow the steps here.The following JSON results in a successful call: But this JSON doesn’t: Is there something that I’m missing that’s preventing me from creating the Allocations?

7 days ago

IvanVarsity I

asked in Develop Integrations with Web Services | APIs

Work with subcontracts

Hi,My application generates REST request which is used for creating BillsThis is my request for creating BillURL : https://mcicj.acumatica.com/entity/ARTSDocAlphaEndpoint/20.200.001/BillBody :{ "VendorRef": { "value": "1ABL-217i941" }, "DueDate": { "value": "3/2/2023" }, "Vendor": { "value": "V-06702" }, "Date": { "value": "1/31/2023" }, "Terms": { "value": "PWP" }, "PostPeriod": { "value": "01-2023" }, "Details": [ { "Description": { "value": "Line 001 - Gypcrete" }, "Qty": { "value": 1 }, "UnitCost": { "value": "34573.2" }, "ExtendedCost": { "value": "34573.2" }, "Account": { "value": "5430" }, "SubcontractLine": { "value": "1" }, "SubcontractNbr": { "value": "234567" }, "rowNumber": { "value": "1" }This request is fully workable.Bill is successfully created, however these 2 fields are missedI can add them only via “

7 days ago

IvanVarsity I

asked in Develop Integrations with Web Services | APIs

Bills are created with Closed state

Hi,I am using such request for creating Bills{ "VendorRef": { "value": "2134" }, "Hold": { "value": false }, "DueDate": { "value": "3/2/2023" }, "Vendor": { "value": "V-02366" }, "Date": { "value": "1/31/2023" }, "Terms": { "value": "N30" }}Console shows that request is successful and it’s status is “Balanced”However in Acumatica it is in “Closed” stateI tried lots of vendors, lots of another combinations, but result remains the sameWhat I should check ?Kindest regards

7 days ago

IvanVarsity I

asked in Develop Integrations with Web Services | APIs

Two columns are not added to Bill Deatils

7 days ago

IvanVarsity I

asked in Develop Integrations with Web Services | APIs

jaysonFreshman II

asked in Develop Integrations with Web Services | APIs

Can't Update Customer Custom Field

11 days ago

jaysonFreshman II

asked in Develop Integrations with 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

11 days ago

DharmandarKumarFreshman I

asked in Develop Integrations with 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

12 days ago

kuldeepsinghFreshman I

asked in Develop Integrations with 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.

12 days ago

development93Freshman II

asked in Develop Integrations with Web Services | APIs

How to include an Action button in a web service endpoint

Hello everyone, hope you all good.How can I include a button on a web service Endpoint?i.e.I need to add this button to web service endpoint. Endpoint: Will really appreciate for any kind of responseThank you.

19 days ago

EvanGVarsity I

asked in Develop Integrations with Web Services | APIs

The system failed to commit the shipmentlist row

Good day,I used this import scenarios a number of time. Now I am getting the below message. I can’t seem to figure out what the problem is now. Attached is the HTML. Any suggestions? Need help. Operations needs these orders upload ASAP.Thank you@Naveen Boga Your help is always spot on. =The system failed to commit the shipmentlist row. Field: Unit Price, Value: 0, Warning: Unit price has been set to zero because no effective unit price was found.

19 days ago

JonahFreshman I

asked in Develop Integrations with Web Services | APIs

Query data for a single company

I am creating an integration with Acumatica and I would like to give the user an option on which of their companies they would like to connect.However, when I query any data endpoint (such as a list of ledgers or journals), I receive the information for all the companies that belong to that user. This means it was irrelevant for the user to select which companies they wanted to connect.Is there a query param that I can pass to the endpoints that will return only the data for the company I specify? I have not been able to find such a thing in the documentation. If not, what is the best approach for getting around this?Any advice would be appreciated.

20 days ago

chris49Varsity I

asked in Develop Integrations with Web Services | APIs

How to create a Normal PO with lines linked to a Blanket PO via REST API

Good day,I’m trying to create a Normal PO which has lines that are linked to a Blanket PO via the REST API. The request I’m sending through is successful, however the line item in the Normal PO is not linked to the Blanket PO as expected. When using the UI to link the Blanket PO Line, all works as expected.From my understanding, we would need to pass through the OrigPONbr & OrigPOType fields, which should link them to the blanket PO, am I perhaps missing something else?API Request & Response:{ "Type": { "value": "Normal" }, "Branch": { "value": "FTNHQ" }, "Date": { "value": "2023-03-08T00:00:00+02:00" }, "Hold": { "value": true }, "Owner": { "value": "FTNHQ-1009" }, "PromisedOn": { "value": "2023-03-15T00:00:00+02:00" }, "VendorID": { "value": "10079" }, "Description": { "value": "Test Blanket PO Creation" }, "Details": [ { "BranchID": { "v

20 days ago

JonahFreshman I

asked in Develop Integrations with Web Services | APIs

Deploying a Customization Project to other Acumatica ERP instances

Hi guys,I am currently developing an integration to pull data from Acumatica ERP. I am trying to implement an OAuth 2.0 flow using the Authorization Code Flow.From reading through the resources, I have gotten this flow to work for my local Acumatica ERP instance. However, I am struggling to understand how to expand this to other Acumatica ERP instances, such as those used by our clients.I understand that a key part of the OAuth flow is creating a record in the Connected Applications form, and being issued a Client ID and a secret. I’ve seen that I can export this Connected Applications form as part of a Customization Project, but when I import this Customization Project in another Acumatica ERP instance, it loses the record in the Connected Applications form. I suspect this may have to do with the tenant name being different in the other instance, but I am unsure how to get around this.Even if I do get this Customization Project approach to work, it doesn’t seem logical to me to have e

20 days ago

DharmandarKumarFreshman I

asked in Develop Integrations with Web Services | APIs

How to call a check delete action endpoint through rest api

21 days ago

IvanVarsity I

asked in Develop Integrations with Web Services | APIs

Acumatica Web Service Endpoints

Hi, what is the last Acumatica endpoint version ?For Acumatica 2022R2 it was 22.200.001What endpoint for 2023R1 ?

22 days ago

Omar GhaziAcumatica Moderator

posted in Develop Integrations with Web Services | APIs

Microsoft Teams Integration Ready for Managed Availability! Searching for Customers

UPDATE: March 3, 2023Thank you to our partners and customers who signed up to try our Teams integration customization and provide feedback! As announced during the Summit 2023 Keynote session, Microsoft Teams integration will be available as part of the core product starting 2023 R1 as part of our new Experimental Features. We have made a lot of great improvements both in the integration as well as its usability. Yet we are just beginning.We will be ending the Managed Availability Program for Teams integration for any new requests. This means that if you were a partner or customer as part of the program, you can continue using the integration as a customization that was provided. However, support, ongoing maintenance, and support for future versions will no longer be available from April 4, 2023. We will continue to monitor this community site as well as our interaction with customers and partners to collect ideas and feedback to help improve our Microsoft Teams Integration (core).Sinc

24 days ago

Page 1 / 13

Badge winners

angierowley75has earned the badge Innovator
vkumarhas earned the badge Innovator
Robert Sternberghas earned the badge Reports and Generic Inquires expert
Tcollins1968has earned the badge Easy talker
DavidEichnerhas earned the badge Product guru

Show all badges

Terms & Conditions Cookie settings

Sign up

Already have an account? Login

Social Login

Login to the community

Social Login

Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.

Username or e-mail

Back to overview

Scanning file for viruses.

Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.

This file cannot be downloaded

Sorry, our virus scanner detected that this file isn't safe to download.

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.

Privacy Policy
Terms of Use
GDPR
SLA
Support
Report an Outage