Skip to main content

Develop Integrations with Web Services | APIs

Technical discussions focused on Web Services and APIs for developers

  • 813 Topics
  • 3,247 Replies
813 Topics
G
gcoder
asked in Develop Integrations with Web Services | APIs
Endpoint mapping

Is there any documentation on how to connect these endpoints in API push?

861
Naveen Boga
Captain II
J
Freshman I
jeremypotoka6Freshman I
asked in Develop Integrations with Web Services | APIs
HTTP PUT to Update Drop Ship PO on SO line of Sales Order

Wondering if anyone has tried the following before: Step 1) Web service call (REST) to create a Drop Ship Purchase Order Step. 2) Web service call (REST) to create Sales Order, including Drop Ship PO information at the SO Line level in the PUT request. Has anyone tried to update the PO information on the SO Line via REST API call? Below are my two API calls – first for creating the PO, second for creating the SO. I am trying to populate the “POOrderNbr” on the Detail record directly (which is essentially what it looks like the PO Link functionality does). Assuming that the PO Link has some extra logic baked in that allows this field to be written to as needed. Purchase Order API call: { "Details":[ { "InventoryId":{ "value":"ITS-002687" }, "LineNbr":{ "value":1 }, "OrderNbr":{ "value":"400080001" }, "OrderQty":{ "value":1.0 }, "UOM":{ "value":"EA" }, "WarehouseId":{ "value":"100" } } ], "Hold":{ "value":false }, "Location":{ "VALUE":"MAIN" }, "OrderNbr":{ "value":"400080001" }, "Shippi

4691
Troy Vars
Semi-Pro I
A
Freshman II
andrewm80Freshman II
asked in Develop Integrations with Web Services | APIs
Transfers Receipt via API

Hi i am looking for help with creating a receipt for a transfer order via API. I created a 2 step transfer as seen in the image. Now i need to create a Receipt for this order using the API. I have tried to follow this post without any success. https://help-2021r1.acumatica.com/(W(10))/Help?ScreenId=ShowWiki&pageid=24c68cc6-6985-4421-86c9-e29156f3c150 This is a sample of what i have tried. Endpoint : https://<baseurl>/entity/Default/18.200.001/PurchaseReceipt { "Type": { "value": "Transfer Receipt" }, "Warehouse": { "value": "DP@RAM" }, "Details": [ { "TransferOrderType": { "value": "TR" }, "TransferOrderNbr": { "value": "INRDP000002" }, "TransferOrderLineNbr": { "value": "1" }, "TransferShipmentNbr": { "value": "INRDP000002" }, "ReceiptQty": { "value": "1" }, "Allocations": [ { "Location": { "value": "RAMREC" }, "Qty": { "value": 1 } } ] } ] }

1230
A
Freshman II
D
Freshman I
DennyYang14Freshman I
asked in Develop Integrations with Web Services | APIs
Authorization doesn't take effect when I use OAuth2.0 to call API

Hi Experts, II’m trying to test Acumatica’s OAuth Authorization flow using Postman. I already created a Client in the Connected Applications screen, and set the flow to Authorization Code. Also I got the access token after I called the authorize api. I can call the OData service successfully as below. But when I call the web service to get sales orders with the access token, I always get a message “You are not logged in.” Here is the screenshot. Do we still need to call LogIn api again when we call the web service with access token? Thanks in advance!

10483
Naveen Boga
Captain II
P
Freshman II
PRapnikasFreshman II
asked in Develop Integrations with Web Services | APIs
Public form submitting data directly to Acumatica

I’m looking for some general direction. I need to create 3 or 4 forms to be embedded on our public website where users can submit and it goes directly into Acumatica (possibly kicking off a workflow). The form might also contain the fields to upload specific documents. Any suggestions?

2893
B
Pro III
C
Freshman I
charlbester34Freshman I
asked in Develop Integrations with Web Services | APIs
REST API - "The given key was not present in the dictionary."

Good day. I am trying to create new leads via an API call. I have the following settings configured inside postman: URL: https://localhost/MyStoreInstance/entity/Default/20.200.001/LeadHTTP method: PUT Parameters:$expand: Contact,Address$select: Contact/FirstName,Contact/LastName,Address/Country Headers:Accept: application/jsonContent-Type: application/json Body: { "Contact":[{ "FirstName":{"value":"NewTest"}, "LastName":{"value":"NewTest"} }], "Address":{ "CountryID":{"value":"ZA"} } } This is just a basic PUT method to make sure that it is working. I will later add it with correct and more values. Any help would be greatly appreciated I am receiving the following internal server error:{"message": "An error has occurred.","exceptionMessage": "The given key was not present in the dictionary.","exceptionType": "System.Collections.Generic.KeyNotFoundException","stackTrace": " at System.ThrowHelper.ThrowKeyNotFoundException()\r\n at System.Collections.Generic.Dictionary`2.get_Item(TKey ke

25213
Naveen Boga
Captain II
I
Freshman I
ihe63Freshman I
asked in Develop Integrations with Web Services | APIs
REST API - empty response for Bill request.

Hello, I created a bill in Acumatica 2020/R1 and am trying to retrieve it via the Contract-Based REST API. I’ve tried with and without parameters like this: GET https://acumatica-dev.psfc.coop/entity/Default/18.200.001//Bill?$select=Date,Amount,ReferenceNbr,Vendor,VendorRef,Details/Description,Details/UnitCost,Details/Qty,Details/Amount,Details/Account&$expand=Details and this:GET https://acumatica-dev.psfc.coop/entity/Default/18.200.001//Bill I get back a 200 response and empty array [] in the body. Can anyone please help me with this?

1973
L
Semi-Pro II
I
Freshman I
ihe63Freshman I
asked in Develop Integrations with Web Services | APIs
REST API - 500 error creating a Bill

Hello, Maybe related to a problem I posted earlier about not being able retrieve a bill created in the Acumatica 2020/R1 gui: I tried to create a bill with the Contract-Based REST API, based on an http request in the integration guide: PUT https://acumatica-dev.psfc.coop/entity/Default/18.200.001/Bill?$select=ReferenceNbr,Details/POOrderNbr,Details/POOrderNbr,Details/InventoryID,Details/Qty&$expand=Details body: { "Vendor": { "value": "V100958" }, "VendorRef": { "value": "123" }, "Description": { "value": "Bill for particular lines of a purchase order" }, "Details": [ { "POOrderType": { "value": "Normal" }, "POOrderNbr": { "value": "000001" }, "POLine": { "value": 1 }, "Qty": { "value": 5 } } ]} I get a 500 response and this body (edited): { "message": "An error has occurred.", "exceptionMessage": "Operation failed", "exceptionType": "PX.Data.PXInvalidOperationException", "stackTrace": " at PX.Api.ContractBased.EntityService.Put(ISystemContract systemContract, String version, String na

3860
I
Freshman I
D
Jr Varsity II
dhollindenJr Varsity II
asked in Develop Integrations with Web Services | APIs
Include user name or ID that made change in Push Notification

Hello, We’re publishing Acumatica push notifications to a Kafka topic as part of our system integration. It would help us greatly to identify push notifications that result from user actions in the Acumatica UI as opposed to actions that are performed via the API. One way to do this, I thought, would be to identify the user performing the actions, since actions performed via the API are always carried out under the same user account. Is it possible to include the name or ID of the user associated with an action in our push notifications? Thank you, Dave

1202
D
Jr Varsity II
D
Jr Varsity II
dhollindenJr Varsity II
asked in Develop Integrations with Web Services | APIs
Postal code requirement / validation

Good morning, We are integrating with Acumatica via its API, and have run into a situation w/regard to postal code. In the Acumatica UI, I can create a business account without entering a postal code. It doesn’t matter which country I specify in the address fields. Via the Acumatica API, I can create a business account without entering a postal code if I specify the country as France. But if I set the country to US and don’t enter a postal code, the response is a 422 error code specifying a problem with postal code. So it seems the postal code is required by Acumatica API if country = US, but there’s no similar requirement in Acumatica UI. Can any one please shed some light on this? I don’t know where requirements like this might be configured or if there’s a way we can work around this. Thank you, Dave

5953
Naveen Boga
Captain II
A
Jr Varsity III
adilaleemJr Varsity III
asked in Develop Integrations with Web Services | APIs
How to use Acumatica API for data uploading

Hi, Interested in knowing how I can use Acumatica API to upload data from C#. I’m looking for any step-by-step document which can explain me from the scratch like how to configure API, how to check it is ready to use or not and then how to use it. I tried to add API’s wsdl in VS project as a service reference but it gave me an error: There was an error downloading 'https://mycompany.acumatica.com/entity/Default/18.200.001/_vti_bin/ListData.svc/$metadata'. The underlying connection was closed: An unexpected error occurred on a send. Unable to read data from the transport connection: An existing connection was forcibly closed by the remote host. An existing connection was forcibly closed by the remote host Metadata contains a reference that cannot be resolved: 'https://mycompanyt.acumatica.com/entity/Default/18.200.001'. An error occurred while making the HTTP request to https://mycompany.acumatica.com/entity/Default/18.200.001. This could be due to the fact that the server certificate i

5203
A
Jr Varsity III
M
Jr Varsity III
mhapsJr Varsity III
asked in Develop Integrations with Web Services | APIs
Cascading Delete [PXParent] does not work

I have a DAC MySOInfo defined as Child of SOOrder and another DAC MySODetail as Child of MySOInfo. If a SOOrder is deleted in Screen SO301000, I would expect that the linked MySOInfo entries are deleted and MySODetail entries, too. In fact the first Children MySOInfo are deleted but the Children’s Children MySODetail are not deleted. The DAC’s are defined like this: [Serializable] [PXCacheName("MySOInfo")] public class MySOInfo : IBqlTable { #region RecordID [PXDBIdentity(IsKey = true)] public virtual int? RecordId { get; set; } public abstract class recordId : PX.Data.BQL.BqlInt.Field<recordId> { } #endregion #region OrderNbr [PXParent(typeof(SelectFrom<SOOrder>.Where<SOOrder.orderNbr.IsEqual<orderNbr> .And<SOOrder.orderType.IsEqual<orderType>>>))] [PXDBString(15, IsUnicode = true, InputMask = "")] [PXUIField(DisplayName = "Order Nbr")] public virtual string OrderNbr { get; set; } public abstract class orderNbr : PX.Data.BQL.BqlString.Field<orderNbr> { } #endregion #region OrderType [

37610
Naveen Boga
Captain II
M
Jr Varsity III
mhapsJr Varsity III
asked in Develop Integrations with Web Services | APIs
How to set Discount on Sales Order programmatically

For a newly created Sales Order I want to add positiv or negativ discounds, on document and line level. Discounts by percentage work find. On document level I create a new SOOrderDiscountDetail, set Type = ‘B’, IsManual = true and DiscountPct. On line level I just set SOLine.DiscPct. But I have problems to set discounts by amount. If I set SOOrderDiscountDetail.DiscountAmt or SOLine.DiscAmt, it is set back to 0,0. The lines and discount details are created any persisted like this. SOOrderEntry.Transactions.Insert(new SOLine{...}); SOOrderEntry.DiscountDetails.Insert(new SOOrderDiscountDetail{...}); SOOrdeEntry.Actions.PressSave(); What is the correct way to set a discount amount on document and line level code?

1680
M
Jr Varsity III
M
Jr Varsity III
manley75Jr Varsity III
asked in Develop Integrations with Web Services | APIs
REST API - Add PO Receipt to Bill - Need Help

Hi community, Where I work we have been using the REST API quite a lot to automate redundant tasks in Acumatica and tie some of our in house software in to it. However, I do not have a lot of experience using “Actions” aside from the “Release” button and so have come to you for help. Objective: Add a PO Receipt to an existing Bill. The Bill has already been created and is on “Hold”. I have added the “AddPOReceipt” action to my extended web service endpoint. When I POST to “AddPOReceipt” endpoint I get a 204 response to which I follow up with a GET to check the status of the request and I get a 200 response. When I look at the bill there is no receipt added to it though. What am I doing wrong? myurl = "https://4iiii.acumatica.com/entity/ManleyEndpoint/17.200.001/Bill/AddPOReceipt" jsonUpdate = { 'entity': { 'Type': {'value': 'Bill'}, 'ReferenceNbr': {'value': '006357'}, }, 'parameters': { 'ReceiptNbr': {'value': '003341'}, 'ReceiptType': {'value': 'Receipt'}, 'Selected': {'value': 1}, }

9566
M
Jr Varsity III
aames
aames
asked in Develop Integrations with Web Services | APIs
Error Getting Attachments for a Purchase Order

I’m following the example in Lesson 3.1 of the I310 training course. But instead of retrieving attachments of a Stock Item, I want the attachments of a Purchase Order. In Postman, I’m performing a GET to: https://localhost/PhoneRepairShop/entity/Default/20.200.001/PurchaseOrder/000001?$select=OrderNbr,files&$expand=files The response is: Operation is not valid due to the current state of the object. This happens for both open and closed purchase orders. Am I missing something?

841
Dmitrii Naumov
Acumatica Moderator
A
Freshman I
amirzouFreshman I
asked in Develop Integrations with Web Services | APIs
how set default Value "mode de reglément" in customer with API

Hello , i need to check this default value "mode de reglément" in customer with API. thank you for help.

451
Dmitrii Naumov
Acumatica Moderator
A
Freshman I
Andrew1986Freshman I
asked in Develop Integrations with Web Services | APIs
Receiving the Customer Summary via API

Hello Team, I hope things are going well. Could you please help me with the following question. Acumatica has the Customer Summary module. Link to the description - https://help-2017r2.acumatica.com/Wiki/ShowWiki.aspx?pageid=4d224cd8-6553-4930-872b-d667ddff891e I want to receive all Customers from this summary and their Currency Ending Balance column. But I cannot find the API to receive these Customers and their Currency Ending Balances. Could you provide a link to the API? Of course, if it is possible.

961
Dmitrii Naumov
Acumatica Moderator
A
Freshman I
Andrew1986Freshman I
posted in Develop Integrations with Web Services | APIs
Updating the Customer's redit limit

Hello Team, Could you please provide an example of the request how to update the Customer’s credit limit?Or could you provide a link to the API that describes how to update the record at the customer level? Regards,Andrew

951
Dmitrii Naumov
Acumatica Moderator
L
loveAtAcumatic
posted in Develop Integrations with Web Services | APIs
Rest Api documnent for all end points

Can you please forward me the doc link where you mention all the native rest API and its schema and all details. if we have custom fields on Sales Order like Amazon ID , how can i get same on invoice creation automatically

2871
Dmitrii Naumov
Acumatica Moderator
M
Jr Varsity III
mhapsJr Varsity III
asked in Develop Integrations with Web Services | APIs
PXDBIdentity field not updated in cache after Persist

Hello, I have a problem getting the value of auto-incremented field of a new inserted record. In my DAC the Id field has [PXDBIdentity(IsKey = true)]. It is the only key field. Here’s some code. MyDac newDac = graph.MyDac.Insert(new MyDac()) ; int? tempId = newDac.Id; graph.MyDac.Cache.Persist(PXDBOperation.Insert); int? newId = newDac.Id; tempId is negativ as expected. But newId is alway 0, I’d expect the real value of the newly created entry like in DB. NewDac is still in Cache.Inserted and in DirtyCashes. If I call graph.Actions.PressSave() instead of Cache.Persist() newDac.Id is updated and it moves to Cache.Cached. But I have entities in other views that should not be saved at this time. I am sure, that with other Dac classes the Id is updated after callling Persist(). Does the system check relations to other entities and and therefore may not give back the new Id in my case? How can I get the real Id of the newly inserted record without PressSave()?

7076
M
Jr Varsity III
dev16
Freshman II
dev16Freshman II
asked in Develop Integrations with Web Services | APIs
REST API - Connecting CIS API to acumatica to be pulling Data

Hi, I have 4 APIs, The first is POST method that posts the credentials to the CIS system and accessToken is generated(the token changes daily) which is used in the GET methods. The rest are GET methods that gets the data and imports into Acumatica. So far my code retrieves the data successful and they are in json format. How can I import this data into Acumatica? N/B The integration is permanent, not a one time thing. Data is Customer Data, Invoices and Payments.

1964
Naveen Boga
Captain II
M
Jr Varsity II
mwong11Jr Varsity II
asked in Develop Integrations with Web Services | APIs
How to filter on a field inside a details table in an EndPoint

Hi, I have extended Default/18.200.001 endpoint to include Construction SubContracts like this http://localhost/test/entity/Subcontracts/18.200.001/Subcontracts I can filter by a field from the summary like this https://localhost/entity/Subcontracts/18.200.001/Subcontracts?$filter=SubcontractNbr eq 'SC-000002' However, can I filter on a field in a details table? Example, Is it possible to filter by the Project field in Document Details tab in SubContracts end point?

5771
Gabriel Michaud
Captain II
M
Jr Varsity III
mhapsJr Varsity III
asked in Develop Integrations with Web Services | APIs
Refresh Tab that is not in View for Master/Detail grids

I have several detail grids with one master. Each detail has its own tab. The problem is the grids that are in a tab, that is not in view, are not updated when the master record changes. I’ve already done in aspx and code: MasterGrid: <px:PXGrid SyncPosition="true" KeepPosition="true" <AutoCallBack Command="Refresh" Target="tree" ActiveBehavior="True"> <Behavior RepaintControlsIDs="DetailGrid1, DetailGrid2View" BlockPage="True" CommitChanges="False"></Behavior> </AutoCallBack> (I am unsure about Target in this case) DetailGrid_n: <px:PXGrid SkinID="DetailsInTab" SyncPosition="True” <CallbackCommands> <Refresh SelectControlsIDs="MasterGrid" ></Refresh> </CallbackCommands> Graph: public SelectFrom<DetailDAC_n> .Where<DetailDAC_n.Id.IsEqual<MasterDAC.Id.FromCurrent>> .View Details_n; BLC: _(Events.RowSelected<MasterDAC> e) { Details_n.View.RequestRefresh(); } The behavior is like this. If the selected row in the master grid changes, the detail grid in the visible tab changes accordingly.

7326
M
Jr Varsity III
D
Captain II
DjangoCaptain II
asked in Develop Integrations with Web Services | APIs
Customer EndPoint mapping question

I’m looking at Endpoint version 20.200.001 and specifically the Customer endpoint. The settings indicated that this endpoint is connected to screen AR303000. Under Customer is a field defined as: BillingContactOverride, Financial → Financial Settings, OverrideBillContact But that field isn’t on that tab. OverrideBillContact is Billing → Bill-to Address → Override, Override Clicking Validate Entity returns a message that says it validated. Am I missing something on understanding the field mapping or is the mapping incorrect?

2792
D
Captain II
M
Jr Varsity III
mhapsJr Varsity III
asked in Develop Integrations with Web Services | APIs
Prevent auto fill-in of password field in custom entity

Hello, I need a configure screen that contains also password and store them to DB. I set the TextMode to “Password” to hide it. <px:PXTextEdit ID="edPassword" runat="server" DataField="Password" TextMode="Password" /> But the web browser (Chrome and Firefox) fills-in the login password into this field. Is there a possibility to prevent that in code? Thanks, Michael

1002
praveenpo
Semi-Pro II

Go to

Discussion Forums
Financials
Distribution
Manufacturing
Construction
CRM
Field Service
Retail
Payroll
Professional Services
Low Code | No Code Customizations or Integrations
Develop Customizations
Develop Integrations with Web Services | APIs
Other Developer Topics
ISV Solutions
Configuration and Installation
Reports and Generic Inquires
Import and Export Scenarios
System Health and Performance
Community site discussions
Community Introductions
Everything Else
Technology Partners and Customers
News & Announcements

Tags

Most helpful members this week

Badge winners

Show all badges
Terms & ConditionsCookie settings

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie 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 — 2024  Acumatica, Inc. All rights reserved