I am working to make a custom application that acts as a middleman service, and I cannot figure out a way to make a call to the Epicor REST API that will return a list of parameters available to a BAQ. It isn’t that big of a deal if they are required, because then it will return an error status. (Although it seems to only return an error for the first parameter). However, if there is optional parameters…it will just return empty. I wanted to know if there’s an API call I could make to see these parameters for a given BAQ?
There’s a table in the database called Ice.QueryParameter. You can look them up using that table.
Database?
The REST service endpoint is here:
api/v1/Ice.BO.BAQDesignerSvc
It returns everything about the BAQ including a table with the parameters.
Thanks this is what I needed! Specifically, the “/BAQDesigners({Company},{QueryID})/QueryCtrlDesigners” seems very helpful as it tells me whether or not a parameter is required.
Thanks!
To be fair, that information is also in the table that @Banderson pointed out, but I saw 3rd Party Cloud Hosted on your profile and we don’t always have access to the database.
I was thinking a Db lookup on a function. But if there is already an endpoint, that works too.