Develop Integrations with Web Services | APIs

Hi,I am trying to call “Add subcontract line" for Bill, but none of subcontracts is availableI tried to create new subcontract and tried to select the existing one subcontract but none of them is depicted at this section. What should I check ? 

I’ve created an inventory item and set-up all options/features to make the “NonStockReceiptAsService” checkbox visible in the UI.Now, I’m trying to update this field via the PUT REST API call to no avail. If I inspect this element, it appears to be defined by the field name “NonStockReceiptAsService” but that is ignored in the PUT/update and it is not acquired/visible via the GET API call.Hoping for more information about how to actually set this value programmatically as it only appears to be accessible via the UI (which is not ideal in an integration situation).  Added:  

Hi,Previously, I had experience with default actions for Bill that are depicted at screenFor using them it was enough to send such request Our client is using custom entity named SubcontractsI need to send new fields from this entity to Bill, these fields are SubcontractNbr and SubcontractLineClient’s Acumatica already contains such actions for this entityI assume that I need to use addSubContractLines action as I need to add these fields to Bill’s columns in DetailsHowever this action does not contain any parametersMy question is : how to use action for adding these custom fields : SubcontractNbr and SubcontractLine to Bill and how to form such request ?This 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": {

I want to use the Task api with the customer visit type, but the response is generated like this, please help

Good day,In nutshell, we send via the API GI results at night PST (e.g. 11:00 AM PST).  We schedule the sending of the data from a product called JB.  I have the conditions on the results set to identity the orders that need to pass through the API endpoint to Jitterbit.  Now, the data received by JB is not finding the results because of the API UTC time is already the next day.  Seems to be eight hours ahead.  It seems that any results we send in the evening  Questions:Is the API in UTC time?If so, How should I set up the filter conditions on the GI so that the current days records are sent via the API and not get all the records for the previous day.  The timestamp is showing the next day on the API transmission.   I was thinking @Today-1; this would send yesterday’s records based on the nightly schedule which seems to be the in Acumatica UTC time the next day. Any assistance would grateful.Thank you 

Hi,My application generates REST requests for creates invoices creationIt is working except one momentOur client has added custom entityThere is opportunity to create Bill based on this subcontract, when I am doing this in Acumatica interface everything works fine I added those fields to endpointand now trying to do same with rest request Here is my request :URL : 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": {

Hi,My application forms rest requests and creates invoicesIt working except one momentOur client has added custom entityThere is opportunity to create Bill based on subcontract, when I am doing this in Acumatica interface everything works fine I added those fields to endpointand now trying to do same with rest request Here is my request :URL : 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" 

Hi,I mistakenly deleted one of endpoints.I tried to load customization project again, I unpublished, and removed the project. Imported and published again, but it did not help, endpoint is absent.What should I do ?

I want to use OAuth 2.0 for more security but it does not really seem more secure if I can still connect via simple auth as well. So I want to block the authentification with only username and password and only be able to use Connected Applications for the instance.Does anyone know how to archive this?

I want to be able to post my solution on Acumatica maket place. But I don't know how to do it. Can anyone help me understand this problem. Thanks a lot !!

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?

I tried put request to the following endpoint:https://mysite/entity/Default/22.200.001/EmployeePayrollSettings/?$expand=TaxSettings{    "id": "7946c002-43d0-eb11-818d-0276c812300c",  ...    "TaxSettings": [        {            "id": "eaf47825-ba75-ed11-834f-026327f073d5",            "Value": {                "value": "2"            },...        }            ]} This is what I get:{    "message": "An error has occurred.",    "exceptionMessage": "Operation failed",    "exceptionType": "PX.Data.PXInvalidOperationException",    "stackTrace": "   at PX.Api.ContractBased.EntityService.Put(ISystemContract systemContract, String version, String name, EntityImpl entity, CbOperationContext operationContext, Boolean throwOnError)\r\n   at PX.Api.ContractBased.Soap.SoapFacadeBase.PutImpl(EntityImpl entity, Boolean throwOnValidationError)\r\n   at PX.Api.ContractBased.SystemContracts.V2.RestController.PutEntity(EntityImpl entity, String select, String filter, String expand, String custom)\r\n   at l

Hello all,I am experimenting with extending Acumatica’s web service endpoint to exposes objects from the PR module. I have added a Top Level Entity with a PR203000 as the base. In addition to a few attributes on that top level entity, I have added a Detail Entity that maps to the TaxSettings tab on the screen. Specifically, in that detail entity, I have exposed the Description, State, and Value properties of the “Tax Settings” object. I then try and add data using the following PUT request:{ "EmployeeID": { "value": "KLM" }, "TaxSettings": [ { "State": { "value": "FED" }, "Description": { "value": "Social Security Number" }, "Value": { "value": "123-45-6789" } } ]}However, I receive the following error message:{ "message": "An error has occurred.", "exceptionMessage": "Operation failed", "exceptionType": "PX.Data.PXInvalidOperationExce

I’m attempting to create a Bill via the API - https://xxxxx.myobadvanced.com/entity/Default/20.200.001/Bill{ "Entity": { "Type": { "value": "Bill" }, "BranchID": { "value": "MAIN" }, "DueDate": { "value": "2023/01/31T00:00:00+00:00" }, "Vendor": { "value": "14340" }, "VendorRef": { "value": "14340" }, "LocationID": { "value": "MAIN" } }}Response{ "id": "60793d30-6698-ed11-ab3d-023a8f428f42", "rowNumber": 1, "note": null, "error": "'VendorLocationID' cannot be empty.; 'VendorLocationID' cannot be empty.; VendorLocationID: 'VendorLocationID' cannot be empty.", "Amount": { "value": 0.0 }, "ApprovedForPayment": { "value": false }, "Balance": { "value": 0.0 }, "CashAccount": {}, "CurrencyID": { "value": "AUD" }, "Date": { "value": "2023-01-20T00:00:00+00:00"

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. 

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  

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

Good day,I have a few old backorders that need a shipment created confirmed.  it is very important to make sure the schedule shipment is based on the file date.  I think my logic is correct.  Any thoughts or modifications needed.  I have attached the xml and the data file.I always appreciate  your assistance.  Saves my time and also I am getting better.  This one is stumper.Thank youEvan 

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

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

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.

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

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?

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

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