Acumatica run Generic Inquiry via REST API

Question

How can I run a generic inquiry that I created via Acumatica's REST API? I was using the Inventory Summary Inquiry before but it was not returning all of the data I needed so we created a Generic Inquiry to return available for shipment quantity for ALL stock items. However I can't find how to get the data from this report via the API.

UPDATE:

I've tried creating an extended endpoint service and adding my endpoint for the report as described in I210 Documentation and then hitting via the REST API (which is not shown in I210). I added all of the result fields to the fields tab of the endpoint that I need returned.

Here are the details I used:

Extended Endpoint Name: MyInventoryAvailable
Endpoint version: 6.00.001
Endpoint: GetAvailableInventory
URL: https://mycompany.acumatica.com/entity/MyInventoryAvailable/6.00.001/GetAvailableInventory?$expand=Results

When I do a PUT request using the above details, this is the response I get:

{
    "message": "The request is invalid.",
    "modelState": {
        "": [
            "The request body should not be empty."
        ]
    }
}

UPDATE 2

Here is the setup in Acumatica for the extended endpoint:

I've tried setting up a request body but with no success:

{
    "InventoryID": {
        "Value": "AB-CL-60"
    },
    "Description": {
        "Value": ""
    },
    "Location": {
        "Value": ""
    },
    "QtyHardAvailable":{
        "Value": 0.0
    },
    "QtyOnHand":{
        "Value": 0.0
    },
    "Warehouse":{
        "Value": 0.0
    }
}

When sending any request body, regardless of the content I recieve this error:

"exceptionMessage": "The given key was not present in the dictionary.",
"exceptionType": "System.Collections.Generic.KeyNotFoundException",

UPDATE 3 - Inquiry Structure

Here is the structure of the inquiry:

And here are the results in Acumatica's UI:

UPDATE 4

Expanded GetAvailableInventory node:

Answer 1

This is how I structure Generic-Inquiries in Web-Service-Endpoints.

While other Endpoints contain any number of Mapped Objects, the Generic-Enquiry Endpoints only have

Enter-Keys, Filter, Result, and Values-for-Update

The FIELDS for the ENDPOINT are the Filters (click POPULATE -> Filters). The example above does not seem to have any filters, which is fine, so this FIELDS should be empty.

To get the data from the Generic Inquiry, a "Detail" entity is added

• click the Generic Inquiry
• click "+ INSERT"
• Fill in form with FieldName='GetAvailableInventoryResults', ObjectName='GetAvailableInventoryResults', ObjectType=Detail
• Save

Now, add the results wanted by clicking on 'GetAvailableInventoryResults', then FIELDS (opens a popup). In the popup, select 'Result' and add all the fields you want. Don't select "Row Number" and "Selected" as these are not needed and can cause errors. SAVE.

To access the ENDPOINT, do a PUT to

   .../GetAvailableInventory?$expand=GetAvailableInventoryResults

with a BODY of

{}

since this ENDPOINT does not define any Filters, but a PUT requires this to exist.

Why do I use "GetAvailableInventoryResults"? Well, because I ran into issues with multiple Generic-Inquiry Endpoint's having Details with the same name, so I make sure they are all unique.

Answer 2

Use GET instead of PUT. Your requirements fall under this. I supposed Generic Inquiry <> Inquiry Form. Hence the different outcome between GET vs PUT.