wholesale_order.json

{
    "order_rn": {
        "type": "RECORD_NUMBER",
        "value": "1"
    },
    "shopify_order_id": {
        "type": "SINGLE_LINE_TEXT",
        "value": "ORDER-1234"
    },
    "client_first": {
        "type": "SINGLE_LINE_TEXT",
        "value": "Steven"
    },
    "client_id": { // *** Is this different from the shopify_client_id below? If so, what are the sources?
        "type": "SINGLE_LINE_TEXT",
        "value": "1234567890"
    },
    "internal_notes": { // *** Please make sure this is an optional field
        "type": "MULTI_LINE_TEXT",
        "value": "Here are some internal notes..."
    },
    "full_name_calc": { // *** Is this calculated by Kintone, or should it be sent?
        "type": "SINGLE_LINE_TEXT",
        "value": "Steven Hallam"
    },
    "ship_date": {
        "type": "DATE",
        "value": "2023-04-25"
    },
    "delivery_date": {
        "type": "DATE",
        "value": "2023-04-26"
    },
    "event_date": { // *** Wishlist: Is it possible and reasonably simple to calculate the delivery and ship dates on insert?
        "type": "DATE",
        "value": "2023-04-27"
    },
    "client_notes": {
        "type": "MULTI_LINE_TEXT",
        "value": "Here are the client notes...."
    },
    "client_last": {
        "type": "SINGLE_LINE_TEXT",
        "value": "Hallam"
    },
    "client_address_1": {
        "type": "SINGLE_LINE_TEXT",
        "value": "44 Montgomery"
    },
    "client_address_2": {
        "type": "SINGLE_LINE_TEXT",
        "value": "Floor 22"
    },
    "client_city": {
        "type": "SINGLE_LINE_TEXT",
        "value": "San Francisco"
    },
    "client_state": {
        "type": "SINGLE_LINE_TEXT",
        "value": "CA"
    },
    "client_state_abb": {
        "type": "SINGLE_LINE_TEXT",
        "value": "CA"
    },
    "client_zip": {
        "type": "SINGLE_LINE_TEXT",
        "value": "94104"
    },
    "client_email": {
        "type": "LINK",
        "value": "steve@kintone.com"
    },
    "client_phone": {
        "type": "LINK",
        "value": "5555555555"
    },
    "shopify_client_id": { // *** Please see note above on client_id
        "type": "SINGLE_LINE_TEXT",
        "value": "1234567890"
    },
    "all_confirmed": { // *** Please ensure this is optional or defaults to false
        "type": "DROP_DOWN",
        "value": "false"
    },
    "amount_paid": { // *** I sent an email asking about this. Please disregard
        "type": "NUMBER",
        "value": "1000"
    },
    "delivery_address_1": {
        "type": "SINGLE_LINE_TEXT",
        "value": "44 Montgomery"
    },
    "delivery_address_2": {
        "type": "SINGLE_LINE_TEXT",
        "value": "Floor 22"
    },
    "delivery_city": {
        "type": "SINGLE_LINE_TEXT",
        "value": "San Francisco"
    },
    "delivery_state": {
        "type": "SINGLE_LINE_TEXT",
        "value": "CA"
    },
    "delivery_state_abb": {
        "type": "SINGLE_LINE_TEXT",
        "value": "United States"
    },
    "delivery_zip": {
        "type": "SINGLE_LINE_TEXT",
        "value": "94104"
    },
    "deliver_notes": {
        "type": "MULTI_LINE_TEXT",
        "value": "Delivery notes..."
    },
    "line_items": {
        "type": "SUBTABLE",
        "value": [
            {
                "value": {
                    "sku": {
                        "type": "SINGLE_LINE_TEXT",
                        "value": "AGRO-1555"
                    },
                    "product": {
                        "type": "SINGLE_LINE_TEXT",
                        "value": "AGRO Product A"
                    },
                    "qty": {
                        "type": "NUMBER",
                        "value": "10"
                    },
                    "confirmed": { // *** Please have this default to "No" or not be a required field
                        "type": "DROP_DOWN",
                        "value": "No"
                    }
                }
            },
            {
                "value": {
                    "sku": {
                        "type": "SINGLE_LINE_TEXT",
                        "value": "AGRO-1222"
                    },
                    "product": {
                        "type": "SINGLE_LINE_TEXT",
                        "value": "AGRO Product B"
                    },
                    "qty": {
                        "type": "NUMBER",
                        "value": "15"
                    },
                    "confirmed": {
                        "type": "DROP_DOWN",
                        "value": "No"
                    }
                }
            },
            {
                "value": {
                    "sku": {
                        "type": "SINGLE_LINE_TEXT",
                        "value": "JET-1333"
                    },
                    "product": {
                        "type": "SINGLE_LINE_TEXT",
                        "value": "JET Prodcut A"
                    },
                    "qty": {
                        "type": "NUMBER",
                        "value": "20"
                    },
                    "confirmed": {
                        "type": "DROP_DOWN",
                        "value": "No"
                    }
                }
            },
            {
                "value": {
                    "sku": {
                        "type": "SINGLE_LINE_TEXT",
                        "value": "DREAM-1444"
                    },
                    "product": {
                        "type": "SINGLE_LINE_TEXT",
                        "value": "DREAM Product A"
                    },
                    "qty": {
                        "type": "NUMBER",
                        "value": "20"
                    },
                    "confirmed": {
                        "type": "DROP_DOWN",
                        "value": "No"
                    }
                }
            }
        ]
    }
}