Skip to main content

Develop Integrations with Web Services | APIs

Technical discussions focused on Web Services and APIs for developers

  • 671 Topics
  • 2,715 Replies
671 Topics
I
Varsity I
IvanVarsity I
asked in Develop Integrations with Web Services | APIs
Call checks and Payments item via Event

Hi,Previously I developed application that generates file when some Payment is SavedIt was done by calling this event  Now I need to do the same for ChecksI tried to create similar event , but I do not know how to define  such event One important moment  that the event must be called only once, due to it generates file.It was advised to use that part of code  e.Cache.VerifyFieldAndRaiseException<ARPayment.refNbr>(e.Row);And it perfectly worked the event was called only by once. How to do same for Cheks and Payments as what was done for Payments and Applications entity ?

5
J
Pro I
2 years ago
C
Freshman II
cmarshall74Freshman II
asked in Develop Integrations with Web Services | APIs
Login error accessing 20.200.001 Web Service Endpoint

We are attempting to Login to a Web Service Endpoint based on the 20.200.001 Default.  However when we send the Login request it returns an errorRequest XML<?xml version="1.0" encoding="utf-8"?><soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/" ><soap:Body xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" ><Login xmlns="http://www.acumatica.com/entity/3/OzLINK_MVP_WSE/20.200.001/"><name>admin</name><password>*****</password></Login></soap:Body></soap:Envelope>Response<s:Envelope xmlns:s="http://schemas.xmlsoap.org/soap/envelope/"><s:Body><s:Fault><faultcode>s:Server</faultcode><faultstring xml:lang="en-US">System.InvalidOperationException: System contract PX.Api.ContractBased.SystemContracts.V4.SystemContract does not implement required interface PX.Api.ContractBased.Soap.ISoapSystemContractThis only happens for 20.200

4
C
Freshman II
2 years ago
I
Varsity I
IvanVarsity I
asked in Develop Integrations with Web Services | APIs
Retrieve Detail Total value from Invoices tab

Hi, I am trying to extract the value from Invoice  as it shown at screen But I need to take into account Reference Nbr of invoice from “Documents To Apply Tab”So, I am going throw rows in Payment event which is called when user saves the Payment  foreach (PXResult<AR.ARAdjust, AR.ARInvoice, PX.Objects.AR.Standalone.ARRegisterAlias, ARTran> gridRow in Base.Adjustments.Select())                                {                                    AR.ARAdjust _ARAdjust = gridRow;                                    AR.ARInvoice _ARInvoice = gridRow;                                 } But how to call necessary Invoice from this place ?                                  

2
I
Varsity I
2 years ago
I
Varsity I
IvanVarsity I
asked in Develop Integrations with Web Services | APIs
Retrieve value Customer from "Documents To Apply" tab in Payment

Hi, I am trying to extract the value from customer in details, as it shown at screen its name is AdjdCustomerIDHowever, when I am getting this value in a code , foreach (PXResult<AR.ARAdjust, AR.ARInvoice, PX.Objects.AR.Standalone.ARRegisterAlias, ARTran> gridRow in Base.Adjustments.Select())                                {                                    AR.ARAdjust _adjust = gridRow;                                                                   try { codeWordArtsyl = _adjust .AdjdCustomerID.ToString() + "VCARD"; }}I am receiving codes (4096, 4078) instead of names ABCVENTURE, ARTCAGES as it is depicted at screenshot.How to extract names of Customers from this tab ?

3
Naveen Boga
Captain II
2 years ago
I
Varsity I
IvanVarsity I
asked in Develop Integrations with Web Services | APIs
Extract data from Customers tab

