Skip to main content

CreateBidSheetCustomerRequest

columns object[]required

Possible values: >= 1, <= 2000

  • Array [
    • oneOf
    nameNamerequired

    The name of the bid sheet column.

    Possible values: <= 255 characters

    typeType
    Constant value: item
    Default value: item
  • ]
    • bidOptions object[]required

    Bid options allowed for the bid sheet columns. Empty array means that per-bid-option columns are not allowed.

  • Array [
    • labelLabelrequired

    The unique label of the bid option.

    Possible values: non-empty and <= 30 characters

    description object

    The description of the bid option.

    anyOf
    string

    Possible values: non-empty and <= 200 characters

  • ]
    • items object[]required

    Items to initialize the current bid sheet with. Each array entry is one row, represented as an object whose keys are the bid sheet column names (exactly as defined for this RFQ) and whose values are the cell contents for that row. Unknown column names or missing required columns are rejected.

    Possible values: >= 1, <= 500

  • Array [
    • values objectrequired

    Cell values keyed by bid sheet column name.

    property name* CustomerColumnValue
    anyOf
    integer
  • ]
    • CreateBidSheetCustomerRequest
    {
      "bidOptions": [
        {
          "description": "The standard bid option.",
          "label": "On-spec"
        },
        {
          "description": "The off-spec bid option.",
          "label": "Off-spec"
        }
      ],
      "columns": [
        {
          "name": "Item",
          "type": "item"
        },
        {
          "name": "Volume",
          "type": "volume"
        },
        {
          "name": "Supplier",
          "type": "supplier"
        },
        {
          "bidOptions": [
            "On-spec",
            "Off-spec"
          ],
          "isRequired": false,
          "name": "Price",
          "type": "price"
        },
        {
          "calculation": "'Price' * 1.05",
          "name": "Price with VAT",
          "type": "formula"
        },
        {
          "calculation": "'Price with VAT' * 'Volume'",
          "name": "Total Cost",
          "type": "total_cost_formula"
        },
        {
          "isVisibleToSupplier": true,
          "name": "Buyer text",
          "type": "buyer_text"
        },
        {
          "bidOptions": [
            "On-spec",
            "Off-spec"
          ],
          "isRequired": false,
          "name": "Supplier text",
          "type": "supplier_text"
        },
        {
          "isVisibleToSupplier": true,
          "name": "Buyer number",
          "type": "buyer_number"
        },
        {
          "bidOptions": [
            "On-spec",
            "Off-spec"
          ],
          "isRequired": false,
          "name": "Supplier number",
          "type": "supplier_number"
        },
        {
          "isVisibleToSupplier": true,
          "name": "Buyer currency",
          "type": "buyer_currency"
        },
        {
          "name": "Supplier currency",
          "type": "supplier_currency"
        },
        {
          "bidOptions": [
            "On-spec",
            "Off-spec"
          ],
          "choices": [
            "Choice 1",
            "Choice 2",
            "Choice 3"
          ],
          "isRequired": false,
          "name": "Single select",
          "type": "single_select"
        },
        {
          "bidOptions": [
            "On-spec",
            "Off-spec"
          ],
          "isRequired": false,
          "name": "Volume - Capacity",
          "type": "capacity"
        }
      ],
      "items": [
        {
          "values": {
            "Buyer currency": "USD",
            "Buyer number": 100,
            "Buyer text": "Buyer note 1",
            "Item": "Item name 1",
            "Volume": 12
          }
        },
        {
          "values": {
            "Buyer currency": "EUR",
            "Buyer number": 200,
            "Buyer text": "Buyer note 2",
            "Item": "Item name 2",
            "Volume": 14
          }
        }
      ]
    }