Price and Availability via REST BAQ

[JasonMcD (Jason McDermott)]

I am tasked with creating a BAQ (for a REST call) to show a part’s “price and availability” based on a customer ID (and part number, duh).

My brain knows of:

1. Return every possible combination of part number (say, 7,500) and customer ID (say 1,000), so 7,500,000 results to then filter on the call. As others have mentioned, also factor in UOM and maybe even price breaks, and yikes.
2. BAQ parameters

Option 1 - seems awfully inefficient.

Option 2 - how do BAQ parameters work in REST? Can you do that at all?

Both kind of remind me of this discussion, but I have no idea if there’s any correlation between this and that:

BAQRpt & QuickSearch Pass Silent Parameters to BAQ

In addition to the previously requested feature: We the developer community would extremely find it useful to do something similar to BAQ Reports and Quick Searches, so we can pass one of those Form Bindable fields to the BAQ before it runs. Just like Dashboards… BAQRpt’s BAQ Grabs 10,000,000 rows (lets say you have that many Jobs) and then filters it after execution, thats the only reason I try to avoid them BAQRpts and Quick Searches etc… all have to run wide-open and can’t bind to a param. …

Really, this seems similar to this post, but again, I don’t know if those thoughts (for a BPM) have any application to a BAQ:

Price Lookup via BPM

I have a need to display the price that a customer would receive on a qty of a part. I have tried the Price List Inquiry, but it does not seem to work exactly the same as Order Entry because there are differing UOMs. I would like to populate some fields with the Unit Price, Disc%, and Disc Amount without creating a Sales Order Line. Is this possible via a BPM? I can run through all the tables (Customer, Customer Group, Price List, Discount Price List, etc), but I would hope there is something …

Thanks for any help. A completely different solution is good, too.

[Olga (Olga Klimova)]

I can’t help you with the task but BAQ parameters do work in Rest.
Create any parameterized BAQ and call it using REST help page.

[JasonMcD (Jason McDermott)]

Holy mackerel that’s crazy simple!

I feel so silly for not even trying it. I just assumed there was some ridiculous setup involved.