Making Requests

Important: Before making any API calls to your sheets you must connect your MilkySheet account to Google. This is done from the MilkySheet Dashboard.

Get your API key

Your API requests are authenticated using API keys. Any request that doesn't include an API key will return an error.

You can generate an API key from your Dashboard at any time.

URL Params

SpreadSheet ID is an identifier of a Sheet in a Google Spreadsheet file.

To obtain it, open the file for the desired Sheet, and locate it as shown here https://docs.google.com/spreadsheets/d/{SheetID}/edit#gid=0

Sheet Name is the title of the sheet you wish to make calls to.

Row ID is the ID assigned to each row by Milkysheet, notice when a GET call is made each row will have a unique ID.

Google Sheet Format

Each column of data must contain a header for Milkysheet to return or post data successfully! MilkySheet will always assume that the first Row are your Column headings and data starts on Row 2.

Movie	Genre
Groundhog Day	Comedy
Die Hard	Action

Header Request

Your API Key is generated from the MilkySheet dashboard, if you feel like the key may have been compromised you can generate a new one. You can also access your Unique Id from the dashboard.

Example Header

{
    "Authorization" = "Bearer {APIKEY}",
    "id" = "{YOUR UNIQUE ID}"
}

Get Rows

GET https://api.milkysheet.com/{SheetID}/{SheetName}

Example Response

[{
        "id": 1,
        "Movie": "Groundhog Day",
        "Genre": "Comedy"
    },
    {
        "id": 2,
        "Movie": "Die Hard",
        "Genre": "Action"
    },
    {
        "id": 3,
        "Movie": "The Lord of the Rings: The Return of the King",
        "Genre": "Adventure"
    }
]

Get Specific Row

GET https://api.milkysheet.com/{SheetID}/{SheetName}/{RowID}

Response

{
    "id": 3,
    "Movie": "The Lord of the Rings: The Return of the King",
    "Genre": "Adventure"
}

Filter Rows

GET https://api.milkysheet.com/{SheetID}/{SheetName}?column=<Columnd Header>&value=<Value to Search for>

Add Rows

POST https://api.milkysheet.com/{SheetID}/{SheetName}

Example Body

[
{
    "Movie": "Ice Age",
    "Genre": "Family"
}
]

Edit Rows

PUT https://api.milkysheet.com/{SheetID}/{SheetName}/{RowID}

Example Body

[
{
    "Movie": "Ice Age",
    "Genre": "Family"
}
]

Delete Rows

DELETE https://api.milkysheet.com/{SheetID}/{SheetName}/{RowID}