Develop Integrations with Web Services | APIs

Technical discussions focused on Web Services and APIs for developers

669 Topics
2,704 Replies

669 Topics

asked in Develop Integrations with Web Services | APIs

How to get custom field value from Payment and Application screen to Bank Deposit screen document level

Hi Everyone ,We have below requirement , can anyone suggest best possible way to achieve it please?Added a new field in Payment and Application header level Should display the above custom field value in Bank Deposit Document level grid Thanks in advance.

2 years ago

greglangVarsity I

asked in Develop Integrations with Web Services | APIs

Using GI's with REST API

I have extended a Web service End Point to include the results using instructions from https://www.acumatica.com/blog/contract-based-apis-in-generic-inquiries/. and Am using a GI as a data source with Celigo (integrator.io). The problem I’m running into is it breaks down the GI into pages and with my $Skip formula to chunk the data into pages. I think its because all the data is in the Detail item “Result” and it sees everything as 1 big record. I think this because to read the results correctly I had to point the resource path to “Result” I’m at a loss here on how to fix the issue but I’m not an expert so maybe someone here has dealt with this and can help! Thanks in advance, Greg

2 years ago

KellyMarchewaFreshman II

asked in Develop Integrations with Web Services | APIs

Custom Integration Scenario "x items have not been processed successfully." - But data instereted correctly

I created a custom Import Scenario that uses the Employee screen. It essentially calls a custom Action I created. The action performs no redirection; it merely creates a new PREmployee record.The configuration is below: When I try to run this in an “Import by Scenario”, I receive an error: Error: x items have not been processed successfully. View name: Employee. No errors appear next to the individual items. Furthermore, the action performs as expected; the PREmployee record is created.Why might this error be appearing and how might I troubleshoot?

2 years ago

dmulveyFreshman I

asked in Develop Integrations with Web Services | APIs

2021R1 Project API - "Account Email" validation (length of field)

We have encountered an issue with the Project API in 2021R1.The validation is on the size of the "Account Email" field in the Project API Model (presumably the email address of the Customer related to the Project). There seems to be some new validation on the length of the field.Does anyone know the size limit for the field?

3 years ago

TharidhiPVarsity III

asked in Develop Integrations with Web Services | APIs

Using External APIs in Acumatica

We are carrying out an integration to export sales records from Acumatica Sales Order Screen into external system via third-party API, what is the best way to carry out this integration?What is the best way to send Acumatica sales data to this external API and also sales data must be sent hourly. Currently thinking of using Contract-based REST API method in Acumatica. Please let me know the right solution to go ahead with this requirement or any documents present.

3 years ago

gcoder

asked in Develop Integrations with Web Services | APIs

Endpoint mapping

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

3 years ago

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 OrderStep. 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"

3 years ago

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-e29156f3c150This 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" },

3 years ago

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!

3 years ago

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?

3 years ago

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: PUTParameters:$expand: Contact,Address$select: Contact/FirstName,Contact/LastName,Address/CountryHeaders:Accept: application/jsonContent-Type: application/jsonBody:{"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 appreciatedI 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 key)\r\n at Microsof

3 years ago

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=Detailsand this:GET https://acumatica-dev.psfc.coop/entity/Default/18.200.001//BillI get back a 200 response and empty array [] in the body.Can anyone please help me with this?

3 years ago

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=Detailsbody:{ "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):{

3 years ago

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

3 years ago

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

3 years ago

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 hostMetadata 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 is not

3 years ago

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")

3 years ago

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?

3 years ago

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'}, '

3 years ago

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?

3 years ago

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.

3 years ago

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.

3 years ago

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

3 years ago

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

3 years ago

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()?

3 years ago

Page 26 / 27

Develop Integrations with Web Services | APIs

Badge winners

Sign up

Social Login

Login to the community

Social Login

Scanning file for viruses.

This file cannot be downloaded