By using this website, you agree to our Terms of Use (click here)
Don't know is this should be here or elsewhere as I don't see an area for API topics:
I am accessing a Generic Inquiry via the REST API and It looks like everything should be working (the Inquiry works fine) and I think I have the endpoint set up correctly with the filter field on the base entity. I have a result sub entity that has the result values as well.
When I run the actual call in Postman I am getting essentially a new Record vs the record of the CustomerID I am filtering by:
{
"id": "07591f92-a4fa-4c94-9f9d-128fd549afaf",
"rowNumber": 1,
"note": null,
"CustomerID": {
"value": "<NEW>"
},
"DefaultLocationResults": [],
"custom": {},
"files": []
}
Anyone run into anything like this or have a better understanding of this than I?
This is limited information, I can provide more if needed, I was just wondering if someone might know offhand. I've had this working before in another instance but for some reason things seem off on this one.
Are you trying to access the Generic Inquiry definition or the result set?
If the result set, any reason why you're using the API instead of OData? I've never thought about doing it through the API.
I think I encounter same problem with him. We built an in-house web app that need to extract data from GI via Rest API, but i cannot apply Filter, it returns all the result of GI. JSON return is our only option.
Mike, congrats you've done everything correctly and you see what you should see 😀  . By default Acumatica API behaves exactly as opening screen manually. If you navigate to any screen in Acumatica, it will open to you screen with <New> as reference number. But you'll need to work a bit more in order to get specific customer by id.Â
@jerwin-alimuin, are you using a REST API or connecting to the Generic Inquiry over OData?
You can get OData to return JSON by doing this:
https://www.augforums.com/forums/acumatica-odata-with-microsoft-excel-and-power-bi/using-json-with-odata-in-acumatica/
You can also apply server-side OData filters in the URL. Here are some examples:
https://www.augforums.com/forums/acumatica-odata-with-microsoft-excel-and-power-bi/applying-filters-in-odata/
