Have been trying to retrieve the data from the Details tab of the Sales Orders(SO301000) screen using the below link with GET request and have been getting the attached screenshot in the response. The requirement is to retrieve the data from the Details tab for all the Sales Orders.
URL: /entity/Default/20.200.001/SalesOrderDetails?$expand=Details
Kindly let me know how shall I get the list in the Response.
Thank you in advance
Best answer by RohitRattan88
View original
+4
Hi
In the request you need to target the top level entity, and then expand the detail entity. The request URL should be like below,
To to a filter record based on a field you can use the filter like below,
For more details on the using parameters in the request refer,
Thanks,
Thank you
I would like to retrieve the data based on the following example:
If there are two Sales Orders with IDs SO-001 and SO-002, and each Sales Order has two Line Items, then the API should return a list of four Line Items, which would be the two Line Items associated with SO-001 and the two Line Items associated with SO-002.
+4
Hello
Make sure you do login call before trying to work with REST APIs though.
Here’s and example:
Then you can call the SalesOrder GET :
Please refer to I310 for additional details:
I310 Data Retrieval with REST API Basics 2022 R2 (acumatica.com)
Hopefully it helps.
Rohit
Thank you
Hello
Similarly I have been trying to update the status of the Sales Orders to “Completed” by using a PUT request with the below mentioned URL and request body:
URL: /entity/Default/20.200.001/SOOrder and also tried with /entity/Default/20.200.001/SalesOrder
Request Body: "Status": { "value" : "Completed"}.
But the status isn’t getting updated.
Can you please guide me out in the same?
Thank you in advance.
+4
Hello
Completing a Sales Order is an "Action" to be performed which can be done using POST call.
Please refer to I330(I330 Data Manipulation with REST API 2022 R2 (acumatica.com)) for respective documentation.
Rohit
Hello Rohit,
I have defined a new Action that is required to be performed as shown below and did try to run a POST request, but still triggering the error 415-Unsupported Media Type
URL : /entity/CustomL/20.200.002/SalesOrder/Completed
Kindly let me know what I am missing here.
Thank you.
+4
+4
Thank you
But since the button is disabled, the action wont work. But still need to confirm on this if still it could work or not.
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
