Get U.S. Public Contract Discount Rates off List Price (kake ratio)
get_us_contract_discounts州と共同購買の契約書が公開している、定価からの値引き率を返す(ワシントン州 DES 23623 配管部材・11121 電気資材、NASPO ValuePoint の資材 MRO の Grainger・Fastenal・MSC・Lawson・HD Supply、Home Depot の塗料)。掛け率 = 1 - 値引き率(computed:true)。定価への上乗せ(Over MSRP)と業者の目録からの値引き(Catalog Off)は別の列で、掛け率には入れない。率は上限で、定価の基準は行ごとに違う。例: query='eaton breakers'。 / Published discount rates off list price in U.S. public contracts (Washington DES plumbing and electrical, NASPO ValuePoint MRO), with kake_ratio = 1 - discount (computed:true). Over-MSRP and catalog-off rows are kept separate. Rates are ceilings; list bases differ by row.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| basis | No | 値引きの基準で絞る: MSRP Discount 定価からの値引き、Over MSRP 定価への上乗せ、Catalog Off 業者の目録からの値引きなど。 / Discount basis filter, e.g. MSRP Discount, Over MSRP, Catalog Off. | |
| limit | No | 返す行の上限(1〜100)。 / Maximum rows to return (1 to 100). | |
| query | No | メーカー・製品系列・分野・業者の語(英語)。 / Manufacturer, product line, category or vendor words. | |
| offset | No | 飛ばす行の数。limit と組んで次のページを取る。 / Rows to skip; use with limit to page through results. | |
| vendor | No | 業者名(英語。例 Grainger, Fastenal)。 / Vendor name. | |
| source_id | No | 契約の出典: wa-des-23623 ワシントン州の配管部材、wa-des-11121 同じく電気資材、naspo-mro-ak NASPO ValuePoint の資材 MRO。 / Contract source: wa-des-23623 (Washington DES plumbing), wa-des-11121 (Washington DES electrical), naspo-mro-ak (NASPO ValuePoint MRO). | |
| manufacturer | No | メーカー名(英語)。 / Manufacturer name. |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| rows | No | 契約・メーカーごとの値引き率と kake_ratio / discount and kake ratio | |
| count | No | How many records matched. 0 means the source was read and nothing matched. It never means the source could not be read, that returns isError: true. | |
| lookup | No | ok = the source was read and something matched. absent = the source was read and nothing matched. A source that could NOT be read never appears here: that returns isError: true and makes no claim about what does or does not exist. | |
| source_read | No | true on every successful result. A failed lookup does not return a result at all, so this is never false, it is declared so a consumer can assert on it. | |
| did_you_mean | No | Near matches, when an exact match was not found. | |
| summary_by_vendor | No | メーカーごとの要約 / summary by vendor |