search

NexarDeveloper / nexar-supply-excel-cs

The Nexar Supply Excel Add-in
MIT License
18 stars 0 forks source link

Specify multiple distributors in single call #22

Closed foggynoggun closed 1 year ago

foggynoggun commented 1 year ago

Hi.

The Excel function help indicates that more than one distributor can be specified in the parameter.

If this is the case, what is the format. I've tried a number of delimiters, no joy :(

Also, being able to ask that all the breakpoint pricing comes back, rather than the specified quantity price would be very useful (like the rest api call)

Cheers an TIA!

Foggy

RobAltium commented 1 year ago

Hi @foggynoggun,

Thanks for your note. For future reference, we have a new support system for Nexar now, see here, so do feel free to use that.

To answer your questions...

  1. To use multiple distributors, you would select multiple cells for that function argument. For example... image

  2. We have a policy in the add-in that each function must only return a single piece of data, not an array. This is to avoid the difficulty where user data in the worksheet is moved of overwritten. You can make the multiple queries into the pricing and always use the API to ascertain the breakpoints for your particular part and seller.