Hi, I need to extract customer data inside my event that is called after user selects a definite paymentAfter payment was select, I pass the customerID from payment that was selected to Customer Search methodIt was suggested in this topic : to use the following code : It works perfectly, but it always extract data only from customer that is located in header of my payment “ABCHOLDING” But I need o get the data for each customer from Details tabSo, in my code I am going throw cycle inside payment rows and passing the parameter of customer according to my last string to the search method  foreach (PXResult<AR.ARAdjust, AR.ARInvoice, PX.Objects.AR.Standalone.ARRegisterAlias, ARTran> gridRow in Base.Adjustments.Select())                                {                                    AR.ARAdjust _Adjust = gridRow;                                    AR.ARInvoice _Invoice = gridRow;                                                                                               PXResu

3
Naveen Boga
Captain II
2 years ago
I
Varsity I
IvanVarsity I
asked in Develop Integrations with Web Services | APIs
Extract Customer Data from General tab

Hi,I need to extract customer data inside my event that is called after user selects a definite paymentAfter payment was select, I pass the customerID from payment that was selected to Customer Search methodThe fields that I can get for this entity are belong to headerHow can I extract fields from the General tab ? 

7
I
Varsity I
2 years ago
I
Varsity I
IvanVarsity I
asked in Develop Integrations with Web Services | APIs
Get credentials for Acumatica via events

Hi,I have linked my project with Acumatica in Customization project editorMy solution calls the eventPerforms check for Payment and execute some REST requests if the desirable payment is selected.My question is : How to get Acumatica credentials in project ? When the event is triggered it is already have access to the system, because can check the element’s values, so maybe I can get credentials in code.Currently I have wrote Acumatica credentials in project for requests like this But, client can change them, or make some modifications in Acumatica, so there is must be opportunity to change them without making changes in project solution.How can I get the credentials for REST request in project ?

20
I
Varsity I
2 years ago
C
Freshman II
cmarshall74Freshman II
asked in Develop Integrations with Web Services | APIs
Called InventorySummaryInquiry from C#

We have setup a Connected Service in C# to our WSE endpoint, I remember from previous work with Acumatica that to access a Generic Inquiry we need to utilize the Put request.  I am trying this on the InventorySummaryInquiry to get the list of locations available for an item but am getting an error saying the select, filter, expand and custom fields need to be supplied, if I attempt to supply values for each of these then it fails because I am not able to determine exactly what should be supplied for expand or custom.Should I be using something else here?InventorySummaryInquiry inquiryData = await inquiryClient.PutEntityAsync(new InventorySummaryInquiry() { InventoryID = new StringValue() { Value = e.RequestData.ItemName }, ExpandByLotSerialNbr = new BooleanValue() { Value = true } }, "", "", "", ""); The data specified in the request is invalid.Status: 400Response: {"message":"The request is invalid.","modelState":{"$select.String":["A value is required but was not present in the reque

5
Chris Hackett
Community Manager
2 years ago
C
Freshman II
cmarshall74Freshman II
asked in Develop Integrations with Web Services | APIs
Filtering Sales Order with substringof on OrderNbr field

We are using C# with Swagger definition to access a Web Service EndpointWe are attempting to perform a filter on the SalesOrderClient GetListAsync and would like to perform a substringof filter on the OrderNbr field to find any orders that contain the value that has been specified. SalesOrderClient soClient = new SalesOrderClient(httpClient);soClient.BaseUrl = "http://localhost/Acumatica_DEV/entity/Test/20.200.001";select = "OrderNbr, OrderType, Status, CustomerID, Details/LineNbr, Details/InventoryID, Details/OpenQty";if (!string.IsNullOrWhiteSpace(e.RequestData.OrderNumber))    filter = "substringof(OrderNbr.Value, '" + e.RequestData.OrderNumber + "')";else    filter = "OrderType eq 'SO' and Status eq 'Open'";IEnumerable<SalesOrder> salesOrders = await soClient.GetListAsync(select, filter, "details", "", null, null);foreach (SalesOrder salesOrder in salesOrders){    // Process Results} When we execute the search the error returned isUnable to cast object of type 'System.String'

4
C
Freshman II
2 years ago
I
Varsity I
IvanVarsity I
asked in Develop Integrations with Web Services | APIs
Make Invoice status "Open"

Hi I need to create Open Invoices for adding them Payments and Application. I just need to create 20 invoices in order to add 20 rows for payment in order to test data generation As I understood only Open Invoices could be added to “Document to Apply” tab and only with same Customer So, how to make Invoice status “Open”  ?If you know more fast way to generate 20 rows for “Document To Apply” tab for payment than creating 20 Invoices individually, I will be very grateful 

16
I
Varsity I
2 years ago
S
Freshman I
sysuser113Freshman I
asked in Develop Integrations with Web Services | APIs
Update of the Detail Lines of a Shipment for "Shipped Qty" field with the Screen-Based SOAP API

I  am trying to update the Shipment line detail with Screen Based SOAP API service.The code is  executed but respective record not updated.Following is the code snippet var commandList = new List<Command>();                                             commandList.Add(new Key                {                    ObjectName = SO302000.Result.DocumentDetails.LineNbr.ObjectName,                    FieldName = SO302000.Result.DocumentDetails.LineNbr.FieldName,                    Value = LineNbr.Trim(),                    Commit = true                });                commandList.Add(new Key                {                    ObjectName = SO302000.Result.DocumentDetails.ShipmentNbr.ObjectName,                    FieldName = SO302000.Result.DocumentDetails.ShipmentNbr.FieldName,                    Value = acushipmentNbr.Trim(),                    Commit = true                });                commandList.Add(new Value { Value = shipmentLines.ShippedQty.ToString(), LinkedCommand = SO30

12
Naveen Boga
Captain II
2 years ago
A
Freshman I
arpitarath01Freshman I
asked in Develop Integrations with Web Services | APIs
Inventory API

Can i get Inventory fetch API for EDI Integration

2
Naveen Boga
Captain II
2 years ago
A
Freshman I
arpitarath01Freshman I
asked in Develop Integrations with Web Services | APIs
Access API

How to access all API for EDI Integration ?

10
Naveen Boga
Captain II
2 years ago
R
Semi-Pro III
rosenjonSemi-Pro III
asked in Develop Integrations with Web Services | APIs
Please uncripple the Acumatica BQL IN Operator so it can be used with Select2 type queries

The IN Operator is a very commonly used function in SQL to subselect items based on a list of values. it is extremely useful, for example, if you were trying to synchronize a data set from an external system with data inside Acumatica/SQL Server. The Acumatica development blog acknowledged this usefulness in its example code when it announced the availability of the IN Operator: SQL In Operator in BQL - Acumatica Developers BlogWhat it glosses over is that there is no way to use this operator with a Select2 query, which means there is no way to use it with a PXProjection for doing advanced data views in Acumatica. This requirement is not documented anywhere, except for the faint mention that it must be used with the Required<> property. The consequences of only being available with the Required property is that it must be used with a PXSelect type query, but cannot be used with a Select2 type of query. Select2 query style is required for any kind of PXProjection in the system. PX

4
R
Semi-Pro III
2 years ago
I
Varsity I
IvanVarsity I
asked in Develop Integrations with Web Services | APIs
Generating Bill with status "Balanced" via REST requests

 Hi,The aim of this case is to identify how to form REST request properly in order to create Bill with status "Balanced"Our client is using our application, which creates requests and put data to Acumatica. Client asked if we can  create invoices with status "Balanced". I checked such request with our Test Acumatica environment and it was easy to implement. My request successfully worked and created Bill in Acumatica with status "Balanced" However, when we do same request with client's Acumatica we get this error :  "exceptionMessage": "Bill.CashDiscountDate: 'Cash Discount Date' cannot be empty.\nBill.DueDate: 'Due Date' cannot be empty.\nBill.LocationID: 'Location' cannot be empty.\nBill.Terms: 'Terms' cannot be empty.\nBill.Vendor: 'Vendor' cannot be empty.\nBill.VendorRef: 'Vendor Ref.' cannot be empty.\nInserting I searched and found that this error is caused by this fieldWhen I removed it from the request it successfully worked.My question is : what is the possible difference bet

14
J
Pro I
2 years ago
PorchlightZach
Varsity II
PorchlightZachVarsity II
asked in Develop Integrations with Web Services | APIs
Is it possible to unmask values returned by the REST API (21R1), specifically CCPID?

I am working on upgrading our Acumatica instance from 2019R1 to 2021R1.  A substantial part of my project involves updating a set of service layer applications that enable bidirectional communication between our ecommerce site and Acumatica.  Our web site runs on a platform that does not have an available integration for Acumatica.  The site interacts with Authorize.net for all credit card transactions.  I’ll spare everyone the long explanation for why I need to unmask the Payment Profile ID (CCPID) in the API.  The TLDR; is “our web site’s integration with Authorize.net could be better”.  Most of what I need to accomplish involves not creating duplicate payment methods in Acumatica because of web orders.With our customized v18 API endpoint in 2019 R1 my code could load a customer’s payment method list to access the temporary ID for that payment method.  A second request was sent to load a single payment method using the temporary ID with the payment method details expanded.  That woul

6
PorchlightZach
Varsity II
2 years ago
R
Freshman II
rebeckamckinney53Freshman II
asked in Develop Integrations with Web Services | APIs
Integration - Distribution has Negative Amounts

Does anyone have an equation that can turn a negative to a positive amount in integrations. Our client integrates several thousand transactions and a handful (maybe a hundred) sometimes have a negative amount in the Debit and Credit field. This is happening because of how they are entered in the originating system. I have tried a few equations but keep getting errors. =IIf( [Debit Amount]>0, [Debit Amount], [Debit Amount]*-1)Cannot perform the ‘*’ Operation on System.String and System.Int32.  I have tried double and decimal formats and still get this error. =ABS([Credit Amount])An error has occurred while the Abs(Identifier(Debit Amount)) function was being executed: ‘Type mismatch in the argument 1 of the Abs() function: Expected on of the Integer types.’ I have tried the Int32, double, and string types.  I use this in excel. Not sure if the function actually works in Acumatica but thought I’d give it a try. 

4
R
Freshman II
2 years ago
J
Varsity II
jwarrenVarsity II
asked in Develop Integrations with Web Services | APIs
Application ID URI

I’m attempting to configure Microsoft Azure for Integration with Acumatica ERP instance by following these instructions:https://help-2021r2.acumatica.com/(W(7))/Help?ScreenId=ShowWiki&pageid=6b852c66-01c4-40b5-af7d-c53d7e4bd672 In Step 4, I’m required to specify the application ID URI of our Acumatica instance. Supposedly I’m supposed to find the application ID URI in the Web.Config file. But I can’t find this Web.Config file - where would I find this or is there an alternative way to find the application ID URI? J

4
J
Varsity II
2 years ago
A
Freshman I
Andrew1986Freshman I
asked in Develop Integrations with Web Services | APIs
How to receive deleted customers from Acumatica via API

Hello Team,Could you clarify, is it possible to receive deleted customers from Acumatica via API?If yes, which endpoint (screen) it is necessary to use?I opened Web Services Endpoints and didn’t find here the necessary endpoint.Thank you!

7
A
Freshman I
2 years ago
E
Freshman I
edwolfer60Freshman I
asked in Develop Integrations with Web Services | APIs
Get Address by Default address id for Branch in OData V4

  This may be a simple question, but I am not having any luck finding the information I need online or in the documentation.  I am trying to use OData V4 to get information from the Branch screen, and I am trying to locate the default address information.  When I try to follow the example from the training material (I300 Data Retrieval with OData 2021 R2), it tells me for the AR Customer to expand using "AddressByDefAddressID".  I tried this for the PX_Objects_GL_Branch entity and I get an error saying "The query specified in the URI is not valid. Could not find a property named 'AddressByDefAddressID' on type 'PX.Objects.GL.Branch'.".  My question is, where can I go in Acumatica, or in the documentation to find what is available for each entity?  ------------------------------(I300 Data Retrieval with OData 2021 R2)------------------------------------------The PX.Objects.AR.Customer entity contains common information about a customer. TheContactByDefBillContactID navigation property o

7
J
Pro I
2 years ago
J
Freshman I
jpappas62Freshman I
asked in Develop Integrations with Web Services | APIs
AR301000GetSchema() returns Null for .ServiceCommands

Background:I have an Acumatica instance installed that has two Tenants. Tenant ID 2 is the actual company data, and Tenant ID 3 is test company data. I have API Web Service started that has access to AR301000(created only in Tenant 2). I have an admin user, with system admin rights on both Tenants. I just change the login information to switch tenants. admin@actual or admin@test. Im doing this via a C# app, and using a SoapScreenClient. My goal is to create an Invoice, and add a couple lines items in the DocumentDetails section.Issue:Calling .AR301000GetSchema() in Tenant 3 will show DocumentDetails.ServiceCommands as NULL, and therefore I can’t access the .NewRow Command. By only changing my login info to Tenant 2, the .AR301000GetSchema() will allow me to access the ServiceCommands, and call .NewRow and add my line items. The two tenants are setup nearly identical, and manually logging into the web interface, I can complete this task as expected.Side Note.This issue of this .ServiceC

2
J
Freshman I
2 years ago
A
Jr Varsity III
adilaleemJr Varsity III
asked in Develop Integrations with Web Services | APIs
How to get Branch and Company IDs via SOAP API

Is there any glossary of complete customer object fields? I’m using SOAP API and some of the fields aren’t coming with the getSchema object and I have to find them by searching through Acumatica question/answers but I don’t know where they are listed properly?? So far I found:LastModifiedDateTimeCreatedDateTimeNow looking for Branch and Company IDs but don’t know the exact field names.. any help?

9
Naveen Boga
Captain II
2 years ago
D
Jr Varsity II
dhollindenJr Varsity II
asked in Develop Integrations with Web Services | APIs
Can push notification URL be dynamic as a function of CompanyId?

Hello, Our push notifications are part of our customization project, and we publish our customization project to all three of our tenants to keep them in sync. When we do this, the push notification URL is set to the same value for all three tenants, whereas we need each tenant to use its own specific push notification URL. Is it possible for the push notification URL to be dynamic? We’d like each tenant to use different  push notification URL depending on the CompanyId of the tenant.Thank you, Dave

3
J
Pro I
2 years ago
D
Jr Varsity II
dhollindenJr Varsity II
asked in Develop Integrations with Web Services | APIs
Can you configure the cache expiration time?

Hello, We are integrating with the Acumatica SAAS product via the REST API by means of lambda functions. This is working fine in general. However, we find that after a period of inactivity, the response to an API request takes much longer than usual. The lambda function is configured with an execution time of 15 seconds, and it often stops executing before the response is received. An Acumatica support rep once mentioned that this could be due to "cache expiration", but we can't find any documentation about this. Is it possible to configure the cache expiration time, or something similar that would help us solve this problem?Thank you,Dave

3
D
Jr Varsity II
2 years ago
J
Pro I
jininPro I
asked in Develop Integrations with Web Services | APIs
How to logout the instance based on branches

Hi Is it any possible way to logout the instance based on the branch using REST API?

2
J
Pro I
2 years ago

Badge winners

  • Low Code | No Code Customizations or Integrations
    aiwanhas earned the badge Low Code | No Code Customizations or Integrations
  • Easy talker
    vineela95has earned the badge Easy talker
  • Easy talker
    hyadav08has earned the badge Easy talker
  • Manufacturing expert
    dcomerfordhas earned the badge Manufacturing expert
  • Easy talker
    courtneybhas earned the badge Easy talker
Show all badges
Terms & ConditionsCookie settings